/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 vote166 views1 answer
How to set up pygame
Python
0 vote211 views2 answers
From django.core.management import execute_from_command_line ImportError: No module named django.core.management
Python Django
0 vote165 views1 answer
Write a python program which accepts the user
Python
12 votes158 views6 answers
Python remove empty string from list
Python
0 vote167 views1 answer
Picobot python
Python
60 votes189 views6 answers
Python list length
Python
5 votes222 views2 answers
Django password field
Python Django
0 vote165 views1 answer
Python uml
Python
0 vote177 views1 answer
Save to xlsx in python
Python
0 vote181 views1 answer
Q fields django Q objects
Python

Share