AttributeError:“系列"对象没有属性"iterrows" [英] AttributeError: 'Series' object has no attribute 'iterrows'

问题描述

accounts = pd.read_csv('C:/*******/New_export.txt', sep=",", dtype={'number': object})
accounts.columns = ["Number", "F"]

for i, j in accounts["Number"].iterrows(): #i represents the row(index number), j is the number
    if (str(j) == "27*******5"):
        print(accounts["F"][i], accounts["Number"][i])

我收到以下错误:

AttributeError:系列"对象没有属性"iterrows"

AttributeError: 'Series' object has no attribute 'iterrows'

我不太明白这个错误，因为帐户"是一个 Pandas 数据框.请协助.

I don't quite understand the error since "accounts" is a pandas dataframe. Please assist.

推荐答案

accounts ["Number"] 是 Series 对象，而不是DataFrame.遍历 accounts.iterrows()并从每一行中获取 Number 列，或使用

accounts["Number"] is a Series object, not a DataFrame. Either iterate over accounts.iterrows() and take the Number column from each row, or use the Series.iteritems() method.

遍历数据框:

for i, row in accounts.iterrows():
    if str(row['Number']) == "27*******5":
        print(row["F"], row["Number"])

或超过 Series.iteritems():

for i, number in accounts['Number'].iteritems():
    if str(number) == "27*******5":
        print(accounts["F"][i], number)

这篇关于AttributeError:“系列"对象没有属性"iterrows"的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！