Taxi Data Insights: Unlocking High-Revenue Zones & Smart Earning Patterns

By abhishek.verma75000 · April 12, 2026

A comprehensive analysis of taxi trips reveals powerful patterns in pickup zones, revenue hotspots, trip behavior, and driver efficiency. From high-demand…

The analysis successfully identified the top 10 pickup zones generating the most trips and highest revenue. A side-by-side bar chart has been created showing each zone's trip count and total revenue, along with detailed data tables for easy comparison.

The analysis identified the top 15 pickup-to-dropoff zone pairs with the highest average total fares, filtered to include only routes with at least 3 trips for reliability. A horizontal bar chart has been generated showing these top routes ranked by their average fare.

The analysis produced a side-by-side bar chart comparing total revenue and average fare per trip across pickup boroughs. The visualization clearly shows which boroughs generate the most overall revenue as well as which ones command the highest average fare per ride.

The analysis produced two visualizations comparing tip behavior across different payment methods. The first bar chart shows the average tip percentage for each payment method, and the second grouped bar chart compares average tip amounts versus total fares side by side.

The analysis successfully produced a grouped bar chart and data table showing how average fare, tip, and trip distance vary by passenger count. The visualization compares these three metrics side by side for each passenger group, making it easy to spot trends and differences.

The analysis produced a chart and data tables showing trip volume and revenue broken down by each hour of the day. The bar chart displays trip counts per hour (in blue) alongside a revenue trend line (in red), making it easy to spot when demand and earnings peak throughout the day.

The data table compares 6,433 total taxi trips across green and yellow cabs. Yellow taxis dominate in trip volume with 5,451 trips compared to green's 982. However, green taxis average slightly higher fares ($14.04 vs $12.92) and cover longer distances (3.41 mi vs 2.96 mi). Interestingly, yellow taxi passengers tip significantly more — $2.19 on average versus just $0.80 for green taxis.

Out of 6,433 total trips, 346 (about 5.4%) incur tolls. The top toll routes are airport connections — JFK, Newark, and LaGuardia — which tend to be longer-distance trips. Interestingly, toll trips actually generate LOWER revenue per mile ($4.53) compared to no-toll trips ($10.08). This is because airport routes are much longer, so even though the total fare is higher, the revenue gets spread across more miles.

A data table was generated exploring the relationship between trip distance and fare. The analysis examined how fare prices correlate with trip distances and identified trips that deviate significantly from the expected pricing pattern.

The analysis of March 2019 trip data reveals daily volume trends and weekday vs. weekend patterns. Two charts were generated: a bar chart showing daily trip counts throughout the month (color-coded teal for weekdays and red for weekends), and a second chart showing average trips by day of the week. The data covers all 31 days of March 2019, totaling 6,432 trips.

The average trip duration is 14.3 minutes. A bar chart has been generated showing the top 15 pickup zones ranked by revenue per minute, filtered to zones with at least 5 trips. This gives you a clear view of which areas generate the most earnings relative to time spent on the trip.

The analysis identifies the highest-demand dropoff zones, giving drivers clear repositioning opportunities. A horizontal bar chart shows the Top 20 Dropoff Zones by trip volume, with zones ranked from highest to lowest demand. These are the areas where the most passengers are being dropped off, making them prime spots for drivers to reposition and pick up new fares.

The analysis reveals that Wednesday generates the highest average revenue per trip at $19.13, while Friday sees the most trip volume with 1,115 trips. A chart and data table have been generated showing both average revenue and trip counts across all days of the week.

About 35.9% of all trips in the dataset received zero tips. The analysis produced charts and data tables breaking this down by both payment method and pickup borough, revealing which segments are most affected. The bar charts clearly show the variation in zero-tip rates across different payment types and boroughs.

Short trips (under 2 miles) are significantly more lucrative on a per-mile basis. They generate $12.73 per mile on average, compared to just $5.71 per mile for long trips — that's 2.2 times more revenue per mile. Two charts and summary tables were generated to visualize this comparison, including a grouped bar chart showing mean vs. median revenue per mile, and a box plot showing the full distribution for each trip type.

The vast majority of taxi trips — 87.5% (5,582 trips) — stay within the same borough, while only 12.5% (801 trips) cross borough boundaries. Cross-borough trips are significantly more expensive, with an average fare of $32.30 and a total of $41.89, compared to within-borough trips which average just $10.09 in fare and $14.89 total. A pie chart and comparison tables were generated to visualize these differences.

The top 5% highest-revenue trips (those totaling $48.08 or more) are clearly distinct from typical rides. These 322 trips average $65.30 in total fare — about 4x the $16.05 average for the other 95%. The biggest differentiator is distance: top trips average 15.2 miles compared to just 2.4 miles for the rest. Visualizations and data tables were generated showing metric comparisons and pickup zone breakdowns.

Daytime (5AM–10PM) dominates trip volume with 5,276 trips (82% of total), compared to just 1,157 late-night trips (10PM–5AM), which is 18% of all rides. Despite the big volume difference, fares are remarkably similar — late-night averages $13.01 vs. daytime's $13.11. Interestingly, late-night trips are slightly longer (3.26 mi vs. 2.97 mi) and generate a slightly higher total charge ($18.66 vs. $18.49). Two charts and comparison tables were generated showing hourly trip volume and fare patterns across the day.