The data is available from https://data.seattle.gov/Transportation/Fremont-Bridge-Daily-Bicycle-Counts/eytj-7qg9/data
The daily.csv
file was created with the following Python script:
import pandas as pd
data = pd.read_csv('https://data.seattle.gov/api/views/eytj-7qg9/rows.csv?accessType=DOWNLOAD')
data = data.rename({'Fremont Bridge West Sidewalk': 'West Sidewalk',
'Fremont Bridge East Sidewalk': 'East Sidewalk'}, axis=1)
data = data.melt('Date', var_name='Side', value_name='Daily Crossings')
data.to_csv('daily.csv', index=False)