Pandas：重塑数据帧

Question

我有一个数据帧，现在看起来像这样

dataframe 1

我需要创建一个如下所示的数据帧

dataframe 2

我需要从dataframe 1列的值填充dataframe 2的列。图为示例。 这方面的算法和过程应该是什么

这是示例数据集

df_dict = {'hostname': {0: 'Comp890263', 1: 'Comp813682', 2: 'Comp213302', 3: 'Comp839013', 4: 'Comp966241'}, 'days': {0: 90, 1: 90, 2: 90, 3: 90, 4: 90}, 'status': {0: '1', 1: '1', 2: '1', 3: '1', 4: '1'}, 'features': {0: '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0', 1: '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0', 2: '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0', 3: '0,0,0,0,0,0,0,21,0,25,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,21,0,0,0,0,0,0,0,0,0,6,46,0,0,0,0,759,0,0,0,0', 4: '0,0,0,0,0,0,0,43,0,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,43,0,0,0,0,0,0,0,0,0,30,46,0,0,0,0,795,0,0,0,0'}}

Answer 1

这里有一个类似的问题：Pandas column values to columns?。看看他们使用.pivot_table或unstack的解决方案是否适合您