How to drop a value in a column with a specific condition?

Asked May 14 '20 at 08:32

Active May 15 '20 at 09:42

Viewed 20 times

I am new to pandas and I want to filter my column c (that is much longer on my df). I just need to drop the several E99 that are in column b.

df = pd.DataFrame(np.array([[1, 2, 3], [E99, 08A, 13B], [7, 8, 9]]),
                   columns=['a', 'b', 'c'])

This is my dataframe df:

   a  b    c
0  1  E99  3
1  4  08A  6
2  7  13B  9
....

I tried this :

df = df[df["b"] != "E99"]

but it just doesn't work, with this I have:

Any ideas?

edited May 15 '20 at 09:42

user78910

asked May 14 '20 at 08:32

Juliette Khan

3

Please mention what do you want your E99 to replace with? For example 0 or NaN? – user78910 May 14 '20 at 08:42
2

This syntax should do the job - `df.loc[df['b'] == 'E99', ['b']] = 'value_to_be_replaced'` – tidakdiinginkan May 14 '20 at 09:02

0 Answers0