AppLIED Stats on Data Set

Question 1

How to know Total no. of rows nd columns in Data Set ?

Answer 1

We have to use shape attribute of data frame object .

df.shape

Question 2

How to know Total no. of rows nd columns in Data Set ?

Answer 2

We have to use shape attribute of data frame object .

df.shape

Question 3

How to sort Data Set by particular column ?

Answer 3

We have to use sort_value() method of Data Frame Object .

df.sort_values(‘column_name’,ascending=True)

Question 4

How to find minimum & maximum value of column , column contains numeric values ?

Answer 4

We have to use min() & max() method of Data Frame Object .
df[‘Age’].max()
df[‘Age’].min()

Question 5

How to use agg method ?

Answer 5

agg method is used for using multiple aggregate functions together on data Frame .

df.groupby(‘Embarked’)[‘Age’].agg([‘count’,’max’,’min’,’mean’])

Question 6

How to get to know basic information of Data Set ?

Answer 6

index
columns
shape
info()
describe()

Question 7

How to get column list of Data Set , & store it in variable?

Answer 7

columns=df.columns

Question 8

How to create a data frame , using column as row index ?

Answer 8

We have to use index_col argument of read_csv method.

df = pd.read_csv(‘dataSets/titanic.csv’,index_col=3)