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-TW

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