populating dataframe column from BOOLEAN column with TRUE value

Question

I have this df:

data = {'book': [True, False, False, False, False],
 'apple': [False, False, True, False, False],
 'cat': [False, False, False, False, True],
 'pigeon': [False, True, False, False, False],
 'shirt': [False, False, False, True, False]}

df = pd.DataFrame(data)

Then I want create a new column, df['category'] that takes in as value, the column's name whose value is true.

So that df['category'] for each TRUE value column as follows:

book - stationery, apple - fruit,  cat - animal, pigeon - bird, shirt - clothes

NO 2 columns have TRUE value in a row.

Expected output:

>>> df
    book    apple    cat    pigeon  shirt    category
0   True    False   False   False   False    stationery
1   False   False   False   True    False    bird 
2   False   True    False   False   False    fruit
3   False   False   False   False   True     clothes
4   False   False   True    False   False    animal

Shubham Sharma · Accepted Answer · 2022-09-11 12:46:30Z

3

Simple..use idxmax along axis=1 to get the name of column having True value, then map the name to the corresponding category

d = {'book': 'stationery', 'pigeon': 'bird', 
     'apple': 'fruit', 'shirt': 'clothes', 'cat': 'animal'}

df['category'] = df.idxmax(1).map(d)

    book  apple    cat  pigeon  shirt    category
0   True  False  False   False  False  stationery
1  False  False  False    True  False        bird
2  False   True  False   False  False       fruit
3  False  False  False   False   True     clothes
4  False  False   True   False  False      animal

answered Sep 11, 2022 at 12:46

Shubham Sharma

71.8k6 gold badges26 silver badges58 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

populating dataframe column from BOOLEAN column with TRUE value

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related