468973_zh-CN

liliconcom

嵌套 if 和 else 语句需要帮助

我正在使用 if else 语句将某些 FS*/SS* 存储为 CAT1 和 CAT2。所有剩余的不属于 CAT1/CAT2 的 FS*/SS* 需要归类为 CAT3。

为 CAT3 编写其他部分时遇到问题。感谢任何帮助。

 

cdt = open("temp\data.csv");

cdt=current data table();
sum_lst2 = {};
sum_lst3 = {};
sum_lst4 = {};
col_lst2 = cdt << get column names( Numeric );
For( i = 1, i <= N Items( col_lst2 ), i++,
 colname = Column( col_lst2[i] ) << get name;
 If( Contains( {"SS008","SS009","SS010","SS015","SS053","FS9429","FS9792","FS9906","FS9908", "FS1302","FS1305","FS1308","FS1360","FS1373","FS2744","FS4621","FS4625","FS4630","FS4640","FS4681","FS4830"}, colname ) | (colname >= "FS2900" & colname <= "FS2950") | (colname >= "FS3400" & colname <= "FS3450"),
  Insert Into( sum_lst2, col_lst2[i] )
 ); ///Cat1// 
 
 If( Contains( {"SS098","SS090"}, colname ) | (colname >= "FS9700" & colname <= "FS9791") | (colname >= "FS9793" & colname <= "FS9799"),
  Insert Into( sum_lst4, col_lst2[i] )
 );//Cat2//
 If( Contains( {"SS019","SS027","SS035","FS9901"}, colname ) | (colname >= "FS3451" & colname <= "FS3499"),
  Insert Into( sum_lst3, col_lst2[i] )
 );//Cat3
);

物品	FS0100	FS0847	FS0875	FS0876	FS0877	FS1059	FS1061	FS1090	FS1315	FS1501	FS1503	FS1505	FS1537	FS1539	FS1541	FS1543	FS1559	FS1590	FS1930	FS1933	FS2706	FS2740	FS2742	FS2745	FS3416	FS3417	FS3418	FS3422	FS3423	FS3455	FS3469	FS3471	FS3492	FS3493	FS5391	FS9429	FS9792	FS9901	FS9906	SS001	SS008	SS010	SS013	SS015	SS019	SS027	SS034	SS053	SS094	SS097	SS099
1	132	1																	3																				1	132	1				3						1
2	600	2																	7	2		1	4				5			1	4					1	1	1	2	600	2		0		9	5	10		1	1	3
3	562					1													9			1	1			1	1	1	2	1	1	1	1	2				2	1	562		1			9	2	11				3
4	527	2		2	1		2	1		7		2	4	3	3	2		24	18	2	3			1	2		1		1		4		1	1	1	3			2	527	5	3		45	20	4	10	1	3		2
5	322		1						1		2						1		7				3											2					3	322	1		1	3	7	3	2			0	3

 

脚本回复：嵌套 if 和 else 语句需要帮助

像下面这样的东西怎么样？ 由于您在 If() 语句之间使用了粘合运算符，因此我实际上没有在脚本中看到任何“else”语句。 请参阅下面我嵌套了所有 If() 语句的位置，然后将最终的 else 作为 Insert Into the sum_lst4 列表（假设这是您想要 Cat4 列名的位置。

 

cdt = Current Data Table();
sum_lst2 = {};
sum_lst3 = {};
sum_lst4 = {};
col_lst2 = cdt << get column names( Numeric );
For( i = 1, i <= N Items( col_lst2 ), i++,
 colname = Column( col_lst2[i] ) << get name;
 If(
  Contains(
   {"SS008", "SS009", "SS010", "SS015", "SS053", "FS9429", "FS9792", "FS9906", "FS9908", "FS1302", "FS1305", "FS1308", "FS1360", "FS1373",
   "FS2744", "FS4621", "FS4625", "FS4630", "FS4640", "FS4681", "FS4830"},
   colname
  ) | (colname >= "FS2900" & colname <= "FS2950") | (colname >= "FS3400" & colname <= "FS3450"),
  Insert Into( sum_lst2, col_lst2[i] ), ///Cat1// 
 
  If( Contains( {"SS098", "SS090"}, colname ) | (colname >= "FS9700" & colname <= "FS9791") | (colname >= "FS9793" & colname <= "FS9799"),
   Insert Into( sum_lst4, col_lst2[i] ), //Cat2//
   
   If( Contains( {"SS019", "SS027", "SS035", "FS9901"}, colname ) | (colname >= "FS3451" & colname <= "FS3499"),
    Insert Into( sum_lst3, col_lst2[i] ),
    Insert Into( sum_lst4, col_lst2[i] )///final nested else statement for Cat4
   );//Cat3
  )
 );
);

