filter out the rows containing missing values?

[ipazin]

Hi Kiro!

Glad it worked.

Don’t think Column Expressions node is too advanced. It is based on JavaScript so if you are not familiar with it might be a bit harder at the beginning. Just wanted to point out that the node has possibility to perform calculations compared to rule engine nodes

Br,
Ivan

[TigerCole]

Hi Steve,

Joining this conversation very late, but being able to delete rows with missing values using a single module would be incredibly useful for me.

I get a lot of massive data sets (in the region of 400 million rows) and some of them may have more than 100 columns, so being able to remove “missing value” rows as simply as possible would be a real benefit.

tC/.

[s.roughley]

Thanks - I will have a think about this. In the meantime, it may be possible using the Missing Values node - see this thread with an example workflow:

Filter missing values

Hi all, I have a excel file which contains 4 columns. With these three columns I would like to create patterns. Name | Surname | Birthday | Country So now there are some rows which are filled with all 4 information, but also row where for example Birthday is missing or a row where Surname and Country is missing. I would like to filter out all rows where, missing values are included. I have tried it with the missing value column filter but it didn’t work. Could you help me? cheers, Canan

Steve

[SamirAbida]

Hello There,

If someone pass by and is interested in this matter, you should know that there is a useful node :

Missing Value Column Filter

Br,
Samir

[uleon]

MISSING $COL1$ AND MISSING $COL2$ AND MISSING $COL3$ => TRUE