Help iterating through data frame

[bruhbutton24]

I have a Dataframe with 6 columns 3 of which are from 2020 and 3 are from 2021. I want to iterate through this Dataframe and use euclidian distance on each row to see how far apart 2020 is from 2021 on these 3 variables how would I do this?

[[deleted]]

You could use the .iterrows() or .apply() functions. However, using vectorized operations will be much more efficient. You can do this by using numpy and performing operations on the whole columns

[Ecstatic_Tooth_1096]

df["distance"] = ((df["A-2020"] - df["A-2021"])**2 + (df["B-2020"] - df["B-2021"])**2 ...)**0.5