Add option to pass na_filter into pd.read_csv() - Dealing with CSV containing NA as string

[dazzag24]

I have a CSV detailing info about airports. The country code column is encoded using 2 character ISO-3166 codes. https://en.wikipedia.org/wiki/List_of_ISO_3166_country_codes

It turns out that the code for Namibia is "NA" and this results in the values being stripped as it converts from CSV to SQLite DB.

I was able to solve this by adding na_filter=False to the pd.read_csv() call in utils.py

csvs-to-sqlite/csvs_to_sqlite/utils.py

Line 24 in dccbf65

return pd.read_csv(

Would you consider adding an option to allow this flag to be passed into the pd.read_csv call?

Thanks
Darren

[frafra]

I agree, I have the same issue.