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-340919%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%EC%83%89%EC%83%81%EC%9D%84%20%EA%B8%B0%EC%A4%80%EC%9C%BC%EB%A1%9C%20%EC%85%80%20%EC%84%A0%ED%83%9D%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-340919%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%EC%95%88%EB%85%95%ED%95%98%EC%84%B8%EC%9A%94%2C%3CBR%20%2F%3E%3CBR%20%2F%3E%20JMP%EC%97%90%EC%84%9C%20%EC%9D%B4%EC%83%81%EA%B0%92%20%EB%B6%84%EC%84%9D%20%EB%8F%84%EA%B5%AC%EB%A5%BC%20%EC%8B%A4%ED%96%89%ED%95%9C%20%ED%9B%84%20%EC%9D%B4%EC%83%81%EA%B0%92%EC%9D%B4%20%ED%8F%AC%ED%95%A8%EB%90%9C%20%EC%85%80%EC%9D%84%20%EC%83%89%EC%83%81%EC%9C%BC%EB%A1%9C%20%EA%B5%AC%EB%B6%84%ED%96%88%EC%8A%B5%EB%8B%88%EB%8B%A4.%20%EC%9D%B4%20%EC%85%80%EC%9D%84%20%EB%AA%A8%EB%91%90%20%EC%84%A0%ED%83%9D%ED%95%98%EA%B3%A0%20%22outlier%22%EB%9D%BC%EB%8A%94%20%EC%9D%B4%EB%A6%84%EC%9C%BC%EB%A1%9C%20%EB%B0%94%EA%BE%B8%EB%A0%A4%EB%A9%B4%20%EC%96%B4%EB%96%BB%EA%B2%8C%20%ED%95%B4%EC%95%BC%20%ED%95%A9%EB%8B%88%EA%B9%8C%3F%20%EB%8B%A4%EC%9D%8C%20%EB%8B%A8%EA%B3%84%EB%8A%94%20%EB%8B%A4%EB%A5%B8%20%EB%AA%A8%EB%93%A0%20%EC%85%80%EC%9D%98%20%EC%9D%B4%EB%A6%84%EC%9D%84%20%22%EC%A0%95%EC%83%81%22%EC%9C%BC%EB%A1%9C%20%EC%A7%80%EC%A0%95%ED%95%98%EB%8A%94%20%EA%B2%83%EC%9E%85%EB%8B%88%EB%8B%A4.%3CBR%20%2F%3E%3CBR%20%2F%3E%EC%9D%B4%EA%B2%83%EC%9D%B4%20%EA%B0%80%EB%8A%A5%ED%95%9C%EC%A7%80%20%EC%95%8C%EB%A0%A4%EC%A3%BC%EC%84%B8%EC%9A%94.%20%EC%9D%B4%20%EA%B2%8C%EC%8B%9C%EB%AC%BC%EC%97%90%20%EC%B2%A8%EB%B6%80%EB%90%9C%20%EB%8D%B0%EC%9D%B4%ED%84%B0%EC%8B%9C%ED%8A%B8%EC%9D%98%20%EC%8A%A4%EB%83%85%EC%83%B7%EC%9E%85%EB%8B%88%EB%8B%A4.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22MikeDereviankin_0-1607644587261.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22MikeDereviankin_0-1607644587261.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22MikeDereviankin_0-1607644587261.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22MikeDereviankin_0-1607644587261.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F28847iE4BAF074B6A57F3B%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22MikeDereviankin_0-1607644587261.png%22%20alt%3D%22MikeDereviankin_0-1607644587261.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-340919%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CLINGO-LABEL%3E%EC%8A%A4%ED%81%AC%EB%A6%BD%ED%8C%85%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-341111%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20%EC%83%89%EC%83%81%EC%97%90%20%EB%94%B0%EB%9D%BC%20%EC%85%80%20%EC%84%A0%ED%83%9D%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-341111%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%EC%9D%B4%EA%B2%83%EC%9D%80%20%ED%9B%8C%EB%A5%AD%ED%95%98%EA%B2%8C%20%EC%9E%91%EB%8F%99%ED%95%A9%EB%8B%88%EB%8B%A4!%3CBR%20%2F%3E%3CBR%20%2F%3E%ED%95%98%EB%82%98%EC%9D%98%20%EC%97%B4%20%EC%9D%B4%EB%A6%84%EB%A7%8C%20%EC%B6%94%EA%B0%80%ED%95%98%EB%8A%94%20%EB%8C%80%EC%8B%A0%20%EA%B0%81%20%EC%97%B4%20%EC%9D%B4%EB%A6%84%EC%9D%84%20%EB%B0%98%EB%B3%B5%EC%A0%81%EC%9C%BC%EB%A1%9C%20%EB%B0%98%EB%B3%B5%ED%95%98%EB%8A%94%20%EA%B5%AC%EB%AC%B8%EC%9D%80%20%EB%AC%B4%EC%97%87%EC%9E%85%EB%8B%88%EA%B9%8C%3F%20%EC%98%88%EB%A5%BC%20%EB%93%A4%EC%96%B4%20%EC%9D%B4%20%EB%A3%A8%ED%94%84%EA%B0%80%20%EC%97%B4%201-10%EB%A7%8C%20%EC%82%B4%ED%8E%B4%EB%B3%B4%EB%8F%84%EB%A1%9D%20%EC%96%B4%EB%96%BB%EA%B2%8C%20%EC%A0%9C%ED%95%9C%ED%95%A9%EB%8B%88%EA%B9%8C%3F%3CBR%20%2F%3E%3CBR%20%2F%3E%EC%8A%A4%ED%81%AC%EB%A6%BD%ED%8C%85%20%EB%8F%84%EC%9B%80%EC%9D%84%20%EC%A3%BC%EC%85%94%EC%84%9C%20%EA%B0%90%EC%82%AC%ED%95%A9%EB%8B%88%EB%8B%A4.%20%EC%9D%B4%EA%B2%83%EC%9D%80%20%ED%9B%8C%EB%A5%AD%ED%95%9C%20%EA%B2%83%EC%9E%85%EB%8B%88%EB%8B%A4.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-341025%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20%EC%83%89%EC%83%81%EC%97%90%20%EB%94%B0%EB%9D%BC%20%EC%85%80%20%EC%84%A0%ED%83%9D%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-341025%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%EC%A0%91%EA%B7%BC%20%EB%B0%A9%EC%8B%9D%EC%9D%98%20%EB%8C%80%EC%95%88%EC%9C%BC%EB%A1%9C%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F2687%22%20target%3D%22_blank%22%3E%20%40txnelson%3C%2FA%3E%20%2C%20%ED%85%8C%EC%9D%B4%EB%B8%94%EC%9D%B4%20%EC%96%B4%EB%96%BB%EA%B2%8C%20%EB%A7%8C%EB%93%A4%EC%96%B4%EC%A1%8C%EB%8A%94%EC%A7%80%20%EC%83%9D%EA%B0%81%ED%95%98%EA%B8%B0%20%EC%9C%84%ED%95%B4%20%ED%95%9C%20%EA%B1%B8%EC%9D%8C%20%EB%92%A4%EB%A1%9C%20%EB%8F%8C%EC%95%84%EA%B0%88%20%EA%B0%80%EC%B9%98%EA%B0%80%20%EC%9E%88%EC%9D%84%20%EA%B2%83%EC%9E%85%EB%8B%88%EB%8B%A4.%20'Penta'%20%EC%83%98%ED%94%8C%20%EB%8D%B0%EC%9D%B4%ED%84%B0%EC%9D%98%20%EC%B2%A8%EB%B6%80%EB%90%9C%20%EB%B2%84%EC%A0%84%EC%9D%80%20'%EB%88%84%EB%9D%BD%EB%90%9C%20%EA%B0%92%20%EC%BD%94%EB%93%9C%EC%97%90%20%EC%B6%94%EA%B0%80'%20%EC%98%B5%EC%85%98%EC%9D%84%20%ED%99%9C%EC%9A%A9%ED%95%98%EC%97%AC%20%EB%A7%8C%EB%93%A4%EC%96%B4%EC%A1%8C%EC%8A%B5%EB%8B%88%EB%8B%A4.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202020-12-11%20at%2012.03.00.png%22%20style%3D%22width%3A%20857px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Screenshot%202020-12-11%20at%2012.03.00.png%22%20style%3D%22width%3A%20857px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Screenshot%202020-12-11%20at%2012.03.00.png%22%20style%3D%22width%3A%20857px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Screenshot%202020-12-11%20at%2012.03.00.png%22%20style%3D%22width%3A%20857px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F28852iDAC388E6DAD57112%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202020-12-11%20at%2012.03.00.png%22%20alt%3D%22Screenshot%202020-12-11%20at%2012.03.00.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%EA%B7%B8%EB%9F%B0%20%EB%8B%A4%EC%9D%8C%20%EB%8B%A4%EC%9D%8C%EA%B3%BC%20%EA%B0%99%EC%9D%80%20%EC%BD%94%EB%93%9C%EB%A5%BC%20%EC%82%AC%EC%9A%A9%ED%95%A0%20%EC%88%98%20%EC%9E%88%EC%9C%BC%EB%A9%B0%20%ED%85%8C%EC%9D%B4%EB%B8%94%EC%9D%98%20%EB%8D%B0%EC%9D%B4%ED%84%B0%20%EA%B0%92%EC%9D%84%20%EC%8B%A4%EC%A0%9C%EB%A1%9C%20%EB%B3%80%EA%B2%BD%ED%95%98%EC%A7%80%20%EC%95%8A%EB%8A%94%EB%8B%A4%EB%8A%94%20%EC%B6%94%EA%B0%80%20%EC%9D%B4%EC%A0%90%EC%9D%B4%20%EC%9E%88%EC%8A%B5%EB%8B%88%EB%8B%A4.%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3ENamesDefaultToHere(1)%3B%0A%0Adt%20%3D%20DataTable(%22myPenta%22)%3B%0A%0A%2F%2F%20Pick%20a%20column%0AmyCol%20%3D%20Column(dt%2C%20%22L4%22)%3B%0A%0A%2F%2F%20Get%20the%20values%20deemed%20to%20be%20outliers%0Amvc%20%3D%20myCol%20%26lt%3B%26lt%3B%20getProperty(%22Missing%20Value%20Codes%22)%3B%0A%0A%2F%2F%20Delete%20this%20column%20property%2C%20else%20the%20subsequent%20'getValues()'%20will%20return%20'.'%0A%2F%2F%20rather%20than%20the%20cell%20value%20in%20the%20case%20of%20outliers%0AmyCol%20%26lt%3B%26lt%3B%20deleteProperty(%22Missing%20Value%20Codes%22)%3B%0A%0A%2F%2F%20Get%20all%20the%20values%0Avals%20%3D%20myCol%20%26lt%3B%26lt%3B%20getValues%3B%0A%0A%2F%2F%20Build%20the%20list%20to%20go%20into%20the%20'Value%20Label'%20property%0AvalList%20%3D%20%7B%7D%3B%0Afor(v%3D1%2C%20v%26lt%3B%3DNItems(vals)%2C%20v%2B%2B%2C%0A%20if(Contains(mvc%2C%20vals%5Bv%5D)%2C%0A%20%20%2F%2F%20We%20have%20an%20outlier%20.%20.%20.%0A%20%20InsertInto(valList%2C%20EvalExpr(Expr(vals%5Bv%5D)%20%3D%20%22Outlier%22))%2C%0A%20%20%2F%2F%20Else%20the%20point%20is%20'Normal'%0A%20%20InsertInto(valList%2C%20EvalExpr(Expr(vals%5Bv%5D)%20%3D%20%22Normal%22))%0A%20%20)%0A%20)%3B%0A%0A%2F%2F%20Add%20the%20'Value%20Label'%20property%0AmyCol%20%26lt%3B%26lt%3B%20valueLabels(valList)%3B%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-340977%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20%EC%83%89%EC%83%81%EC%97%90%20%EB%94%B0%EB%9D%BC%20%EC%85%80%20%EC%84%A0%ED%83%9D%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-340977%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%ED%8A%B9%EC%A0%95%20%EC%83%89%EC%83%81%EC%9D%B4%20%EC%9E%88%EB%8A%94%20%EC%97%B4%EC%9D%98%20%EC%85%80%EC%97%90%20%EB%8C%80%ED%95%9C%20%EB%AA%A8%EB%93%A0%20%ED%96%89%EC%9D%84%20%EC%84%A0%ED%83%9D%ED%95%98%EB%8A%94%20%EA%B2%83%EC%9D%80%20%EB%A7%90%ED%95%A0%20%EA%B2%83%EB%8F%84%20%EC%97%86%EA%B3%A0%20%EC%85%80%EC%97%90%EC%84%9C%20%EC%85%80%20%EC%83%89%EC%83%81%EC%9D%84%20%EA%B0%80%EC%A0%B8%EC%98%A4%EB%8A%94%20%EC%89%AC%EC%9A%B4%20%EB%B0%A9%EB%B2%95%EC%9D%84%20%EC%95%8C%EC%A7%80%20%EB%AA%BB%ED%95%A9%EB%8B%88%EB%8B%A4.%EA%B7%B8%EB%9F%AC%EB%82%98%20%EB%82%B4%EA%B0%80%20%ED%95%98%EB%8A%94%20%EB%B0%A9%EB%B2%95%EC%9D%80%20%EA%B4%80%EC%8B%AC%20%EC%9E%88%EB%8A%94%20%EC%97%B4%EC%97%90%20%EB%8C%80%ED%95%9C%20%EC%8A%A4%ED%81%AC%EB%A6%BD%ED%8A%B8%EB%A5%BC%20%EC%B6%94%EC%B6%9C%ED%95%9C%20%EB%8B%A4%EC%9D%8C%20%EC%8A%A4%ED%81%AC%EB%A6%BD%ED%8A%B8%EC%9D%98%20Color%20Cells%20%EC%98%81%EC%97%AD%EC%9D%84%20%EA%B2%80%EC%83%89%ED%95%98%EA%B3%A0%20%ED%96%89%EC%9D%84%20%EA%B5%AC%EB%AC%B8%20%EB%B6%84%EC%84%9D%ED%95%98%EB%8A%94%20%EA%B2%83%EC%9E%85%EB%8B%88%EB%8B%A4.%3C%2FP%3E%0A%3CP%3E%EC%83%98%ED%94%8C%20%EB%8D%B0%EC%9D%B4%ED%84%B0%20%ED%91%9C%EB%A5%BC%20%EC%B2%A8%EB%B6%80%ED%96%88%EC%8A%B5%EB%8B%88%EB%8B%A4.%EB%8D%B0%EC%9D%B4%ED%84%B0%20%ED%85%8C%EC%9D%B4%EB%B8%94%EC%9D%80%20Outlier%20Analysis%20Tool%EC%9D%84%20%EC%82%AC%EC%9A%A9%ED%95%98%EC%97%AC%20%EC%83%9D%EC%84%B1%EB%90%98%EC%97%88%EC%8A%B5%EB%8B%88%EB%8B%A4.%20%ED%95%B4%EB%8B%B9%20%EB%8D%B0%EC%9D%B4%ED%84%B0%20%ED%85%8C%EC%9D%B4%EB%B8%94%EC%97%90%EC%84%9C%20%EC%95%84%EB%9E%98%20%EC%8A%A4%ED%81%AC%EB%A6%BD%ED%8A%B8%EB%A5%BC%20%EC%8B%A4%ED%96%89%ED%95%98%EB%A9%B4%20SS-E%20%EC%97%B4%EC%97%90%EC%84%9C%20%EB%B0%9D%EC%9D%80%20%EB%B9%A8%EA%B0%84%EC%83%89(%EC%83%89%EC%83%81%2035%EC%97%90%EC%84%9C%20JMP)%EC%9C%BC%EB%A1%9C%20%ED%91%9C%EC%8B%9C%EB%90%9C%20%EC%85%80%EC%9D%84%20%EC%B0%BE%EA%B3%A0%20%ED%95%B4%EB%8B%B9%20%EC%85%80%EC%9D%98%20%EA%B0%92%EC%9D%84%20%22outlier%22%EB%A1%9C%20%EB%B3%80%EA%B2%BD%ED%95%9C%20%EB%8B%A4%EC%9D%8C%20%EB%AA%A8%EB%91%90%20%EB%B3%80%EA%B2%BD%ED%95%A9%EB%8B%88%EB%8B%A4.%20%EB%8B%A4%EB%A5%B8%20%EC%85%80%EC%9D%98%20%22%EC%A0%95%EC%83%81%22.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22sc1.PNG%22%20style%3D%22width%3A%20787px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22sc1.PNG%22%20style%3D%22width%3A%20787px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22sc1.PNG%22%20style%3D%22width%3A%20787px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22sc1.PNG%22%20style%3D%22width%3A%20787px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F28848i459133851C82C4C3%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22sc1.PNG%22%20alt%3D%22sc1.PNG%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%EC%85%80%EC%9D%84%20%22outlier%22%20%EB%98%90%EB%8A%94%20%22normal%22%EB%A1%9C%20%EB%B3%80%EA%B2%BD%ED%95%98%EB%A0%A4%EB%A9%B4%20%EC%97%B4%EC%9D%84%20%EB%AC%B8%EC%9E%90%20%EC%97%B4%EB%A1%9C%20%EB%B3%80%EA%B2%BD%ED%95%B4%EC%95%BC%20%ED%95%98%EB%A9%B0%20%EC%9B%90%EB%9E%98%20%EB%8D%B0%EC%9D%B4%ED%84%B0%EA%B0%80%20%EB%AA%A8%EB%91%90%20%EB%8C%80%EC%B2%B4%EB%90%A9%EB%8B%88%EB%8B%A4.%3C%2FP%3E%0A%3CP%3E%EC%8A%A4%ED%81%AC%EB%A6%BD%ED%8A%B8%EB%8A%94%20%EB%8B%A4%EC%9D%8C%EA%B3%BC%20%EA%B0%99%EC%8A%B5%EB%8B%88%EB%8B%A4.%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3Enames%20default%20to%20here(1)%3B%0Adt%3Dcurrent%20data%20table()%3B%0A%0A%0Ax%3Dchar(%3Aname(%22ss-e%22)%26lt%3B%3CGET%20script%3D%22%22%3E%3C%2FGET%3E%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-774482%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20%EC%83%89%EC%83%81%EC%9D%84%20%EA%B8%B0%EC%A4%80%EC%9C%BC%EB%A1%9C%20%EC%85%80%20%EC%84%A0%ED%83%9D%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-774482%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3E%EC%97%B4%20%EB%92%A4%EC%97%90%20%EC%9E%88%EB%8A%94%20%EC%8A%A4%ED%81%AC%EB%A6%BD%ED%8A%B8%EB%A5%BC%20%ED%86%B5%ED%95%B4%20%EB%AA%A8%EB%93%A0%20%EC%83%89%EC%83%81%EC%9D%B4%20%EC%A7%80%EC%A0%95%EB%90%9C%20%EC%85%80%EC%9D%84%20%EC%96%BB%EC%9D%84%20%EC%88%98%20%EC%9E%88%EC%8A%B5%EB%8B%88%EB%8B%A4.%3CBR%20%2F%3E%20%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2FDiscussions%2FHow-to-get-the-row-number-of-colored-cells-in-a-column-and%2Fm-p%2F749264%23U749264%22%20class%3D%22lia-mention-container-editor-message%20lia-img-icon-forum-thread%20lia-fa-icon%20lia-fa-forum%20lia-fa-thread%20lia-fa%22%20target%3D%22_blank%22%3E%EC%97%B4%EC%97%90%20%EC%9E%88%EB%8A%94%20%EC%83%89%EC%83%81%20%EC%85%80%EC%9D%98%20%ED%96%89%20%EB%B2%88%ED%98%B8%EB%A5%BC%20%EA%B0%80%EC%A0%B8%EC%98%A4%EA%B3%A0%20%EC%83%88%EB%A1%9C%20%EC%83%9D%EC%84%B1%EB%90%9C%20%EC%97%B4%EC%97%90%20%ED%83%9C%EA%B7%B8(%EC%98%88%3A%20%221%22)%EB%A5%BC%20%ED%95%A0%EB%8B%B9%ED%95%98%EB%8A%94%20%EB%B0%A9%EB%B2%95%EC%9D%80%20%EB%AC%B4%EC%97%87%EC%9E%85%EB%8B%88%EA%B9%8C%3F%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar
View Original Published Thread

색상을 기준으로 셀 선택

MikeDereviankin
Level IV

안녕하세요,

JMP에서 이상값 분석 도구를 실행한 후 이상값이 포함된 셀을 색상으로 구분했습니다. 이 셀을 모두 선택하고 "outlier"라는 이름으로 바꾸려면 어떻게 해야 합니까? 다음 단계는 다른 모든 셀의 이름을 "정상"으로 지정하는 것입니다.

이것이 가능한지 알려주세요. 이 게시물에 첨부된 데이터시트의 스냅샷입니다.

undefined

 

원래 English (US) 로 작성된 이 게시물은 귀하의 편의를 위해 번역되었습니다. 답장을 보내면 English (US) 로 다시 번역됩니다.

4 REPLIES 4
txnelson
Super User

Re: 색상에 따라 셀 선택

특정 색상이 있는 열의 셀에 대한 모든 행을 선택하는 것은 말할 것도 없고 셀에서 셀 색상을 가져오는 쉬운 방법을 알지 못합니다.그러나 내가 하는 방법은 관심 있는 열에 대한 스크립트를 추출한 다음 스크립트의 Color Cells 영역을 검색하고 행을 구문 분석하는 것입니다.

샘플 데이터 표를 첨부했습니다.데이터 테이블은 Outlier Analysis Tool을 사용하여 생성되었습니다. 해당 데이터 테이블에서 아래 스크립트를 실행하면 SS-E 열에서 밝은 빨간색(색상 35에서 JMP)으로 표시된 셀을 찾고 해당 셀의 값을 "outlier"로 변경한 다음 모두 변경합니다. 다른 셀의 "정상".

undefined

셀을 "outlier" 또는 "normal"로 변경하려면 열을 문자 열로 변경해야 하며 원래 데이터가 모두 대체됩니다.

스크립트는 다음과 같습니다.

names default to here(1);
dt=current data table();


x=char(:name("ss-e")<

원래 English (US) 로 작성된 이 게시물은 귀하의 편의를 위해 번역되었습니다. 답장을 보내면 English (US) 로 다시 번역됩니다.

ian_jmp
Level X

Re: 색상에 따라 셀 선택

접근 방식의 대안으로 @txnelson , 테이블이 어떻게 만들어졌는지 생각하기 위해 한 걸음 뒤로 돌아갈 가치가 있을 것입니다. 'Penta' 샘플 데이터의 첨부된 버전은 '누락된 값 코드에 추가' 옵션을 활용하여 만들어졌습니다.

undefined

그런 다음 다음과 같은 코드를 사용할 수 있으며 테이블의 데이터 값을 실제로 변경하지 않는다는 추가 이점이 있습니다.

NamesDefaultToHere(1);

dt = DataTable("myPenta");

// Pick a column
myCol = Column(dt, "L4");

// Get the values deemed to be outliers
mvc = myCol << getProperty("Missing Value Codes");

// Delete this column property, else the subsequent 'getValues()' will return '.'
// rather than the cell value in the case of outliers
myCol << deleteProperty("Missing Value Codes");

// Get all the values
vals = myCol << getValues;

// Build the list to go into the 'Value Label' property
valList = {};
for(v=1, v<=NItems(vals), v++,
 if(Contains(mvc, vals[v]),
  // We have an outlier . . .
  InsertInto(valList, EvalExpr(Expr(vals[v]) = "Outlier")),
  // Else the point is 'Normal'
  InsertInto(valList, EvalExpr(Expr(vals[v]) = "Normal"))
  )
 );

// Add the 'Value Label' property
myCol << valueLabels(valList);

원래 English (US) 로 작성된 이 게시물은 귀하의 편의를 위해 번역되었습니다. 답장을 보내면 English (US) 로 다시 번역됩니다.

Re: 색상에 따라 셀 선택

이것은 훌륭하게 작동합니다!

하나의 열 이름만 추가하는 대신 각 열 이름을 반복적으로 반복하는 구문은 무엇입니까? 예를 들어 이 루프가 열 1-10만 살펴보도록 어떻게 제한합니까?

스크립팅 도움을 주셔서 감사합니다. 이것은 훌륭한 것입니다.

원래 English (US) 로 작성된 이 게시물은 귀하의 편의를 위해 번역되었습니다. 답장을 보내면 English (US) 로 다시 번역됩니다.

hogi
Level XII

Re: 색상을 기준으로 셀 선택

열 뒤에 있는 스크립트를 통해 모든 색상이 지정된 셀을 얻을 수 있습니다.
열에 있는 색상 셀의 행 번호를 가져오고 새로 생성된 열에 태그(예: "1")를 할당하는 방법은 무엇입니까?

원래 English (US) 로 작성된 이 게시물은 귀하의 편의를 위해 번역되었습니다. 답장을 보내면 English (US) 로 다시 번역됩니다.