英文:
How to solve KeyError for iteration?
问题
我目前有一个包含名为timeAccepted的列的数据框架。
我正在尝试在每次迭代时打印timeAccepted的值。我只是使用以下代码：
def print_time(df):print(df['timeAccepted'])for i, row in df.iterrows():print(df.columns)print(df.at[i, 'timeAccepted'])
但是我得到以下错误：
KeyError: 'timeAccepted'
请注意，print(df['timeAccepted'])的输出是：
0 2023-07-27T06:50:03.747135Z1 2023-07-27T06:50:06.030559Z2 2023-07-27T06:50:08.025268Z3 2023-07-27T06:50:10.024531Z4 2023-07-27T06:50:12.028957Z...26232 2023-07-27T12:46:27.024663Z26233 2023-07-27T12:46:27.024663Z26234 2023-07-27T12:45:02.027558Z26235 2023-07-27T12:46:29.023594Z26236 2023-07-27T12:46:29.023594ZName: timeAccepted, Length: 26237, dtype: object
和print(df.columns)：
Index(['Order identification code', 'Initial quantity', 'side', 'Order type','timeInForce', 'Limit price', 'quoteId', 'userId', 'timeAccepted'],dtype='object')
所以，我已经检查了数据框中是否存在该列，但仍然出现KeyError！请帮助！
英文:
I currently have a dataframe which include a column called timeAccepted.
I'm trying to print the value of timeAccepted for every iteration. I'm simply using the following code:
def print_time(df):print(df['timeAccepted'])for i, row in df.iterrows():print(df.columns)print(df.at[i, 'timeAccepted'])
But I'm getting the following error:
KeyError: 'timeAccepted'
please note that print(df['timeAccepted']) have as an output:
0 2023-07-27T06:50:03.747135Z1 2023-07-27T06:50:06.030559Z2 2023-07-27T06:50:08.025268Z3 2023-07-27T06:50:10.024531Z4 2023-07-27T06:50:12.028957Z...26232 2023-07-27T12:46:27.024663Z26233 2023-07-27T12:46:27.024663Z26234 2023-07-27T12:45:02.027558Z26235 2023-07-27T12:46:29.023594Z26236 2023-07-27T12:46:29.023594ZName: timeAccepted, Length: 26237, dtype: object
and print(df.columns):
Index(['Order identification code', 'Initial quantity', 'side', 'Order type','timeInForce', 'Limit price', 'quoteId', 'userId', 'timeAccepted'], dtype='object')
So, I've checked and the column do exist in the dataframe but I'm still having the KeyError! Please help!
答案1
得分: 1
尝试更深入地检查索引名称：
index_names = df.columns.to_list()time_accepted_index = index_names[-1]print(len(time_accepted_index))if not time_accepted_index == 'timeAccepted':print('strings are not the same')
我遇到了一个类似的情况，索引名称末尾有空格。
英文:
Try to inspect the Index names a bit deeper:
index_names = df.columns.to_list()time_accepted_index = index_names[-1]print(len(time_accepted_index))if not time_accepted_index == 'timeAccepted':print('strings are not the same')
I got a similar case where the index name had trailing whitespaces.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论