熊猫：将 Yfinance 字典转换为数据框，但该行为空

Question

我有一个像这样的 Yfinance 字典：

{'zip': '94404', 'sector': 'Healthcare', 'fullTimeEmployees': 11800, 'circulatingSupply': None, 'startDate': None, 'regularMarketDayLow': 67.99, 'priceHint': 2, 'currency' ： '美元'}

我想将它转换成 DataFrame 但输出没有关于行的信息：

Jupyter 笔记本视图：

Answer 1

Data = {'zip': '94404', 'sector': 'Healthcare', 'fullTimeEmployees': 11800, 'circulatingSupply': None, 'startDate': None, 'regularMarketDayLow': 67.99, 'priceHint': 2, 'currency': 'USD'}字典变量周围的第三个括号：df = pd.DataFrame([Data])df结果：     zip    sector   fullTimeEmployees  circulatingSupply   startDate   regularMarketDayLow priceHint   currency0   94404   Healthcare  11800               None              None          67.99              2         USD

Answer 2

# Data returned back by yfinancestock = yf.Ticker('AAPL')# Store stock info as dictionarystock_dict = stock.info# Create DataFrame from non-compatible dictionarystock_df = pd.DataFrame(list(stock_dict.items()))    0   10   zip 950141   sector  Technology2   fullTimeEmployees   1370003   longBusinessSummary Apple Inc. designs, manufactures, and markets ...4   city    Cupertino5   phone   408-996-10106   country United States7   companyOfficers []8   website http://www.apple.com9   maxAge  110  address1    One Apple Park Way