This data is stored in an OracleDB, queried in NodeJS, passed in using EJS and formatted as a chart using ChartJS.
This app uses a sampling of 7.8 million rows of taxicab trip data from the years of 2018-2020. This data was downloaded from https://www1.nyc.gov/site/tlc/about/tlc-trip-record-data.page . This data was then sampled (~5%) using a Python script and Pandas. The data was then cleaned using a combination of SQL scripts.
Excuse the app's appearance, I did not want to spend the unecessary time learning enough CSS to make it look pretty.
* This app is not published on the public internet and cannot be locally hosted by anyone without a UF gatorlink account. For this reason, some sample screenshots are posted below:
Home page:
Taxi Drivers page (example query):
Business Owners page (sample query):
Riders page (sample query):
