Parse text file python and covert to pandas dataframe

Viewed 8346

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() )
2 Answers
Related