/Python/Pandas get column values distinct

Pandas get column values distinct

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

4 votes171 views2 answers
Tkinter draw squaer
Python
0 vote167 views1 answer
Standardise columns python
Python
15 votes202 views3 answers
How to get a row from a dataframe in python
Python
5 votes178 views2 answers
Python append to csv on new line
Python
0 vote300 views1 answer
Python - give a name to index column
Python
1 vote212 views1 answer
How to print something with tkinter
Python
11 votes163 views3 answers
Logistic regression algorithm in python
Python
8 votes160 views6 answers
Python int to binary
Python
0 vote115 views1 answer
How to use constructor of base class in derived class in python
Python
0 vote172 views1 answer
How to do an infinte while in python
Python

Share