I have a folder of .CSV files which I'd like a script to process.
The files have the following naming convention:
And I have located these to the following directory: C:\Users\Stephen\Desktop\L
I've attached an example .csv file (Mouse) to show the format and style of the CSV file I'm currently working with.
Roughly 100 rows into each file is a table, row headings beginning with "prot_hit_num, prot acc" etc.
I basically need to modify each .csv file to keep this table but remove all prior information for each file.
Therefore this table header would move from row 99 to row 1, and the rest of the table would move up.
The second thing I'd like to do with this table, is to add a new column called "pep_label
" and insert this one column to the right hand side of the "pep_end" column in the table.
For each row of the table, I would like to match up "pep_start
" and "pep_end
" with "Start
" and "End
" of Label_List.xls (attached) and if:
" from Label_List.xls and put this into the"pep_label
" column on the appropriate row in the .csv table.