Icon

Questions2

Questions2 Homework2 Berkant Güneş

Questions2 Homework2 Berkant Güneş

Read the sales.csv dataset.
• Using the Rule Engine node, create a new column “currency” with value “USD” for the orders
from the USA, and “EUR” for the orders from Germany.
• Using the Rule Engine node, create a new column “conversion” with value 1 if currency is
“EUR”, and 0.88 if currency is “USD” (we refer to the exchange rate of Nov-04-2018).
• Using the Math Formula node, calculate values in a new column named “amount-in-EUR” by
multiplying the value in column “amount” by the value in column “conversion”.
The product names are of type “prod_1”. Using the String Manipulation node, change the product
names to “1”, “2”, and so on.

reading sales.csvcreate a new column “currency” with value “USD”create conversion column with value 1 “EUR”, and 0.88 “USD”calculate values“amount-in-EUR”change the productnames to “1”, “2” File Reader Rule Engine Rule Engine Math Formula String Manipulation reading sales.csvcreate a new column “currency” with value “USD”create conversion column with value 1 “EUR”, and 0.88 “USD”calculate values“amount-in-EUR”change the productnames to “1”, “2” File Reader Rule Engine Rule Engine Math Formula String Manipulation

Nodes

Extensions

Links