# ---
# jupyter:
#   jupytext:
#     text_representation:
#       extension: .py
#       format_name: light
#       format_version: '1.5'
#       jupytext_version: 1.14.4
#   kernelspec:
#     display_name: Python 3
#     language: python
#     name: python3
# ---

# This is a python 3 Jupyter notebook for the "Array of Things"

# +
import pandas as pd

# Load the 'Array of things' dataset on Socrata into a DataFrame

AoT_url = "http://data.cityofchicago.org/resource/dbwu-caep.csv"
df = pd.read_csv(AoT_url)

df.shape
# -

df.head()

# +
useful = [7, 14, 15, 12, 6, 17, 16]

ludf = df[df['status'] == 'Live'][['latitude', 'longitude', 'name', 'location_type', 'category', 'notes']]
ludf.head()

# Shifted by one unit (5 - ...) because the count is from 0 here.
# -

ludf.shape



StarcoderdataJupyterScriptsDedupFiltered