python - 如何转置特定的csv表？

Question

我是编程新手，我的数据如下所示：

name | age | address | phone |
------------------------------
hei  | 18  | home    | 123   |
     |     |         | 231   |
     |     |         | 432   |
------------------------------
hay  | 19  | house   | 455   |
     |     |         | 555   |
     |     |         | 666   |
------------------------------

有没有办法让它像这样：

name | age | address | phone | phone | phone |
----------------------------------------------
hei  | 18  | home    | 123   | 231   | 432   |
----------------------------------------------
hay  | 19  | house   | 455   | 555   | 666   |

我用这段代码阅读了文件：

import pandas as pd
pf = pd.read_csv('test.csv)

标签： pythonpandascsv

Answer 1

df1 =

name | age | address | phone |
------------------------------
hei  | 18  | home    | 123   |
     |     |         | 231   |
     |     |         | 432   |
------------------------------
hay  | 19  | house   | 455   |
     |     |         | 555   |
     |     |         | 666   |
------------------------------

df2 = pd.DataFrame(d1)
df2.drop(columns=['phone'])

请将以下内容更改为您想要的任何内容。

df2[['phone','phone1','phone2']] = pd.DataFrame(df1.phone.values.tolist(), index= df2.index)

name | age | address | phone | phone1 | phone2|
----------------------------------------------
hei  | 18  | home    | 123   | 231    | 432   |
----------------------------------------------
hay  | 19  | house   | 455   | 555    | 666   |
-----------------------------------------------

我希望这有帮助