open-sdg / sdg-build

Python package to convert SDG-related data and metadata between formats
MIT License
6 stars 22 forks source link

Fix empty values by column to avoid datatype issues #252

Closed brockfanning closed 3 years ago

brockfanning commented 3 years ago

The way that we are fixing empty values is apparently problematic. It randomly changes the datatype of data. For example, the string "2010" can change to the float 2010.0.

More discussion here: https://stackoverflow.com/questions/59500812/pandas-dataframe-replace-change-dtype-of-columns