And age masking sign apply bucketing for the age column using the ranges
Q3. correct or add loyalty flag (column loyal_customer, values true/false) using following conditions: if customer transacted on the amount greater than 1000 per month loyal_customer = true, otherwise false Note: each transaction total amount is in column Total
Q4. filter out transactions of customers that do not present in the customer dataset after previous treatments.
The whole solution should be written in a single programming language.
Deliverables:
output files customer.csv, transactions.csv, and possible summaries generated in the calculation