Hi All,
I need to develop a workflow for a data modelling task for which I need to do data cleaning and preprocessing.
I have the below requirement and request anyone to solve/guide me on this workflow.
Below dataset has customer_id column which may have duplicate and also churn_St column which indicates whether the customer is active or inactive,. Churn_St =1 ,means customer is active and Churn_St=0 customer is inactive. So based on this requirement we have to find whether the duplicate churn_St is same for the customer_id if it is same then we have to merge else consider the churn_St =1 .
For your reference I hereby attach the dataset.
Thanks,
Karthik
Hello @Karthik_7694 ,
I think the unique tool and then a filter will do the trick for you:
Attached is the workflow for your convenience.
Dear @Karthik_7694
The solution I gave may be slightly the same as the solution from Garabujo, I just added a few. I attach my solution.
the result is the data below is for the customer ID that must be considered.