I have a major issue with my csv file, can anyone here suggestion a possible python solution to my problem?
In my csv file, the 'remarks' text column creates multiple newlines and appended itself to the next row, essentially messing up the row order. I tried to read it as text, split it by newline and delimiter, but it is challenging because newlines created from 'remarks' vary in order.
I have attached below the sample csv file below for your reference, its in txt format so you can have a better understanding of the delimiter formats, your inputs will be grateful.
Current File
key1\tkey2\tremarks\tdate_created\tprogram_type\n
1910-ASD3\tT342-1AE2\tJohan has applied for\n
this program on 2020-03-13, good application etc.\tprogram_A\n
9572-45A3\t823A-1T3C\tMary has applied for this program\n
on 2019-03-13, she has doubts about this program\n
so she switched her program on 2019-04-13 etc.\tprogram_B\n
842E-123A\t343D-6TYB\t\tnot enrolled\n
Desired Outcome
key1\tkey2\tremarks\tdate_created\tprogram_type\n
1910-ASD3\tT342-1AE2\tJohan has applied for this program on 2020-03-13, good application etc.\tprogram_A\n
9572-45A3\t823A-1T3C\tMary has applied for this program on 2019-03-13, she has doubts about this program so she switched her program on 2019-04-13 etc.\tprogram_B\n
842E-123A\t343D-6TYB\t\tnot enrolled\n