Software for automated database processing
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)
Topic data-table data software-recommendation dataset bigdata
Category Data Science