從json中提取資料，使用for回圈追加并另存為CSV

我已經使用 Tweepy 為 102 位政客提取了id、username和name的 100 個追隨者。資料存盤在名為 .json 的 JSON 檔案中pol_followers。現在我希望使用下面的函式附加id并username保存為 CSV 檔案。但是，在最后一行中使用該函式時，append_followers_to_csv(pol_followers, "pol_followers.csv")我會在底部看到錯誤。

# Structure of pol_followers. The full pol_followers is much longer... 
print(json.dumps(pol_followers, indent=4, sort_keys=True))  # see json data structure

[
{
        "data": [
            {
                "id": "1464206217807601666",
                "name": "terry alex",
                "username": "terryal51850644"
            },
            {
                "id": "1479032154394968064",
                "name": "Charles Williams",
                "username": "Charles99924770"
            },
            {
                "id": "2526015770",
                "name": "LISA P",
                "username": "LISAP0910"
            },
            {
                "id": "2957692520",
                "name": "fayaz ahmad",
                "username": "ahmadfayaz202"
            }
        ],
        "meta": {
            "next_token": "F6HS7IU5SRGHEZZZ",
            "result_count": 100
        }
    },
    {
        "data": [
            {
                "id": "2482703136",
                "name": "HieuVu",
                "username": "sachieuhaihanh"
            },
            {
                "id": "580882148",
                "name": "Maxine D. Harmon",
                "username": "maxxximd"
            },
            {
                "id": "1478867472841334787",
                "name": "RBPsych1",
                "username": "RBPsych1"

# Create file
csv_follower_file = open("pol_followers.csv", "a", newline="", encoding='utf-8')
csv_follower_writer = csv.writer(csv_follower_file)

# Create headers for the data I want to save. I only want to save these columns in my dataset
csv_follower_writer.writerow(
    ['id', 'username'])
csv_follower_file.close()\


def append_followers_to_csv(pol_followers, csv_follower_file):
    # A counter variable
    global follower_id, username
    counter = 0

    # Open OR create the target CSV file
    csv_follower_file = open(csv_follower_file, "a", newline="", encoding='utf-8')
    csv_follower_writer = csv.writer(csv_follower_file)

    for ids in pol_followers['data']:

        # 1. follower ID
        follower_id = ids['id']

        # 2. follower username
        username = ids['username']

        # Assemble all data in a list
        ress = [follower_id, username]

        # Append the result to the CSV file
        csv_follower_writer.writerow(ress)
        counter  = 1

        # When done, close the CSV file
        csvFile.close()

    # Print the number of tweets for this iteration
    print("# of Tweets added from this response: ", counter)


append_followers_to_csv(pol_followers, "pol_followers.csv")  # Save tweet data in a csv file

 File "<input>", line 1, in <module>
  File "<input>", line 11, in append_followers_to_csv
TypeError: list indices must be integers or slices, not str

uj5u.com熱心網友回復：

您只是缺少額外的回圈，如下所示：

for each_dict in pol_followers:
    for ids in each_dict['data']:
        follower_id = ids['id']
        username = ids['username']

uj5u.com熱心網友回復：

您似乎已將 JSON 物件包裝在一個串列中，因此當您在append_followers_to_csv函式中進行迭代時，您不是獲取 JSON 的“資料”位，而是獲取串列的“資料”元素，這是您無法獲得的用蟒蛇做。嘗試洗掉 JSON 周圍的方括號或將其設為for ids in pol_followers[0]['data'].

標籤：

上一篇：Android改造更改發布請求中的日期格式“yyyy-MM-ddhh:mm:ss”

下一篇：如何對python陣列進行base64編碼，而不是對其進行雙重編碼？