/Python/Python extract values that have different values in a column

Python extract values that have different values in a column

How to get distinct value in a column dataframe in python

df.column.unique()

Source: chrisalbon.com

Python extract values that have different values in a column

df = pd.DataFrame({'author':['a', 'a', 'b'], 'products':['sr1', 'sr2', 'sr2']}) # Create df

group = df.groupby('author') # Group by author used as index
df2 = group.apply(lambda x: x['subreddit'].unique()) # List of all product per author
df2 = df2.apply(pd.Series) # Split products in multiple columns

Source: stackoverflow.com

Similar codes

0 vote102 views1 answer
Check how many days old file is python
Python
0 vote108 views1 answer
Webdriver antibot
Python
0 vote148 views1 answer
Django blog new post
Python Django
1 vote54 views1 answer
Reverse slice python
Python
0 vote108 views1 answer
Replace commas with spaces python
Python
1 vote96 views3 answers
Making ckeditor django responsive
Python
0 vote105 views1 answer
How to set geometry to full screen in pyqt5
Python
3 votes95 views2 answers
Update_or_create django
Python
1 vote143 views1 answer
Flask cors policy no 'access-control-allow-origin'
Python Flask
15 votes108 views4 answers
Float to int in python
Python