DATA APPLICATION PROCESSING (DAP)
Turn messy data into usable intelligence.
THE PROBLEM
Monthly visitor-arrival and hotel datasets use wide tables and inconsistent values. They need a common date structure before analysis and prediction.
WHAT I BUILT
- Reshape with melt and pivot_table; parse year/month fields and inner-join hotel and arrival data on date.
- Select numeric arrays, impute missing values with medians, remove duplicates and cap outliers using IQR bounds.
- Engineer lag, rolling-average and seasonal features; compare scaling, PCA and eight regression models.
Project evidence
DAP_ProjectCode - Copy.ipynb · data_quality_helpers - Copy.py