Title: Dropping Rows And Columns In pandas Dataframe
Slug: pandas_dropping_column_and_rows
Summary: Dropping Rows And Columns In pandas Dataframe
Date: 2016-05-01 12:00
Category: Python
Tags: Data Wrangling
Authors: Chris Albon
In [1]:
import pandas as pd
In [2]:
data = {'name': ['Jason', 'Molly', 'Tina', 'Jake', 'Amy'],
'year': [2012, 2012, 2013, 2014, 2014],
'reports': [4, 24, 31, 2, 3]}
df = pd.DataFrame(data, index = ['Cochice', 'Pima', 'Santa Cruz', 'Maricopa', 'Yuma'])
df
Out[2]:
In [3]:
df.drop(['Cochice', 'Pima'])
Out[3]:
In [4]:
df.drop('reports', axis=1)
Out[4]:
In [5]:
df[df.name != 'Tina']
Out[5]:
In [6]:
df.drop(df.index[2])
Out[6]:
can be extended to dropping a range
In [7]:
df.drop(df.index[[2,3]])
Out[7]:
or dropping relative to the end of the DF.
In [8]:
df.drop(df.index[-2])
Out[8]:
you can select ranges relative to the top or drop relative to the bottom of the DF as well.
In [9]:
df[:3] #keep top 3
Out[9]:
In [10]:
df[:-3] #drop bottom 3
Out[10]: