How to select non null rows in a dataframe

Question

Shop_name         Bikes_available             Shop_location       Average_price_of_bikes   Rating_of_shop

NYC Velo          Ninja,hbx                      Salida                   5685$               4.2               
Bike Gallery      dtr,mtg,Harley Davidson        Portland                 6022$               4.8

This dataset is stored in dataframe named df. I am tying to create new dataframe that contains only those rows whose shop name, bikes_available and shop_location values are not null

xtrain = df[df['Shop_name','Bikes_available','Shop_location']!=NULL]

Its showing keyerror: ('Shop_name','Bikes_available','Shop_location')

Check out notna().

Quang Hoang
– Quang Hoang

2020-06-29 12:20:02 +00:00
Commented Jun 29, 2020 at 12:20 — Quang Hoang
– Quang Hoang, Commented Jun 29, 2020 at 12:20

gnoodle · Accepted Answer · 2022-08-12 04:54:56Z

9

First, select multiple columns use [[]]. Then, test for non missing values by DataFrame.notna with DataFrame.all:

xtrain = df[df[['Shop_name','Bikes_available','Shop_location']].notna().all(axis=1)]

edited Aug 12, 2022 at 4:54

gnoodle

18811 bronze badges

answered Jun 29, 2020 at 12:20

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

Collectives™ on Stack Overflow

How to select non null rows in a dataframe

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related