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

jezrael 2020-01-31 19:22

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)

Deepweber 2020-02-03 15:04:44

thanks ...i need to know how can i find the extact word,even am getting the similar word

jezrael 2020-02-03 15:06:23

@Deepweber - Not easy, need fuzzy match

selecting columns based on row value, Python, Pandas

plotting count of zeros and ones in a dataframe

BeautifulSoup find.all() web scraping returns empty

Python hide ticks but show tick labels