I am pretty new to coding and lately I chanced upon something which I wanted to try solving with Python. Below is the text content of which I wanted to query, extract certain fields into a new file. The text content is repetitive and can go up to several thousands of line. Currently, I am only able to parse and output the first two columns which still look wrong. Hope to seek some guidance here. Cheers!

Original TXT File:

Classroom arrangement : 1A-1

(Student Name: Jess, Subject: EC001, Time: 9am – 10am)

(Student Name: Whit, Subject: EC001, Time: 9am – 10am)

(Student Name: Jon, Subject: EC0011, Time: 11am – 12pm)

(Student Name: Kevin, Subject: EC011, Time: 11am – 12pm)

(Student Name: Jess, Subject: EC011, Time: 11am – 12pm)

Classroom arrangement : 1A-2

(Student Name: Jess, Subject: EC002, Time: 11am – 12pm)

(Student Name: Whit, Subject: EC002, Time: 11am – 12pm)

(Student Name: Jon, Subject: EC002, Time: 11am – 12pm)

(Student Name: Kevin, Subject: EC002, Time: 11am – 12pm)

(Student Name: Claire, Subject: EC011, Time: 2pm – 3pm)

(Student Name: Joshua, Subject: EC0011, Time: 2pm – 3pm)

(Student Name: Florence, Subject: EC011, Time: 2pm – 3pm)

(Student Name: Neil, Subject: EC011, Time: 2am – 3pm)

Intended Output:

Classroom: 1A-1, Jess, Subject: EC001 Time: 9am – 10am, Subject: EC011, Time: 11am – 12pm

Classroom: 1A-1, Whit, Subject: EC001 Time: 9am – 10am

Classroom: 1A-1, Jon, Subject: EC0011 Time: 11am – 12pm

Classroom: 1A-1, Kevin, Subject: EC011 Time: 11am – 12pm

Classroom: 1A-2, Jess, Subject: EC002 Time: 11am – 12pm

Classroom: 1A-2, Jon, Subject: EC002, Time: 11am – 12pm

Classroom: 1A-2, Whit, Subject: EC002 Time: 11am – 12pm

Classroom: 1A-2, Kevin, Subject: EC002, Time: 11am – 12pm

Classroom: 1A-2, Claire, Subject: EC011, Time: 2pm – 3pm

Classroom: 1A-2, Joshua, Subject: EC0011, Time: 2pm – 3pm

Classroom: 1A-2, Florence, Subject: EC011, Time: 2pm – 3pm

Classroom: 1A-2, Neil, Subject: EC011, Time: 2am – 3pm

I tried passing readlines into modules before performing an output in the console, but it seems really wrong because I need the Class 1A-1 preceding on each line.

Current Output:

Class 1A-1

Jess, Subject: EC001 Time: 9am – 10am, Subject: EC011, Time: 11am – 12pm

Whit, Subject: EC001 Time: 9am – 10am

Jon, Subject: EC0011 Time: 11am – 12pm

Kevin, Subject: EC011 Time: 11am – 12pm