Answers for "pandas delete columns by name"

85

delete column pandas dataframe

df.drop(['column_1', 'Column_2'], axis = 1, inplace = True)
Posted by: Guest on November-08-2020
18

df.drop

>>>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
Posted by: Guest on March-26-2020
0

delete column in dataframe pandas

df = df.drop(df.columns[[0, 1, 3]], axis=1)  # df.columns is zero-based pd.Index
Posted by: Guest on March-29-2021
0

how to drop a column by name in pandas

>>> midx = pd.MultiIndex(levels=[['lama', 'cow', 'falcon'],
...                              ['speed', 'weight', 'length']],
...                      codes=[[0, 0, 0, 1, 1, 1, 2, 2, 2],
...                             [0, 1, 2, 0, 1, 2, 0, 1, 2]])
>>> df = pd.DataFrame(index=midx, columns=['big', 'small'],
...                   data=[[45, 30], [200, 100], [1.5, 1], [30, 20],
...                         [250, 150], [1.5, 0.8], [320, 250],
...                         [1, 0.8], [0.3, 0.2]])
>>> df
                big     small
lama    speed   45.0    30.0
        weight  200.0   100.0
        length  1.5     1.0
cow     speed   30.0    20.0
        weight  250.0   150.0
        length  1.5     0.8
falcon  speed   320.0   250.0
        weight  1.0     0.8
        length  0.3     0.2
Posted by: Guest on August-29-2020

Code answers related to "pandas delete columns by name"

Python Answers by Framework

Browse Popular Code Answers by Language