#!/usr/bin/env python
# coding: utf-8

# In[1]:


get_ipython().system('pip install sodapy')


# In[2]:


get_ipython().system('python -m pip list')


# In[3]:


get_ipython().system('python -m pip show sodapy')


# In[4]:


get_ipython().system('pip install matplotlib')


# In[5]:


get_ipython().system('python -m pip show matplotlib')


# In[6]:


get_ipython().system('pip install sklearn')


# In[7]:


get_ipython().system('python -m pip show sklearn')


# In[8]:


import pandas as pd


# In[9]:


from sodapy import Socrata


# In[10]:


client = Socrata("www.datos.gov.co", None)


# In[11]:


results = client.get("gt2j-8ykr", limit = 10000)


# In[12]:


results_df = pd.DataFrame.from_records(results)


# In[13]:


results


# In[14]:


results_df


# In[15]:


results_df.head()


# In[16]:


results_df.head(20)


# In[17]:


results_df.tail()


# In[18]:


results_df.tail(20)


# In[19]:


results_df.sample()


# In[20]:


results_df.sample(10)