如何用python来处理数据表的长宽转换(图文详
import pandas as pdimport numpy as npmydata=pd.dataframe({"name":["苹果","谷歌","**","亚马逊","腾讯"],"conpany":["apple","google","**","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]})mydata1=mydata.melt(id_vars=["name","conpany"], #要保留的主字段var_name="year", #拉长的分类变量value_name="sale" #拉长的度量值名称) 20210311