576391_zh-CN

liliconcom

堆叠时导入的变量会丢失格式

你好，

 

当我使用以下代码导入数据集时：

Names Default To Here( 1 );
Clear Symbols();

pb = Page Break Box();

fileopen= "\\prusntyfil01\home$\sv001241\Desktop\FCCC\Scripts\Data tables for statistical analysis 07NOV22.xlsx";

//dt=open(fileopen,private);
 dt = Open(
   fileopen, 
   Worksheets( "USP & DSP Subtype Dependent" ),
   
  Worksheet Settings(
    1,
    Has Column Headers( 1 ),
    Number of Rows in Headers( 1 ),
    Headers Start on Row( 1 ),
    Data Starts on Row( 2 ),
    Data Starts on Column( 1 ),
    Data Ends on Row( 262 ),
    Data Ends on Column( 14 ),
    Replicated Spanned Rows( 1 ),
    Replicated Spanned Headers( 0 ),
    Suppress Hidden Rows( 1 ),
    Suppress Hidden Columns( 1 ),
    Suppress Empty Columns( 1 ),
    Treat as Hierarchy( 0 ),
    Multiple Series Stack( 0 ),
    Import Cell Colors( 0 ),
    Limit Column Detect( 0 ),
    Column Separator String( "" )
   ),
  ); 

////Had to change the data type of some variables, some of the variables have operators in the name had to change the names of some variables then change data types//// 
///When l tried to work with the variables with an operator in there name such as "/" and "%" i had problems so tried to change the names of Variables with/////
///either brackets or a operator in the variable name//////

dt :Specific Purity << Data type (Numeric) << Set Modeling Type (continuous); 

col = Column( 2 );
 col << Set Name( "Scale Area" );
 
col = Column( 4 );
 col << Set Name( "Subtype" );
 
col = Column( 6 );
 col << Set Name( "ICD 106 cells mL" );
 
col = Column( 7 );
 col << Set Name( "HA µg mL" );
///need to format the below column as percent/////
col = Column( 8 );
 col << Set Name( "HA Step Yield percent" );

dt :HA Step Yield percent << Data type (Numeric) << Format( "Percent", 12, 1 )  << Set Modeling Type (continuous) << Set Selected;

col = Column( 9 );
 col << Set Name( "Total Protein BCA ug mL" );
 
dt :Total Protein BCA ug mL << Data type (Numeric) << Set Modeling Type (continuous);

col = Column( 11 );
 col << Set Name( "HA by SRD µg mL" );

dt :HA by SRD µg mL  << Data type (Numeric) << Set Modeling Type (continuous);

col = Column( 12 );
 col << Set Name( "HCP by ELISA µg mL" );

dt :HCP by ELISA µg mL << Data type (Numeric) << Set Modeling Type (continuous);

col = Column( 13 );
 col << Set Name( "HCP µg µg" );

dt :HCP µg µg  << Data type (Numeric) << Set Modeling Type (continuous);

一些变量导入为序数或名义变量，我需要对此进行更正，这很好，但是当我使用以下代码堆叠数据时，变量：HA Step Yield percent 会丢失其格式，如何防止这种情况发生？ ？

dt2 = dt << stack(
  columns(:ICD 106 cells mL, :HA µg mL, :HA Step Yield percent,
    :Total Protein BCA ug mL, :Specific Purity, :HA by SRD µg mL,
    :HCP by ELISA µg mL, :HCP µg µg),
  Source Label Column( "Quality Attribute" ),
  Stacked Data Column( "Data" ),
  output table name( "stacked" )
);<BR />

 

脚本回复：导入的变量在堆叠时丢失格式

你好@米奇男孩,

听起来您希望单个列中的不同行具有不同的属性。 不幸的是，这是不可能的。 格式等列属性适用于整个列。 这就是堆叠格式的本质。 如果您希望不同的变量具有不同的属性，则需要将它们保留为宽格式。

为什么需要百分比格式？ 也许你可以在堆叠之前做一个乘法。

对不起，但我希望能有所帮助。

菲尔

回复：导入的变量在堆叠时丢失格式

谢谢菲尔，

 

如果我找不到解决方案，我确实考虑过在堆叠之前乘以 100，感谢您的建议，不胜感激。