I need a python script that re-arranges a text file

I need a python script capable of re-organizing a text file into a specific arrangement. I uploaded two text files below to show you what the raw text files look like and what the final text file should look like.

In the raw text file there are 4 columns of text, only pay attention to the first 2, you can ignore the last 2. The first columns represent time in seconds, and the second column represents the condition. 1 = the letter condition and 2 = the word condition.

In the final text file the goal is to group all the times corresponding to their associated condition together on one line, in a comma delineated format.

Each final txt documents needs to have the following in the first line:

condition_name,subject_number,session_number,onsets,durations,

The next two lines in the final text are for each condition. The first variable is condition name (either word or letter, the second variable is subject number (this is the first number in the text file title), the third variable is the session number (this is the second number in the title), the 4th number is all the onset times (please make sure that each time is separated by a space, not a comma), then the last variable is duration (this will always be a value of 2).