Remove column from dataframe

Drop a column from dataframe

#To delete the column without having to reassign df
df.drop('column_name', axis=1, inplace=True)

Source: stackoverflow.com

Df drop column

df = df.drop(['B', 'C'], axis=1)

Source: pandas.pydata.org

Python code to drop columns from dataframe

# Let df be a dataframe
# Let new_df be a dataframe after dropping a column

new_df = df.drop(labels='column_name', axis=1)

# Or if you don't want to change the name of the dataframe
df = df.drop(labels='column_name', axis=1)

# Or to remove several columns
df = df.drop(['list_of_column_names'], axis=1)

# axis=0 for 'rows' and axis=1 for columns

Drop a column in pandas

note: df is your dataframe

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

Remove column from dataframe

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

Source: stackoverflow.com

Delete unnamed coloumns in pandas

# Best method so far.
df = df.loc[:, ~df.columns.str.contains('^Unnamed')]

Similar codes

-3 votes270 views1 answer
ValueError: With n_samples=0, test_size=0.2 and train_size=None, the resulting train set will be empty. Adjust any of the aforementioned parameters.
Python
2 votes315 views6 answers
What are args and kwargs in python
Python
109 votes235 views6 answers
Python string contains substring
Python
2 votes212 views1 answer
Public in python
Python
9 votes212 views1 answer
Comment out a block in python
Python
15 votes231 views4 answers
Check pip version
Python
39 votes203 views6 answers
Get file names in folder python
Python
0 vote239 views1 answer
Python get name of vlue
Python
0 vote223 views1 answer
How to read numbers from a text file in python
Python
0 vote206 views1 answer
Cieling function pandas
Python