df | source code and dataset are used to demonstrate the DF model | Machine Learning library

I want to add a new column 'BEST' to this dataframe, which contains a list of the names of the columns which meet these criteria:

• Subtract from the current value in each column the value in the row that is 2 rows back
• The column that has the highest result of this subtraction will be listed in 'BEST'
• If more more than one column shares the same highest result, they all get listed
• If all columns have the same result, they all get listed

Input:

I have a dataframe as below:

I have a data frame including three columns named 'Altitude', 'Distance', 'Slope'. The column of 'Slope' is calculated using the two first columns 'Altitude', 'Distance'. @ the first step the purpose was to calculate 'Slope' using a condition explained below: A condition function was deployed to start from the top column of the "Distance" variable and add up (sum) values until the summation of them is greater or equal to 10 (>=10). If this condition corrects then calculate the "Slope" using the given formula: Slope=Average(Altitude)/(sum(Distance)). The summation of the 'Distance' was counting from the first value of that to the index that the 'Distance' has stopped there). The following code is for the above explanation (By Tim Roberts):

I have a dataset with many columns and I'd like to locate the columns that have fewer than n unique responses and change just those columns into factors.

Here is one way I was able to do that:

I have a column with the datatype 'object', but it actually contains numbers (408, 415, 510) with no missing values. I want to convert this to integer with the code below, but I get the error: invalid literal for int() with base 10: 'A415' (I added the first line of code after reading other posts, but I get the same error even if I drop the first line of code).

I am a beginner in Data Science, so please sorry if my mistake is dumb.

Here, I have a loop which views my data frame and makes changes using .loc The problem is that the changes are not saved at the end. I checked every step, everything is processing right. I even checked the modified cell right after working on it (look below) and its gives the value I put into it. However, when the program finishes the my excel data frame is not changed at all.

Help please. Thank you in advance!

I am trying to check if the value in 'diff' column is greater than 0 if it is, then the value in 'worth' should be False else it should be True

I am using the below code to compute and check but it always gives me True. Can anyone point here what is the mistake. I am attaching pic of output as well

I'm trying to add lists together using a loop. Here is some example data.

After looking at several posts here, every post explains how to replace yes/no in a column with 1/0, but the datatype of those numbers remain 'object' and is not float or int (even after I use astype(int)), so I can't do further operation with them. My code is below. Anyone knows how to convert datatype now from object to float or int?