https://www.cnblogs.com/traditional/p/11967360.html

    1. #!/usr/bin/env python
    2. # coding: utf-8
    4. # In[1]:
    7. import pandas as pd
    8. import numpy as np
    11. # In[2]:
    14. df  = pd.read_csv(r"D:\Mywork\DB\_上海舱单_SELECT_上海舱单_AS_PRODUCT_A_ENTERPRISE_ID_AS_ENTERPRISE_ID_A__202206251055.csv",
    15.                  usecols =['NAME','PRODUCT','NUM','MAXDATE','SELL_NAME','PHONE'])
    16. df
    19. # In[4]:
    22. #对前三个字段进行去重
    23. df1 = df.drop_duplicates(['PRODUCT','NAME','SELL_NAME'],keep = 'first')
    26. # In[6]:
    29. #pivot函数
    30. df2 = df1.pivot(index=['NAME','SELL_NAME'],columns=['PRODUCT'],values=['NUM','MAXDATE','PHONE'])
    31. df2
    32. #导出csv
    33. df2.to_csv("D:\Mywork\DB\shichangbu",sep=',')
    36. # In[8]:
    39. #unstack函数
    40. three = df1.set_index(['NAME','SELL_NAME','PRODUCT'])['NUM'].unstack()
    41. three