-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathtaxi_analysis_report
43 lines (28 loc) · 1.42 KB
/
taxi_analysis_report
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
--- Project Report: Analyzing Performance and Customer Preferences in NYC's Green and Yellow Taxis ---
**Findings:**
1. **Trip Distances:**
- Yellow Taxi: Mean Trip Distance - 2.59 miles
- Green Taxi: Mean Trip Distance - 7.79 miles
2. **Fare Amounts:**
- Yellow Taxi: Mean Fare Amount - $15.72
- Green Taxi: Mean Fare Amount - $32.21
3. **Average Tip Amount:**
- Yellow Taxi: Mean Tip Amount - $2.01
- Green Taxi: Mean Tip Amount - $5.51
### Visualizations
Here is a screenshot of the Power BI dashboard:
![Power BI Dashboard](visualizations/power_bi_dashboard.png)
--- Recommendations ---
1. **Recommendation 1:**
- Consider expanding the green taxi service as it generated higher total revenue.
2. **Recommendation 2:**
- Promote green taxis for their higher average tip amounts, which may attract more drivers.
3. **Recommendation 3:**
- Explore ways to improve the fuel efficiency of green taxis to reduce operational costs.
4. **Recommendation 4:**
- Consider promoting credit card payments for yellow taxis to enhance payment convenience.
--- Conclusion ---
Based on the analysis of yellow and green taxis in NYC, the following conclusions can be drawn:
- Green taxis tend to have longer average trip distances compared to yellow taxis.
- Green taxis tend to have higher average fare amounts compared to yellow taxis.
- Passengers of green taxis tend to give higher average tips compared to yellow taxis.