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: 'Series' object has no attribute 'iterrows'
我不太明白这个错误,因为“accounts”是一个 pandas 数据框。
accounts["Number"]
is a Series对象,而不是 DataFrame。要么迭代一遍accounts.iterrows()
并采取Number
每行的列,或使用Series.items() method https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.Series.items.html.
迭代数据框:
for i, row in accounts.iterrows():
if str(row['Number']) == "27*******5":
print(row["F"], row["Number"])
or over Series.items()
:
for i, number in accounts['Number'].items():
if str(number) == "27*******5":
print(accounts["F"][i], number)
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)