import pandas as pd
data = pd.read_excel('世界各国人口统计数据_2000-2020(世界银行).xlsx')
data.head()
![在这里插入图片描述](https://img-blog.csdnimg.cn/b94df359cf53497ab481c66397a281b9.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjE2NzcxMg==,size_16,color_FFFFFF,t_70)
print(data.columns.tolist())
![在这里插入图片描述](https://img-blog.csdnimg.cn/530cabc9cd3d454798978ca2f75d7ca5.png)
# 将上面显示出来的列名列表,选出几列作为主类别,此类别
output = data.melt(id_vars=['Country Name','Country Code', '国家/地区名称'])
output
![在这里插入图片描述](https://img-blog.csdnimg.cn/4b7dc2af2a334eb5a6677b215280a86b.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjE2NzcxMg==,size_16,color_FFFFFF,t_70)
output.to_excel('世界人口统计数据_tableau.xlsx',index=False)