i have multiple columns with the status of the areas,i need to get the status on status column if all the status are completed

Question

I have multiple columns with the status of the areas, I need to get the status on status column if all the status are completed.

Table

Areas are 3 or more than that? – Pankhuri Agarwal Jan 31 '20 at 09:58 — Pankhuri Agarwal, Jan 31 '20 at 09:58

score 0 · Accepted Answer · answered Jan 31 '20 at 11:22

0

You can filter all columns with Area in columns names by DataFrame.filter, compare by DataFrame.eq for == and test if all Trues per rows by DataFrame.all:

df['Status'] = df.filter(like='Area').eq('Completed').all(axis=1)

Or you can seelct all columns without first 2 by DataFrame.iloc:

df['Status'] = df.iloc[:, 2:].eq('Completed').all(axis=1)

Or last 3 columns:

df['Status'] = df.iloc[:, -3:].eq('Completed').all(axis=1)

answered Jan 31 '20 at 11:22

jezrael

thanks ...i need to know how can i find the extact word,even am getting the similar word – Deepweber Feb 03 '20 at 07:04
@Deepweber - Not easy, need [fuzzy match](https://stackoverflow.com/questions/38577332/apply-fuzzy-matching-across-a-dataframe-column-and-save-results-in-a-new-column) – jezrael Feb 03 '20 at 07:06

1 Answers1