Suppose I have the following two datasets:
d1 = Dataset[{
<|"x" -> 195, "y" -> 2.0|>,
<|"x" -> 198, "y" -> 6.4|>,
<|"x" -> 204, "y" -> -3.0|>
}]
d2 = Dataset[{
<|"x" -> 195, "z" -> 3.9|>,
<|"x" -> 198, "z" -> 4.5|>,
<|"x" -> 204, "z" -> 1.2|>
}]
I want to multiply the y
values from d1
with the z
values of d2
, and to create the new dataset
Dataset[{
<|"x" -> 195, "w" -> 7.8|>,
<|"x" -> 198, "w" -> 28.8|>,
<|"x" -> 204, "w" -> -3.6|>
}]
Any ideas?