wowee.....如何在Python和Pandas中使用iterrows?如果我进行行迭代,我是否能够通过row ['COL_NAME']访问列?
这是列名:
print df
Int64Index: 152 entries, 0 to 151
Data columns:
Date 152 non-null values
Time 152 non-null values
Time Zone 152 non-null values
Currency 152 non-null values
Event 152 non-null values
Importance 152 non-null values
Actual 127 non-null values
Forecast 86 non-null values
Previous 132 non-null values
dtypes: object(9)
for row in df.iterrows():
print row['Date']
Traceback (most recent call last):
File "/home/ubuntu/workspace/calandar.py", line 34, in <module>
print row['Date']
TypeError: tuple indices must be integers, not str
如果我打印一行:
(0, Date Sun Apr 13
Time 17:30
Time Zone GMT
Currency USD
Event USD Fed's Stein Speaks on Financial Stability ...
Importance Low
Actual NaN
Forecast NaN
Previous NaN
Name: 0)
row ['Date']
返回该单个列的Series表示形式而不是实际值的情况?尽管在迭代iterrows()
之外从数据帧中访问相同单元格的行为符合预期,但我现在正在遇到这种情况。 - kuanb