remove specific rows from dataframe python code example

Example 1: python: remove specific values in a dataframe

df.drop(df.index[df['myvar'] == 'specific_name'], inplace = True)

Example 2: 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 3: delete a row in pandas dataframe

df.drop(df.index[2])

Example 4: removing rows with specific column values from a dataframe

+---+--------------------------+----------------------------------+-----------+
| 1 | Sign up date | no_stores | no_unin_app     no_stores_recei  | ed_order  |
+---+--------------------------+----------------------------------+-----------+
| 2 | 2020-04-01   |      1    |             0                    |   0       |
| 3 | 2020-04-04   |     11    |             3                    |   6       |
| 4 | 2020-04-13   |      8    |             1                    |   4       |
+---+--------------------------+----------------------------------+-----------+