Altcademy - a Forbes magazine logo Best Coding Bootcamp 2023

How to remove columns in Pandas

Understanding DataFrames in Pandas

Before we dive into the process of removing columns, let's ensure we're on the same page about what a DataFrame is. In Pandas, a DataFrame is a two-dimensional, size-mutable, and potentially heterogeneous tabular data structure with labeled axes (rows and columns). Think of it as a table in a spreadsheet or a database where each column is a feature or attribute, and each row is a record or entry.

Identifying Columns for Removal

Sometimes, you might find that not all columns in your DataFrame are useful for your analysis. They could be redundant, contain too much missing data, or simply not relevant to your current task. In such cases, you might want to remove one or more columns to tidy up your data and focus on what's important.

Removing a Single Column

Let's start with the basics: removing a single column. You can do this using the drop method. Imagine you have a DataFrame named df and you want to remove a column named 'unnecessary_column'. Here's how you would do it:

df = df.drop('unnecessary_column', axis=1)

The axis=1 parameter is crucial here. It tells Pandas that you want to drop a column, not a row. If you were to set axis=0, Pandas would look for a row with the label 'unnecessary_column', which is not what we want in this case.

Removing Multiple Columns

What if you have more than one column to remove? No problem. You can pass a list of column names to the drop method:

df = df.drop(['first_column_to_remove', 'second_column_to_remove'], axis=1)

Again, remember to set axis=1 to indicate that you are dropping columns.

Using the del Keyword

Another way to remove a column is by using the del keyword, which is a Python feature for deleting objects. This method is straightforward and works in-place, meaning it will change the original DataFrame without the need to reassign it:

del df['column_to_delete']

This method is handy for quickly removing a single column, but it doesn't allow you to delete multiple columns in one go.

Selecting Columns to Keep

Instead of specifying which columns to remove, you can also approach the problem from the other direction: specifying which columns to keep. This can be done by selecting those columns explicitly:

df = df[['column_to_keep1', 'column_to_keep2']]

This creates a new DataFrame with only the columns listed. It's a good method when you have a small number of columns you wish to retain compared to the number you want to remove.

Using the inplace Parameter

Most methods in Pandas that modify DataFrames have an inplace parameter. Setting inplace=True applies the operation on the DataFrame in place, without the need for reassignment:

df.drop('column_to_remove', axis=1, inplace=True)

This is equivalent to df = df.drop('column_to_remove', axis=1), but with inplace=True, the original df is modified directly.

Handling Errors Gracefully

What if the column you're trying to remove doesn't exist? By default, Pandas will throw an error. To handle this more gracefully, you can use the errors parameter:

df.drop('non_existent_column', axis=1, errors='ignore')

With errors='ignore', if the column is not found, nothing happens, and the DataFrame is returned unaltered, preventing your program from crashing due to a missing column.

Using Boolean Masks to Filter Columns

A more advanced technique involves using boolean masks. You can create a mask that specifies True for columns you want to keep and False for those you don't:

mask = df.columns.isin(['column_to_keep1', 'column_to_keep2'])
df = df.loc[:, mask]

This might seem a bit complex at first, but it's a powerful technique, especially when combined with other conditions to dynamically select columns.

Renaming Columns Before Removal

Sometimes, you might want to standardize column names before removing them. This can be done with the rename method:

df = df.rename(columns={'old_name': 'new_name'})
# Now you can drop the renamed column
df = df.drop('new_name', axis=1)

Renaming can help avoid confusion, especially if you're working with data from multiple sources with different naming conventions.

Understanding the Impact of Removing Columns

When you remove columns, you're discarding data. It's essential to understand the impact of this on your analysis. Always ensure that the columns you're removing are indeed unnecessary and that you're not losing valuable information.


Removing columns in a Pandas DataFrame is like decluttering your workspace: it helps you focus on the data that matters. Whether you're using the drop method, the del keyword, or a boolean mask, the goal is to streamline your dataset for better analysis. Remember, each method has its place, and understanding when to use each one is part of becoming a proficient data wrangler. As you continue your programming journey, you'll find that these operations become second nature, and you'll develop an intuition for managing your data effectively. So, go ahead and clean up those DataFrames, and may your insights be as clear as your well-curated datasets!