vkoves / electrify-chicago

Learn about Chicago's most polluting buildings, and what they can do to clean up their act!
http://electrifychicago.net
9 stars 5 forks source link

Fix pandas data type interpretation #78

Open alexkcode opened 3 months ago

alexkcode commented 3 months ago

For certain fields the data type is being interpreted as something undesirable before being converted, changing the data institutionally. For example, this happens with 'Latitude', 'Longitude', which gets truncated as a float type before it gets converted to a string type. This could be happening with other columns as well, but only those two columns are confirmed. We should give the pandas read_csv method fixed data types (at least for the columns we care about and have fixed type information for) to read the data.