convert MVT records from json to csv

convert_to_csv.py

import pandas as pd
import json
import os

filenames = next(os.walk('.'), (None, None, []))[2]

# read json
for filename in filenames:
    if '.csv' in filename:
        continue
    if '.json' in filename:
        print(filename)
        with open(filename, 'r') as f:
            data = json.load(f)
            # create dataframe
            df = pd.json_normalize(data)
            #write .csv
            df.to_csv(os.path.splitext(filename)[0] + '.csv', index=True, encoding='utf-8')