當前位置:成語大全網 - 新華字典 - Python怎麽轉換Dictionary為DataFrame

Python怎麽轉換Dictionary為DataFrame

轉換方法:

import json

import pandas as pd

db = json.loads(open('pruItems.json', 'r').read())

pieces = []

for d in db:

if d['data']:

df = pd.DataFrame(d['data'])

df.columns = ['date', 'bid', 'ask']

df = df.set_index('date')

pieces.append(df)

df = pd.concat(pieces, axis=1, keys=[d['fund'] for d in db])

print df

TGC FEF FAF

bid ask bid ask bid ask

date

18/06/2013 34.8400 34.8400 14.9179 14.9179 6.6780 6.6780

17/06/2013 34.4900 34.4900 14.8712 14.8712 6.6510 6.6570