How to select all columns except one in a Pandas DataFrame?

To select all columns except one column in Pandas DataFrame, we can use df.loc[:, df.columns != <column name>].

Steps

• Create a two-dimensional, size-mutable, potentially heterogeneous tabular data, df.

• Print the input DataFrame, df.

• Initialize a variable col with column name that you want to exclude.

• Use df.loc[:, df.columns != col] to create another DataFrame excluding a particular column.

• Print the DataFrame without col column.

Example

<span class="kwd">import</span><span class="pln"> pandas </span><span class="kwd">as</span><span class="pln"> pd

df </span><span class="pun">=</span><span class="pln"> pd</span><span class="pun">.</span><span class="typ">DataFrame</span><span class="pun">(</span><span class="pln">
   </span><span class="pun">{</span><span class="pln">
      </span><span class="str">"x"</span><span class="pun">:</span><span class="pln"> </span><span class="pun">[</span><span class="lit">5</span><span class="pun">,</span><span class="pln"> </span><span class="lit">2</span><span class="pun">,</span><span class="pln"> </span><span class="lit">1</span><span class="pun">,</span><span class="pln"> </span><span class="lit">9</span><span class="pun">],</span><span class="pln">
      </span><span class="str">"y"</span><span class="pun">:</span><span class="pln"> </span><span class="pun">[</span><span class="lit">4</span><span class="pun">,</span><span class="pln"> </span><span class="lit">1</span><span class="pun">,</span><span class="pln"> </span><span class="lit">5</span><span class="pun">,</span><span class="pln"> </span><span class="lit">10</span><span class="pun">],</span><span class="pln">
      </span><span class="str">"z"</span><span class="pun">:</span><span class="pln"> </span><span class="pun">[</span><span class="lit">4</span><span class="pun">,</span><span class="pln"> </span><span class="lit">1</span><span class="pun">,</span><span class="pln"> </span><span class="lit">5</span><span class="pun">,</span><span class="pln"> </span><span class="lit">0</span><span class="pun">]</span><span class="pln">
   </span><span class="pun">}</span><span class="pln">
</span><span class="pun">)</span><span class="pln">
</span><span class="kwd">print</span><span class="pun">(</span><span class="str">"Input DataFrame is:<br>"</span><span class="pun">,</span><span class="pln"> df</span><span class="pun">)</span><span class="pln">

col </span><span class="pun">=</span><span class="pln"> </span><span class="str">"y"</span><span class="pln">
df1 </span><span class="pun">=</span><span class="pln"> df</span><span class="pun">.</span><span class="pln">loc</span><span class="pun">[:,</span><span class="pln"> df</span><span class="pun">.</span><span class="pln">columns </span><span class="pun">!=</span><span class="pln"> col</span><span class="pun">]</span><span class="pln">

</span><span class="kwd">print</span><span class="pln"> </span><span class="str">"DataFrame without Column-y: <br>"</span><span class="pun">,</span><span class="pln"> df1</span>

Output

Input DataFrame is:
   x  y  z
0  5  4  4
1  2  1  1
2  1  5  5
3  9 10  0

DataFrame without Column-y:
   x  z
0  5  4
1  2  1
2  1  5
3  9  0