Write a JSON String to CSV using Python

Question

I know this question has been asked many times. I tried several solutions but I couldn't solve my problem.

I have a nested JSON file and I would like to convert it to a CSV file.

The JSON structure is like this:

[
  {
    "audio_analysis": [
      {
        "audio_percentage": 0.10006836243325763,
        "audio_completed": false,
        "audio_fast_forwarded": false,
        "audio_rewinded": false,
        "episode_downloaded": true,
        "listened_episode_time": 1799,
        "episode": 1,
        "elapsed_time": 1799,
        "location": {
          "": ""
        }
      },
      {
        "audio_percentage": 0.10290520872791918,
        "audio_completed": false,
        "audio_fast_forwarded": true,
        "audio_rewinded": true,
        "episode_downloaded": true,
        "listened_episode_time": 1850,
        "episode": 1,
        "elapsed_time": 1850,
        "location": {
          "": ""
        }
      }
    ],
    "correct_answers": 1,
    "count_completed_episodes": 0,
    "count_downloaded_episodes": 2,
    "total_time_spent_listening": 3649,
    "season": "Tiraarka Qoyska - Taxanaha 1aad",
    "user": "Joseph Kimani"
  }
]

The desired output should in the format attached on the below link.

csv output

Possible dupe, stackoverflow.com/questions/41180960/…

sushanth
– sushanth

2020-07-07 06:54:33 +00:00
Commented Jul 7, 2020 at 6:54 — sushanth
– sushanth, Commented Jul 7, 2020 at 6:54

r-beginners · Accepted Answer · 2020-07-07 08:00:49Z

0

pandas.normalize() to set the record (record_path ) and the other columns (meta).

data = pd.json_normalize(data, record_path='audio_analysis', meta=['correct_answers','count_completed_episodes','count_downloaded_episodes','total_time_spent_listening','season','user'])
data.to_csv('filename.csv')

    audio_percentage    audio_completed audio_fast_forwarded    audio_rewinded  episode_downloaded  listened_episode_time   episode elapsed_time    location.   correct_answers count_completed_episodes    count_downloaded_episodes   total_time_spent_listening  season  user
0   0.100068    False   False   False   True    1799    1   1799        1   0   2   3649    Tiraarka Qoyska - Taxanaha 1aad Joseph Kimani
1   0.102905    False   True    True    True    1850    1   1850        1   0   2   3649    Tiraarka Qoyska - Taxanaha 1aad Joseph Kimani

edited Jul 7, 2020 at 8:00

answered Jul 7, 2020 at 7:55

r-beginners

35.6k3 gold badges20 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Write a JSON String to CSV using Python

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related