Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Lære 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 alt klart?

Hvordan kan vi forbedre det?

Tak for dine kommentarer!

Sektion 4. Kapitel 2

Spørg AI

expand

Spørg AI

ChatGPT

Spørg om hvad som helst eller prøv et af de foreslåede spørgsmål for at starte vores chat

Suggested prompts:

Spørg mig spørgsmål om dette emne

Opsummér dette kapitel

Vis virkelige eksempler

Awesome!

Completion rate improved to 3.33

bookUnique Observations

Stryg for at vise menuen

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 alt klart?

Hvordan kan vi forbedre det?

Tak for dine kommentarer!

Sektion 4. Kapitel 2
some-alt