python3 如何解决嵌套json转csv

Question

json文件是嵌套json，目前通过遍历能存在一个list中，我想要将他存到csv中，该怎么办啊？

{"id":"oUtNZ6WK47citf2SLvtvrg_0000","full_name":"user userb","first_name":"user","middle_initial":null,"middle_name":null,"last_name":"userb","gender":null,"birth_year":null,"birth_date":null,"ABC_url":"ABC.com/in/user-userb-6137b646","ABC_username":"user-userb-6137b646","ABC_id":"163224303","facebook_url":null,"facebook_username":null,"facebook_id":null,"twitter_url":null,"twitter_username":null,"github_url":null,"github_username":null,"work_email":null,"mobile_phone":null,"industry":"media production","job_title":"communication officer","job_title_role":null,"job_title_sub_role":null,"job_title_levels":[],"job_company_id":null,"job_company_name":"plan international cambodia","job_company_website":null,"job_company_size":null,"job_company_founded":null,"job_company_industry":null,"job_company_ABC_url":null,"job_company_ABC_id":null,"job_company_facebook_url":null,"job_company_twitter_url":null,"job_company_location_name":null,"job_company_location_locality":null,"job_company_location_metro":null,"job_company_location_region":null,"job_company_location_geo":null,"job_company_location_street_address":null,"job_company_location_address_line_2":null,"job_company_location_postal_code":null,"job_company_location_country":null,"job_company_location_continent":null,"job_last_updated":"2018-12-01","job_start_date":"2010-09","job_summary":null,"location_name":"cambodia","location_locality":null,"location_metro":null,"location_region":null,"location_country":"cambodia","location_continent":"asia","location_street_address":null,"location_address_line_2":null,"location_postal_code":null,"location_geo":null,"location_last_updated":"2018-12-01","ABC_connections":10,"inferred_salary":null,"inferred_years_experience":6,"summary":"Student at Department of Media and Communication","phone_numbers":[],"emails":[{"address":"[e-mail]","type":"personal"}],"interests":[],"skills":[],"location_names":[],"regions":[],"countries":["cambodia"],"street_addresses":[],"experience":[{"company":{"name":"plan international cambodia","size":null,"id":null,"founded":null,"industry":null,"location":null,"ABC_url":null,"ABC_id":null,"facebook_url":null,"twitter_url":null,"website":null},"location_names":[],"end_date":null,"start_date":"2010-09","title":{"name":"communication officer","role":null,"sub_role":null,"levels":[]},"is_primary":true,"summary":null}],"education":[{"school":null,"end_date":"2014","start_date":"2010","gpa":null,"degrees":["bachelors","bachelor of arts"],"majors":["media management"],"minors":[],"summary":null}],"profiles":[{"network":"ABC","id":"163224303","url":"userb-6137b646","username":"user-userb-6137b646"}],"certifications":[],"languages":[],"version_status":{"status":"updated","contains":[],"previous_version":"12.0","current_version":"13.0"}}

希望能够成功转csv，至少要指定的key转出来。

Answer 1

比如存到 list1 ， 用pandas 转成DataFrame就可以存csv了

import pandas as pd
df1 =  pd.DataFrame(list1)
df1.to_csv("data.csv")