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%3EGr%C3%A1fico%20de%20mapa%20de%20calor%3A%20mezcla%20de%20colores%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-659599%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EEn%20mi%20b%C3%BAsqueda%20de%20extraterrestres%20en%20BigClass%2C%20hoy%20quiero%20generar%20un%20diagrama%20de%20mapa%20de%20calor%20para%20mostrar%20a%20los%20extraterrestres%20de%20un%20vistazo.%3C%2FP%3E%3CP%3ELa%20idea%3A%20colorear%20a%20los%20estudiantes%20no%20alien%C3%ADgenas%20de%20verde%20y%20a%20los%20alien%C3%ADgenas%20de%20rojo.%3C%2FP%3E%3CP%3EPero%20con%20varios%20no%20alien%C3%ADgenas%20en%20el%20mismo%20grupo%20de%20edad%2C%20el%20rojo%20alien%C3%ADgena%20es%20apenas%20visible%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%3ESiguiente%20idea%3A%3CBR%20%2F%3E%20Aumentemos%20la%20transparencia%20para%20los%20no%20extraterrestres%2C%20de%20modo%20que%20los%20grupos%20de%20edad%20con%20extraterrestres%20dentro%20se%20vean%20bien.%3CBR%20%2F%3E%20Expuls%C3%A9%20esas%20c%C3%A9lulas%20para%20que%20se%20pusieran%20rojas%20(con%20un%20toque%20verdoso)%2C%20pero%20son%20bastante%20verdes%2C%20no%20rojas.%3CBR%20%2F%3E%20Parece%20que%20la%20transparencia%20no%20se%20trata%20por%20separado%20para%20diferentes%20colores%2C%20pero%3CSTRONG%3E%20mezclado%3C%2FSTRONG%3E%20tambi%C3%A9n%20y%20luego%20se%20aplica%20al%20color%20mezclado.%3C%2FP%3E%3CP%3EEntonces%2C%205%25%20verde%20%2B%20100%25%20rojo%20da%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%3E%C3%BAltimo%20intento%3A%3CBR%20%2F%3E%20cambie%20el%20tipo%20de%20datos%20y%20use%20Estad%C3%ADsticas%20de%20resumen%20m%C3%A1ximas%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%20veces%20es%20m%C3%A1s%20f%C3%A1cil%20cambiar%20de%20car%C3%A1cter%20a%20n%C3%BAmeros%2C%20si%20desea%20agregar%2C%20como%20aqu%C3%AD.%3CBR%20%2F%3E%20Pero%20la%20agregaci%C3%B3n%20de%20valores%20de%20caracteres%20tambi%C3%A9n%20tiene%20cierto%20potencial%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%3EResumen%20y%20tabulaci%C3%B3n%3A%20agregue%20la%20opci%C3%B3n%20de%20agregaci%C3%B3n%20para%20las%20columnas%20de%20caracteres%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%3EFusi%C3%B3n%20y%20limpieza%20de%20datos%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExploraci%C3%B3n%20y%20visualizaci%C3%B3n%20de%20datos%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