Ride Sharing Case Study Through Python

Study patterns in the ride-share business, measure Ride time statistics, analyze top routes, & catch false rides on the platform

Learn the following Python Concepts:

• How to get N rows of data in Python
• How to use Aggregate Functions in Python
  • Count, Count Distinct, Sum, Maximum, Minimum etc.
• How to Group data and aggregate in Python
• How to convert an aggregate column to percentage in Python
• How to round a column to N decimal places in Python
• How to concatenate columns and strings in Python
• How to define and find outliers in Python
• How to use Statistical Functions in Python
  • How to find the mean of a column in Python
  • How to find the median of a column in Python
  • How to find the Nth percentile of a column in Python
  • How to find the Inter-Quartile range of a column in Python
    
• How to use Date Functions in Python
  • How to extract a part of date from a column in Python
  • How to extract Year, Month, Date from a column in Python
• How to find difference of time columns in Python

Learn the following Concepts about Clickstream Analytics:

• Understand the various ride sharing metrics
• How to analyze total rides that happen on a platform
• How to find contribution of rides by vehicle type on the platform
• How to find contribution of rides by different kind of members on the platform
• How to analyze the top N routes on the platform by the number of rides
• How to find out the ride time for each ride on the platform
• How to find out false rides on the platform
• How to remove outliers and calculate average ride time on the platform
• How to perform statistical analysis of ride times on the platform
  • Find Mean, Median, Inter-Quartile range etc. for ride times on the platform
• How to analyze the daily/weekly rides on the platform