Please allow ads on our site
Kindly log in to use this feature. We’ll take you to the login page automatically.
LoginExtracting multiple values from a column to a new column in pandas
General Tech Technology & Software 3 years ago
User submissions are the sole responsibility of contributors, with TuteeHUB disclaiming liability for accuracy, copyrights, or consequences of use; content is for informational purposes only and not professional advice.
Answers (2)
manpreet 3 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.
Similar Forum
Explore Other Libraries
Online Exams
Question Bank
Career News
Feeds
Full Forms
Dictionary
Interview Question
Gigs
Quotes
Lyrics
Videos
Courses
Blogs
Tutorials
Forum
Educators
Corporates
Tools
Please allow ads on our site
Kindly log in to use this feature. We’ll take you to the login page automatically.
Login
manpreet![Tuteehub forum best answer]()
Best Answer
3 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