# Analyzing Uber Trips -EDA using python



# What is uber?

Uber is an independent taxicab company that hires drivers who use their personal vehicles while logged into the Uber app on a mobile device. Passengers request rides using the app, inputting pick-up and drop-off locations, and all payment is done through a pre-authorized credit card right through the app.

> source:https://techboomers.com/t/what-is-uber

## About this project
This dataset has 1 million rows and four columns. I personally have the interest to know more about uber and its data. And this dataset grabbed my attention to analyze this data.

This dataset contains the uber rides pickups in New York City.
All data points lie in September month of 2014.

Features:
dateAndTime, Lat, Lon, Base

## My Findings
### 1. Sunday has the least number of trips in a week
> And Tuesday has the highest trips in a week
![weekdays.png](https://cdn.hashnode.com/res/hashnode/image/upload/v1660226333339/mNw4B9Qec.png align="left")

- Tue: 163230
- Sat: 162057
- Fri: 160380
- Thus: 153276
- Mon: 137288
- Wed: 135373
- Sun: 116532

### 2.Hourly analysis -  4 PM to 8 PM has more rides in a day
> Uber rides get a noticeable hike From 7 AM  and again drop in the lunchtime.

> At 6 PM uber has the highest number of bookings.

![hour counts.png](https://cdn.hashnode.com/res/hashnode/image/upload/v1660227170971/3AzjhNQzE.png align="left")

### 3.There are significant drops in bookings on weekends
> day 13th has the highest bookings in September month (43205 bookings)

![day trend.png](https://cdn.hashnode.com/res/hashnode/image/upload/v1660227732347/hv69RS-ij.png align="left")

### 4. Hours and Trips have a strong correlation
> correlation between Hours and Trips: 0.81205

![scratter-hours-trips.png](https://cdn.hashnode.com/res/hashnode/image/upload/v1660228353118/qJq327okT.png align="left")

### 5. Weekends have more percentage of midnight bookings compared to normal days

![uber trips per hour on weekends.png](https://cdn.hashnode.com/res/hashnode/image/upload/v1660228556108/zTfJNcUXZ.png align="left")
![hour counts.png](https://cdn.hashnode.com/res/hashnode/image/upload/v1660227170971/3AzjhNQzE.png align="left")

### 6. Saturdays and Sundays have a similar amount of bookings


![trip counts on saturdays.png](https://cdn.hashnode.com/res/hashnode/image/upload/v1660229303810/l7QVhZ1aI.png align="left")

![trips counts on sundays.png](https://cdn.hashnode.com/res/hashnode/image/upload/v1660230956469/UsUvnsKYB.png align="left")

### 7. The B02617 Base(Weiter) has the highest bookings

![tlc base count plot.png](https://cdn.hashnode.com/res/hashnode/image/upload/v1660229602187/S_T7AsV3e.png align="left")

### 8. Manhattan has the highest bookings in NewYork City

![heatmap cooridinates-uber trips.PNG](https://cdn.hashnode.com/res/hashnode/image/upload/v1660230037813/PAoo6FL2B.PNG align="left")

### End