search

jawadmhoque / transit_ridership_decline

Causes of transit ridership decline
0 stars 2 forks source link

Clean up fare data #3

Closed gregerhardt closed 4 years ago

gregerhardt commented 4 years ago

Look through charts showing average fares. Identify spikes. Investigate whether the data can be traced to the NTC, or if it is a bug in our aggregation of those data. IF the former, create overrides to smooth.

jawadmhoque commented 4 years ago

There is an updated csv file on the Estimation_File folder. It contains two new rows: FARE_ADJ and FARE_ADJ_ORIGINAL. I looked at the MSAs individually to identify sudden jumps or drops in the Fare and UPT data. Corrected/ Interpolated/ Averaged where necessary. The NOTE column references such changes. But would be useful to sort the whole dataframe by PROBLEM_FLAG to see where additional assumptions are needed.