# since the data is nested, we use json_normalize to unnest df = pd.json_normalize(dataset1, max_level=2) df # this however does not unnest as we need it
survey_idobject
AM2000DHS0.5%
AM2005DHS0.5%
197 others99%
countryobject
Senegal5.5%
Bangladesh4%
50 others90.5%

0

AM2000DHS

Armenia

1

AM2005DHS

Armenia

2

AM2010DHS

Armenia

3

AM2016DHS

Armenia

4

BU2010DHS

Burundi

5

BU2016DHS

Burundi

6

BJ1996DHS

Benin

7

BJ2001DHS

Benin

8

BJ2006DHS

Benin

9

BJ2012DHS

Benin

Hosted onDeepnote