I currently have a parquet file that contains date above the pandas timestamp limit. Because of that, the dates gets converted to values that I do not want.
Date inserted to parquet file:
05/01/1927
05/01/2322
Using the code:
df = pd.read_parquet('dateTest.parquet')
print(df)
will appear as
0 1 1927-05-01 00:00:00.000000000
1 2 1737-10-10 00:25:26.290448384
What would be the best approach to reading the parquet file & show the out of bound date as blank instead? like the error=coerce option