Error handling python in excel

[jamescooper]

Hello

Where in a crosstab #NUM! is returned, how do I go about setting this to blank?

import pandas as pd
filtered_df = df[df['DOW'] == 'Monday']
ct_mean = pd.crosstab(filtered_df['Check-In'], filtered_df['Date Captured'], values=filtered_df['Current price'], aggfunc='min')

Many thanks.

 

[RoryA]

You could add

.fillna('')

to the end.

 

[jamescooper]

Thank you RoryA