Hi @neha ,
I tried .fillna(np.nan) - same result. For me helped below:
real_data[['afsluitdatum', 'openingsdatum']] = \
real_data[['afsluitdatum', 'openingsdatum']].apply(pd.to_datetime)
I load data from csv files:
real_data = pd.read_csv("file.csv")
real_data= real_data.convert_dtypes()
In real_data.dtypes I get:
openingsdatum string[python]
afsluitdatum string[python]