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.