/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 vote326 views1 answer
Python skip line
Python
0 vote329 views1 answer
You will be provided a file path for input I, a file path for output O, a string S, and a string T.
Python
14 votes328 views3 answers
How to get user id discord.py
Python
0 vote342 views1 answer
How to restore windows security
Python
7 votes338 views1 answer
How to give column names in pandas when creating dataframe
Python
0 vote338 views5 answers
Pine script to python
Python
1 vote416 views1 answer
Get sheet names using pandas
Python
0 vote315 views1 answer
How to print 2 list in python as table
Python
0 vote325 views1 answer
Infinity range or infinity looping
Python
4 votes399 views5 answers
Module 'datetime' has no attribute 'now' django
Python Django