cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
%3CLINGO-SUB%20id%3D%22lingo-sub-659599%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3EHeatmap%20Plot%20-%20mescolando%20i%20colori%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-659599%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3ENella%20mia%20ricerca%20di%20alieni%20in%20BigClass%2C%20oggi%20voglio%20generare%20un%20grafico%20heatmap%20per%20mostrare%20gli%20alieni%20a%20colpo%20d'occhio.%3C%2FP%3E%3CP%3EL'idea%3A%20colorare%20di%20verde%20gli%20studenti%20non%20alieni%20e%20di%20rosso%20gli%20alieni.%3C%2FP%3E%3CP%3EMa%20con%20diversi%20non%20alieni%20nella%20stessa%20fascia%20di%20et%C3%A0%2C%20il%20rosso%20alieno%20%C3%A8%20appena%20visibile%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22hogi_3-1689680051325.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_3-1689680051325.png%22%20style%3D%22width%3A%20370px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_3-1689680051325.png%22%20style%3D%22width%3A%20370px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F54845i7299D74F0C0D3773%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22hogi_3-1689680051325.png%22%20alt%3D%22hogi_3-1689680051325.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EProssima%20idea%3A%3CBR%20%2F%3E%20Aumentiamo%20la%20trasparenza%20per%20i%20non%20alieni%20in%20modo%20tale%20che%20i%20gruppi%20di%20et%C3%A0%20con%20alieni%20all'interno%20diventino%20ben%20visibili.%3CBR%20%2F%3E%20Mi%20aspettavo%20che%20tali%20cellule%20diventassero%20rosse%20(con%20un%20tocco%20verdastro)%2C%20ma%20sono%20piuttosto%20verdi%2C%20non%20rosse.%3CBR%20%2F%3E%20Sembra%20che%20la%20trasparenza%20non%20sia%20trattata%20separatamente%20per%20colori%20diversi%2C%20ma%3CSTRONG%3E%20misto%3C%2FSTRONG%3E%20pure%20e%20poi%20applicato%20al%20colore%20misto.%3C%2FP%3E%3CP%3EQuindi%2C%205%25%20verde%20%2B%20100%25%20rosso%20d%C3%A0%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22hogi_2-1689680046296.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_2-1689680046296.png%22%20style%3D%22width%3A%20370px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_2-1689680046296.png%22%20style%3D%22width%3A%20370px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F54844iF88EFB04E361276B%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22hogi_2-1689680046296.png%22%20alt%3D%22hogi_2-1689680046296.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3Eultimo%20tentativo%3A%3CBR%20%2F%3E%20modificare%20il%20tipo%20di%20dati%20e%20utilizzare%20Statistiche%20di%20riepilogo%20massime%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22hogi_4-1689680624330.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_4-1689680624330.png%22%20style%3D%22width%3A%20388px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_4-1689680624330.png%22%20style%3D%22width%3A%20388px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F54846i9651105DB79ED68D%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22hogi_4-1689680624330.png%22%20alt%3D%22hogi_4-1689680624330.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EA%20volte%20%C3%A8%20pi%C3%B9%20facile%20passare%20dal%20carattere%20ai%20numeri%2C%20se%20vuoi%20aggregare%2C%20come%20qui.%3CBR%20%2F%3E%20Ma%20l'aggregazione%20dei%20valori%20dei%20caratteri%20ha%20anche%20qualche%20potenziale%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2FJMP-Wish-List%2FSummary-and-Tabulate-add-aggregation-option-for-Character%2Fm-p%2F659314%23U659314%22%20class%3D%22lia-mention-container-editor-message%20lia-img-icon-idea-thread%20lia-fa-icon%20lia-fa-idea%20lia-fa-thread%20lia-fa%22%20target%3D%22_blank%22%3ERiepilogo%20e%20tabella%3A%20aggiungi%20l'opzione%20di%20aggregazione%20per%20le%20colonne%20di%20caratteri%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3ENames%20Default%20To%20Here(%201%20)%3B%0Adt%20%3D%20Open(%20%22%24SAMPLE_DATA%2FBig%20Class.jmp%22%20)%3B%0Adt%20%26lt%3B%26lt%3B%20New%20Column(%20%22alien%22%2C%20Character%2Cnominal%2C%20set%20each%20value(%20%22-%22%20)%20)%3B%0Adt%20%26lt%3B%26lt%3B%20add%20rows(%20%7Bname%20%3D%20%22XX%22%2C%20alien%20%3D%20%22alien%22%2C%20sex%20%3D%20%22M%22%2C%20age%20%3D%2015%7D%20)%3B%0Adt%20%26lt%3B%26lt%3B%20add%20rows(%20%7Bname%20%3D%20%22YZ%22%2C%20alien%20%3D%20%22alien%22%2C%20sex%20%3D%20%22F%22%2C%20age%20%3D%2012%7D%20)%3B%0Adt%20%26lt%3B%26lt%3B%20add%20rows(%20%7Bname%20%3D%20%22KR%22%2C%20alien%20%3D%20%22alien%22%2C%20sex%20%3D%20%22F%22%2C%20age%20%3D%2017%7D%20)%3B%0A%0A%0A%2F%2F%20first%20attempt%0Adt%20%26lt%3B%26lt%3B%20Graph%20Builder(%0A%20Variables(%20X(%20%3Asex%20)%2C%20Y(%20%3Aage%20)%2C%20Color(%20%3Aalien%20)%20)%2C%0A%20Elements(%20Heatmap(%20X%2C%20Y%2C%20Legend(%2010%20)%20)%20)%2C%0A%20SendToReport(%0A%20%20Dispatch(%7B%7D%2C%22400%22%2CScaleBox%2C%0A%20%20%20%7BLegend%20Model(%2010%2C%20Properties(%200%2C%20%7BFill%20Color(%2036%20)%7D%2C%20Item%20ID(%20%22-%22%2C%201%20)%20)%20)%7D%0A%20%20)%0A%20)%0A)%3B%0A%0A%2F%2F%20second%20attempt%3A%20increase%20transparency%20for%20non-aliens%0Adt%20%26lt%3B%26lt%3B%20Graph%20Builder(%0A%20Variables(%20X(%20%3Asex%20)%2C%20Y(%20%3Aage%20)%2C%20Color(%20%3Aalien%20)%20)%2C%0A%20Elements(%20Heatmap(%20X%2C%20Y%2C%20Legend(%2010%20)%20)%20)%2C%0A%20SendToReport(%0A%20%20Dispatch(%0A%20%20%20%7B%7D%2C%0A%20%20%20%22400%22%2C%0A%20%20%20ScaleBox%2C%0A%20%20%20%7BLegend%20Model(%2010%2C%20Properties(%200%2C%20%7BFill%20Color(%2036%20)%2C%20Transparency(%200.05%20)%7D%2C%20Item%20ID(%20%22-%22%2C%201%20)%20)%20)%7D%0A%20%20)%0A%20)%0A)%3B%0A%0A%2F%2F%203rd%20attempt%3A%20aggregate%0AGraph%20Builder(%0A%20Variables(%0A%20%20X(%20%3Asex%20)%2C%0A%20%20Y(%20%3Aage%20)%2C%0A%20%20Color(%20%3Aalien_num%2C%20Summary%20Statistic(%20%22Max%22%20)%20)%0A%20)%2C%0A%20Elements(%20Heatmap(%20X%2C%20Y%2C%20Legend(%2010%20)%20)%20)%2C%0A%20SendToReport(%0A%20%20Dispatch(%0A%20%20%20%7B%7D%2C%0A%20%20%20%22400%22%2C%0A%20%20%20ScaleBox%2C%0A%20%20%20%7BLegend%20Model(%0A%20%20%20%2010%2C%0A%20%20%20%20Properties(%200%2C%20%7BFill%20Color(%2036%20)%7D%2C%20Item%20ID(%20%220%22%2C%201%20)%20)%0A%20%20%20)%7D%0A%20%20)%0A%20)%0A)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-659599%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CLINGO-LABEL%3EMiscelazione%20e%20pulizia%20dei%20dati%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EEsplorazione%20e%20visualizzazione%20dei%20dati%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Choose Language Hide Translation Bar
hogi
Level XII

