I am converting an excel sheet to .shp via pandas i.e. I have a dataframe with 150+ columns and ~900 records (increasing by about 50 every day), that I convert to geodataframe and export to shp:
output_data.to_file(filename, driver='ESRI Shapefile')
Saving this data to shp in Global Mapper creates a 3.5MB dbf
In QGIS, a 14MB dbf
Using Geopandas 6.5MB dbf
I've seen that the geodataframe has 15 decimal places for every numeric field, including whole numbers. Same thing for QGIS. Global Mapper's field lengths are equal to the lengthiest field in each column.
How can I keep geopandas from adding 15 decimals? I assume this is what bloats the filesize since I refactored some fields in QGIS and got a much smaller output dbf. The fields are also shorter in pandas df, before converting to geodf.