读取json文件pandas时发生异常: ValueError数组的长度必须相同

Question

path = r'\\xxxxxx\JIRA_BOW_11670.JSON'
load_df=pd.read_json(path)

出现异常: ValueError数组的长度必须相同

我把json文件剪短了，只需要ID和显示名，无法读取文件

{"expand": "description,lead,issueTypes,url,projectKeys,permissions,insight",
     "self": "https://xxx.atlassian.net/rest/api/3/project/11670",
      "id": "11670", "key": "FSD", "description": "",
       "lead": {"self": "https://xxx.atlassian.net/rest/api/3/user?accountId=5e5fabed27b3910afc2fcd44", "accountId": "5e5fabed27b3910afc2fcd44", "avatarUrls": {"48x48": "https://secure.gravatar.com/avatar/8b50ca39af21105162b4d362324f8b74?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FNM-0.png", "24x24": "https://secure.gravatar.com/avatar/8b50ca39af21105162b4d362324f8b74?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FNM-0.png", 
        "16x16": "https://secure.gravatar.com/avatar/8b50ca39af21105162b4d362324f8b74?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FNM-0.png", "32x32": "https://secure.gravatar.com/avatar/8b50ca39af21105162b4d362324f8b74?d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FNM-0.png"}, "displayName": "Ntombi Mahlangu"}

Answer 1

显然，问题来自于熊猫的更新。请阅读这篇文章：https://stackoverflow.com/a/63581744/3958878

你可以通过降低你的pandas版本来解决这个问题