0

I faced a problem which I'd like to solve w/o any programming. And looking for a software to do this.

I have a dataset, for example: (brand-id, brand-name, product-class-name;)

0, Audi, economy business premium;
1, Rolls Royce, luxury;
2, Seat, economy;
3, Tesla, business premium;

And I'd like to automatically process this dataset, resulting in creating an additional table to classify parameters in column 3, like: (product-class-id, product-class-name, brand-id;)

0, economy, 0 2;
1, business, 0 3;
2, premium, 0 3;
3, luxury, 1;

Is there any database managing tool with features like this one? (preferably Mac)

Ethan
  • 1,657
  • 9
  • 25
  • 39
Fedor Alexandrovich
  • 1

1 Answers1

1

Do you consider SQL to be programming? Because at the very least you're going to need to do some SQL manipulations to solve this. There's no visual tool that I know of that will do this for you (especially for OSX!)

I don't know why you have a barrier for a new language; if you were willing to do this in python it could be solved relatively quickly.

I_Play_With_Data
  • 2,129
  • 3
  • 17
  • 40