Removing duplicate columns

Options
frotograf
frotograf Registered Posts: 5 ✭✭✭✭

Dear community,

I have such a case:

- I have a large database that needs cleaning.

- while performing the typical cleaning activities (parsing etc.) I discovered that I have numerous columns that are just duplicates of one another (judging by basic analysis it's hundreds) but with different names.

Example: 1 column name is "things_bought_on_2021_03_07", it's duplicates have names like "things_bought_on_2021_03_07_01" and "things_bought_on_2021_03_07_02".

I know none of the ways to deal with this in Dataiku. Working on duplicate rows would be easier (I do not have duplicate rows on this one..)

Thank you!

Answers

Setup Info
    Tags
      Help me…