How do I remove a column from a dataframe using Pandas library for python?

Question

Trying to remove a column from a dataframe with simple line of code using panda for python.

The name of the column that i'm trying to remove is "Comments"

import pandas as pd  
location2 = 'datasets_travel_times.csv'     
travelTime_df= pd.read_csv(location2)  
traveltime_df = travelTime_df.drop('Comments',1)  
traveltime_df

It does not give any error; but then I print the dataframe and see that the column "Comments" is still there

Please provide enough information for us to replicate your code. That way we will be able to better help you. For more information, see minimal reproducible example — Andrew Fan
– Andrew Fan, Commented Oct 13, 2019 at 1:13

Ashish Agarwal · Accepted Answer · 2019-10-13 01:15:31Z

1

Here are 2 possible ways:-

First Way:-

 travelTime_df.drop(['Comments'], axis=1)

Second way:-

travelTime_df.drop(columns=['Comments'])

Adding link for deep dive:- https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.drop.html

answered Oct 13, 2019 at 1:15

Ashish Agarwal

6,29313 gold badges62 silver badges92 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Michael Gardner Over a year ago

Third way:- del travelTime_df['Comments']

Collectives™ on Stack Overflow

How do I remove a column from a dataframe using Pandas library for python?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related