回复：嵌套 if 和 else 语句需要帮助

我在我的问题中错误地复制了错误的代码。下面是我为 if/else 实现编写的代码，但 CAT3 列只有零。else 语句的位置是否存在问题。

 

重申一下，我试图将其分为 2 类，无论什么值不属于 CAT1/2 都需要被分类为 CAT3。

 

cdt = open("temp\Rawdata.csv");
cdt = Current Data Table();
sum_lst2 = {};
sum_lst3 = {};
sum_lst4 = {};
col_lst2 = cdt << get column names( Numeric );
For( i = 1, i <= N Items( col_lst2 ), i++,
 colname = Column( col_lst2[i] ) << get name;
 If(
  Contains(
   {"SS008", "SS009", "SS010", "SS015", "SS053", "FS9429", "FS9792", "FS9906", "FS9908", "FS1302", "FS1305", "FS1308", "FS1360", "FS1373",
   "FS2744", "FS4621", "FS4625", "FS4630", "FS4640", "FS4681", "FS4830"},
   colname
  ) | (colname >= "FS2900" & colname <= "FS2950") | (colname >= "FS3400" & colname <= "FS3450"),
  Insert Into( sum_lst2, col_lst2[i] ), ///CAT1// 
 
  If( Contains( {"SS098", "SS090"}, colname ) | (colname >= "FS9700" & colname <= "FS9791") | (colname >= "FS9793" & colname <= "FS9799"),
   Insert Into( sum_lst4, col_lst2[i] ), //CAT2//
   
   
   
   
   ),
   Insert Into( sum_lst3, col_lst2[i] )///CAT3
  )
 );
Eval( Eval Expr( cdt << New Column( "CAT1", formula( Sum( Expr( sum_lst2 ) ) ) ) ) );
Eval( Eval Expr( cdt << New Column( "CAT3", formula( Sum( Expr( sum_lst3 ) ) ) ) ) );
Eval( Eval Expr( cdt << New Column( "CAT2", formula( Sum( Expr( sum_lst4 ) ) ) ) ) );

回复：嵌套 if 和 else 语句需要帮助

这是我对您的代码的修改，它正确处理了所有 51 列。它将 12 列插入 sum_lst2，将 39 列插入 sum_lst3，将 0 列插入 sum_lst4

Names Default To Here( 1 );
//cdt = open("temp\Rawdata.csv");
cdt = Current Data Table();
sum_lst2 = {};
sum_lst3 = {};
sum_lst4 = {};
col_lst2 = cdt << get column names( Numeric);
For( i = 1, i <= N Items( col_lst2 ), i++,
 colname = Column( col_lst2[i] ) << get name;
 If(
  Contains(
   {"SS008", "SS009", "SS010", "SS015", "SS053", "FS9429", "FS9792", "FS9906", "FS9908", "FS1302", "FS1305",
   "FS1308", "FS1360", "FS1373", "FS2744", "FS4621", "FS4625", "FS4630", "FS4640", "FS4681", "FS4830"},
   colname
  ) | (colname >= "FS2900" & colname <= "FS2950") | (colname >= "FS3400" & colname <= "FS3450")
  ,
   Insert Into( sum_lst2, col_lst2[i] )///CAT1//
 , // Else 
 
  Contains( {"SS098", "SS090"}, colname ) | (colname >= "FS9700" & colname <= "FS9791") | (colname >= "FS9793" &
  colname <= "FS9799")
  , 
   Insert Into( sum_lst4, col_lst2[i] ) //CAT2//  
 , // Else
   Insert Into( sum_lst3, col_lst2[i] )///CAT3
 );
); 

Eval( Eval Expr( cdt << New Column( "CAT1", formula( Sum( Expr( sum_lst2 ) ) ) ) ) );
Eval( Eval Expr( cdt << New Column( "CAT3", formula( Sum( Expr( sum_lst3 ) ) ) ) ) );
Eval( Eval Expr( cdt << New Column( "CAT2", formula( Sum( Expr( sum_lst4 ) ) ) ) ) );

回复：嵌套 if 和 else 语句需要帮助

我觉得你很亲近！ 您过早地关闭了第二个 If() 语句。 我得到了 CAT2 的全零，但 CAT3 现在有值。 如果此时您期望 CAT2 的值，那么可能需要做更多的工作。

 

