This project provides an understanding of historical trips for all Green Taxis in New York City, NYC (2017 – 2020)
The dataset contains trip records from all green taxis in NYC from 2017 to 2020. Records include fields capturing pick-up and drop-off dates/times, pick-up and drop-off locations, trip distances, itemized fares, rate types, payment types, and driver-reported passenger counts. (Source: NYC Taxi & Limousine Commission)
Loading a dataset with 28,327,624 number of records to power bi was a challenge. I used Python for the data cleaning and removal of columns I will not be using for the analysis. This made the dataset easier to load in Power BI for the analysis.