在pandas中将字典转换为DataFrame

Question

我使用了以下代码：

import pandas as pd
from yahoofinancials import YahooFinancials

mutual_funds = ['PRLAX', 'QASGX', 'HISFX']
yahoo_financials_mutualfunds = YahooFinancials(mutual_funds)
daily_mutualfund_prices = yahoo_financials_mutualfunds.get_historical_price_data('2015-01-01', '2021-01-30', 'daily')

我得到一个字典作为输出文件。我想得到一个包含以下列的pandas数据帧：data, PRLAX, QASGX, HISFX，其中数据是每个股票行情的formatted_date和开盘价

pandas dataframe

Answer 1

你能做的是：

df = pd.DataFrame({
    a: {x['formatted_date']: x['adjclose'] for x in daily_mutualfund_prices[a]['prices']} for a in mutual_funds
})

这就给出了：

           PRLAX      QASGX      HISFX
2015-01-02  19.694817  17.877445  11.852874
2015-01-05  19.203604  17.606575  11.665626
2015-01-06  19.444574  17.316357  11.450289
2015-01-07  19.963596  17.616247  11.525190
2015-01-08  20.260176  18.003208  11.665626
...               ...        ...        ...
2021-01-25  21.799999  33.700001  14.350000
2021-01-26  22.000000  33.139999  14.090000
2021-01-27  21.620001  32.000000  13.590000
2021-01-28  22.120001  32.360001  13.990000
2021-01-29  21.379999  31.709999  13.590000

[1530 rows x 3 columns]

或字典中的任何其他值。