Question

Identify the correct code to remove the column Humidity from the given dataframe, stated:

• A. statedf = statedf.pop('Humidity')
  print(statedf)
• B. statedf = statedf.pop(['Humidity'], axis = 1)
• C. statedf = statedf.drop(['Humidity'], axis = 0)
• D. statedf = statedf.drop(['Humidity'], axis = 1)
• A. statedf.loc[3]
• B. statedf.loc['Rajasthan']
• C. statedf.loc(3)
• D. statedf.loc('Rajasthan')
• A. statedf.size
• B. statedf.shape
• C. statedf.ndim
• D. statedf.index
• A. statedf.head(5), statedf.tail(-5)
• B. statedf.head(), statedf.tail(-5)
• C. statedf.head(5), statedf.tail(5)
• D. statedf.head(-5), statedf.tail(5)
• A.

  State	Value
  Assam	True
  Delhi	False
  Kerala	True
  Rajasthan	False
  Telangana	False

• B.

  State	Value
  Assam	True
  Delhi	False
  Kerala	True
  Rajasthan	False
  Telangana	False

• C.

  1	150
  3	120

• D.

  Assam	150
  Kerala	120

Answer 1

The Correct Option is D

The correct way to remove a column in a pandas dataframe is by using the `drop()` function with `axis = 1` to specify that you are removing a column (as opposed to a row). The `pop()` method is used for removing a column but does not support the `axis` parameter. Therefore, the correct syntax is: \[ \text{statedf = statedf.drop(['Humidity'], axis = 1)} \] Therefore, the correct answer is option (4).

Answer 2

To display all the data of the state "Rajasthan" from the dataframe, the correct syntax is `statedf.loc['Rajasthan']`. The `loc[]` function in pandas is used to access a group of rows and columns by labels or a boolean array. Here, 'Rajasthan' is the label of the row, and using `.loc` accesses the entire row of that state.
Therefore, the correct answer is option (2).

Answer 3

The `shape` attribute in pandas is used to display the dimensions of a DataFrame, which returns a tuple showing the number of rows and columns. For the given dataframe, `statedf.shape` will return a tuple (5, 4), indicating that the dataframe has 5 rows and 4 columns.
Therefore, the correct answer is "statedf.shape" (Option 2).

Answer 4

In pandas, the `head()` function is used to display the first few records of the dataframe, and by default, it shows the first 5 rows if no argument is passed. The `tail()` function displays the bottom rows of the dataframe. To display the bottom 5 records, we use `tail(5)`. Therefore, the correct statement is: \[ \text{statedf.head(5)}, \text{statedf.tail(5)} \] Thus, the correct answer is option (3).

Answer 5

The given Python code is used to filter the "Rainfall (in cm)" column and check which values are greater than 90. The `loc` function is used to access all rows (indicated by `:`) of the 'Rainfall (in cm)' column, and then the condition `> 90` is applied. The output will return `True` for the rows where the rainfall is greater than 90 and `False` otherwise. The result is:
- Assam: 150 cm>90, so True
- Delhi: 70 cm ≤ 90, so False
- Kerala: 120 cm>90, so True
- Rajasthan: 50 cm ≤ 90, so False
- Telangana: 90 cm ≤ 90, so False
Therefore, the correct output is option (1).