In the following statement, if column ‘Rollno’ already exists in the DataFrame ‘D1’ then the assignment statement will __________ D1['Rollno'] = 11

  1. Home

- Online Exam Test Papers | - MCQs[multiple choice questions and answers ] | - Mock Test Papers | - Practice Papers | - Sample Test Papers |

Question:
In the following statement, if column ‘Rollno’ already exists in the DataFrame ‘D1’ then the assignment statement will __________
D1['Rollno'] = 11

1.Return error

2.Change all values of column Roll numbers to 11

3.Add new column

4.None of the above

More MCQS Questions and answers

  1. A _______________ is a two-dimensional labelled data structure .
  2. DF1.loc[ ] method is used to ______ # DF1 is a DataFrame
  3. Display first row of dataframe ‘DF’
  4. If the following statement return (5, 3) it means _____ >>> DF.shape #DF is a DataFrame object
  5. In given code dataframe ‘D1’ has _____ rows and _____ columns. import pandas as pd S1 = pd.Series([1, 2, 3, 4], index = ['a', 'b','c','d']) S2 = pd.Series([11, 22, 33, 44], index = ['a', 'bb','c','dd']) D1 = pd.DataFrame([S1,S2])
  6. The following code create a dataframe named ‘D1’ with ______ rows. import pandas as pd LoD = [{'a':10, 'b':20}, {'a':5, 'b':10, 'c':20}] D1 = pd.DataFrame(LoD)
  7. The following statement will _________ df = df.drop(['Name', 'Class', 'Rollno'], axis = 1) #df is a DataFrame object
  8. The parameter axis=’index’ of rename( ) function is used to specify that the __
  9. The ________________parameter of append() method in DataFrame may be set to True, when we do not want to use row index labels.
  10. What we are doing in the following statement? dF1=dF1.append(dF2) #dF1 and dF2 are DataFrame object
  11. When we create DataFrame from List of Dictionaries, then dictionary keys will become ___________
  12. Which of the following attribute of DataFrame display all the values from DataFrame?
  13. Which of the following function is used to load the data from the CSV file into a DataFrame?
  14. Which of the following parameter is used to specify row or column in rename function of DataFrame?
  15. Write statement to transpose dataframe DF.
  16. ______________ parameter is used in append( ) function of DataFrame to get the column labels in sorted order.
  17. D1[ : ] = 77 , will set __________ values of a Data Frame ‘D1’ to 77.
  18. DataFrame created from single Series has ____ column.
  19. DataFrame.loc[ ] is an important method that is used for ____________ with DataFrames
  20. Display last two rows from dataframe ‘DF’
  21. Following statement will display ___________ rows from DataFrame ‘DF1’. >>> DF1.head()
  22. If the DataFrame has more than one row with the same label, then DataFrame.drop( ) method will delete _____
  23. In DataFrame, by default new column added as the _____________ column
  24. In given code dataframe ‘D1’ has _____ rows and ______ columns.
  25. In given code dataframe ‘D1’ has ________ rows and _______ columns. import pandas as pd LoD = [{‘a’:10, ‘b’:20}, {‘a’:5, ‘b’:10, ‘c’:20},{‘a’:7, ‘d’:10, ‘e’:20}] D1 = pd.DataFrame(LoD)
  26. In Pandas _______________ is used to store data in multiple columns.
  27. In the following statement, if column ‘Rollno’ already exists in the DataFrame ‘D1’ then the assignment statement will __________ D1['Rollno'] = 11
  28. In the following statement, if column ‘Rollno’ already exists in the DataFrame ‘D1’ then the assignment statement will __________ D1['Rollno'] = [1, 2] #There are only three rows in DataFrame D1'
  29. In the following statement, if column ‘Rollno’ already exists in the DataFrame ‘D1’ then the assignment statement will _____________ D1['Rollno'] = [1,2,3] #There are only three rows in DataFrame D1'
  30. Parameters of read_csv( ) function is _____
  31. The append() method of DataFrame can also be used to append ____________to a DataFrame
  32. The default value for sep parameter is ____
  33. The following code create a dataframe named ‘D1’ with ___________ columns. import pandas as pd LoD = [{‘a’:10, ‘b’:20}, {‘a’:5, ‘b’:10, ‘c’:20}] D1 = pd.DataFrame(LoD)
  34. The following code create a dataframe named ‘D1’ with _______________ columns.
  35. The following statement is __________ >>> DF=DF.rename({‘Maths’:’Sub1′,‘Science’:’Sub2′}, axis=’index’) #DF is a DataFrame
  36. The following statement will display ________ rows of DataFrame ‘DF’ print(df.loc[[True, False,True]])
  37. The following statement will return the column as a _______ >>> DF.loc[: , 'Name'] #DF is a DataFrame object
  38. The following two statement will return _______________ >>> DF.loc[:,'Name'] #DF is a DataFrame object >>> DF['Name'] #DF is a DataFrame object
  39. To delete a column, the parameter axis of function drop( ) is assigned the value ____
  40. To delete a row, the parameter axis of function drop( ) is assigned the value __
  41. Transpose the DataFrame means _______
  42. We can add a new row to a DataFrame using the _____________ method
  43. We can create DataFrame from _____
  44. We can merge/join only those DataFrames which have same number of columns
  45. We can use the ______ method to merge two DataFrames
  46. What value should be given to axis parameter of rename function to alter column name?
  47. What will happen if in the rename( ) function we pass only a value for a row label that does not exist?
  48. When we create DataFrame from Dictionary of List then Keys becomes the ______
  49. When we create DataFrame from Dictionary of List then List becomes the __________
  50. When we create DataFrame from List of Dictionaries, then number of columns in DataFrame is equal to the _
  51. When we create DataFrame from List of Dictionaries, then number of rows in DataFrame is equal to the _______
  52. Which library is to be imported for creating DataFrame?
  53. Which method is used to change the labels of rows and columns in DataFrame?
  54. Which method is used to delete row or column in DataFrame?
  55. Which of the following are ways of indexing to access Data elements in a DataFrame?
  56. Which of the following attribute of DataFrame display the dimension of DataFrame
  57. Which of the following attribute of DataFrame is used to display column labels?
  58. Which of the following attribute of DataFrame is used to display data type of each column in DataFrame?
  59. Which of the following attribute of DataFrame is used to display row labels?
  60. Which of the following function display the last ‘n’ rows from the DataFrame?
  61. Which of the following function is used to create DataFrame?
  62. Which of the following is used to display first 2 rows of DataFrame ‘DF’?
  63. Which of the following is used to give user defined column index in DataFrame?
  64. Which of the following statement is Transposing the DataFrame ‘DF1’?
  65. Which property of dataframe is used to check that dataframe is empty or not?
  66. Write a statement to delete column labelled as ‘R1’ of DataFrame ‘DF’..
  67. Write statement to display the column labels of DataFrame ‘DF’
  68. Write statement to display the data types of each column of dataframe ‘DF’.
  69. Write statement to display the dimension of dataframe ‘DF’.
  70. Write statement to display the row labels of ‘DF’.
  71. Write the code to remove duplicate row labelled as ‘R1’ from DataFrame ‘DF1’
  72. Write the output of the statement >>>df.empty , if df has the following structure: Name Class Rollno 0 Amit 6 1 1 Anil 7 2 2 Ravi 8 3
  73. Write the output of the statement >>>df.shape , if df has the following structure. Name Class Rollno 0 Amit 6 1 1 Anil 7 2 2 Ravi 8 3
  74. Write the output of the statement >>>df.size , if df has the following structure: Name Class Rollno 0 Amit 6 1 1 Anil 7 2 2 Ravi 8 3
  75. _____ parameter of append( ) method may be set to True when we want to raise an error if the row labels are duplicate.
  76. _________ data Structure has both a row and column index.
R4R Team
R4Rin Top Tutorials are Core Java,Hibernate ,Spring,Sturts.The content on R4R.in website is done by expert team not only with the help of books but along with the strong professional knowledge in all context like coding,designing, marketing,etc!