/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

13 votes117 views6 answers
How to open pickle file
Python
1 vote127 views1 answer
Fill python list with input
Python
0 vote178 views1 answer
Shebang line python
Python
0 vote145 views1 answer
Mail.send_message flask not working, SSL ==> 465
Python Flask
7 votes120 views3 answers
Lambda and function in python
Python
-1 vote127 views1 answer
How to sort by date in .csv
Python
0 vote129 views1 answer
Get list of all document in django-elasticsearch-dsl
Python
-1 vote118 views2 answers
How to set pandas dataframe as global
Python
0 vote112 views1 answer
Get first not null value from column dataframe
Python
0 vote130 views1 answer
Value isn't remembered in lambda python
Python

Share