I am trying to parse a text file, converting it into a pandas dataframe. The file (inclusive of blank lines):
HEADING1
value 1
HEADING2
value 2
HEADING1,
value 11
HEADING2
value 12
should be converted into a dataframe:
HEADING1, HEADING2
value 1, value 2
value 11, value 12
I have tried the following code. However, I am not sure using converters could work?
df = pd.read_table(textfile, header=None, skip_blank_lines=True, delimiter='\n',
# converters= 'what should I use?',
names= 'HEADING1, HEADING2'.split() )