The purpose of the analysis is to work together with Omar to deliver a summary of the ride-sharing data by city type. The final product should also include a line graph that shows the total weekly fares for each city type.
The results from the analysis can be looked at in two formats. The first is a table summarizing the total rides, total drivers, total fares, average fare per ride, and average fare per driver. The seconds in a line graph of total fares by week. From the table we can conclude the below statements:
- Urban areas have the highest number of total rides and drivers
- The average fare per ride is highest for rural areas and lowest for urban areas
- The average fare per driver is highest for rural areas and lowest for urban areas For more information see table here:
From the line graph we can conclude the below statements:
- The total fare is highest all year round for urban cities, this is in line with the data given that urban areas have the highest number of rides and drivers
- The total fare is lowest all year round for rural cities, this is in line with the data given that rural areas have the lowest number of rides and drivers
- The last week of February (2019-02-24) was a week with some of the highest total fares for all three type of cities
- Total fares for urban rides spike significantly in the last week of February (2019-02-24) and the second week of March (2019-03-10)
- Total fares for suburban rides spike significantly in the last week of February (2019-02-24) and last week of April (2019-04-28)
- Total fares for rural rides spike significantly in the last week of February (2019-02-24) and first week of April (2019-04-07) For more information see line graph here:
Based on the data summarized above, I would suggest the following three actions be taken to address any disparities among the city types:
- Increase efforts to register drivers in suburban and rural city to increase the number of rides, and therefore the total fares
- Increasing efforts to register drivers in suburban and rural cities would also help lower price surges which would in tern bring the average fare per ride and per driver closer to that of urban cities. It would be important to check the average distance per ride to ensure that is not contributing to the higher average fare per ride.
- Increasing fares in suburban and rural areas will increase the total fares per city type. Given that public transportation is not as common in these areas, it should not greatly impact the number of customers and average rides.