Python Pandas MCQs Solution | TCS Fresco Play

Disclaimer: The primary purpose of providing this solution is to assist and support anyone who are unable to complete these courses due to a technical issue or a lack of expertise. This website's information or data are solely for the purpose of knowledge and education.

Make an effort to understand these solutions and apply them to your Hands-On difficulties. (It is not advisable that copy and paste these solutions).

All Question of the MCQs Present Below for Ease Use Ctrl + F with the question name to find the Question. All the Best!

1) Which of the following cannot be used to create a Data frame? A tuple of tuples
2) Which of the following expressions are used to check if each element of a series s is present in the list of elements [67, 32]. Series s is defined as shown below.

s = pd.Series([99, 32, 67],list('abc'))

s.isin([67,32])
3) What is the shape of the data frame df defined in the below=shown code? import pandas as pd
data = [{'a': 1, 'b': 2}, {'a': 5, 'b': 10, 'c': 20}]

df = pd.DataFrame(data)

(2,3)
4) What is the output of the following code? import pandas as pd
s = pd.Series([89.2, 76.4, 98.2, 75.9], index=list('abcd'))

print(s[['c', 'a']]) c 98.2
a 89.2

dtype: float64
5) Which of the following attributes or arguments are used to set column names of a data frame?

columns
6) What is the output of the expression 'b' in s, where s is the series defined as shown below? s = pd.Series([89.2, 76.4, 98.2, 75.9],
index=list('abcd'))

True
7) Which of the following is not a Data Structure of Pandas? Dictionary
8) What is the shape of the data frame df defined in the below shown code? import pandas as pd
data = [{'a': 1, 'b': 2}, {'a': 5, 'b': 10, 'c': 20}]

df = pd.DataFrame(data, columns=['a', 'b']) (2,2)
9) What is the data type of series s defined in below code? import pandas as pd
s = pd.Series([9.2, 'hello', 89])
object
10) Which of the following argument is used to label the elements of a series?

Index
11) Which of the following expression is used to add a new column 'C' to a data frame df, with three rows? df['C'] = [12,98,45]
12) Which of the following expression is used to delete the column, A from a data frame named df? del df['A']
13) Which of the following expression returns data of column B of data frame df, defined below? Which of the following expression returns the data of column B in data frame df, defined below. import pandas as pd
df = pd.DataFrame({'A':[34, 78, 54], 'B':[12, 67, 43]}, index=['r1', 'r2', 'r3'])

df.B
14) Which of the following expression returns the second row of df, defined below?
import pandas

df = pd.DataFrame({'A':[34, 78, 54], 'B':[12, 67, 43]}, index=['r1', 'r2', 'r3'])
df.iloc[1]
15) Which of the following expression returns the first two rows of df, defined below? import pandas as pd
df = pd.DataFrame({'A':[34, 78, 54], 'B':[12, 67, 43]}, index=['r1', 'r2',

'r3'])

Both df[:2] and df.iloc[:2]
16) Which of the following expression returns last two rows of df, defined below? import pandas as pd
df = pd.DataFrame({'A':[34, 78, 54], 'B':[12, 67, 43]}, index=['r1', 'r2',

'r3'])

df.loc['r2':'r3']
17) What does the expression df.loc['r4'] = [67, 78] do for the data frame df, defined below? df = pd.DataFrame({'A':[34, 78, 54], 'B':[12, 67, 43]}, index=['r1', 'r2',
'r3'])

Add a new row
18) State whether the following statement is true or false? The read_csv method can read multiple columns of an input file as indexes.

True
19) Which of the following is used as an argument of read_csv method to skip first n lines of an input CSV file?

skiprows
20) State whether the following statement is true or false? The read_csv method, by default, reads all blank lines of an input CSV file.

False
21) is used as an argument of the readcsv method to make data of a specific column as an index.

index_col
22) Which of the following method is used to write a data frame data to an output CSV file?
to_csv
23) Which of the following is used as argument of read_csv method to treat data of specific columns as dates?

parse_dates
24) Which of the following method is used to read data from excel files? read_excel
25) What does the expression d + pd.Timedelta('1 days 2 hours') do to DatetimeIndex object d, defined below?

d = pd.date_range('11-Sep-2017', '17-Sep-2017', freq='2D')
Increases each datetime value by 1 day and 2 hours
26) What is the output of the following code? import pandas as pd
d = pd.date_range('11-Sep-2017', '17-Sep-2017', freq='2D')

len(d[d.isin(pd.to_datetime(['12-09-2017', '15-09-2017']))])

1
27) What is the length of DatetimeIndex object created with the below expression? pd.date_range('11-Sep-2017', '17-Sep-2017',
freq='2D')

