Aug-03-2020, 09:20 PM
Hello all
I have a dataframe which i have imported from excel.
It has column headings and below the column headings it has all of my data in rows.
I want to LOOP through each row of the first column and if it is equal to a value say 123 then i just want to remove it.
I want to LOOP through each item in the data frame.
so far i have:-
Can anyone help provide some guidance.
Thank you.
I have a dataframe which i have imported from excel.
It has column headings and below the column headings it has all of my data in rows.
I want to LOOP through each row of the first column and if it is equal to a value say 123 then i just want to remove it.
I want to LOOP through each item in the data frame.
so far i have:-
t = 0 while t < len(Report): Value = Report.iloc[t,0] #the value i want to check is always in the 0 column index if Value == Report.iloc[t,0]: #how do i delete the the row???? t=t+1deleting the rows is proving to be very difficult.
Can anyone help provide some guidance.
Thank you.