finding common numbers from multiple files and write them in a single one

Job ID: 34259947

Budget: ₹600 – ₹1,500 INR

i have ~20 csv files each with 2 columns and varied rows. need a script which will find the common names from column 1 present in each of 20 files and write their values (present in column 2 of each file) along with names in a new csv file. i need different columns for each input in output file i.e. in 20 files cumulatively there are total 40 columns i want 40 columns serially in output files. example input and output are attached. i would prefer shell or python script.
Related categories: Python Linux Software Architecture Shell Script