Pandas loc not filtering properly

Question

I am using pandas to read a csv file and then trying to filter by some condition to remove blank/null/NaN values and then sorting. it still does not filter and returns all the contents. Below is the code. The cells in the csv under the"Status" columns either have some value or they are blank and in some cases have the actual word "NaN."

df = pd.read_csv("**************", encoding="ISO-8859-1")
df = df.loc[(df["Status"] != "Ready") | (df["Status"] != "NaN") | (df["Status"] != "") | (df["Status"] != " ")]
df = df.sort_values(by=["Room Number"])
df = df.reset_index(drop=True)

replace "NaN" with np.NaN and import numpy as np

Jason Baker
– Jason Baker

2023-02-10 16:17:57 +00:00
Commented Feb 10, 2023 at 16:17 — Jason Baker
– Jason Baker, Commented Feb 10, 2023 at 16:17

Hadi Farahani · Accepted Answer · 2023-02-12 19:35:15Z

0

if u want to remove rows with na, u can use code pd.dropna(axis = 0). for changing " " and any cell for nan befor removing nan, u can use below: df.replace(' ', np.nan, inplace=True)

edited Feb 12, 2023 at 19:35

answered Feb 12, 2023 at 19:34

Hadi Farahani

11 bronze badge

Sign up to request clarification or add additional context in comments.

1 Comment

xlmaster Over a year ago

if you want to remove rows with na, you can use code pd.dropna(axis = 0). for changing " " and any cell for nan before removing nan, you can use below: df.replace(' ', np.nan, inplace=True)

Collectives™ on Stack Overflow

Pandas loc not filtering properly

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related