Python Forum
ISNULL/NVL alternative in filter
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
ISNULL/NVL alternative in filter
#1
Hi,
I'm very new in data science and Python,so i'm trying now to learn by playing with the data
i'm trying to select data from data Frame where the containing column data is neither None or NaN or NA
In SQL this will be very simple to do IFNULL(GarageType,"NA") <> "NA" or NVL(GarageType,"NA") <> "NA"
I'm Python i cannot find a similar option ( enclosed example). Can anyone help with a better solution

Quote:c1[(c1["MiscFeature"].isna()) & ((c1["GarageType"] != "NA") & (c1["GarageType"].notna()) )][["MiscFeature","GarageType","CentralAir","Heating","PoolQC"]]

Thank You,
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  isnull() in pandas not able to identify blank value (Python coding) darpInd 1 2,089 Mar-20-2020, 11:14 AM
Last Post: scidam
  Looking for Eval alternative scionsamurai 2 2,896 Jul-16-2019, 02:41 AM
Last Post: scionsamurai

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020