topic Re: Insert 0 if missing Data in Discussions

Insert 0 if missing Data

voy-voy — Mon, 01 Jul 2024 08:02:25 GMT

Hello Community,

I searched for, but I can't find a skip in the Community.

I Looking for a Script, which simply make out of all missing Datas in my data table a "0" (Zero).

Thanks in advance

Andrea

Re: Insert 0 if missing Data

jthi — Mon, 01 Jul 2024 08:18:42 GMT

There are many posts regarding this in the community, here are few (I would suggest checking them in order)

Names Default To Here(1);

dt = Current Data Table();

nc = dt << get column names(Numeric);
mat = dt[0, nc];
mat[Loc(mat, .)] = 0;
dt[0, nc] = mat;

Write();

Re: Insert 0 if missing Data

hcarr01 — Mon, 01 Jul 2024 08:20:41 GMT

Bonjour,

Vous avez deux façons pour réaliser ce genre de chose.

La première serait d'utiliser un script comme ceci (prend en compte les colonnes numériques) :

dt = current data table();

nc = dt << get column names( Numeric );
For( i = 1, i <= 18, i++,
	Column( nc[i] )[dt << get rows where( Is Missing( As Column( nc[i] ) ) )] = 0
);

//the end of the loop is the number of your numeric columns

Ou si vous souhaitez le faire pour une colonne en particulier :

Names default to here(1);

// Ouvrir la table de données : Missing Data Pattern.jmp
dt = Open( "$SAMPLE_DATA/Missing Data Pattern.jmp" );


// Nouvelle colonne : Colonne 5
dt << New Column( "TEST",
	Numeric,
	"Continuous",
	Format( "Best", 12 ),
	Set Formula( If( Is Missing( :Trial 4 ), :TEST = 0, :TEST = :Trial 4 ) );
);

Re: Insert 0 if missing Data

txnelson — Mon, 01 Jul 2024 08:50:53 GMT

Here is one way of handling it

Names Default To Here( 1 );
dt = Current Data Table();
For( i = 1, i <= N Cols( dt ), i++,
	If( Column( dt, i ) << get data type == "Numeric",
		Column( dt, i )[Loc( dt[0, i], . )] = 0
	)
);

This example works, but Jarmo's response is best.

Re: Insert 0 if missing Data

P_Bartell — Mon, 01 Jul 2024 20:26:44 GMT

Without regard to the mechanics of changing missing values in a JMP data table from 'missing' to a numeric zero, you do realize that this change will make a huge difference in whatever analysis or data visualization technique you use in JMP for any variables in the data table where this change has been implemented? I can think of many situations where changing the value from 'missing' to a numeric zero would be a very improper thing to do. Without context of your reasons behind wanting to make this change...I just wanted to possibly alert you or others reading this thread that this type of change could be a very bad idea.