过滤掉离子 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。那行得通。谢谢。该文件无法以其文件名打开,因此我仍然使用当前数据表:)