I'm very new to pandas and I'm trying to implement the code to search for something on an excel spreadsheet.
Basically, the most recent price can be found on the furthest right column named
"final cost", and that's what I need. However, there are multiple columns named
"final cost" (as every invoice is posted on there).
What I currently have:
def find_most_recent(row_num: int, df) -> float: k = -1 checker = False while not checker: if df.columns[k] == "final cost": if not pd.isnull(df.iloc[row_num, k]): checker = True return df.loc[row_num, df.columns[k]] k -= 1
row_num is the current row that is being searched, and
df is the current dataframe being searched.
However, this gets only the first encounter of
"final cost". For example, on a dataset of:
I want the return to be one of the prices in
column L, but I'm getting returns of values from
column F instead.
Any suggestions of a method to use?