Newyork Taxi Trip Data

### Context

Dive into the rich dataset of New York City's yellow taxis, a treasure trove for any data scientist. This dataset is a detailed chronicle of urban mobility, capturing intricate details of each taxi trip. From temporal data points like pickup and drop-off times to spatial dimensions involving locations, this data offers a granular view of urban transit patterns. It also includes quantitative metrics like trip distance, fare composition, payment methods, and passenger counts. Provided by tech companies under the TPEP/LPEP initiatives, this data is a goldmine for analyzing urban transportation trends, fare dynamics, and passenger behavior. It's not just about taxis and their routes; it's a window into the lifeblood of the city, offering endless possibilities for data-driven insights and urban plannin

### Content

**Column Descriptions**

* **VendorID**: Identifier for the TPEP provider supplying the record.
* 1 = Creative Mobile Technologies, LLC
* 2 = VeriFone Inc.
* **tpep_pickup_datetime**: The date and time when the meter was activated.
* **tpep_dropoff_datetime**: The date and time when the meter was turned off.
* **Passenger_count**: The number of passengers in the vehicle, as entered by the driver.
* **Trip_distance**: The distance of the trip in miles, as recorded by the taximeter.
* **PULocationID**: TLC Taxi Zone where the meter was engaged.
* **DOLocationID**: TLC Taxi Zone where the meter was disengaged.
* **RateCodeID**: The applicable rate code at the end of the trip.
* 1 = Standard rate
* 2 = JFK
* 3 = Newark
* 4 = Nassau or Westchester
* 5 = Negotiated fare
* 6 = Group ride
* **Store_and_fwd_flag**: Indicates if the trip record was stored in the vehicle's memory before transmission to the vendor due to lack of server connection.
* Y = Store and forward trip
* N = Not a store and forward trip
* **Payment_type**: How the passenger paid for the trip, represented by a numeric code.
* 1 = Credit card
* 2 = Cash
* 3 = No charge
* 4 = Dispute
* 5 = Unknown
* 6 = Voided trip
* **Fare_amount**: The fare as calculated by the meter based on time and distance.
* **Extra**: Additional charges, currently including only the $0.50 and $1 rush hour and overnight charges.
* **MTA_tax**: A $0.50 tax automatically added based on the metered rate.
* **Improvement_surcharge**: A $0.30 surcharge added at the start of the trip, implemented since 2015.
* **Tip_amount**: Credit card tip amounts. (Note: Cash tips are not recorded here.)
* **Tolls_amount**: Total tolls paid during the trip.
* **Total_amount**: The total charge to passengers, excluding cash tips.

### Acknowledgements

Data is sourced from the NYC Taxi & Limousine Commission website.
[Link to TLC Trip Record Data](https://www1.nyc.gov/site/tlc/about/tlc-trip-record-data.page)

深入探究纽约市黄色出租车丰富多样的数据集，此数据集堪称数据科学家们的宝库。该数据集详尽记录了城市出行的点点滴滴，捕捉了每趟出租车行程的细微细节。从时间数据点如上车和下车时间，到空间维度涉及的地理位置，此数据提供了对城市交通模式的高分辨率视图。此外，它还包括诸如行程距离、车费构成、支付方式和乘客数量等定量指标。该数据由TPEP/LPEP倡议下的科技公司提供，是分析城市交通趋势、车费动态和乘客行为的重要资源。这不仅关乎出租车及其路线；更是洞察城市生命线的一扇窗口，为数据驱动的洞察和城市规划提供了无限可能。

**列描述**

* **VendorID**：为提供记录的TPEP供应商的标识符。
* 1 = Creative Mobile Technologies, LLC
* 2 = VeriFone Inc.
* **tpep_pickup_datetime**：启动计价器的日期和时间。
* **tpep_dropoff_datetime**：关闭计价器的日期和时间。
* **Passenger_count**：车辆中由司机输入的乘客数量。
* **Trip_distance**：计价器记录的行程距离（英里）。
* **PULocationID**：计价器启动时的TLC出租车区域。
* **DOLocationID**：计价器断开时的TLC出租车区域。
* **RateCodeID**：行程结束时的适用费率代码。
* 1 = 标准费率
* 2 = 纽约肯尼迪机场
* 3 = 新泽西纽瓦克机场
* 4 = 纳索或韦斯特切斯特县
* 5 = 协商费用
* 6 = 团队出行
* **Store_and_fwd_flag**：指示由于服务器连接中断，行程记录是否被存储在车辆内存中然后传输给供应商。
* Y = 存储和转发行程
* N = 非存储和转发行程
* **Payment_type**：乘客支付行程的方式，以数值代码表示。
* 1 = 信用卡
* 2 = 现金
* 3 = 免费
* 4 = 争议
* 5 = 未知
* 6 = 作废行程
* **Fare_amount**：计价器根据时间和距离计算的车费。
* **Extra**：额外费用，目前仅包括0.50美元和1美元的拥堵时段和夜间费用。
* **MTA_tax**：基于计费率自动添加的0.50美元税。
* **Improvement_surcharge**：自2015年起在行程开始时添加的0.30美元附加费。
* **Tip_amount**：信用卡小费金额。（注意：现金小费在此处未记录。）
* **Tolls_amount**：行程中支付的总税费。
* **Total_amount**：向乘客收取的总费用，不包括现金小费。

### 致谢

数据来源于纽约市出租车及豪华轿车委员会网站。
[链接至TLC行程记录数据](https://www1.nyc.gov/site/tlc/about/tlc-trip-record-data.page)