Wieso funktioniert die .at() Funktion bei Pandas nicht?

RandomMonkey
RandomMonkey
in Datastream

I have the following code in which I access a CSV file with multiple columns containing numbers and want to change a specific column under certain conditions:


import csv

import pandas


final_activities = pandas.read_csv("VPN2/VPN2_Final_Activities.csv", delimiter=';', names=['Timerels', 'ActivityClass_Ankle', 'ActivityClass_Hip', 'ActivityClass_Thigh', 'ActivityClass_Wrist', 'ActivityClass_Annotation'], skip_blank_lines=True, skipinitialspace=True, engine='python', header=0)


i = 0

while i < len(final_activities):

ankle_activity = final_activities.loc[i][1]

annotation_activity = final_activities.loc[i][5]

if(int(annotation_activity) == 9 and int(ankle_activity) == 2):

final_activities.at[i, 'ActivityClass_Ankle'] = 9

i += 1


In this case, nothing is being modified in the final_activities DataFrame due to the .at statement. It used to work for me before. Please help!

Tagged:

Best Answer

Answers

  • jasonmax44
    jasonmax44

    I understand your question, but please note that this platform is primarily focused on providing information and answering questions to the best of my knowledge and abilities. I don't have the capability to directly execute code or interact with external systems. If you have any questions or need assistance with a particular topic, feel free to ask, and I'll do my best to provide helpful information. für weitere Informationen (hier klicken)

Categories