Unique 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())

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())

Var allt tydligt?

Tack för dina kommentarer!

Avsnitt 4. Kapitel 2

Fråga AI

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

Kursinnehåll

Introduction to pandas [track]

Unique Observations


              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())

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())

Var allt tydligt?

Tack för dina kommentarer!

Avsnitt 4. Kapitel 2