Extracting multiple values from a column to a new column in pandas

General Tech Technology & Software 2 years ago

0 2 0 0 0 tuteeHUB earn credit +10 pts

5 Star Rating 1 Rating

Posted on 16 Aug 2022, this text provides information on Technology & Software related to General Tech. Please note that while accuracy is prioritized, the data presented might not be entirely correct or up-to-date. This information is offered for general knowledge and informational purposes only, and should not be considered as a substitute for professional advice.

Take Quiz To Earn Credits!

Turn Your Knowledge into Earnings.

tuteehub_quiz

Answers (2)

Post Answer
profilepic.png
manpreet Tuteehub forum best answer Best Answer 2 years ago

 

 

I have a dataframe df having a column name Category and the values inside are 
Category 
Furniture 
Technology 
Office Supply 

These three values are repeated having total of 1000 values in the column. I want to create a new column name Category_filter having values Furniture and Technology from the Category column.

df['Category_Filter'] = df[df['Category'].isin(['Furniture', 'Technology'])]

I have tried the above code to create new column but not working. 

Category_Filter
Furniture
Technology

This is the desired output

profilepic.png
manpreet 2 years ago

I assume you mean you want a dataframe where the values in 'Category' are either 'Furniture' or 'Technology'. Here's something you can do.

df[df['Category'].isin(['Furniture ', 'Technology '])]

If this isn't what you meant, perhaps you could clarify.

EDIT: Responding to your comment below:

 df['Category_filter'] = df['Category'].where(df['Category'].isin(['Furniture ', 'Technology ']))

0 views   0 shares

No matter what stage you're at in your education or career, TuteeHub will help you reach the next level that you're aiming for. Simply,Choose a subject/topic and get started in self-paced practice sessions to improve your knowledge and scores.