[1146]python函数之iterrows(), iteritems(), itertuples()对dataframe进行遍历
[1146]python函数之iterrows(), iteritems(), itertuples()对dataframe进行遍历
周小董
发布于 2022-06-13 08:24:55
发布于 2022-06-13 08:24:55
文章目录
- 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)
# 输出
c1 c2
0 10 100
1 11 110
2 12 1231、iterrows()
for date, row in df.iterrows():
print(date)输出
0
1
2for date, row in df.iterrows():
print(row)输出
c1 10
c2 100
Name: 0, dtype: int64
c1 11
c2 110
Name: 1, dtype: int64
c1 12
c2 123
Name: 2, dtype: int64对于每一行，通过列名访问对应的元素
for date, row in df.iterrows():
print(row['c1'], row['c2'])输出
10 100
11 110
12 1232、iteritems()
for date, row in df.iteritems():
print(date)输出
c1
c2for date, row in df.iteritems():
print(row)输出
0 10
1 11
2 12
Name: c1, dtype: int64
0 100
1 110
2 123
Name: c2, dtype: int64for date, row in df.iteritems():
print(row[0], row[1], row[2])输出
10 11 12
100 110 1233、itertuples()
for row in df.itertuples():
print(row)输出
Pandas(Index=0, c1=10, c2=100)
Pandas(Index=1, c1=11, c2=110)
Pandas(Index=2, c1=12, c2=123)for row in df.itertuples():
print(getattr(row, 'c1'), getattr(row, 'c2'))输出
10 100
11 110
12 123参考：https://blog.csdn.net/likeyou1314918273/article/details/89514038
本文参与 腾讯云自媒体分享计划，分享自作者个人站点/博客。
原始发表：2022-06-12，如有侵权请联系 cloudcommunity@tencent.com 删除
评论
登录后参与评论
推荐阅读
目录