Examples
In [1]:
import numpy as np
import pandas as pd
In [2]:
df = pd.DataFrame(np.arange(12).reshape(3, 4),
columns=['P', 'Q', 'R', 'S'])
df
Out[2]:
Drop columns:
In [3]:
df.drop(['Q', 'R'], axis=1)
Out[3]:
In [4]:
df.drop(columns=['Q', 'R'])
Out[4]:
Drop a row by index:
In [5]:
df.drop([0, 1])
Out[5]:
Drop columns and/or rows of MultiIndex DataFrame
In [6]:
midx = pd.MultiIndex(levels=[['deer', 'dog', 'eagle'],
['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=[[60, 35], [30, 12], [5.5, 1], [40, 20],
[25, 10], [4.5, 0.8], [320, 220],
[2, 0.8], [2.2, 0.2]])
df
Out[6]:
In [7]:
df.drop(index='dog', columns='small')
Out[7]:
In [8]:
df.drop(index='length', level=1)
Out[8]:
