python - 如何使用唯一名称透视表并避免空值？

Question

我有一个 Pandas 数据框，当我在具有唯一值(混合数据类型)的列上旋转时，它如下所示。

In [1]: import pandas as pd
In [2]: import numpy as np
In [3]: df = pd.DataFrame({'A' : ['one', 'two', 'three', 'four', 'five', 'six', 'seven', 'eight'],'B' : [0.815, 0.765, 'two', 'four', 0.981, 'six', 'seven', 'eight']})
In [4]: df
Out[4]: 
       A      B
0    one  0.815
1    two  0.765
2  three    two
3   four   four
4   five  0.981
5    six    six
6  seven  seven
7  eight  eight

In [5]: df.pivot(columns='A', values='B')
Out[5]: 
A  eight   five  four    one  seven   six three    two
0   None   None  None  0.815   None  None  None   None
1   None   None  None   None   None  None  None  0.765
2   None   None  None   None   None  None   two   None
3   None   None  four   None   None  None  None   None
4   None  0.981  None   None   None  None  None   None
5   None   None  None   None   None   six  None   None
6   None   None  None   None  seven  None  None   None
7  eight   None  None   None   None  None  None   None

有没有办法将“A”列上的此数据框转换为没有“无”值的单行？

Answer 1

我认为您是在建议转置数据框。

df.set_index('A').T