- iterrows(): 将DataFrame迭代为(insex, Series)对。
- itertuples(): 将DataFrame迭代为元祖。
- iteritems(): 将DataFrame迭代为(列名, Series)对
有如下DataFrame数据
import pandas as pd
inp = [{'c1':10, 'c2':100}, {'c1':11, 'c2':110}, {'c1':12, 'c2':123}]
df = pd.DataFrame(inp)
print(df)
#输出
1、iterrows():
for date, row in df.iterrows():
print(date)
for date, row in df.iterrows():
print(row)
# 对于每一行,通过列名访问对应的元素
for date, row in df.iterrows():
print(row['c1'], row['c2'])
----------------------和iterrows()刚好相反------------
2、iteritems()
for date, row in df.iteritems():
print(date)
for date, row in df.iteritems():
print(row)
for date, row in df.iteritems():
print(row[0], row[1], row[2])
3、itertuples()
for row in df.itertuples():
print(row)
for row in df.itertuples():
print(getattr(row, 'c1'), getattr(row, 'c2'))