cdt = Current Data Table();
sum_lst2 = {};
sum_lst3 = {};
sum_lst4 = {};
col_lst2 = cdt << get column names( Numeric );
For( i = 1, i <= N Items( col_lst2 ), i++,
 colname = Column( col_lst2[i] ) << get name;
 If(
  Contains(
   {"SS008", "SS009", "SS010", "SS015", "SS053", "FS9429", "FS9792", "FS9906", "FS9908", "FS1302", "FS1305", "FS1308", "FS1360", "FS1373",
   "FS2744", "FS4621", "FS4625", "FS4630", "FS4640", "FS4681", "FS4830"},
   colname
  ) | (colname >= "FS2900" & colname <= "FS2950") | (colname >= "FS3400" & colname <= "FS3450"),
  Insert Into( sum_lst2, col_lst2[i] ), ///CAT1// 
 
  If( Contains( {"SS098", "SS090"}, colname ) | (colname >= "FS9700" & colname <= "FS9791") | (colname >= "FS9793" & colname <= "FS9799"),
   Insert Into( sum_lst4, col_lst2[i] ), //CAT2//
   Insert Into( sum_lst3, col_lst2[i] )///CAT3
  )
 )
);
Eval( Eval Expr( cdt << New Column( "CAT1", formula( Sum( Expr( sum_lst2 ) ) ) ) ) );
Eval( Eval Expr( cdt << New Column( "CAT3", formula( Sum( Expr( sum_lst3 ) ) ) ) ) );
Eval( Eval Expr( cdt << New Column( "CAT2", formula( Sum( Expr( sum_lst4 ) ) ) ) ) );

回复：嵌套 if 和 else 语句需要帮助

我想出了问题所在 - 对于 Cat3，我得到了一个巨大的价值（在修复列格式后范围为 e15）。原因是我在表中还有几列。

对于 Cat3 和剩余的 FS*，我的脚本正在将其他列的值相加。

在 else 语句中，我如何只考虑列名为 FS* 的列？

 

物品	地点	操作	TOTAL_TESTED	TOTAL_GOOD	TOTAL_BAD	测试日期	包	博士	程序	星期	FS0100	FS0847	FS0875	FS0876	FS0877	FS1059	FS1061	FS1090	FS1315	FS1501	FS1503	FS1505	FS1537	FS1539	FS1541	FS1543	FS1559	FS1590	FS1930	FS1933	FS2706	FS2740	FS2742	FS2745	FS3416	FS3417	FS3418	FS3422	FS3423	FS3455	FS3469	FS3471	FS3492	FS3493	FS5391	FS9429	FS9792	FS9901	FS9906
											132	1																	3																				1
											600	2																	7	2		1	4				5			1	4					1	1	1	2
											562					1													9			1	1			1	1	1	2	1	1	1	1	2				2	1
											527	2		2	1		2	1		7		2	4	3	3	2		24	18	2	3			1	2		1		1		4		1	1	1	3			2
											322		1						1		2						1		7				3											2					3

回复：嵌套 if 和 else 语句需要帮助

对于您拥有的最后一个 Else 语句（如下所示的片段）：

 

Insert Into( sum_lst3, col_lst2[i] )///CAT3

像下面这样添加最后一个嵌套的 If() 语句怎么样？ 然后不要有 Else 语句

 

If( 
 Contains( colname, "FS" ),
 Insert Into( sum_lst3, col_lst2[i] )
)///CAT3, no ELSE statement

回复：嵌套 if 和 else 语句需要帮助

这无济于事，因为我需要排除属于 Cat 1 和 Cat2 的 FS 列。

猫 1 -

  {"SS008", "SS009", "SS010", "SS015", "SS053", "FS9429", "FS9792", "FS9906", "FS9908", "FS1302", "FS1305", "FS1308", "FS1360", "FS1373",
   "FS2744", "FS4621", "FS4625", "FS4630", "FS4640", "FS4681", "FS4830"},
   colname
  ) | (colname >= "FS2900" & colname <= "FS2950") | (colname >= "FS3400" & colname <= "FS3450"),

猫 2 -

Contains( {"SS098", "SS090"}, colname ) | (colname >= "FS9700" & colname <= "FS9791") | (colname >= "FS9793" & colname <= "FS9799"),
   Insert Into( sum_lst4, col_lst2[i] )

 

Cat3 - 属于 Cat1 和 Cat2 的所有 FS* cols