The Python Oracle

Using pandas and json_normalize to flatten nested JSON API response

Become part of the top 3% of the developers by applying to Toptal https://topt.al/25cXVn

--

Music by Eric Matyas
https://www.soundimage.org
Track title: Techno Bleepage Open

--

Chapters
00:00 Question
03:54 Accepted answer (Score 16)
04:20 Answer 2 (Score 2)
04:53 Thank you

--

Full question
https://stackoverflow.com/questions/5319...

Question links:
[json_normalize]: https://pandas.pydata.org/pandas-docs/st...
[generic sample]: https://developer.surveymonkey.com/api/v...
[SurveyMonkey API response output]: https://developer.surveymonkey.com/api/v...
["all responses" excel sheet that their export service provides]: https://help.surveymonkey.com/articles/e...
[.apply()]: https://pandas.pydata.org/pandas-docs/st...
[survey structure API output]: https://developer.surveymonkey.com/api/v...

Answer 1 links:
[flatten package]: https://github.com/amirziai/flatten
[example usage]: https://github.com/amirziai/flatten#usag...

--

Content licensed under CC BY-SA
https://meta.stackexchange.com/help/lice...

--

Tags
#python #json #pandas #surveymonkey

#avk47