Automatidata works with its clients to transform their unused and stored data into useful solutions, such as performance dashboards, customer-facing tools, strategic business insights, and more. They specialize in identifying a client’s business needs and utilizing their data to meet those business needs.
Automatidata is consulting for the New York City Taxi and Limousine Commission (TLC). New York City TLC is an agency responsible for licensing and regulating New York City's taxi cabs and for-hire vehicles. The TLC data comes from over 200,000 taxi and limousine licensees, making approximately one million combined trips per day.
To Develop a Regression Model that helps estimate taxi fares before the ride, based on the data gathered by New York City Taxi and Limousine Commission (TLC).
Python
2017_Yellow_Taxi_Trip_Data nyc_pred_means
The model reveals that for every mile travelled the fare increases by $2. Or for every 3.57 miles travelled, the fare increases by $7.13.
The model provides a generally strong and reliable fare prediction that can be used in downstream modeling efforts.
These findings can be used to create an app that allows NYC TLC riders to see the estimated fare before their ride begins. Model Metrics: Model metrics:
R-squared 0.868: This means that 86.8% of the variance is described by the model.
MAE 2.13
MSE: 14.34
RMSE 3.8
Executive summary on Initial Data Exploration
Executive summary on Exploratory Data Analysis
Executive summary on Hypothesis Testing