使用FOR循环的数据更新列

Question

我有下面的代码，我需要打印的输出更新一个新的列

import pandas as pd
import re
import numpy as np
import urllib.parse
from urllib.request import urlopen
import requests
from bs4 import BeautifulSoup
df = pd.read_csv('IR006.csv')
pd.set_option('display.max_colwidth', -1)

df4 = pd.read_csv('IR006.csv')
df4['UPDATE'] = "" **#This is the column where i wanna see the output of the for loop**

下面是从URL获取数据的循环--

for link in df4.iterrows():
    url = link[1]['URL'].replace('/v01/', '/depot/')
    x = urlopen(url)
    new = x.read()
    soup = BeautifulSoup(new, "lxml-xml")
    match = ''.join(re.findall(r"[C][L]\S{8}", str(soup)))
    print(match)

output:

CLdbDQgFdD
CLYwHQYDVR

CLYwHQYDVR
CLYwHQYDVR

CLYwHQYDVR

Dataframe如下所示：DATAFRAME，那么如何将生成循环的数据放入新的列名“UPDATE”中呢

Answer 1

请尝试以下代码：

for idx,row in df4.iterrows():
    url = row['URL'].replace('/v01/', '/depot/')
    x = urlopen(url)
    new = x.read()
    soup = BeautifulSoup(new, "lxml-xml")
    match = ''.join(re.findall(r"[C][L]\S{8}", str(soup)))
    df4.at[idx,'UPDATE'] = match