首页 > 解决方案 > 如何修复 GET JSON 的“尝试运行错误”并创建 DataFrame

问题描述

我正在尝试获取 JSON 数据,提取“pull_request_contributors”将其添加到 DF 并设置索引。

我得到错误:

KeyError: "Try running with errors='ignore' as key 'pull_request_contributors' is not always present"

代码

cg = CoinGeckoAPI()

ts = '01-01-2017'
cs = 'bitcoin'

# get data
result = cg.get_coin_history_by_id(cs, ts)

#pull_request_contributors
df_pr = pd_json.json_normalize(data, 
                            record_path='developer_data', 
                            meta=['pull_request_contributors']).set_index(ts)

JSON:

{'community_data': {'facebook_likes': 40055,
  'reddit_accounts_active_48h': '4657.4',
  'reddit_average_comments_48h': 186.5,
  'reddit_average_posts_48h': 3.75,
  'reddit_subscribers': 1014816,
  'twitter_followers': 64099},
 'developer_data': {'closed_issues': 3845,
  'commit_count_4_weeks': 245,
  'forks': 22024,
  'pull_request_contributors': 564,
  'pull_requests_merged': 6163,
  'stars': 36987,
  'subscribers': 3521,
  'total_issues': 4478}...

我期望df:

date        bitcoin 
01-01-2017  564

标签: pythonjsonpandas

解决方案


推荐阅读