topic Re: Select multiple columns (numeric, continuous) and update missing column value ("" -> "0") in Discussions

Select multiple columns (numeric, continuous) and update missing column value ("" -> "0")

PS_Ato — Tue, 12 Nov 2019 12:34:51 GMT

Hi,

I found the following example:

Select Multiple Columns and Update Missing Column Value [ May 28, 2019 10:21 PM (1195 views)]

and tried to modifiy it to my case, but without succes.

Column 4 to 14 (numeric, continuous) have missing values, and I would like to have "0" instead.

The script below only works for data type (character, nominal). What do I need to change to make it work for data type (numeric)?

Names Default To Here( 1 );

dt_corr = Current Data Table();

// Fill-up columns with "0", when empty.
colNames_corr = dt_corr << get column names( string );

For( i = 4, i <= N Items( colNames_corr ), i++, 
	dt_corr << select where( As Column( colNames_corr[i] ) == "" );

	If( N Rows( dt_corr << get selected rows ) > 0,
		As Column( colNames_corr[i] )[dt_corr << get selected rows] = "0"
	);
);

Re: Select multiple columns (numeric, continuous) and update missing column value ("" -> "0")

ron_horne — Tue, 12 Nov 2019 12:48:04 GMT

Hi @PS_Ato

try the following:

https://community.jmp.com/t5/Discussions/Replace-missing-values-with-0/td-p/64614

https://community.jmp.com/t5/Discussions/set-value-to-selected-cells/m-p/62545/highlight/true#M33726

let us know if they do the job.

Re: Select multiple columns (numeric, continuous) and update missing column value ("" -> "0")

Mark_Zwald — Wed, 13 Nov 2019 04:54:52 GMT

The script would need to be modified as such to work with numeric columns:

Names Default To Here( 1 );
dt_corr = Current Data Table();
// Fill-up columns with "0", when empty.
colNames_corr = dt_corr << get column names( string );
For( i = 4, i <= N Items( colNames_corr ), i++, 
	dt_corr << select where( is missing(As Column( colNames_corr[i] )) == 1  );
	If( N Rows( dt_corr << get selected rows ) > 0,
		As Column( colNames_corr[i] )[dt_corr << get selected rows] = 0
	);
);

Re: Select multiple columns (numeric, continuous) and update missing column value ("" -> "0")

PS_Ato — Wed, 13 Nov 2019 09:51:32 GMT

many thanks - wonderful