Hi, i am new to python world
my problem is that i am getting a output file from a software which is very messy first i just want to delete first 3 rows and the columns F onwards from the excel file and that i just want to change the title of each column.
here is the format
Nominal Dates: 12/6/2009 to 12/6/2009
Employee Group: OTHER
Start Date: 12/6/2009
Code: COACH ID Employee Name Start Time Stop Time Duration Memo
1234 name1 MADDY MAIL/MM <12/2/2009 22:56:56>
4567 name2 MADDY MAIL/MM <12/2/2009 22:56:56>
1254 name3 MADDY MAIL/MM <12/2/2009 22:56:56>
4568 name4 MADDY MAIL/MM <12/2/2009 22:56:56>
Code: EWOP ID Employee Name Start Time Stop Time Duration Memo
8972 name5 11:32 PM 5:00 AM 5:28 AM/RTA <12/6/2009 13:15:00>
7392 name6 8:15 AM 10:00 AM 1:45 No Sick bal/gg <12/6/2009 20:08:18>
i just want need the data from the code which is id but the software through it like that name, start time, end time and duration.