| Ecode | Name | Age | Fav_Color | Salary |
| 101 | Rohit | 20 | Blue | 45000 |
| 102 | Mohanti | 24 | Red | 36000 |
| 103 | Tushar Koul | 23 | Green | 42000 |
| 104 | Rupali | 22 | Yellow | 38000 |
| 105 | Gurpreet | 21 | Pink | 40000 |
(a) Select the command from the given options that will give the following output:-
(i) print(emp.max)
(ii) print(emp.max(axis=1))
(iii) print(emp.max,axis=1)
(iv) print(emp.max())
(b) A manager wants to know the Favourite colour of the employee with the employee code 103. Help him to identify the correct set of statements from the given options:
(i) df1=emp[emp[‘Ecode’]==103]
print(df1)
(ii) df1=emp['Ecode'==103]
print(df1)
(iii) df1=emp[emp.Ecode=103]
print(df1)
(iv) df1=emp[emp.Ecode==103]
print(df1)
(c) Which of the following statement will give the names of the employees whose salary is more than 40000.
(i) print(emp.max())
(ii) print(emp[emp["Salary"]>40000])
(iii) print(emp["Salary"]>40000)
(iv) print(emp.max()>40000)
(d) Which of the following command will list only the columns Ename and Salary using loc:
(i) print(emp.loc[:,[0,2]]
(ii) print(emp.loc[:,["Ename","Salary"]])
(iii) print(emp.loc(:["Ename","Salary"]))
(iv) print(emp.loc[["Ename","Salary"]])
(e) Mr. Singh, the manager wants to add a new column, the Rank with the values ‘IV’, ‘II’, ‘III’, ‘IV’, ‘I’, to the data frame Help him to identify the right command from the followings to do so :
(i) emp.column=[‘IV’, ‘II’, ‘III’, ‘IV’, ‘I’ ]
(ii) emp.iloc["Rank"] =[‘IV’, ‘II’, ‘III’, ‘IV’, ‘I’]
(iii) emp["Rank"] =[‘IV’, ‘II’, ‘III’, ‘IV’, ‘I’ ]
(iv) None of the above
