def Kickstarter_Example_86():
print()
print(format('How to drop ROW and COLUMN in a Pandas DataFrame','*^82'))
import warnings
warnings.filterwarnings("ignore")
# load libraries
import pandas as pd
# Create a dataframe
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'])
print(); print(df)
# Drop an observation (row)
print(); print(df.drop(['Cochice', 'Pima']))
# Drop a variable (column) # Note: axis=1 denotes that we are referring to a column, not a row
print(); print(df.drop('reports', axis=1))
# Drop a row if it contains a certain value (in this case, “Tina”)
print(); print(df[df.name != 'Tina'])
# Drop a row by row number (in this case, row 3)
print(); print(df.drop(df.index[2]))
# can be extended to dropping a range
print(); print(df.drop(df.index[[2,3]]))
# dropping relative to the end of the DF.
print(); print(df.drop(df.index[-2]))
# Keep top 3
print(); print(df[:3])
# Drop bottom 3
print(); print(df[:-3])
Kickstarter_Example_86()