In a Pandas DataFrame, which value for axis will be used to delete a column?
In a Pandas DataFrame, which value for axis will be used to delete a column?
Show Hint
- axis = -1
- axis = 0
- axis = 1
- axis = 2
The Correct Option is C
Solution and Explanation
A DataFrame has two axes. axis = 0 stands for rows (the index). axis = 1 stands for columns.
Methods such as drop() use axis to decide whether a row label or a column label is removed.
Step 2: Apply this to deleting a column:
To delete a column we write df.drop('colname', axis=1). Here Pandas looks for 'colname' among the column labels and removes it.
With axis=0 it would look in the row index instead.
Step 3: Check option (A) axis = -1:
Pandas accepts only 0 and 1 (or the names 'index' and 'columns') for a DataFrame. Running df.drop('a', axis=-1) gives ValueError: No axis named -1. So (A) is wrong.
Step 4: Check option (B) axis = 0:
This removes rows, not columns. So (B) is wrong.
Step 5: Check option (D) axis = 2:
A DataFrame has only two axes (0 and 1). axis = 2 raises an error. So (D) is wrong.
Final Answer:
A column is deleted with axis = 1. This is option (C).
Top CBSE CLASS XII Informatics Practices Questions
State whether the following statement is True or False:
In Pandas Series, the Positional index can be a string or an integer.
We can add a new row to a DataFrame
DFusing the ______ method.Naveen discarded various types of waste material without realizing that e-waste contains harmful substances that could pollute the environment. He wants to know which of the following will be considered as e-waste?
In which scenario is a bar chart preferred over a line chart?
Which of the following network topology uses a central cable (backbone) to connect all devices?
Top CBSE CLASS XII Pandas Series and DataFrame Questions
State whether the following statement is True or False:
In Pandas Series, the Positional index can be a string or an integer.
We can add a new row to a DataFrame
DFusing the ______ method.Aditya is working on a DataFrame named
df. He has written the statement:print(df.loc['S2'])What will the above statement do?
In the context of creating a Pandas Series from a dictionary, which of the following statement is correct?
In Pandas, when extracting a portion of a Series
ser1usingser1[start:end]with positional indicesstartandend, which of the following statements is true?
Top CBSE CLASS XII Questions
- 2, b, c are in A.P. and the range of determinant $\begin{vmatrix}1&1&1\\ 2&b&c\\ 4&b^{2}&c^{2}\end{vmatrix}$ is [2, 16]. Then find range of c is
- A boy of mass 50 kg is standing at one end of a, boat of length 9 m and mass 400 kg. He runs to the other, end. The distance through which the centre of mass of the boat boy system moves is
- A capillary tube of radius r is dipped inside a large vessel of water. The mass of water raised above water level is M. If the radius of capillary is doubled, the mass of water inside capillary will be
- A circular disc is rotating about its own axis. An external opposing torque 0.02 Nm is applied on the disc by which it comes rest in 5 seconds. The initial angular momentum of disc is
- A circular disc is rotating about its own axis at uniform angular velocity \(\omega.\) The disc is subjected to uniform angular retardation by which its angular velocity is decreased to \(\frac {\omega}{2}\) during 120 rotations. The number of rotations further made by it before coming to rest is