nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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 语句需要帮助

感谢您的所有建议。我终于可以通过添加两个 else 语句并在最后一个 else 语句中添加 contains 条件来使其工作

For( i = 1, i <= N Items( col_lst2 ), i++,
 colname = Column( col_lst2[i] ) << get name;
 If(
  Contains({"FS9429", "FS9792", "FS9906","FS1156","FS1157"},colname) | (colname >= "FS800" & colname <= "FS899") |(colname >= "FS901" & colname <= "FS916") |
  (colname >= "FS954" & colname <= "FS965") |(colname >= "FS1059" & colname <= "FS1063") |(colname >= "FS1348" & colname <= "FS1363") |(colname >= "FS1374" & colname <= "FS1379") |
   (colname >= "FS1500" & colname <= "FS1599") | (colname >= "FS2581" & colname <= "FS2586") | (colname >= "FS2900" & colname <= "FS2950") | (colname >= "FS3400" & colname <= "FS3450") |(colname >= "FS5300" & colname <= "FS5399") |
   (colname >= "FS6700" & colname <= "FS6799"),
  Insert Into( sum_lst2, col_lst2[i] )///CAT1//
 
 , // Else 
 
  Contains( {"FS9700"}, colname ) | (colname >= "FS9701" & colname <= "FS9791") | (colname >= "FS9793" & colname <= "FS9799")
  , 
   Insert Into( sum_lst4, col_lst2[i] ) //CAT2//  
 , // Else
  Contains( colname, "FS" ) & (colname > "FS0100"),
   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 语句需要帮助

如果脚本执行到最后一个 Else 语句，在其中检查列名称中的 FS，则根据定义，该列尚未包含在 Cat1 或 Cat2 中。因此，一列不会同时放入 Cat1 和 Cat3。如果识别出 Cat1 列，您的代码会将其插入到正确的列表中，然后移至 For() 循环的下一个迭代，它不会继续沿着链运行，因为它不需要运行 Else 部分。

我会尝试一下，看看是否有效。抱歉，我不完全清楚你在问什么，但希望这能做到！

回复：嵌套 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* 列

回复：嵌套 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 语句需要帮助

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

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

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

物品	地点	歌剧院	TOTAL_TESTED 已测试	总计_好	总计_坏	测试日期	封装	博士	程序	星期	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 语句需要帮助

我认为你们非常接近！您关闭第二个 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 语句需要帮助

这是我对您的代码的修改，它可以正确处理所有 51 列。它将 12 列插入到 sum_lst2，将 39 列插入到 sum_lst3，将零插入到 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/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 语句需要帮助

像下面这样的怎么样？我实际上没有在脚本中看到任何“else”语句，因为您在 If() 语句之间使用了粘合运算符。请参阅下面，我嵌套了所有 If() 语句，然后将最后的 else 作为“插入到 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
  )
 );
);

Comments

There are no comments yet