Altcademy - a Forbes magazine logo Best Coding Bootcamp 2023

How to remove a column in Pandas

Understanding DataFrames in Pandas

Before we dive into the process of removing a column, it's important to understand the structure we're working with. In Pandas, a DataFrame is like a table with rows and columns, similar to what you might find in an Excel spreadsheet. Each column in a DataFrame can be thought of as a list of entries, much like a column in a real-world ledger or a list of ingredients in a recipe. The rows represent individual records or entries, each with data corresponding to the various columns.

Identifying the Column to Remove

Imagine your DataFrame as a bookshelf, with each column being a book. If you want to remove a book, you need to know its title. Similarly, in Pandas, to remove a column, you need to know its name, which is the string that labels the top of the column. This name is the key to telling Pandas which piece of data you want to take out.

Removing a Column Using drop

The drop method in Pandas is like telling a friend to pick up a specific book from your shelf and put it away. It's the primary tool for removing columns. Here's how you might use it:

import pandas as pd

# Create a simple DataFrame
df = pd.DataFrame({
    'Name': ['Alice', 'Bob', 'Charlie'],
    'Age': [24, 27, 22],
    'City': ['New York', 'Los Angeles', 'Chicago']

# Remove the 'Age' column
df = df.drop('Age', axis=1)


In the code above, axis=1 is an instruction that specifies we're working with columns (axis=0 would refer to rows). After running this code, the DataFrame df no longer contains the 'Age' column.

Using the del Statement

If drop is like asking a friend to help, del is like picking up the book yourself and removing it. It's a more direct, Pythonic way to remove a column:

# Assume the same DataFrame as before
del df['City']


After this operation, the 'City' column is gone. The del statement is straightforward and efficient, but it doesn't allow for the flexibility of the drop method, such as removing multiple columns at once or creating a copy of the DataFrame without the removed column.

Removing Multiple Columns

What if you have more than one book to remove? In Pandas, you can drop multiple columns in a single line:

# Create a DataFrame with multiple columns
df = pd.DataFrame({
    'Name': ['Alice', 'Bob', 'Charlie'],
    'Age': [24, 27, 22],
    'City': ['New York', 'Los Angeles', 'Chicago'],
    'Occupation': ['Engineer', 'Designer', 'Writer']

# Remove 'Age' and 'City' columns
df = df.drop(['Age', 'City'], axis=1)


Here, by passing a list of column names to drop, we tell Pandas to remove both 'Age' and 'City' at the same time.

In-Place Removal

Sometimes, you may want to remove a column without having to reassign the DataFrame. This can be done using the inplace=True parameter:

# Remove 'Occupation' column and modify the DataFrame in place
df.drop('Occupation', axis=1, inplace=True)


With inplace=True, the DataFrame df is updated directly, and there's no need to write df = df.drop(...).

Handling Errors Gracefully

Let's say you're trying to remove a book that isn't on your shelf. Similarly, you might attempt to drop a column that doesn't exist in your DataFrame. Pandas will raise an error. To handle this gracefully, you can use the errors='ignore' parameter:

# Attempt to remove a non-existent column
df.drop('Salary', axis=1, errors='ignore', inplace=True)

If 'Salary' isn't a column in df, no error will be raised, and the DataFrame will remain unchanged.

Alternatives to Removing Columns

Sometimes, instead of taking books off your shelf, you might want to select only the books you're interested in reading. Similarly, in Pandas, you can select specific columns to keep, effectively removing the others:

# Select only the 'Name' and 'Occupation' columns
df = df[['Name', 'Occupation']]


This technique creates a new DataFrame with only the chosen columns.


Removing a column in Pandas is like tidying up your bookshelf: it's about organizing your data in a way that makes sense for your current needs. Whether you use drop, del, or simply select the columns you want to keep, the goal is to streamline your DataFrame so that you're only working with the data that matters to you. With the methods discussed, even those who are new to programming can confidently manipulate their data sets, ensuring that their analysis is both efficient and relevant. Remember, managing data is an art, and with each column you remove, you're sculpting your masterpiece. Happy data cleaning!