support for newer pandas versions

[veenstrajelmer]

• Dddlpy version: latest release
• Python version: 3.11
• Operating System: Windows

Description

Trying to use part of the example code from the measurements.ipynb example notebook, but I get "AttributeError: module 'pandas.io.json' has no attribute 'json_normalize'". When I replace pd.io.json.json_normalize with pd.json_normalize the error is avoided. This is probably due to a newer pandas version. When looking back, they replaced normalize.py with _normalize.py from version 0.24.0 to 0.25.0, in 2019 already. Time to move on..

What I Did

import datetime as dt
import ddlpy

locations = ddlpy.locations()
codes = ['WALSODN', 'HOEKVHLD', 'IJMDBTHVN','SCHEVNGN']
parameters = ['WATHTE']
selected = locations[locations.index.isin(codes)]
selected = selected[selected['Grootheid.Code'].isin(parameters)]

# numtiple parameters avaialble per location
records = selected.loc['WALSODN']

# if we pass one row to the measurements function you can get all the measurements
measurements = ddlpy.measurements(records, dt.datetime(2010,1,1), dt.datetime(2011,1,1))

[veenstrajelmer]

Fixed in master branch already