Pandas Package

Select all possible way to import "pandas" package

• import pandas

• import pandas as pd

• from pandas import *

• load pandas

We import a comma-separated-value file "flights.csv" using "pandas" package by

• import pandas as pd

  df = pd.read_csv("flights.csv")

• import pandas as pd

  df = pd.load_csv("flights.csv")

• import pandas as pd

  df = pd.import_csv("flights.csv")

• import pandas as pd

  df = pd.open_csv("flights.csv")

import pandas as pd

df = pd.read_csv("flights.csv")

We view the first 5 row by

• df.head()

• df.head(5)

• df.head(n=5)

• df.tail(n=5)

import pandas as pd

df = pd.read_csv("flights.csv")

We view the last 10 rows by

• df.tail(n=10)

• df.tail(10)

• df.head()

• df.tail()

import pandas as pd

df = pd.read_csv("flights.csv")

We view a quick descriptive statistics of numerical features by

• df.describe()

• df.describe(include="number")

• df.summary()

• df.summary(exclude="category")

We select column "year" by

• df[ "year" ]

• df.loc[ : , "year" ]

• df.iloc[ : , 0 ]

• df.iloc[ : , 1 ]

We select the fifth row (with index "4") by

• df.loc[4]

• df.iloc[4, : ]

• df[4, : ]

• df[4]

What is the data type of "df["passengers"]?

• pandas Series

• pandas DataFrame

• numpy 1-dimensional array

• numpy 2-dimensional array

We select a sub-dataframe with two columns "year" and "passengers" by

• df[["year", "passengers"]]

• df.loc[ : , ["year", "passengers"]]

• df.iloc[["year", "passengers"]]

• df.iloc[ : , [0, 2]]

We select a sub-dataframe of one column "year" by

• df["year"]

• df[["year"]]

• df.loc[ : , "year"]

• df.loc[ : , ["year"]]