We must note that few of these columns are the keys of second level dictionaries as shown in the pic above. Now, for each json file we will extract the data of the relevant columns e.g. We will be using os module to browse through the directories.įirst of all, we will skim through the directory ‘descriptions’ and add all the files (filenames) into a list:- import os import json import csv def get_list_of_json_files(): list_of_files = os.listdir('descriptions') return list_of_files We will be making it a re-useable script and hence, we will not be doing any hard coding for it. So create an empty ‘output.csv’ file and copy paste the above line as the header in it:- $ nano output.csv _id,_modelType,creator_id,creator_name,dataset_accessLevel,dataset_id,dataset_description,dataset_name,meta_acquisition_image_type,meta_acquisition_pixelsX,meta_acquisition_pixelsY,meta_clinical_age_approx,meta_clinical_benign_malignant,meta_clinical_diagnosis,meta_clinical_diagnosis_confirm_type,meta_clinical_melanocytic,meta_clinical_sex,meta_unstructured_diagnosis,meta_unstructured_race,name

We need to parse the following columns from the json file and convert it to csv file:.

Convert json to csv excel