python - 为什么我的 DataFrame 将添加内容复制到特定列？

Question

我正在尝试在 for 循环中按顺序将新数据添加到 DataFrame。它成功写入了我（我认为）选择的 DataFrame 列，但它也将数据写入了我不想编辑的另一列。为什么要这样做？我该如何解决？

# Resetting the data
supplier_rics = supplier_sheet['RICs']
supplier_rics = supplier_rics.dropna()

# Create a DataFrame object that will contain our headlines
supplier_headlines = pd.DataFrame(data={'RIC':supplier_rics},columns=['RIC','Headline'])
supplier_headlines

for i, ric in supplier_rics.iteritems():
    # Add R: prefix to RICS for news search
    supplier_rics[i] = "R:"+supplier_rics[i]

    # Create the news query
    query = supplier_rics[i] + ' AND (Topic:SIG AND Language:LEN)'

    # Make the Eikon API Call 
    headline = ek.get_news_headlines(query=query,count=1)
    headline_string = headline['text'].to_string(index=False)
    # Add the headline text to the supplier_headlines DataFrame Object
    supplier_headlines.iloc[[i,2]] = headline_string

标签： pythonpandasrefinitiv-eikon-api