shyamsrinivasan / sqlpy

python front-end for SQL db
0 stars 0 forks source link

Pandas converts empty excel fields to Nan which raises exception #5

Closed shyamsrinivasan closed 2 years ago

shyamsrinivasan commented 2 years ago

When data provided in excel has empty fields, they are converted to Nan by pandas. This raises an exception in other parts of the code when used as is. When reading data from excel into pandas dataframe, change Nan to relevant empty data type. 6b004ba978161397683f74848617e8214163f56a