Pndas Dara Frames

What will be the output of following code- import pandas as pd s1=pd.Series([1,2,2,7,’Sachin’,77.5]) print(s1.head()) print(s1.head(3))

• 0 1 1 2 2 2 3 7 4 Sachin dtype: object

• 0 1 1 2 2 2 dtype: object

Write a program in python to find maximum value over index in Data frame.

What are the purpose of following statements- 1. df.columns 2. df.iloc[ : , :-5] 3. df[2:8] 4. df[ :] 5. df.iloc[ : -4 , : ]

• It displays the names of columns of the Dataframe.

• It will display all columns except the last 5 columns.

• It displays all columns with row index 2 to 7.

• It will display entire dataframe with all rows and columns.

• It will display all rows except the last 4 four rows.

Write a python program to sort the following data according to ascending order of Age. Name Age Designation Sanjeev 37 Manager Keshav 42 Clerk Rahul 38 Accountant

Write a python program to sort the following data according to descending order of Name. Name Age Designation Sanjeev 37 Manager Keshav 42 Clerk Rahul 38 Accountant

Which of the following thing can be data in Pandas? 1. A python dictionary 2. An nd array 3. A scalar value 4. All of above

All pandas data structure are ___________mutable but not always ________mutable. 1. Size, value 2. Semantic , size 3. Value, size 4. None of the above

• Size, value

• Semantic , size

• Value, size

• None of the above

Data and index in an nd array must be of same length- 1. True 2. False

• True

• False

What is the output of the following program? import pandas as pd df=pd.DataFrame(index=[0,1,2,3,4,5],columns=[‘one’,’two’]) print df[‘one’].sum()

What will be the output of following code: Users.groupby(‘occupation’).age.mean() 1. Get mean age of occupation 2. Groups users by mean age 3. Groups user by age and occupation 4. None

• Get mean age of occupation

• Groups users by mean age

• Groups user by age and occupation

• None