Practice Worksheet- Informatics Practices

Assuming the given series, named stud, which command will be used to print 5 as output? Amit 90 Ramesh 100 Mahesh 50 john NaN Abdul 89 Name: Student, dtype: int64

• stud.index

• stud. length

• stud. values

• stud.size

What will be produced by the following python code? (Assuming that all necessary libraries and modules are imported) series1 = pd.Series(np.array([31,28,31,30]), index = ["Jan", "Feb", "Mar"]) print(series1)

• Error: Length of passed values is 4, index implies 3

• No output

• Jan 31 Feb 28 Mar 31

• Jan 31 Feb 28 Mar 31 Apr NaN

What is the correct syntax to return both the first column and the second column in a pandas DataFrame df? (considering default labels for rows and columns)

• df.loc [ : ,0,1]

• df[[0,1]]

• df.loc[[0-1]]

• df.loc[[0,1]]

To rename the row indices 'Emp1' to 'Manisha', 'Emp2' to 'Shreya', 'Emp3' to 'Roshan' and 'Emp4' to 'Rakesh' in a data frame EmpD, Which of the following statement (a) to (d) will be used?

• EmpDF=EmpDF.rename({'Emp1':'Manisha', 'Emp2': 'Shreya', 'Emp3': 'Roshan', 'Emp4': 'Rakesh'}, axis = 'index')

• EmpDF=EmpDF.rename({'Emp1':'Manisha', 'Emp2': 'Shreya', 'Emp3': 'Roshan', 4': 'Emp 'Emp4': 'Rakesh'}, axis = 'rows')

• EmpDF=EmpDF.rename(['Emp1':'Manisha', 'Emp2': 'Shreya', 'Emp3': 'Roshan', 'Emp': 'Rakesh'], axis = 'index')

• None of the above

The correct statement to read from a CSV file in a DataFrame is:

• .read_csv()

• . read_csv( )()

• =pandas.read()

• = pandas.read_csv()

Which of the following command is used to display values of all the records having price>3?

• print(df[df['price']>3])

• print(df['price']>3)

• print(df.price>3])

• print(df('price')>3)

Which of the following can be used to specify the data while creating a DataFrame?

• Series

• List of Dictionaries

• Structured ndarray

• All of these

Identify the command to display last 5 rows of the dataFrame.

• Df1.head(5)

• Df1.Tail(5)

• Df1.bottom(5)

• Df1.tail(5)

EApp is a dictionary with the following elements, {'Photomath':35,'Simply Piano':20, 'Google Classroom':50, 'Kahoot':30, 'Duolingo':40} A series EduApp is created with the above dictionary 'EApp'. Which statement given below will produce the following output? Output: Simply Piano 20 Google Classroom 50 Kahoot 30

• print(EduApp.loc['Simply Piano':'Duolingo'])

• print(EduApp.iloc[1:3])

• print(EduApp.loc['Simply Piano':'Kahoot'])

• print(EduApp.iloc[2:5])

ASSERTION(A): The shape attribute returns the number of rows and number of columns available in data frame. REASONING (R): The shape attribute returns the values in form of list.

• Both A and R are true and R is the correct explanation for A.

• Both A and R are true and R is not the correct explanation for A.

• A is True but R is False.

• A is false but R is True.