/Python/Pandas distinct

Pandas distinct

How to get distinct value in a column dataframe in python

df.column.unique()

9

Source: chrisalbon.com

Pandas distinct

>gapminder['continent'].unique()
array(['Asia', 'Europe', 'Africa', 'Americas', 'Oceania'], dtype=object)

2

Source: cmdlinetips.com

Pandas unique values to list

df.groupby('param')['column'].nunique().sort_values(ascending=False).unique().tolist()

1

Distinct rows in this DataFrame

# distinct rows in this DataFrame

df.distinct().count()
# 2

0

Source: spark.apache.org

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())

0

Returns a new DataFrame containing the distinct rows in this DataFrame

# Returns a new DataFrame containing the distinct rows in this DataFrame

df.ditinct().count()
# 2

-1

Source: spark.apache.org

Similar codes

0 vote176 views1 answer
Off-by-one error in python
Python
0 vote213 views1 answer
How to estimate process timing python
Python
1 vote209 views2 answers
Build dataframe from dictionary
Python
13 votes270 views6 answers
Tensorflow check gpu
Python
0 vote212 views1 answer
Drop row with duplicate value
Python
33 votes219 views2 answers
Python bytes
Python
11 votes224 views3 answers
Get yesterday date python
Python
21 votes243 views5 answers
Python stop script
Python
0 vote228 views2 answers
Operator in django query
Python Django
8 votes222 views6 answers
Python int to binary
Python

Share