d6t / d6tstack

Quickly ingest messy CSV and XLS files. Export to clean pandas, SQL, parquet
MIT License
195 stars 45 forks source link

error while dumping NA values #9

Closed girijesh18 closed 5 years ago

girijesh18 commented 5 years ago

Hi, First of all, thank you very much for such a wonderful library. I am facing while dumping data to MySQL database. The NA and blank are getting either 'Null' or 'blank' randomly in the database. For eg. If some value in CSV is 'null' or 'NA' then after dumping this kind of CSV into database these values become 'NA' or blank.

Can you please address this problem.

d6tdev commented 5 years ago

it should work, closing for now, reopen if it doesnt