Search code examples
pythonpandasmissing-datadata-quality

Data quality - Missing values (Pandas)

I'm working on a data quality project. I'm trying to generate a data quality report using pandas-profiling profileReport but when i verify the report it says that i have no missing values while i do have empty cells. Or do you have any other suggestion Result

df = pd.read_excel('D:/SDAD/PFE/bi_bpcustomer.xls')
print(df.dtypes)
reportCl=ProfileReport(df)
reportCl.to_file(output_file='rapportClient.html')

Here's a part of my xls file showing missing cells: xls file

Solution

  • It's fine, i found a way by adding this to my code:

    missing_values = [""," "]
client= pd.read_excel('D:/SDAD/PFE/bi_bpcustomer.xls',na_values = 
missing_values)