-
This project begins with loading the csv files from the data folder and converting them into a single Excel file for easy visualisation and analysis on Microsot PowerBI(Tableau can also be used); kindly check eda.ipyb file
-
The exported Excel file is named full_data.xlsx
-
Images of visualisations performed can be seen in the img folder
-
The Microsoft PowerBI file is taxi_cabs_visualisation.pbix
-
Further analysis was done using Python; kindly check eda_notebook.ipynb & plots folder.
-
Based on the analysis the following can be drawn;
Conclusion
After analysis and observations made, Yellow Cab company has come out as the preferred choice for investment based on the following;
- Yellow Cab company has a greater reach in genders compared to that of Pink Cab company.
- Yellow Cab company has a greater profit margin compared to the Pink Cab company.
- Yellow Cab company has a lower loss margin compared to that of Pink Cab company.
- Yellow Cab company has profit increases considerably more than Pink Cab company as price charged increases.
- Yellow Cab has a higher transaction margin for each year and month more than that of Pink Cab company
- The mean profit for each year and month for Yellow Cab company is more than that of Pink Cab company
Recommendations
- Although Yellow Cab has three cities that are in the top six cities namely; New York NY, Chicago IL, Los Angeles CA and the remaining in cities with population below 1 million. It needs to increase its reach in the following remaining top six cities namely; Miami FL, Silicon Valley and Orange County, in order to fully maximise its profit.