All work
Python · Parquet
Data Preparation Using Python
This project integrates Yelp review, business, and user datasets for the Greater Philadelphia area, applies category standardization, and filters to relevant business types. Data cleaning, category normalization, and spatial filtering produce a refined Parquet dataset for focused regional analysis.
- 3 datasets joined
- Spatial filtering
- Parquet output
What it demonstrates
- Three datasets integrated
- Yelp review, business, and user datasets joined into a single working set.
- Category standardization
- Business categories are normalized so related types group correctly instead of fragmenting.
- Spatial filtering
- Filtered to the Greater Philadelphia area to keep the analysis regionally focused.
- Parquet output
- Produces a refined Parquet dataset sized for downstream analytical work.
Live
The data preparation
Loading