Question

Ms. Ritika conducted an online assessment and stored the details in a DataFrame result as given below: 

	Name	Score	Attempts	Qualify
a	Atulya	12.5	1	yes
b	Disha	9.0	3	no
c	Kavita	16.5	2	yes
d	John	15.0	1	no

Answer the following questions:

1. Predict the output of the following Python, statement:
   print(result.loc [:, 'Attempts'] > 1)
2. Write python statement to display the last three records.
3. Write python statement to display records of 'a' and 'd row labels. 
                                       OR 
   Write suitable Python statement to retrieve the data stored in the file, 'registration.csv' into a DataFrame, 'regis'. 

Answer 1

1. The output will be:
   0 False
   1 True
   2 True
   3 False
   Explanation: Since the value for the first element (index 0) is 1, which is not more than 1, the outcome is False.
   Since the value for the second item (index 1) is 3, which is greater than 1, the outcome is True.
   Since the value for the third element (index 2) is 2, which is more than 1, the outcome is True.
   Since the value for the fourth element (index 3) is 1, which is not more than 1, the outcome is False.
2. You can use any one of the following statement:
   result.tail(3)
result.loc['b':]
result.iloc[−3:]
result.loc[['b', 'c', 'd']]
result.loc['b': 'd']
3. A list with the desired row labels can be used with the .loc[^.] method.
   result.loc[['a', 'd']] 
                                        OR
   If 'registration.csv' is present in the current directory, then
   regis = pd.read_csv(registration.csv')
   The information will be retrieved from the CSV file "registration.csv" and stored in a data frame called "Regis."