-
Ngoc Thuy Dung Tran authoredNgoc Thuy Dung Tran authored
Code owners
Assign users and groups as approvers for specific file changes. Learn more.
tidy_data.py 510 B
#%%
import json
import pandas as pd
from helpers import get_raw_data_path, get_tidy_data_path
tidy_data_path = get_tidy_data_path()
tidy_data_path.mkdir(parents=True, exist_ok=True)
print(tidy_data_path)
#%%
with open(get_raw_data_path() / 'current.json', 'r') as f:
d = json.load(f)
# df = pd.json_normalize(d['MRData']['RaceTable']['Races'][0]['Results'])
df = pd.json_normalize(d["InsuranceCompanies"]["Top Insurance Companies"])
print(d)
#%%
df.to_parquet(tidy_data_path / 'current_race.parquet')