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'

  1. Home

Question:
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'

1.Return error

2.Replace the already existing values.

3.Add new column

4.None of the above

Posted Date:-2021-12-13 09:49:40

More MCQS Questions and answers

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