Python长宽表的转换

• 先创建一组数据

data=pd.DataFrame({"Name":["苹果","谷歌","脸书","亚马逊","腾讯"],
                   "Conpany":["Apple","Google","Facebook","Amozon","Tencent"],
                   "Sale2013":[5000,3500,2300,2100,3100],
                   "Sale2014":[5050,3800,2900,2500,3300],
                   "Sale2015":[5050,3800,2900,2500,3300],
                   "Sale2016":[5050,3800,2900,2500,3300]})

---

• 数据形状
  

使用melt将宽表转换成长表

---

data=data.melt(id_vars=["Name","Conpany"],value_name="Sale",var_name="Year")

• 转换好的数据的形状
  

---

使用pivot_tbale将长表转换成宽表

---

print('pivot_table将长表转换成宽表')
data = data.pivot_table(index=['Name','Conpany'],columns='Year',values='Sale')

• 转换好的数据形状是
  

---