The question refers above all to what to do in the absence of data.
How to fill in those cells in Excel - explicitly indicating that a data is missing, that is: not leaving them blank?
In Python there is None
; in Pandas we even have NaN
, but how to make these values be read correctly by Excel?
You could use pandas
, although I would prefer the module csv
built into the standard library.
Thanks for your suggestions.
Thanks actually to a vulnerability in Excel known as formula injection , it's entirely possible to do this, even on a file
csv
that by its nature represents passive data.The idea would be to use the functions
NOD()
that return a value "Not available",#N/A
or#N/D
depending on the language. It's as simple as specifying the formula in the filecsv
:Obviously this doesn't seem like a "feature", so eventually it might one day stop working.