Project:
Uber Data Analysis Using Jupyter Notebook
Albert Savill 3505901
,Table of Contents
Table of Figures.....................................................................................................................................1
1 Introduction........................................................................................................................................3
2 Data....................................................................................................................................................3
2.1 Uber New York City April 2014.....................................................................................................3
3 Methods.............................................................................................................................................4
3.1 K-Means Clustering......................................................................................................................4
3.2 Cross Analysis...............................................................................................................................4
4 Modelling............................................................................................................................................5
4.1 Data Manipulation.......................................................................................................................5
4.2 Analysing Time.............................................................................................................................7
4.2.1 Analysing Hours....................................................................................................................7
4.2.2 Analysing Weekdays.............................................................................................................8
5 Results................................................................................................................................................8
5.1 K-Means Clustering......................................................................................................................9
5.2 Cross Analysis.............................................................................................................................12
5.2.1 Hours & Days......................................................................................................................12
5.2.2 Longitude & Latitude..........................................................................................................12
6 Conclusion........................................................................................................................................15
References...........................................................................................................................................16
Bibliography & Link to Dataset............................................................................................................16
Table of Figures
- Figure 1: Raw Data Rows....................................................................................................................4
- Figure 2: Loading CSV File & Raw Data................................................................................................5
- Figure 3: Manipulating Date/Time.......................................................................................................5
- Figure 4: Adding Extra Column............................................................................................................6
- Figure 5: Adding Weekday & Hour......................................................................................................6
- Figure 6: Plotting & Analysing Hours...................................................................................................7
- Figure 7: More Plotting & Analysing Weekdays...................................................................................8
- Figure 8: Beginning of K-Means Clustering.........................................................................................9
- Figure 9: Output K Rows.....................................................................................................................9
- Figure 10: Sorted Values...................................................................................................................10
- Figure 11: K-means Chart 1................................................................................................................11
, - Figure 12: K-means Chart 2................................................................................................................11
- Figure 13: Cross-Analysis...................................................................................................................12
- Figure 14: Separate Longitude & Latitude Visualised Data...............................................................13
- Figure 15: Cross-Analysis of Longitude & Latitude.............................................................................14
- Figure 16: Input of NYC Map.............................................................................................................14
- Figure 17: NYC Map...........................................................................................................................15