sakimori / blaseball-livestream-watcher Goto Github PK

import numpy as np
import pandas as pd
import json
from collections import defaultdict
import glob

with open('../../BIGGESTLOG.json', 'r') as f:
    sakistyle = json.load(f)

data = defaultdict(list)
for game in sakistyle:
    for batter in game['awayBatters']:
        for key in batter:
            data[key].append(batter[key])
    for batter in game['homeBatters']:
        for key in batter:
            data[key].append(batter[key])

df = pd.DataFrame(data)

df[df['_id'] == ''].to_csv('blanks_for_investigation.csv')