/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 vote304 views2 answers
Java to python code conversion
Python
0 vote333 views2 answers
Composition in python
Python
33 votes318 views3 answers
Password generator python
Python
0 vote315 views1 answer
Virtualbox python manage.py not found
Python
2 votes384 views1 answer
How to save bulk create in django
Python Django
0 vote314 views2 answers
Install iris
Python
0 vote301 views1 answer
Maior valor lista python
Python
-4 votes316 views4 answers
Latest version of django
Python Django
1 vote318 views1 answer
Requirements.py for flask
Python
0 vote340 views2 answers
Most common letter in string python
Python