756094_zh-TW

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;