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%E6%A0%B9%E6%8D%AE%E9%A2%9C%E8%89%B2%E9%80%89%E6%8B%A9%E5%8D%95%E5%85%83%E6%A0%BC%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-340919%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E4%BD%A0%E5%A5%BD%EF%BC%8C%3CBR%20%2F%3E%3CBR%20%2F%3E%E5%9C%A8%20JMP%20%E4%B8%AD%E8%BF%90%E8%A1%8C%E5%BC%82%E5%B8%B8%E5%80%BC%E5%88%86%E6%9E%90%E5%B7%A5%E5%85%B7%E5%90%8E%EF%BC%8C%E6%88%91%E5%AF%B9%E5%8C%85%E5%90%AB%E5%BC%82%E5%B8%B8%E5%80%BC%E7%9A%84%E5%8D%95%E5%85%83%E6%A0%BC%E8%BF%9B%E8%A1%8C%E4%BA%86%E9%A2%9C%E8%89%B2%E7%BC%96%E7%A0%81%E3%80%82%20%E5%A6%82%E4%BD%95%E9%80%89%E6%8B%A9%E6%89%80%E6%9C%89%E8%BF%99%E4%BA%9B%E5%8D%95%E5%85%83%E6%A0%BC%E5%B9%B6%E5%B0%86%E5%AE%83%E4%BB%AC%E6%9B%BF%E6%8D%A2%E4%B8%BA%E5%90%8D%E7%A7%B0%E2%80%9C%E5%BC%82%E5%B8%B8%E5%80%BC%E2%80%9D%EF%BC%9F%20%E4%B8%8B%E4%B8%80%E6%AD%A5%EF%BC%8C%E5%B0%86%E5%91%BD%E5%90%8D%E6%89%80%E6%9C%89%E5%85%B6%E4%BB%96%E5%8D%95%E5%85%83%E6%A0%BC%E4%B8%BA%E2%80%9C%E6%AD%A3%E5%B8%B8%E2%80%9D%E3%80%82%3CBR%20%2F%3E%3CBR%20%2F%3E%E8%AE%A9%E6%88%91%E7%9F%A5%E9%81%93%E8%BF%99%E6%98%AF%E5%90%A6%E5%8F%AF%E8%A1%8C%E3%80%82%20%E6%95%B0%E6%8D%AE%E8%A1%A8%E7%9A%84%E5%BF%AB%E7%85%A7%E9%99%84%E5%9C%A8%E8%BF%99%E7%AF%87%E6%96%87%E7%AB%A0%E4%B8%AD%E3%80%82%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%E8%84%9A%E6%9C%AC%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%3E%E5%9B%9E%E5%A4%8D%EF%BC%9A%E6%A0%B9%E6%8D%AE%E9%A2%9C%E8%89%B2%E9%80%89%E6%8B%A9%E5%8D%95%E5%85%83%E6%A0%BC%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-341111%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E8%BF%99%E5%BE%88%E5%A5%BD%E7%94%A8%EF%BC%81%3CBR%20%2F%3E%3CBR%20%2F%3E%E8%BF%AD%E4%BB%A3%E9%81%8D%E5%8E%86%E6%AF%8F%E4%B8%80%E5%88%97%E5%90%8D%E7%A7%B0%E8%80%8C%E4%B8%8D%E6%98%AF%E4%BB%85%E9%99%84%E5%8A%A0%E4%B8%80%E4%B8%AA%E5%88%97%E5%90%8D%E7%A7%B0%E7%9A%84%E8%AF%AD%E6%B3%95%E6%98%AF%E4%BB%80%E4%B9%88%EF%BC%9F%20%E4%BE%8B%E5%A6%82%EF%BC%8C%E6%82%A8%E5%A6%82%E4%BD%95%E9%99%90%E5%88%B6%E6%AD%A4%E5%BE%AA%E7%8E%AF%E4%BB%85%E6%9F%A5%E7%9C%8B%E7%AC%AC%201-10%20%E5%88%97%EF%BC%9F%3CBR%20%2F%3E%3CBR%20%2F%3E%E6%84%9F%E8%B0%A2%E8%84%9A%E6%9C%AC%E5%B8%AE%E5%8A%A9%EF%BC%8C%E8%BF%99%E6%98%AF%E5%BE%88%E6%A3%92%E7%9A%84%E4%B8%9C%E8%A5%BF%E3%80%82%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-341025%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%E5%9B%9E%E5%A4%8D%EF%BC%9A%E6%A0%B9%E6%8D%AE%E9%A2%9C%E8%89%B2%E9%80%89%E6%8B%A9%E5%8D%95%E5%85%83%E6%A0%BC%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-341025%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E4%BD%9C%E4%B8%BA%E6%96%B9%E6%B3%95%E7%9A%84%E6%9B%BF%E4%BB%A3%E6%96%B9%E6%B3%95%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F2687%22%20target%3D%22_blank%22%3E%40txnelson%3C%2FA%3E%20%EF%BC%8C%E6%88%96%E8%AE%B8%E5%80%BC%E5%BE%97%E5%9B%9E%E8%BF%87%E5%A4%B4%E6%9D%A5%E6%80%9D%E8%80%83%E4%B8%80%E4%B8%8B%E8%BF%99%E5%BC%A0%E6%A1%8C%E5%AD%90%E6%98%AF%E5%A6%82%E4%BD%95%E5%88%B6%E4%BD%9C%E7%9A%84%E3%80%82%20%E2%80%9CPenta%E2%80%9D%E7%A4%BA%E4%BE%8B%E6%95%B0%E6%8D%AE%E7%9A%84%E9%99%84%E5%8A%A0%E7%89%88%E6%9C%AC%E6%98%AF%E5%88%A9%E7%94%A8%E2%80%9C%E6%B7%BB%E5%8A%A0%E5%88%B0%E7%BC%BA%E5%A4%B1%E5%80%BC%E4%BB%A3%E7%A0%81%E2%80%9D%E9%80%89%E9%A1%B9%E5%88%B6%E4%BD%9C%E7%9A%84%EF%BC%9A%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%E7%84%B6%E5%90%8E%E6%82%A8%E5%8F%AF%E4%BB%A5%E4%BD%BF%E7%94%A8%E8%BF%99%E6%A0%B7%E7%9A%84%E4%BB%A3%E7%A0%81%EF%BC%8C%E5%AE%83%E6%9C%89%E4%B8%80%E4%B8%AA%E9%A2%9D%E5%A4%96%E7%9A%84%E5%A5%BD%E5%A4%84%EF%BC%8C%E5%8D%B3%E6%82%A8%E5%AE%9E%E9%99%85%E4%B8%8A%E5%B9%B6%E6%B2%A1%E6%9C%89%E6%9B%B4%E6%94%B9%E8%A1%A8%E4%B8%AD%E7%9A%84%E6%95%B0%E6%8D%AE%E5%80%BC%EF%BC%9A%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%3E%E5%9B%9E%E5%A4%8D%EF%BC%9A%E6%A0%B9%E6%8D%AE%E9%A2%9C%E8%89%B2%E9%80%89%E6%8B%A9%E5%8D%95%E5%85%83%E6%A0%BC%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-340977%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E6%88%91%E4%B8%8D%E7%9F%A5%E9%81%93%E4%BB%8E%E5%8D%95%E5%85%83%E6%A0%BC%E4%B8%AD%E8%8E%B7%E5%8F%96%E5%8D%95%E5%85%83%E6%A0%BC%E9%A2%9C%E8%89%B2%E7%9A%84%E7%AE%80%E5%8D%95%E6%96%B9%E6%B3%95%EF%BC%8C%E6%9B%B4%E4%B8%8D%E7%94%A8%E8%AF%B4%E4%B8%BA%E5%88%97%E4%B8%AD%E5%85%B7%E6%9C%89%E7%89%B9%E5%AE%9A%E9%A2%9C%E8%89%B2%E7%9A%84%E5%8D%95%E5%85%83%E6%A0%BC%E9%80%89%E6%8B%A9%E6%89%80%E6%9C%89%E8%A1%8C%E4%BA%86%E3%80%82%E4%BD%86%E6%98%AF%EF%BC%8C%E6%88%91%E8%BF%99%E6%A0%B7%E5%81%9A%E7%9A%84%E6%96%B9%E6%B3%95%E6%98%AF%E6%8F%90%E5%8F%96%E6%84%9F%E5%85%B4%E8%B6%A3%E7%9A%84%E5%88%97%E7%9A%84%E8%84%9A%E6%9C%AC%EF%BC%8C%E7%84%B6%E5%90%8E%E6%90%9C%E7%B4%A2%E8%84%9A%E6%9C%AC%E7%9A%84%E9%A2%9C%E8%89%B2%E5%8D%95%E5%85%83%E6%A0%BC%E5%8C%BA%E5%9F%9F%EF%BC%8C%E5%B9%B6%E8%A7%A3%E6%9E%90%E5%87%BA%E8%A1%8C%E3%80%82%3C%2FP%3E%0A%3CP%3E%E6%88%91%E9%99%84%E4%B8%8A%E4%BA%86%E4%B8%80%E4%B8%AA%E7%A4%BA%E4%BE%8B%E6%95%B0%E6%8D%AE%E8%A1%A8%E3%80%82%E6%95%B0%E6%8D%AE%E8%A1%A8%E6%98%AF%E4%BD%BF%E7%94%A8%E5%BC%82%E5%B8%B8%E5%80%BC%E5%88%86%E6%9E%90%E5%B7%A5%E5%85%B7%E7%94%9F%E6%88%90%E7%9A%84%E3%80%82%20%E5%BD%93%E4%B8%8B%E9%9D%A2%E7%9A%84%E8%84%9A%E6%9C%AC%E5%9C%A8%E8%AF%A5%E6%95%B0%E6%8D%AE%E8%A1%A8%E4%B8%8A%E8%BF%90%E8%A1%8C%E6%97%B6%EF%BC%8C%E5%AE%83%E4%BC%9A%E5%9C%A8%20SS-E%20%E5%88%97%E4%B8%AD%E6%89%BE%E5%88%B0%E6%B5%85%E7%BA%A2%E8%89%B2%E7%9A%84%E5%8D%95%E5%85%83%E6%A0%BC%EF%BC%88%E9%A2%9C%E8%89%B2%2035%20%E5%88%B0%20JMP%EF%BC%89%EF%BC%8C%E5%B9%B6%E5%B0%86%E8%BF%99%E4%BA%9B%E5%8D%95%E5%85%83%E6%A0%BC%E7%9A%84%E5%80%BC%E6%9B%B4%E6%94%B9%E4%B8%BA%E2%80%9C%E7%A6%BB%E7%BE%A4%E5%80%BC%E2%80%9D%EF%BC%8C%E7%84%B6%E5%90%8E%E6%9B%B4%E6%94%B9%E6%89%80%E6%9C%89%E5%85%B6%E4%BB%96%E7%BB%86%E8%83%9E%E7%9A%84%E2%80%9C%E6%AD%A3%E5%B8%B8%E2%80%9D%E3%80%82%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%E8%AF%B7%E6%B3%A8%E6%84%8F%EF%BC%8C%E8%A6%81%E5%B0%86%E5%8D%95%E5%85%83%E6%A0%BC%E6%9B%B4%E6%94%B9%E4%B8%BA%E2%80%9C%E7%A6%BB%E7%BE%A4%E5%80%BC%E2%80%9D%E6%88%96%E2%80%9C%E6%AD%A3%E5%B8%B8%E5%80%BC%E2%80%9D%EF%BC%8C%E5%BF%85%E9%A1%BB%E5%B0%86%E5%88%97%E6%9B%B4%E6%94%B9%E4%B8%BA%E5%AD%97%E7%AC%A6%E5%88%97%EF%BC%8C%E5%B9%B6%E6%9B%BF%E6%8D%A2%E6%89%80%E6%9C%89%E5%8E%9F%E5%A7%8B%E6%95%B0%E6%8D%AE%E3%80%82%3C%2FP%3E%0A%3CP%3E%E8%BF%99%E6%98%AF%E8%84%9A%E6%9C%AC%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%3E%E5%9B%9E%E5%A4%8D%EF%BC%9A%E6%A0%B9%E6%8D%AE%E9%A2%9C%E8%89%B2%E9%80%89%E6%8B%A9%E5%8D%95%E5%85%83%E6%A0%BC%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-774482%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3E%E5%8F%AF%E4%BB%A5%E9%80%9A%E8%BF%87%E5%88%97%E5%90%8E%E9%9D%A2%E7%9A%84%E8%84%9A%E6%9C%AC%E6%9D%A5%E8%8E%B7%E5%8F%96%E6%89%80%E6%9C%89%E5%BD%A9%E8%89%B2%E5%8D%95%E5%85%83%E6%A0%BC%EF%BC%9A%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%E5%A6%82%E4%BD%95%E5%9C%A8%E6%96%B0%E5%88%9B%E5%BB%BA%E7%9A%84%E5%88%97%E4%B8%AD%E8%8E%B7%E5%8F%96%E5%88%97%E4%B8%AD%E5%BD%A9%E8%89%B2%E5%8D%95%E5%85%83%E6%A0%BC%E7%9A%84%E8%A1%8C%E6%95%B0%E5%B9%B6%E4%B8%BA%E5%85%B6%E5%88%86%E9%85%8D%E6%A0%87%E7%AD%BE%EF%BC%88%E4%BE%8B%E5%A6%82%E2%80%9C1%E2%80%9D%EF%BC%89%EF%BC%9F%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar
View Original Published Thread

