how to delete rows in dataframe python code example
Example 1: python code to drop columns from dataframe
# 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
Example 2: pandas how to delete a row
>>> df
A B C D
0 0 1 2 3
1 4 5 6 7
2 8 9 10 11
Drop a row by index
df.drop([0, 1])
A B C D
2 8 9 10 11
Drop columns
df.drop(columns=['B', 'C'])
A D
0 0 3
1 4 7
2 8 11