4
28) Which of the following method is used to convert a list of dates like strings into datetime objects? to_datetime
29) What is the length of DatetimeIndex object created with the below expression? pd.bdate_range('11-Sep-2017', '17-Sep-2017',
freq='2D')

4
30) What is the length of PeriodIndex object created from the expression pd.period_range('11-Sep- 2017', '17-Sep-2017', freq='M')?

1
31) Which of the following method of pandas is used to check if each value is a null or not?

isnull
32) By default, missing values in any data set are read as ...........

NaN
33) Which of the following method is used to fill null values with a deafult value?

fillna
34) Unrecognized datetime value is treated as _.

NaT
35) Which of the following argument values are allowed for the method argument of fillna?

All the options
36) Which of the following method is used to eliminate rows with null values?
dropna
37) Which of the following methods is used to remove duplicates? drop_duplicates
38) Consider a data frame df with 10 rows and index [ 'r1', 'r2', 'r3', 'row4', 'row5', 'row6', 'r7', 'r8', 'r9', 'row10']. How many rows are obtained after executing the below expressions

g = df.groupby(df.index.str.len()) g.filter(lambda x: len(x) > 1)
9
39) Consider a data frame df with columns ['A', 'B', 'C', 'D'] and rows ['r1', 'r2', 'r3'], Which of the following expression is used to extract columns 'C' and 'D'?

df.loc[:, lambda x : x.columns.isin(['C', 'D'])]
40) Consider a data frame df with columns ['A', 'B', 'C', 'D'] and rows ['r1', 'r2', 'r3']. What does the expression df[lambda x : x.index.str.endswith('3')]

do? Filters the row labelled r3
41) Consider a data frame df with 10 rows and index [ 'r1', 'r2', 'r3', 'row4', 'row5', 'row6', 'r7', 'r8', 'r9', 'row10']. What does the aggregate method shown in below code do?

g = df.groupby(df.index.str.len()) g.aggregate({'A':len, 'B':np.sum})
Computes length of column A and Sum of Column B values of each group
42) Consider a data frame df with columns ['A', 'B', 'C', 'D'] and rows ['r1', 'r2', 'r3']. Which of the following expression filters the rows whose column B values are greater than 45 and column 'C' values are less than 30?

df.loc[(df.B > 45) & (df.C < 30)]
43) What does the expression df.iloc[:, lambda x : [0,3]] do? Consider a data frame df with columns ['A', 'B', 'C', 'D'] and rows ['r1', 'r2', 'r3'].
44) Which of the following method can be applied on a groupby object to get the group details?
groups
45) Consider a data frame df with columns ['A', 'B', 'C', 'D'] and rows ['r1', 'r2', 'r3']. Which of the following expression filters the rows whose column B values are greater than 45?

df[df.B > 45]
46) Which of the following methods is used to group data of a data frame, based on specific columns?

Which of the following methods is used to group data of a data frame, based on a specific column?
groupby
47) Consider a data frame df with 10 rows and index [ 'r1', 'r2', 'r3', 'row4', 'row5', 'row6', 'r7', 'r8', 'r9', 'row10']. What does the expression g = df.groupby(df.index.str.len()) do?

Data frames cannot be grouped by index values. Hence it results in Error.
48) Which of the following argument is used to set the key to be used for merging two data frames?

on
49) What is the shape of d defined in below code? import pandas as pd
s1 = pd.Series([0, 1, 2, 3])

s2 = pd.Series([0, 1, 2, 3])

s3 = pd.Series([0, 1, 4, 5])

d = pd.concat([s1, s2, s3], axis=1) (4,3)
50) Which of the following are allowed values of the argument how of merge method?

Which of the following are allowed values of argument how of merge method?
All the options
51) Which argument is used to override the existing column names, while using concat method?
keys
52) Which of the following argument is used to ignore the index while concatenating two data frames?
53) Which of the following method is used to concatenate two or more data frames?

concat

**************************************************

Python Pandas Hands-on solution --> Click here

**************************************************
Credit for the above notes, goes to the respective owners. 

If you have any queries, please feel free to ask on the comment section.
If you want MCQs and Hands-On solutions for any courses, Please feel free to ask on the comment section too.

Please share and support our page!

MNC Answers

Python Pandas MCQs Solution | TCS Fresco Play

1 comment

Azure Virtual Machines MCQs Solution | TCS Fresco Play

Node.Js Essentials Hands-On Solutions | TCS Fresco Play

Python 3 Functions and OOPs MCQs Solution | TCS Fresco Play

List of Fresco Play courses with MCQ and Hands-on | TCS Fresco Play

Artillery - API Freighting MCQs Solution | TCS Fresco Play

MNC Answers