Closed PrettyWood closed 9 months ago
the following values are now interpreted as null: ‘’, ‘#N/A’, ‘#N/A N/A’, ‘#NA’, ‘-1.#IND’, ‘-1.#QNAN’, ‘-NaN’, ‘-nan’, ‘1.#IND’, ‘1.#QNAN’, ‘<NA>’, ‘N/A’, ‘NA’, ‘NULL’, ‘NaN’, ‘None’, ‘n/a’, ‘nan’, ‘null’. (list taken from https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.read_excel.html)
‘’, ‘#N/A’, ‘#N/A N/A’, ‘#NA’, ‘-1.#IND’, ‘-1.#QNAN’, ‘-NaN’, ‘-nan’, ‘1.#IND’, ‘1.#QNAN’, ‘<NA>’, ‘N/A’, ‘NA’, ‘NULL’, ‘NaN’, ‘None’, ‘n/a’, ‘nan’, ‘null’.
For now no need to add a param to override this list I reckon
closes #181 I say most because I didn't add support for date / utf mixed types as it's a bit unclear for me if it's a good idea or not...
Thank you!
adrivn
commented
9 months ago adrivn
commented
9 months ago
the following values are now interpreted as null:
‘’, ‘#N/A’, ‘#N/A N/A’, ‘#NA’, ‘-1.#IND’, ‘-1.#QNAN’, ‘-NaN’, ‘-nan’, ‘1.#IND’, ‘1.#QNAN’, ‘<NA>’, ‘N/A’, ‘NA’, ‘NULL’, ‘NaN’, ‘None’, ‘n/a’, ‘nan’, ‘null’.(list taken from https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.read_excel.html)For now no need to add a param to override this list I reckon
closes #181 I say most because I didn't add support for date / utf mixed types as it's a bit unclear for me if it's a good idea or not...