There is an issue when we try to pull data from multiple sites when time series have two differents date format.
The function read_json() try to keep the default date format. In the first case the type of the date is an object and in the second case it is a dateformat64. There is a mismatch when we try to merge two dataframe with different object type.
2020-01-01T00:00:00.000-06:00 (type is Object)
2020-01-01 00:00:00.000-06:00 (type is datetime64)
I fixed it with the "keep_default_dates=False".
record_df = pd.read_json(record_json,
orient='records',
dtype={'value': 'float64',
'qualifiers': 'unicode'},
keep_default_dates=False)
Thanks
There is an issue when we try to pull data from multiple sites when time series have two differents date format.
The function read_json() try to keep the default date format. In the first case the type of the date is an object and in the second case it is a dateformat64. There is a mismatch when we try to merge two dataframe with different object type.
2020-01-01T00:00:00.000-06:00 (type is Object)
2020-01-01 00:00:00.000-06:00 (type is datetime64)
I fixed it with the "keep_default_dates=False".
Thanks