如何在Pandas中使用Melt来整理数据框架?



dt = {' Ind1': {0: 'Ind1',1:"Ind2",2:"Ind3",3:"Ind4",4:"Ind5",5:"Ind6",6:"Ind7",7:"Ind8",8:"Ind9",9:"Ind10",10:"Ind1",11:"Ind2",12:"Ind3",13:"Ind4",14:"Ind5",15:"Ind6",16:"Ind7",17:"Ind8",18:"Ind9",19: Ind10},"治疗":{0:"治疗",1:"治疗",2:"治疗",3:"治疗",4:"治疗",5:"治疗",6:"治疗",7:"治疗",8:"治疗",9:"治疗",10:"无法忍受",11:"无法忍受",12:"无法忍受",13:"无法忍受",14:"无法忍受",15:"无法忍受",16:"无法忍受",17:"无法忍受",18:"无法忍受",19:"租"},"价值":{0:4.5,1: 8.3,2: 6.2,3: 4.2,4: 7.1,5: 7.5,6: 7.9,7: 5.1,8: 5.8,9: 6.0,10: 11.3,11: 11.6,12: 13.3,13: 12.2,14: 13.4,15: 11.7,16: 12.1,17: 12.0,18: 14.0,19日:13.8}}

mydt = pd。DataFrame (dt,列=[‘州’,‘治疗’,‘价值’)

我如何整理我的数据框架,使它看起来像?

所需输出

您可以使用DataFrame.from_dict

pd.DataFrame.from_dict(data, orient='index')

最新更新