Convert multiple json to text


Wed Jun 15 2022 09:50:23 GMT+0000 (Coordinated Universal Time)

Saved by @edubrigham #python #json #converter

import os
import pandas as pd

# Get the list of json files, which are in the folder:   
str_address = r"/media/New Volume/a3d/pdb/json_parser/"
lst_files = [i for i in os.listdir(str_address) if i.endswith(".json")]

# Loop through the json files
for file_ in lst_files: 
    df = pd.read_json(str_address + file_)
    df.to_csv(str_address+ file_+ ".txt", index = False)