/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

24 votes224 views3 answers
Ignore warnings python
Python
1 vote149 views1 answer
How to remove every other letter from a string python
Python
5 votes199 views1 answer
Get request body flask
Python Flask
-1 vote168 views1 answer
Print something after sec python
Python
10 votes147 views1 answer
How do i convert a list to a string in python
Python
0 vote141 views1 answer
Draw a bow tie in python
Python
0 vote144 views1 answer
Seaborn barplot remove error bars
Python
2 votes163 views1 answer
Ascii values in python of
Python
31 votes107 views1 answer
Sort_values pandas series
Python
0 vote151 views1 answer
Using -h on python file
Python