How to can I trail and eliminate extra separators in a simple maner

CasperjexCasperjex Member Posts: 2 Newbie
Hi all at the moment I have this problem, I have done all the steps to remove missing values ("#") and obtain separators ("_") for each product in a row since this is a list of purchases. But I can't remove the extra "_". I would appreciate if any of you could help me.

Kind regards

Best Answer


  • Options
    CasperjexCasperjex Member Posts: 2 Newbie
    Hi @Edin_Klapic,

    Thank you so much, that's exactly what I intended to do, I what to perform a market basket analysis using FP-Growth and Association Rules, and I think last "_" separator was messing up all the retrieved information.

    So using the "Split" operator I would be able to change my row examples into attributes? I was thinking maybe was best to transform all the examples into attributes and apply yes to all at the same time purchased items.

    Thank you
Sign In or Register to comment.