Grismar
0
Q:

drop df column

df.drop(['column_1', 'Column_2'], axis = 1, inplace = True) 
3
note: df is your dataframe

df = df.drop('coloum_name',axis=1)
5
df = df.drop('column_name', 1)
2
df.drop(columns=['Unnamed: 0'])
4
df = df.drop(['B', 'C'], axis=1)
4
#To delete the column without having to reassign df
df.drop('column_name', axis=1, inplace=True) 
0
#working with "text" syntax for the columns:
df.drop(['column_nameA', 'column_nameB'], axis=1, inplace=True)
1
# Import pandas package 
import pandas as pd 

# create a dictionary with five fields each 
data = { 
	'A':['A1', 'A2', 'A3', 'A4', 'A5'], 
	'B':['B1', 'B2', 'B3', 'B4', 'B5'], 
	'C':['C1', 'C2', 'C3', 'C4', 'C5'], 
	'D':['D1', 'D2', 'D3', 'D4', 'D5'], 
	'E':['E1', 'E2', 'E3', 'E4', 'E5'] } 

# Convert the dictionary into DataFrame 
df = pd.DataFrame(data) 

# Remove column name 'A' 
df.drop(['A'], axis = 1) 
2
df = df.drop(df.columns[[0, 1, 3]], axis=1)  # df.columns is zero-based pd.Index 
0
>>> df.drop(['B', 'C'], axis=1)
   A   D
0  0   3
1  4   7
2  8  11
0

New to Communities?

Join the community