WorksheetsSolve Questions on DataFrame
Total questions: 6
Worksheet time: 7mins
DataFramedf
Age Name
rank1 28 Tom
rank2 34 Jack
rank3 29 Steve
rank4 42 Ricky
Find out the command used to get the following output from the above dataframe,
Age
rank1 28
rank2 34
rank3 29
rank4 42
Print(df[‘Age’])
print(df[‘Age’])
print(df(‘Age’))
Print(df[‘Age’], axis=1)
The instructor wants to know the age of the persons with rank3. Help her to identify the correct set of statement/s from the given options:
a) Print(df.loc[‘rank3’])
b) print(df.iloc[‘rank3’])
c) print(df.loc[‘rank3’])
d) Print(df.loc(‘rank3’))
Which of the following statement/s will give 2 rows from bottom of the dataframe ?
Print(df.tail())
print(df.tail(2))
print(df.tail[2])
print(df.tail(4))
i) Which of the following statement will delete rank2 row from the dataframe ?
df.drop(‘rank2’)
df.drop(rank2)
delete df(rank2)
df.del(“rank2”)
The instructor wants to add a new column, Marks to the dataframe. The values of the marks will be 12, 22, 21, 24. Help him to choose the correct command to do so.
a) Df.columns=[12, 22, 21, 24]
b) df[‘marks’] = [12, 22, 21, 24]
c) df.loc[marks] = [12, 22, 21, 24]
d) Both (b) and (c) are correct
The instructor wants to add a new row to the dataframe. Help him to choose the correct command to do so.
df.loc[ ]
df.iloc[ ]
