1

# 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. 1) Which of the following cannot be used to create a Data frame? A tuple of tuples

2. 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. 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. 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. 5) Which of the following attributes or arguments are used to set column names of a data frame?

columns

6. 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. 7) Which of the following is not a Data Structure of Pandas? Dictionary

8. 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. 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. 10) Which of the following argument is used to label the elements of a series?

Index

11. 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. 12) Which of the following expression is used to delete the column, A from a data frame named df? del df['A']

13. 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. 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

15. 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. 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. 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'])

18. 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. 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. 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. 21) is used as an argument of the readcsv method to make data of a specific column as an index.

index_col

22. 22) Which of the following method is used to write a data frame data to an output CSV file?

to_csv

23. 23) Which of the following is used as argument of read_csv method to treat data of specific columns as dates?

parse_dates

24. 24) Which of the following method is used to read data from excel files? read_excel

25. 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. 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. 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. 28) Which of the following method is used to convert a list of dates like strings into datetime objects? to_datetime

29. 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. 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. 31) Which of the following method of pandas is used to check if each value is a null or not?

isnull

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

NaN

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

fillna

34. 34) Unrecognized datetime value is treated as _.

NaT

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

All the options

36. 36) Which of the following method is used to eliminate rows with null values?

dropna

37. 37) Which of the following methods is used to remove duplicates? drop_duplicates

38. 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. 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. 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. 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. 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. 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. 44) Which of the following method can be applied on a groupby object to get the group details?

groups

45. 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. 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. 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. 48) Which of the following argument is used to set the key to be used for merging two data frames?

on

49. 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. 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. 51) Which argument is used to override the existing column names, while using concat method?

keys

52. 52) Which of the following argument is used to ignore the index while concatenating two data frames?

53. 53) Which of the following method is used to concatenate two or more data frames?

concat

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

```**************************************************
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!```

1.  