search

CodeWithAloha / Hawaii-Zoning-Atlas

Interactive map showing how outdated zoning laws make it hard to build diverse, affordable housing in Hawaii.
https://hawaiizoningatlas.com
MIT License
22 stars 11 forks source link

🐛 [BUG] - redundant headers appended to last rows of spreadsheet tabs #93

Open tyliec opened 1 year ago

tyliec commented 1 year ago

Contact Details

No response

What happened?

In the CSV file being ingested into the Python Notebook, there are redundant headers being put in from the original data spreadsheet link.

Examples of redundant headers:

  1. https://github.com/CodeWithAloha/Hawaii-Zoning-Atlas/blob/6d15833259f346e3edafa4f9aedee85611ca23ba/data/hawaii-zoning-data.csv#L132
  2. https://github.com/CodeWithAloha/Hawaii-Zoning-Atlas/blob/6d15833259f346e3edafa4f9aedee85611ca23ba/data/hawaii-zoning-data.csv#L570C302-L570C302
  3. https://github.com/CodeWithAloha/Hawaii-Zoning-Atlas/blob/6d15833259f346e3edafa4f9aedee85611ca23ba/data/hawaii-zoning-data.csv#L674

Reproduction steps

1. Go to original data spreadsheet (https://docs.google.com/spreadsheets/d/1YGt_Y70oy6qc09ZZ7kip9DM2JGtRC2fAHxi6JXOIsSk/edit#gid=448730928) and observe tab headers
2. go to output csv and observe redundant tab headers in csv format: https://github.com/CodeWithAloha/Hawaii-Zoning-Atlas/blob/main/data/hawaii-zoning-data.csv#L674

Screenshots

No response

Logs

No response

Browsers

No response

OS

No response

Code of Conduct