/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

0 vote314 views1 answer
Extract all namespace from xml file python
Python
0 vote342 views1 answer
Python string name out of mail
Python
0 vote342 views1 answer
Python login to O365
Python
0 vote329 views1 answer
Django serve media folder
Python
12 votes311 views6 answers
Python format string
Python
0 vote317 views1 answer
Operations in python
Python
0 vote359 views1 answer
How to know if the numbers is par in python
Python
5 votes334 views2 answers
Pandas convert index to column
Python
2 votes331 views1 answer
Sqlalchemy query bilter by current month
Python
2 votes327 views1 answer
How to add a function in python
Python

Share