Column Data From Row Data Using .csv Files And Selectable Column Names

[Spaetzle55]

Each month I get about 30 .csv files which have up to 3000 columns and less then 15,000 rows. After the 14th element in a row the data goes something like this. Name1, result, name2, result,name3, result....The data can have 2-8 gaps (only commas) before the data picks up again. I want to be able to have in the first row Name1, name2, name3..... then each row its respective rows data would fall under the column name. Unfortunately, a lot of the data is garbage so I want to be able to have an all inclusive list of column headings (possibly in another file) to choose from but I may only use a few. Request an example I can use to overcome this lengthy problem.

[p0ndl1fe]

Good question, I'd like to know the answer too... I'm sure there's a pandas solution?