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,625
  • 8
  • 23
  • 39
Fedor Alexandrovich
  • 1
  • You can use Google DataFlow, it enables you to do such operations on datasets without programming anything. The framework has lots of tools to use. Not free, of course. – Ugur MULUK Dec 19 '18 at 14:57
  • You should be able to use Power Query in Excel for this, however I would not consider that a database management tool. – Oxbowerce Feb 23 '21 at 08:43

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,079
  • 2
  • 16
  • 39
  • No doubt, that's just a few mins with the proper approach. But I need this task to be done by non-developers. We have a bunch of this kind manipulations to be done continuously. I'm rather sure that there is a GUI(or excel-difficulty) tool for it. Not found yet) – Fedor Alexandrovich Oct 20 '18 at 16:33
  • 2
    @FedorAlexandrovich if that’s the case then this is a GUI issue, not a data science issue. You probably need help from someone that is a Mechanical Turk specialist or something like that. A custom interface is what you need - not a data scientist. – I_Play_With_Data Oct 21 '18 at 18:49