CSV format adjustments / filterout only needed items

[Rikky789]

Hello guys, i am glad i found this forum and saw a lot of solution but unfortunately i was not able to find something that would help me, or atleast i could not understand that.

What i am looking for is a preferably script (editable if something changes) which will help me out with CSV file which i use for e-shop.

The point of that is that i am not able to import the one i am getting, but with some changes in header and filtering i would have what i need.
Here is the attached example:
(input - raw file csv, COMMA separated)

number,description,category_name,eancode,part_nr_,vendor_name,price,stock,inflowing

<tbody>
</tbody>

39830,"Adapter DeLock DP male - DVI female","Adapter","4043619618477","61847","Delock",7.29,"10","10.05.2018"

(output - raw file csv, SEMICOLON separated)

name;ean;partNumber;categoryText;price;stock;availabilityInStock;
"Gigabyte Radeon RX 570 Gaming 8G Mining";"4719331303242";"GV-RX570GAMING-8GD-MI";"Grafické karty";"330,00";"0";"Na dotaz";

For the output i need a few things to be done:
1. Use only certain rows base on some reference CSV. Because the input has 1000+ entries, and i only need roughly 50. That reference could be based on the "partNumber" which would compare the input CSV with exported (used/updated on that day in eshop).
2. Change the COMMA to SEMICOLON
3. Change the header:
a. Delete number, description, category_name, vendor_name,
b. Rename the header so it fits the output (i will not need to edit name, categoryText as in output presented now, its only as example, please ignore)
eancode >> ean // part_nr_ >> partNumber // inflowing >> availabilityInStock (this can be date or text)

I am not sure whether this can be done by script or some kind of automation but it would help me a lot with all the manual editing. Please try to check on that and if you can do it.

Thank you very much for looking into it.

BR, Rikk