/Python/Delete rows based on condition python

Delete rows based on condition python

Pandas drop rows with value in list

import pandas as pd

a = ['2015-01-01' , '2015-02-01']

df = pd.DataFrame(data={'date':['2015-01-01' , '2015-02-01', '2015-03-01' , '2015-04-01', '2015-05-01' , '2015-06-01']})

print(df)
#         date
#0  2015-01-01
#1  2015-02-01
#2  2015-03-01
#3  2015-04-01
#4  2015-05-01
#5  2015-06-01

df = df[~df['date'].isin(a)]

print(df)
#         date
#2  2015-03-01
#3  2015-04-01
#4  2015-05-01
#5  2015-06-01

Source: stackoverflow.com

Delete rows based on condition python

df = df.drop(df[df.score < 50].index)

Source: stackoverflow.com

Delete rows based on condition python

df.drop(df[df.score < 50].index, inplace=True)

Source: stackoverflow.com

Similar codes

0 vote175 views1 answer
How do you say not equal to python
Python
0 vote150 views1 answer
How to store svgs in django image field with SVGAndImageFormField
Python
1 vote130 views1 answer
Python convert base
Python
74 votes151 views9 answers
Online python compiler
Python
0 vote184 views1 answer
Error: The file/path provided (flaskr) does not appear to exist. Please verify the path is correct. If app is not on PYTHONPATH, ensure the extension is .py
Python Flask
0 vote134 views1 answer
Python file hashlib
Python
0 vote150 views1 answer
Sort values within groups pandas dataframe
Python
1 vote132 views1 answer
Get content of one column in pandas
Python
1 vote134 views1 answer
Private instance attribute python
Python
27 votes139 views3 answers
Splitting a string and appending each character to a list python
Python