Heatmap Plot - mixing colors

In my search for aliens in BigClass, today I want to generate a heatmap plot to show the aliens at a glance.

The idea: color the non-alien students green and the aliens red.

But with several non-aliens in the same age group, the alien red is just slightly visible:

hogi_3-1689680051325.png

 

Next idea:
Let's increase the transparency for non-aliens such that age groups with aliens inside get nicely visible.
I exected such cells to get red (with some greenish touch) - but they are quite green, not red.
Seems that transparency is not treated separately for different colors, but mixed as well and then applied to the mixed color.

So, 5% green + 100% red gives 

hogi_2-1689680046296.png

last attempt:
change the data type and use Max summary Statistics:

hogi_4-1689680624330.png

Sometimes it's easier to switch from character to numbers, if you want to aggregate - like here.
But aggregation of character values has also some potential:

Summary and Tabulate: add aggregation option for Character columns 

 

 

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
dt << New Column( "alien", Character,nominal, set each value( "-" ) );
dt << add rows( {name = "XX", alien = "alien", sex = "M", age = 15} );
dt << add rows( {name = "YZ", alien = "alien", sex = "F", age = 12} );
dt << add rows( {name = "KR", alien = "alien", sex = "F", age = 17} );


// first attempt
dt << Graph Builder(
	Variables( X( :sex ), Y( :age ), Color( :alien ) ),
	Elements( Heatmap( X, Y, Legend( 10 ) ) ),
	SendToReport(
		Dispatch({},"400",ScaleBox,
			{Legend Model( 10, Properties( 0, {Fill Color( 36 )}, Item ID( "-", 1 ) ) )}
		)
	)
);

// second attempt: increase transparency for non-aliens
dt << Graph Builder(
	Variables( X( :sex ), Y( :age ), Color( :alien ) ),
	Elements( Heatmap( X, Y, Legend( 10 ) ) ),
	SendToReport(
		Dispatch(
			{},
			"400",
			ScaleBox,
			{Legend Model( 10, Properties( 0, {Fill Color( 36 ), Transparency( 0.05 )}, Item ID( "-", 1 ) ) )}
		)
	)
);

// 3rd attempt: aggregate
Graph Builder(
	Variables(
		X( :sex ),
		Y( :age ),
		Color( :alien_num, Summary Statistic( "Max" ) )
	),
	Elements( Heatmap( X, Y, Legend( 10 ) ) ),
	SendToReport(
		Dispatch(
			{},
			"400",
			ScaleBox,
			{Legend Model(
				10,
				Properties( 0, {Fill Color( 36 )}, Item ID( "0", 1 ) )
			)}
		)
	)
)

 

 

0 REPLIES 0