從json中提取日期和數字并將它們附加到Pandas資料幀

我想提取日期和強力球號碼并將它們附加到熊貓資料框。我已經制作了列，但似乎無法將資料獲取到列中。當我轉到. 但是當我嘗試列出數字 IE ['8'] 或 ['9'] 時，它不會附加資料。我已經為此作業了大約 3 天。提前致謝。

###########
# MODULES #
###########
import json
import requests
import urllib
import pandas as pd

###########
# HISTORY #
###########

#We need to pull the data from the website.
#Then we need to organize the numbers based off of position.
#Basically it will be several lists of numbers
URL = "https://data.ny.gov/api/views/d6yy-54nr/rows"
r = requests.get(URL)
my_json = r.json()
#my_json_dumps = json.dumps(my_json, indent = 2)
#print(my_json_dumps)
df = pd.DataFrame(columns=["Date","Powerball Numbers","1","2","3","4","5","6","7"])#Create columns in df
for item in my_json['data']:
    df = pd.DataFrame(my_json['data'])
    l_date = df.iloc['8']#Trying to pull columns from json
    p_num =  (df.iloc['9'])#Trying to pull columns from json
    df = df.append({"Date": l_date,
                    "Powerball Numbers": p_num, 
                    },ignore_index=True)
    #test = item['id']
    print(l_date)

編輯：這就是我想要得到的。

uj5u.com熱心網友回復：

試試這個：

舊代碼：

l_date = df.iloc['8'] #Trying to pull columns from json
p_num =  (df.iloc['9']) #Trying to pull columns from json

用引號df.iloc['8']更改此行：

l_date = df.iloc[8] # without quotation
p_num =  (df.iloc[9]) # without quotation

作業正常。結果是：

0                       row-w3y7.4r9a-caat
1     00000000-0000-0000-3711-B495A26E6E8B
2                                        0
3                               1619710755
4                                     None
5                               1619710755
6                                     None
7                                      { }
8                      2020-10-24T00:00:00
9                        18 20 27 45 65 06
10                                       2
Name: 8, dtype: object
0                       row-w3y7.4r9a-caat
1     00000000-0000-0000-3711-B495A26E6E8B
2                                        0
3                               1619710755
4                                     None
5                               1619710755
6                                     None
7                                      { }
8                      2020-10-24T00:00:00
9                        18 20 27 45 65 06
10                                       2

希望對你有幫助。

uj5u.com熱心網友回復：

我是這樣做的：

URL = "https://data.ny.gov/resource/d6yy-54nr.json"
r = requests.get(URL)
my_json = r.json()
for item in my_json:
    df = pd.DataFrame(my_json)
    l_date = item['draw_date']#Trying to pull columns from json
    p_num =  item['winning_numbers']#Trying to pull columns from json
    n_list = list(map(int, p_num.split())) #Convert powerball numbers into list
    n_1 = n_list[0]
    n_2 = n_list[1]
    n_3 = n_list[2]
    n_4 = n_list[3]
    n_5 = n_list[4]
    n_6 = n_list[5]
    df1 = pd.DataFrame(columns=["Date","Powerball Numbers", "1","2","3","4","5","6"])#Create columns in df
    df = df1.append({"Date": l_date,
                    "Powerball Numbers": p_num, 
                    "1": n_1,
                    "2": n_2,
                    "3": n_3,
                    "4": n_4,
                    "5": n_5,
                    "6": n_6,
                    },ignore_index=True)
    print(df)

其中產生

標籤：Python json 熊猫 解析 蟒蛇请求

上一篇：正則運算式匹配JCL作業卡的最后一行或整張卡

下一篇：Go - 如何撰寫 ProtoBuf 插件（二）？