Im reading an excel sheet using the pandas read_excel which gives me a dataframe then Im using df.to_json(…) to convert the dataframe into json string. However when there are no values in the excel cell its coming as empty string “” in json. The question how do I ensure empty cells are translated to null values in json?

Thanks for your help.