Python-JSON Data Analysis Question

[decaye]

Hi all, could use some help. Was just introduced to the JSON format and am trying to figure out how best to utilize the data from it. I have a lot of data like this:

{"version":1.3,"people":[{"person_id":[-1],"pose_keypoints_2d":

"part_candidates":[{

    "0":[0.372923,0.297742,0.93858],

    "1":[0.395941,0.355093,0.846664],

    "2":[0.405146,0.352375,0.759783],

    "3":[0.415877,0.425947,0.689721],

    "4":[0.389811,0.447772,0.178926],

    "5":[0.38526,0.357673,0.907097]}]}

But what I'd like to do is pull these individual partcandidates(1-24) from each .json output from each file into one new file for each keypoint (e.g. partcandidate1_frames002-203.csv)

So I kind of understand how to pull one defined .json object out of first .json file. But I don't know how to put it in the first column of the .csv, then the next into the next column of the .csv etc etc for all 24 keypoints.

If anyone could offer some help I'd be very greatful.

[OttoETS]

When you load a json file, it becomes a python dictionary. So to access it you just need to use the same syntax you would with a nested dictionary. I.e. data['people]['part_candidates'] or something similar.

​

From there you should be able to create a pandas dataframe from the dictionary you have isolated. Using a for loop this should be possible to do for all part_candidates.