Load multiple Jason data in one Data Frame

[Larz60+]

Try:

import pandas as pd
import os
from pathlib import Path


jpath = Path('C://JsonFiles//')
filelist = [filename for filename in jpath.iterdir()
    if filename.is_file() and filename.suffix == '.json']

df = pd.DataFrame([pd.read_json(file, typ="series") for file in filelist])
print(df)