This is a data cleaning & visualising project using Google Bigquery API and Socrata API.
Before you run the notebook:
- Create a project on Google Cloud for querying Google Bigquery Dataset.
- Install Google Cloud SDK and authenticate the account.
(i.e. in command prompt,
gcloud auth application-default login
)
- Retrieve road data in New York City
- EDA on road data
- Clean road data
- Retrieve tree data
- Retrieve air quality data