I’m prepping some data in Python (pandas data frames) where certain columns don’t have a value for each row, e.g. are NULL or NaN for integers and floats. However, when writing the dataframe as Excel file and then loading this into Celonis CPM46 I get the error as below. When writing as CSV I do not get this error on the same data, but the files are far larger and therefore take longer to upload (working from home )
Any idea or tips how to handle this?