Rows with with NaN in double column is skipped

Hi quicksight community!

I was working with importing a dataset and all of the rows was skipped because a column has NaN in a double column. I suppose the user used Pandas to generate the tables, so before I ask them to change their format. Is there anything I can do on quicksight side? and what would be the appropriate representation of Nulls in a double column for quicksight.

Thanks!

You can handle the data transformation by using calculated field in QuickSight. You can change the data type to be string to import this column and create a calculated field to use ifelse condition to modify the Null values to zero. Lastly, change back this field’s data type to decimal by using parseDecimal