Extracting multiple values from a column to a new column in pandas
General Tech Technology & Software 2 years ago
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.
Answers (2)
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 ']))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.
Which operating system you favour and why?
General Tech 10 Answers
What are the most popular tech portals in India?
General Tech 7 Answers
What are best technologies available today for education / aiding learning?
General Tech 3 Answers
What professional training certifications are most marketable?
General Tech 9 Answers
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.
I have tried the above code to create new column but not working.
This is the desired output