/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

10 votes222 views2 answers
How to find duplicate numbers in list in python
Python
4 votes210 views1 answer
Try with multiple except python
Python
3 votes205 views1 answer
If condition
Python
2 votes203 views1 answer
Logout in discord.py
Python
3 votes214 views2 answers
Change column value based on another column pandas
Python
4 votes204 views5 answers
Add a new column to numpy array
Python
0 vote266 views1 answer
ModuleNotFoundError: No module named 'django.db.models.enums'
Python Django
2 votes167 views1 answer
Python insert object into list
Python
11 votes203 views2 answers
Re.compile example
Python
10 votes224 views10 answers
Hello
Python

Share