756094_zh-CN

liliconcom

如何复制具有相同属性的行

你好，

我尝试根据其他属性将某些行相乘。例如，我想将名字和姓氏相同的概率相乘。

我怎样才能在代码中做到这一点？

谢谢。

内容组织数据访问数据探索与可视化回复：如何增加具有相同属性的行

我对@Liranlev的理解与 Jarmo 不同。我理解请求是能够将第 1 行和第 3 行中的机会值相乘并放在第 7 行，然后取第 7 行的值并放在第 8 行。这似乎是在处理 JMP 表，就像在 Excel 中执行此操作一样，但除此之外，下面的脚本将创建表。

dt = New Table("Untitled",
	Add Rows(5),
	Compress File When Saved(1),
	New Column("A", Character, "Nominal", Set Values({"E", "E", "E", "E", "E"})),
	New Column("B", Character, "Nominal", Set Values({"L", "C", "L", "L", "C"})),
	New Column("C",
		Numeric,
		"Continuous",
		Format("Best", 12),
		Set Values([5, 7, 10, 50, 7])
	)
);

aa = Associative Array();

For Each Row(dt,
	name = :A || :B;
	If(!Contains(aa, name),
		aa[name] = 1;
	);
	Multiply To(aa[name], :C);
);

newcol = dt << New Column("R", Numeric, Continuous, Formula(
	aa[:A || :B];
));
dt << run formulas;
newcol << delete formula;

回复：如何增加具有相同属性的行

你想拥有这样的东西吗？

这是一个相当简单的选择

Names Default To Here(1);

dt = New Table("Untitled",
	Add Rows(5),
	Compress File When Saved(1),
	New Column("A", Character, "Nominal", Set Values({"E", "E", "E", "E", "E"})),
	New Column("B", Character, "Nominal", Set Values({"L", "C", "L", "L", "C"})),
	New Column("C",
		Numeric,
		"Continuous",
		Format("Best", 12),
		Set Values([5, 7, 10, 50, 7])
	)
);

aa = Associative Array();

For Each Row(dt,
	name = :A || :B;
	If(!Contains(aa, name),
		aa[name] = 1;
	);
	Multiply To(aa[name], :C);
);

newcol = dt << New Column("R", Numeric, Continuous, Formula(
	aa[:A || :B];
));
dt << run formulas;
newcol << delete formula;