過濾掉離子 ID。你好我有以下腳本。我運行它,但它不會對我的表產生任何差異,並且不會吐出任何錯誤。
dt = Current Data Table(); % The only data table I have open.
exclusion_list = {"P1638070-00-D:TGTX240584C0006:20TVD97GN",
"P1638070-00-D:TGTX240584C0006:20T40A34P",
"P1638070-00-D:TGTX240584C0006:20TXECFDY",
"P1638070-00-D:TGTX240584C0006",};
// Add all values to exclude
dt << Select Where(Ion Component ID << exclusion_list); % Ion Component ID is the column name I want to delete these entries from.
dt << Delete Rows;如果有更快的方法來過濾掉多個 ID 我也很想知道:) 謝謝!
基礎資料分析與建模回覆:過濾掉離子 ID。這是我處理這個問題的方法:
names default to here(1);
dt =
// Open Data Table: Big Class.jmp
// → Data Table( "Big Class" )
Open( "$SAMPLE_DATA/Big Class.jmp" );
exclusion_list = /*{"P1638070-00-D:TGTX240584C0006:20TVD97GN",
"P1638070-00-D:TGTX240584C0006:20T40A34P",
"P1638070-00-D:TGTX240584C0006:20TXECFDY",
"P1638070-00-D:TGTX240584C0006",};*/
{"TIM", "JAMES","JUDY"};
// Add all values to exclude
dt << Select Where(contains(exclusion_list, :Name)); // Ion Component ID is the column name I want to delete these entries from.
dt << Delete Rows;回覆:過濾掉離子 ID。那行得通。謝謝。該文件無法以其文件名打開,因此我仍然使用當前數據表:)