我想重塑我的數(shù)據(jù)框，它只有鍵值對。例如， key value0 Message-ID <5525962.1075855679785.JavaMail.evans@thyme>1 Date Wed, 13 Dec 2000 07:04:00 -0800 (PST)2 From phillip.allen@enron.com3 To christi.nicolay@enron.com, james.steffes@enron...4 X-From Phillip K Allen5 X-To Christi L Nicolay, James D Steffes, Jeff Dasov...6 X-cc: None7 X-bcc: None8 X-Origin Allen-P9 Message-ID <4650921.1075855679981.JavaMail.evans@thyme>10 Date Tue, 5 Dec 2000 07:31:00 -0800 (PST)11 From ina.rangel@enron.com12 To amanda.huble@enron.com13 X-From Ina Rangel14 X-To Amanda Huble15 X-cc: None16 X-bcc: None17 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我嘗試旋轉(zhuǎn)表格，但我很困惑我應(yīng)該提供什么作為索引參數(shù)。請幫我解決這個問題。如果您發(fā)現(xiàn)它，請隨意標(biāo)記為重復(fù)。
1 回答
臨摹微笑
TA貢獻(xiàn)1982條經(jīng)驗 獲得超2個贊
如果每個組具有總是9值是可能的用途numpy.reshape為2d array與DataFrame構(gòu)造器，也可用于列的值先取列值9 key：
print (df['value'].values.reshape(-1, 9))
[['<5525962.1075855679785.JavaMail.evans@thyme>'
'Wed, 13 Dec 2000 07:04:00 -0800 (PST)' 'phillip.allen@enron.com'
'christi.nicolay@enron.com, 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)' 'ina.rangel@enron.com'
'amanda.huble@enron.com' '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) phillip.allen@enron.com
1 Tue, 5 Dec 2000 07:31:00 -0800 (PST) ina.rangel@enron.com
key To X-From \
0 christi.nicolay@enron.com, james.steffes@enron... Phillip K Allen
1 amanda.huble@enron.com 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
如果Message-ID每個組的數(shù)據(jù)總是可以set_index與布爾掩碼Series創(chuàng)建的助手一起使用cumsum- 比較用于識別每個組的開始：eq ==
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) phillip.allen@enron.com
2 Tue, 5 Dec 2000 07:31:00 -0800 (PST) ina.rangel@enron.com
key Message-ID \
key
1 <5525962.1075855679785.JavaMail.evans@thyme>
2 <4650921.1075855679981.JavaMail.evans@thyme>
key To X-From \
key
1 christi.nicolay@enron.com, james.steffes@enron... Phillip K Allen
2 amanda.huble@enron.com 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
添加回答
舉報
0/150
提交
取消