根据颜色选择单元格

MikeDereviankin
Level IV

你好,

在 JMP 中运行异常值分析工具后,我对包含异常值的单元格进行了颜色编码。 如何选择所有这些单元格并将它们替换为名称“异常值”? 下一步,将命名所有其他单元格为“正常”。

让我知道这是否可行。 数据表的快照附在这篇文章中。

undefined

 

This post originally written in English (US) has been computer translated for you. When you reply, it will also be translated back to English (US).

4 REPLIES 4
txnelson
Super User

回复:根据颜色选择单元格

我不知道从单元格中获取单元格颜色的简单方法,更不用说为列中具有特定颜色的单元格选择所有行了。但是,我这样做的方法是提取感兴趣的列的脚本,然后搜索脚本的颜色单元格区域,并解析出行。

我附上了一个示例数据表。数据表是使用异常值分析工具生成的。 当下面的脚本在该数据表上运行时,它会在 SS-E 列中找到浅红色的单元格(颜色 35 到 JMP),并将这些单元格的值更改为“离群值”,然后更改所有其他细胞的“正常”。

undefined

请注意,要将单元格更改为“离群值”或“正常值”,必须将列更改为字符列,并替换所有原始数据。

这是脚本

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


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

This post originally written in English (US) has been computer translated for you. When you reply, it will also be translated back to English (US).

ian_jmp
Level X

回复:根据颜色选择单元格

作为方法的替代方法@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);

This post originally written in English (US) has been computer translated for you. When you reply, it will also be translated back to English (US).

回复:根据颜色选择单元格

这很好用!

迭代遍历每一列名称而不是仅附加一个列名称的语法是什么? 例如,您如何限制此循环仅查看第 1-10 列?

感谢脚本帮助,这是很棒的东西。

This post originally written in English (US) has been computer translated for you. When you reply, it will also be translated back to English (US).

hogi
Level XII

回复:根据颜色选择单元格

This post originally written in English (US) has been computer translated for you. When you reply, it will also be translated back to English (US).