Number of Observations

There are several aggregate functions in pandas. One of them is .count() method, which counts number of non-null observation for each 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')
# Count number of non-null rows
print(df.count())

This method is popular for counting number of rows under specific condition. For example, you may count number of cars manufactured after 2015. This time you don't need to see the number of observation in each column, so you can choose particular one.


              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')
# Count number of cars manufactured after 2015
print(df.loc[df.year > 2015, 'model'].count())

Var allt tydligt?

Tack för dina kommentarer!

Avsnitt 4. Kapitel 1

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]

Number of Observations

There are several aggregate functions in pandas. One of them is .count() method, which counts number of non-null observation for each 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')
# Count number of non-null rows
print(df.count())


              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')
# Count number of cars manufactured after 2015
print(df.loc[df.year > 2015, 'model'].count())

Var allt tydligt?

Tack för dina kommentarer!

Avsnitt 4. Kapitel 1