Skip to content

De-aggregate subway ridership data into daily values #24

@idreyn

Description

@idreyn

Right now we aggregate subway ridership value into weekday means for a given week:

final = final.groupby(["year", "week", "route_or_line"])["validations"].mean().round().reset_index()

This is because we copied this code from the Covid Recovery Dash, which did this to provide a direct comparison to bus ridership data, which is only available weekly. But elsewhere, we can store and display daily subway ridership data.

We probably want to preserve the weekly aggregates, so this task will involve creating a second table to hold the daily (or weekly) ridership.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions