Project Overview
This mini-project focuses on practicing SQL queries and data exploration using Google BigQuery within a Jupyter Notebook environment. The goal is to get familiar with connecting Python to BigQuery, running queries on a public dataset, and retrieving results into pandas DataFrames for basic analysis and visualization.
The project uses the Chicago Crime dataset from Google’s public BigQuery datasets as an example. A few exploratory questions are addressed, such as:
- What are the most common types of crimes?
- How many crimes were reported in a specific area (Area 23)?
- On which day of the week do robberies occur most frequently?