key                                              value
0     Message-ID       <5525962.1075855679785.JavaMail.evans@thyme>
1           Date              Wed, 13 Dec 2000 07:04:00 -0800 (PST)
2           From                            [email protected]
3             To  [email protected], james.steffes@enron...
4         X-From                                    Phillip K Allen
5           X-To  Christi L Nicolay, James D Steffes, Jeff Dasov...
6          X-cc:                                               None
7         X-bcc:                                               None
8       X-Origin                                            Allen-P
9     Message-ID       <4650921.1075855679981.JavaMail.evans@thyme>
10          Date               Tue, 5 Dec 2000 07:31:00 -0800 (PST)
11          From                               [email protected]
12            To                             [email protected]
13        X-From                                         Ina Rangel
14          X-To                                       Amanda Huble
15         X-cc:                                               None
16        X-bcc:                                               None
17      X-Origin                                            Allen-P

Message-ID       Date                  From             To        X-From                 X-To                            X-cc:  X-bcc:  X-Origin
<5525962.10...   Wed, 13 Dec 2000...   phillip.allen... christi.nicolay.. Phillip K Allen..     Christi L Nicolay, Ja... NaN    NaN     Allen-P
<4650921.10...   Tue, 5 Dec 2000 ...   ina.rangel...    amanda.huble@...  Ina Rangel            Amanda Huble             NaN    NaN     Allen-P

print (df['value'].values.reshape(-1, 9))
[['<5525962.1075855679785.JavaMail.evans@thyme>'
  'Wed, 13 Dec 2000 07:04:00 -0800 (PST)' '[email protected]'
  '[email protected], james.steffes@enron...' 'Phillip K Allen'
  'Christi L Nicolay, James D Steffes, Jeff Dasov...' 'None' 'None'
  'Allen-P']
 ['<4650921.1075855679981.JavaMail.evans@thyme>'
  'Tue, 5 Dec 2000 07:31:00 -0800 (PST)' '[email protected]'
  '[email protected]' 'Ina Rangel' 'Amanda Huble' 'None' 'None'
  'Allen-P']]


df = pd.DataFrame(df['value'].values.reshape(-1, 9), columns=df['key'].iloc[:9])
print (df)
key                                    Message-ID
0    <5525962.1075855679785.JavaMail.evans@thyme>
1    <4650921.1075855679981.JavaMail.evans@thyme>

key                                   Date                     From
0    Wed, 13 Dec 2000 07:04:00 -0800 (PST)  [email protected]
1     Tue, 5 Dec 2000 07:31:00 -0800 (PST)     [email protected]

key                                                 To           X-From
0    [email protected], james.steffes@enron...  Phillip K Allen
1                               [email protected]       Ina Rangel

key                                               X-To X-cc: X-bcc: X-Origin
0    Christi L Nicolay, James D Steffes, Jeff Dasov...  None   None  Allen-P
1                                         Amanda Huble  None   None  Allen-P

df = df.set_index([df['key'].eq('Message-ID').cumsum(), 'key'])['value'].unstack()
print (df)
key                                   Date                     From
key
1    Wed, 13 Dec 2000 07:04:00 -0800 (PST)  [email protected]
2     Tue, 5 Dec 2000 07:31:00 -0800 (PST)     [email protected]

key                                    Message-ID
key
1    <5525962.1075855679785.JavaMail.evans@thyme>
2    <4650921.1075855679981.JavaMail.evans@thyme>

key                                                 To           X-From
key
1    [email protected], james.steffes@enron...  Phillip K Allen
2                               [email protected]       Ina Rangel

key X-Origin                                               X-To X-bcc: X-cc:
key
1    Allen-P  Christi L Nicolay, James D Steffes, Jeff Dasov...   None  None
2    Allen-P                                       Amanda Huble   None  None