Python Pandas MCQs Solution | TCS Fresco Play

1

Python Pandas MCQ Solutions | 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. 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[1]


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


    Add a new row


  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 


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

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!

Post a Comment

1Comments
* Please Don't Spam Here. All the Comments are Reviewed by Admin.
  1. Python Pandas Hands-on Solution --> https://www.mncanswers.site/2021/10/python-pandas-hands-on-solutions-tcs.html

    ReplyDelete
Post a Comment

#buttons=(Accept !) #days=(20)

Our website uses cookies to enhance your experience. Learn More
Accept !