How To Drop Columns In Pandas Code Example

Snippet 1
  # 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 
Snippet 2
  df = pd.DataFrame(np.arange(12).reshape(3, 4),
...                   columns=['A', 'B', 'C', 'D'])
>>> df
   A  B   C   D
0  0  1   2   3
1  4  5   6   7
2  8  9  10  11

Drop columns
>>> df.drop(['B', 'C'], axis=1)
   A   D
0  0   3
1  4   7
2  8  11
>>> df.drop(columns=['B', 'C'])
   A   D
0  0   3
1  4   7
2  8  11 
Snippet 3
  DataFrame.drop(self, labels=None, axis=0, index=None, columns=None, level=None, inplace=False, errors='raise')[source] 
Snippet 4
  >>>df = pd.DataFrame(np.arange(12).reshape(3, 4), 
                     columns=['A', 'B', 'C', 'D'])
>>>df
   A  B   C   D
0  0  1   2   3
1  4  5   6   7
2  8  9  10  11

>>> df.drop(['B', 'C'], axis=1)
   A   D
0  0   3
1  4   7
2  8  11

OR

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

Similar Snippets


How To Drop Columns In Pandas Code Example - pandas

Pandas Select All Columns Except One Code Example - pandas

How To Set Pandas Dataframe As Global Code Example - pandas

How To Change Column Name In Pandas Code Example - pandas

Pandas Merge Two Columns From Different Dataframes Code Example - pandas

Onehot Encode List Of Columns Pandas Code Example - pandas

How To Merge Two Column Pandas Code Example - pandas

Pandas Iterrows Code Example - pandas

Slicing In Pandas Code Example - pandas

Pandas Count Rows With Value Code Example - pandas

Add An Index Column Pandas Code Example - pandas

Pandas Ttable With Sum Totals Code Example - pandas

Remove 1st Column Pandas Code Example - pandas

Pandas Dataframe Froms String Code Example - pandas

Combine Two Dataframe In Pandas Code Example - pandas

Str_Count On Pandas Series Code Example - pandas

Convert Pandas Data Frame To Latex File Code Example - pandas

Append New Data On Pandas Dataframe Code Example - pandas

Getting Dummies And Input Them To Pandas Dataframe Code Example - pandas

Index Max Pandas Code Example - pandas

Rename Row Pandas Code Example - pandas

Dictionary To A Dataframe Pandas Arrays Must All Be Same Length Code Example - pandas

Pandas Cumulative Sum Column Code Example - pandas

Creating A Pandas Df Code Example - pandas

Pandas Read From Website Code Example - pandas

Pandas Show Top 10 Rows Code Example - pandas

Pandas Read Excel With Two Headers Code Example - pandas

Pandas Frame Convert String Code Example - pandas

Reshape Wide To Long In Pandas Code Example - pandas