Here is how to delete a column from a pandas dataframe in Python.


# Import the library and create a dataframe object
import pandas
df = pandas.DataFrame({'A': [1, 2], 'B': [10, 20]}) 
# Delete column A
del df['A'] 
# Print out the updated dataframe
print(df) 

Output

    B

0  10

1  20


Explanation

The del command can be used to delete a pandas dataframe column.

Another alternative that would also delete a dataframe column is this:

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

Note that drop does not modify the original dataframe. Instead, it returns a new modified dataframe object. In the line above, we are reassigning that new object to the existing df variable.


Related HowTos
Deploy a web app to Heroku
Schedule a Python script for execution at a specific time every day
Store Python passwords securely on Windows, Mac, and Linux
Do dictionary comprehension
Do list comprehension
Create a virtual environment
Create a new file
Merge two lists
Extract items from two different lists into one list
Check if a text file is empty
Randomly select an item from a list
Generate a random integer
Break a while loop
Create a pandas DataFrame from a dictionary
Create a pandas DataFrame from a list
Get the last item of a list
Access a column of a pandas dataframe
Create a class
Make a webpage request
Get the first two characters of a string
Loop through two lists at the same time
Recommended Course

Learn Flask development and learn to build cool apps with our premium Python course on Udemy.


Mailing List

We will keep you Python-motivated if you subscribe below.