Trying to filter out unique values in a pandas data frame

Question

Hi is there a way to filter out unique values ina a pandas data frame. I am using the code below to filter out the unique values. However, I am getting different ordered combinations. For example, ['Creative, Modern Cuisine', 'Modern Cuisine, Creative'] is there a way to filter this out.

[ Part of the data ]

cuisine = df.Cuisine.unique()
cuisine_count = df.Cuisine.nunique()
print(cuisine, cuisine_count)

Though, it sounds like the real issue is in how your dataframe is formatted, can you provide a couple sample lines from it? — BeRT2me
– BeRT2me, Commented Apr 22, 2022 at 22:30
@BeRT2me yea this is part of the data set I am working on Cuisine Creative, Modern Cuisine Creative Creative Creative Modern Cuisine, Creative Classic French Classic French, Creative Modern French, Creative Classic French Creative Creative Classic French French Modern Cuisine Modern British Modern French French Creative, Contemporary Taizhou Vegetarian Cantonese French Contemporary I am try to only get the unique values — lkhs00
– lkhs00, Commented Apr 22, 2022 at 22:33

Peter Leimbigler · Accepted Answer · 2022-04-23 02:59:12Z

1

If I understand your intent, you are trying to get a list of all distinct cuisines which appear in your DataFrame. Try this:

df['Cuisine'].str.split(',').explode().str.strip().unique().tolist()

Explanation:

df['Cuisine'].str.split(','): split Cuisine strings at commas, producing a Series with a Python list in each row, where each list item holds an individual cuisine string
.explode(): for each list of cuisine strings, transform each string to a row
.str.strip(): strip whitespace
.unique().tolist(): get list of unique cuisines

answered Apr 23, 2022 at 2:59

Peter Leimbigler

11.1k1 gold badge27 silver badges39 bronze badges

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

Collectives™ on Stack Overflow

Trying to filter out unique values in a pandas data frame

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