Count Null Values¶
Counts null value in columns using the specified input
Type¶
transform
Class¶
fire.nodes.etl.NodeNullCount
Fields¶
Name |
Title |
Description |
|---|---|---|
inputCols |
Input Columns |
Input Columns for which the number of nulls needs to be counted |
Details¶
Count Null Values Node¶
This node counts the number of null values in each specified column of a dataset.
Examples¶
Count Null Values Node Example¶
Given the following dataset:
id column1 column2 column3 column4 column5 column6 column7 column8
1 10.2 5 null 20 “A” null “C” “D”
2 null 6 15 30 “B” “E” null null
3 12.3 null 25 40 null “F” “G” “H”
If you configure the Count Null Values node to count null values in all columns, the output would look like this:
Column Name Number of Null Values
id 0
column1 1
column2 1
column3 1
column4 0
column5 1
column6 1
column7 1
column8 2