RusticHaze634/Uber-data-analysis

Data analysis and visualization

Uber-data-analysis

Uber Data Analysis : Case Study 1

| Click here for the code |

Dataset details:

Dataset name : My Uber Drives (2016)

Dataset Contents:

• Geography: USA, Sri Lanka and Pakistan
• Time period: January - December 2016
• Unit of analysis: Drives
• Total Drives: 1,155
• Total Miles: 12,204
• contains Start Date, End Date, Start Location, End Location, Miles Driven and Purpose of drive (Business, Personal, Meals, Errands, Meetings, Customer Support etc.)
• Aim : To learn from the behavior of an ordinary Uber customer.

Table of Content

• Data acquisition
• Missing Value Handling
• Duplicate Rows Handling
• Renaming Columns
• Replace Null values
• Introduction of MONTH and Related Visualization
• Exploratory Data Analysis
• Questions :
  • 1. Top 10 starting location
  • 2. Which was the most Frequent Starting Point?
  • 3. Top 10 STOP locations
  • 4. Which was the most Frequent Stopping Point?
  • 5. What is the number of trips per month?
  • 6. What is the number of trips per day?
  • 7. How many trips for each purpose?
  • 8. How many trips in any particular day of all months (Category-wise) ?
  • 9. How many trips in any weekday?
  • 10. Is there any Round Trip? If, Yes, then How many Round Trips?
  • 11. Calculate Ride durations and Analyse
  • 12. Show Month-wise number of Uber Rides
  • 13. At which day uber rides were mostly used?
  • 14. Which was the Longest and the Shorest Ride Months (Based on Average Distance covered per month)?
  • 15. When was the Max no. of Trips in a day generally?
  • 16. Speed
• Save the Result

Answers

• 1. Top 10 starting location

  

• 2. Which was the most Frequent Starting Point?

• 3. Top 10 STOP locations

• 4. Which was the most Frequent Stopping Point?

• 5. What is the number of trips per month?

• 6. What is the number of trips per day?

• 7. How many trips for each purpose?

  

• 8. How many trips in any particular day of all months (Category-wise) ?

  

• 9. How many trips in any weekday?

  

• 10. Is there any Round Trip? If, Yes, then How many Round Trips?

  

• 11. Calculate Ride durations and Analyse

  

• 12. Show Month-wise number of Uber Rides

  

• 13. At which day uber rides were mostly used?

  

• 14. Which was the Longest and the Shorest Ride Months (Based on Average Distance covered per month)?

  

• 15. When was the Max no. of Trips in a day generally?

  

• 16. Speed

• Every city has a speed limit. Speed limit visualisation? Higher speed limit in a city---more frequent stops--- low traffic--- More fuel savings
• Calculation: Related cities and their highest speed and lowest
• Introduce a column .