Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Lära Unique Observations | Aggregate Functions
Introduction to pandas [track]

bookUnique Observations

You can get unique values of particular column by applying the .unique() method. Note, that this is Series method, so it works only for one column of DataFrame. For example, you can get all the cars' fuel types.

1234567
# Importing library import pandas as pd # Reading csv file df = pd.read_csv('https://codefinity-content-media.s3.eu-west-1.amazonaws.com/67798cef-5e7c-4fbc-af7d-ae96b4443c0a/audi.csv') # Unique fuel types print(df.fuelType.unique())
copy

Also you can get the total number of unique values within specific column by applying .nunique() method to the column.

1234567
# Importing library import pandas as pd # Reading csv file df = pd.read_csv('https://codefinity-content-media.s3.eu-west-1.amazonaws.com/67798cef-5e7c-4fbc-af7d-ae96b4443c0a/audi.csv') # Number of unique engine sizes print(df.engineSize.nunique())
copy

Var allt tydligt?

Hur kan vi förbättra det?

Tack för dina kommentarer!

Avsnitt 4. Kapitel 2

Fråga AI

expand

Fråga AI

ChatGPT

Fråga vad du vill eller prova någon av de föreslagna frågorna för att starta vårt samtal

Awesome!

Completion rate improved to 3.33

bookUnique Observations

Svep för att visa menyn

You can get unique values of particular column by applying the .unique() method. Note, that this is Series method, so it works only for one column of DataFrame. For example, you can get all the cars' fuel types.

1234567
# Importing library import pandas as pd # Reading csv file df = pd.read_csv('https://codefinity-content-media.s3.eu-west-1.amazonaws.com/67798cef-5e7c-4fbc-af7d-ae96b4443c0a/audi.csv') # Unique fuel types print(df.fuelType.unique())
copy

Also you can get the total number of unique values within specific column by applying .nunique() method to the column.

1234567
# Importing library import pandas as pd # Reading csv file df = pd.read_csv('https://codefinity-content-media.s3.eu-west-1.amazonaws.com/67798cef-5e7c-4fbc-af7d-ae96b4443c0a/audi.csv') # Number of unique engine sizes print(df.engineSize.nunique())
copy

Var allt tydligt?

Hur kan vi förbättra det?

Tack för dina kommentarer!

Avsnitt 4. Kapitel 2
some-alt