无法将 Json 转换为熊猫 df

Question

这应该很容易，但我无法弄清楚如何将以下json文件转换为pandas df经过一个小时的尝试:https://www.sec.gov/files/company_tickers_exchange.json

有以下不常见的格式:

{"fields":["cik","name","ticker","exchange"],"data":[[320193,"Apple Inc.","AAPL","Nasdaq"],[789019,"MICROSOFT CORP","MSFT","Nasdaq"],[1652044,"Alphabet...

DF应该包含以下列:

cik, name, ticker, exchange

下面的项是:

320193,"Apple Inc.","AAPL","Nasdaq"
789019,"MICROSOFT CORP","MSFT","Nasdaq"
...

放在一起看起来像:

cik     name            ticker      exchange
320193  Apple Inc.      AAPL        Nasdaq
789019  MICROSOFT CORP  MSFT        Nasdaq
...

事先感谢您的帮助。

Answer 1

指向json中的data部分。
下面代码中的data是实际数据的子集。

import pandas as pd
data = [[320193,"Apple Inc.","AAPL","Nasdaq"],[789019,"MICROSOFT CORP","MSFT","Nasdaq"],[1652044,"Alphabet Inc.","GOOG","Nasdaq"],[1018724,"AMAZON COM INC","AMZN","Nasdaq"],[1326801,"Facebook Inc","FB","Nasdaq"]]
df = pd.DataFrame(data,columns=['id','name','short_name','other'])
print(df)

输出

id            name short_name   other
0   320193      Apple Inc.       AAPL  Nasdaq
1   789019  MICROSOFT CORP       MSFT  Nasdaq
2  1652044   Alphabet Inc.       GOOG  Nasdaq
3  1018724  AMAZON COM INC       AMZN  Nasdaq
4  1326801    Facebook Inc         FB  Nasdaq