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%93%9A%E9%A1%8F%E8%89%B2%E9%81%B8%E6%93%87%E5%96%AE%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%E9%81%8B%E8%A1%8C%E7%95%B0%E5%B8%B8%E5%80%BC%E5%88%86%E6%9E%90%E5%B7%A5%E5%85%B7%E5%BE%8C%EF%BC%8C%E6%88%91%E5%B0%8D%E5%8C%85%E5%90%AB%E7%95%B0%E5%B8%B8%E5%80%BC%E7%9A%84%E5%96%AE%E5%85%83%E6%A0%BC%E9%80%B2%E8%A1%8C%E4%BA%86%E9%A1%8F%E8%89%B2%E7%B7%A8%E7%A2%BC%E3%80%82%20%E5%A6%82%E4%BD%95%E9%81%B8%E6%93%87%E6%89%80%E6%9C%89%E9%80%99%E4%BA%9B%E5%96%AE%E5%85%83%E6%A0%BC%E4%B8%A6%E5%B0%87%E5%AE%83%E5%80%91%E6%9B%BF%E6%8F%9B%E7%82%BA%E5%90%8D%E7%A8%B1%E2%80%9C%E7%95%B0%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%87%E5%91%BD%E5%90%8D%E6%89%80%E6%9C%89%E5%85%B6%E4%BB%96%E5%96%AE%E5%85%83%E6%A0%BC%E7%82%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%93%E6%88%91%E7%9F%A5%E9%81%93%E9%80%99%E6%98%AF%E5%90%A6%E5%8F%AF%E8%A1%8C%E3%80%82%20%E6%95%B8%E6%93%9A%E8%A1%A8%E7%9A%84%E5%BF%AB%E7%85%A7%E9%99%84%E5%9C%A8%E9%80%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%85%B3%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%93%9A%E9%A1%8F%E8%89%B2%E9%81%B8%E6%93%87%E5%96%AE%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%E9%80%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%E6%AD%B7%E6%AF%8F%E4%B8%80%E5%88%97%E5%90%8D%E7%A8%B1%E8%80%8C%E4%B8%8D%E6%98%AF%E5%83%85%E9%99%84%E5%8A%A0%E4%B8%80%E5%80%8B%E5%88%97%E5%90%8D%E7%A8%B1%E7%9A%84%E8%AA%9E%E6%B3%95%E6%98%AF%E4%BB%80%E9%BA%BC%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%92%B0%E5%83%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%AC%9D%E8%85%B3%E6%9C%AC%E5%B9%AB%E5%8A%A9%EF%BC%8C%E9%80%99%E6%98%AF%E5%BE%88%E6%A3%92%E7%9A%84%E6%9D%B1%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%93%9A%E9%A1%8F%E8%89%B2%E9%81%B8%E6%93%87%E5%96%AE%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%E7%82%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%A8%B1%E5%80%BC%E5%BE%97%E5%9B%9E%E9%81%8E%E9%A0%AD%E4%BE%86%E6%80%9D%E8%80%83%E4%B8%80%E4%B8%8B%E9%80%99%E5%BC%B5%E6%A1%8C%E5%AD%90%E6%98%AF%E5%A6%82%E4%BD%95%E8%A3%BD%E4%BD%9C%E7%9A%84%E3%80%82%20%E2%80%9CPenta%E2%80%9D%E7%A4%BA%E4%BE%8B%E6%95%B8%E6%93%9A%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%A2%BC%E2%80%9D%E9%81%B8%E9%A0%85%E8%A3%BD%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%BE%8C%E6%82%A8%E5%8F%AF%E4%BB%A5%E4%BD%BF%E7%94%A8%E9%80%99%E6%A8%A3%E7%9A%84%E4%BB%A3%E7%A2%BC%EF%BC%8C%E5%AE%83%E6%9C%89%E4%B8%80%E5%80%8B%E9%A1%8D%E5%A4%96%E7%9A%84%E5%A5%BD%E8%99%95%EF%BC%8C%E5%8D%B3%E6%82%A8%E5%AF%A6%E9%9A%9B%E4%B8%8A%E4%B8%A6%E6%B2%92%E6%9C%89%E6%9B%B4%E6%94%B9%E8%A1%A8%E4%B8%AD%E7%9A%84%E6%95%B8%E6%93%9A%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%93%9A%E9%A1%8F%E8%89%B2%E9%81%B8%E6%93%87%E5%96%AE%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%E5%BE%9E%E5%96%AE%E5%85%83%E6%A0%BC%E4%B8%AD%E7%8D%B2%E5%8F%96%E5%96%AE%E5%85%83%E6%A0%BC%E9%A1%8F%E8%89%B2%E7%9A%84%E7%B0%A1%E5%96%AE%E6%96%B9%E6%B3%95%EF%BC%8C%E6%9B%B4%E4%B8%8D%E7%94%A8%E8%AA%AA%E7%82%BA%E5%88%97%E4%B8%AD%E5%85%B7%E6%9C%89%E7%89%B9%E5%AE%9A%E9%A1%8F%E8%89%B2%E7%9A%84%E5%96%AE%E5%85%83%E6%A0%BC%E9%81%B8%E6%93%87%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%E9%80%99%E6%A8%A3%E5%81%9A%E7%9A%84%E6%96%B9%E6%B3%95%E6%98%AF%E6%8F%90%E5%8F%96%E6%84%9F%E8%88%88%E8%B6%A3%E7%9A%84%E5%88%97%E7%9A%84%E8%85%B3%E6%9C%AC%EF%BC%8C%E7%84%B6%E5%BE%8C%E6%90%9C%E7%B4%A2%E8%85%B3%E6%9C%AC%E7%9A%84%E9%A1%8F%E8%89%B2%E5%96%AE%E5%85%83%E6%A0%BC%E5%8D%80%E5%9F%9F%EF%BC%8C%E4%B8%A6%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%E5%80%8B%E7%A4%BA%E4%BE%8B%E6%95%B8%E6%93%9A%E8%A1%A8%E3%80%82%E6%95%B8%E6%93%9A%E8%A1%A8%E6%98%AF%E4%BD%BF%E7%94%A8%E7%95%B0%E5%B8%B8%E5%80%BC%E5%88%86%E6%9E%90%E5%B7%A5%E4%BF%B1%E7%94%9F%E6%88%90%E7%9A%84%E3%80%82%20%E7%95%B6%E4%B8%8B%E9%9D%A2%E7%9A%84%E8%85%B3%E6%9C%AC%E5%9C%A8%E8%A9%B2%E6%95%B8%E6%93%9A%E8%A1%A8%E4%B8%8A%E9%81%8B%E8%A1%8C%E6%99%82%EF%BC%8C%E5%AE%83%E6%9C%83%E5%9C%A8%20SS-E%20%E5%88%97%E4%B8%AD%E6%89%BE%E5%88%B0%E6%B7%BA%E7%B4%85%E8%89%B2%E7%9A%84%E5%96%AE%E5%85%83%E6%A0%BC%EF%BC%88%E9%A1%8F%E8%89%B2%2035%20%E5%88%B0%20JMP%EF%BC%89%EF%BC%8C%E4%B8%A6%E5%B0%87%E9%80%99%E4%BA%9B%E5%96%AE%E5%85%83%E6%A0%BC%E7%9A%84%E5%80%BC%E6%9B%B4%E6%94%B9%E7%82%BA%E2%80%9C%E9%9B%A2%E7%BE%A4%E5%80%BC%E2%80%9D%EF%BC%8C%E7%84%B6%E5%BE%8C%E6%9B%B4%E6%94%B9%E6%89%80%E6%9C%89%E5%85%B6%E4%BB%96%E7%B4%B0%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%AB%8B%E6%B3%A8%E6%84%8F%EF%BC%8C%E8%A6%81%E5%B0%87%E5%96%AE%E5%85%83%E6%A0%BC%E6%9B%B4%E6%94%B9%E7%82%BA%E2%80%9C%E9%9B%A2%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%A0%88%E5%B0%87%E5%88%97%E6%9B%B4%E6%94%B9%E7%82%BA%E5%AD%97%E7%AC%A6%E5%88%97%EF%BC%8C%E4%B8%A6%E6%9B%BF%E6%8F%9B%E6%89%80%E6%9C%89%E5%8E%9F%E5%A7%8B%E6%95%B8%E6%93%9A%E3%80%82%3C%2FP%3E%0A%3CP%3E%E9%80%99%E6%98%AF%E8%85%B3%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%E8%A6%86%EF%BC%9A%E4%BE%9D%E9%A1%8F%E8%89%B2%E9%81%B8%E6%93%87%E5%84%B2%E5%AD%98%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%E4%BA%BA%E5%80%91%E5%8F%AF%E4%BB%A5%E9%80%8F%E9%81%8E%E5%88%97%E5%BE%8C%E9%9D%A2%E7%9A%84%E8%85%B3%E6%9C%AC%E4%BE%86%E5%8F%96%E5%BE%97%E6%89%80%E6%9C%89%E5%BD%A9%E8%89%B2%E5%84%B2%E5%AD%98%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%8F%96%E5%BE%97%E5%88%97%E4%B8%AD%E5%BD%A9%E8%89%B2%E5%84%B2%E5%AD%98%E6%A0%BC%E7%9A%84%E8%A1%8C%E8%99%9F%E4%B8%A6%E5%9C%A8%E6%96%B0%E5%BB%BA%E7%AB%8B%E7%9A%84%E5%88%97%E4%B8%AD%E7%82%BA%E5%85%B6%E6%8C%87%E6%B4%BE%E6%A8%99%E7%B1%A4%EF%BC%88%E4%BE%8B%E5%A6%82%E3%80%8C1%E3%80%8D%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

 

本文原文为English (US)撰写,为方便起见已翻译过。 当你回复时,它也会被翻译回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")<

本文原文为English (US)撰写,为方便起见已翻译过。 当你回复时,它也会被翻译回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);

本文原文为English (US)撰写,为方便起见已翻译过。 当你回复时,它也会被翻译回English (US)。

回复:根據顏色選擇單元格

這很好用!

迭代遍歷每一列名稱而不是僅附加一個列名稱的語法是什麼? 例如,您如何限制此循環僅查看第 1-10 列?

感謝腳本幫助,這是很棒的東西。

本文原文为English (US)撰写,为方便起见已翻译过。 当你回复时,它也会被翻译回English (US)。

hogi
Level XII

回覆:依顏色選擇儲存格

本文原文为English (US)撰写,为方便起见已翻译过。 当你回复时,它也会被翻译回English (US)。