Answers for "select distinct values pandas"

9

how to get distinct value in a column dataframe in python

df.column.unique()
Posted by: Guest on May-30-2020
0

pandas get column values distinct

import pandas as pd

colors = {'color': ['green', 'blue', 'blue', 'red', 'green']}
df = pd.DataFrame.from_dict(colors)

print(df['color'].unique())
Posted by: Guest on August-31-2021
0

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
Posted by: Guest on June-24-2020

Code answers related to "select distinct values pandas"

Python Answers by Framework

Browse Popular Code Answers by Language