検索

ホームページ  >  に質問  >  本文

python 复杂表格合并

[
{"ID":"1","订单号":"123456","用户名":"路人甲","产品":"XX用品","颜色":"色1","数量":"1",},
{"ID":"1","订单号":"123456","用户名":"路人甲","产品":"XX用品","颜色":"色2","数量":"20",},
{"ID":"1","订单号":"123456","用户名":"路人甲","产品":"XX用品","颜色":"色3","数量":"3",},
{"ID":"1","订单号":"123456","用户名":"路人甲","产品":"XX用品","颜色":"色4","数量":"4",},
{"ID":"1","订单号":"123456","用户名":"路人甲","产品":"XX用品","颜色":"色5","数量":"5",},
{"ID":"1","订单号":"123456","用户名":"路人甲","产品":"XX用品","颜色":"色6","数量":"6",},
{"ID":"1","订单号":"123456","用户名":"路人甲","产品":"XX用品","颜色":"色7","数量":"30",},
{"ID":"1","订单号":"123456","用户名":"路人甲","产品":"XX用品","颜色":"色8","数量":"8",},
{"ID":"1","订单号":"123456","用户名":"路人甲","产品":"XX用品","颜色":"色9","数量":"9",},
{"ID":"1","订单号":"123456","用户名":"路人甲","产品":"XX用品","颜色":"色10","数量":"40",},
{"ID":"2","订单号":"456789","用户名":"路人乙","产品":"XXX用品","颜色":"红色","数量":"100",},
{"ID":"3","订单号":"123456789","用户名":"路人丙","产品":"XXXX用品","颜色":"金色","数量":"300",},
{"ID":"3","订单号":"987654321","用户名":"路人丙","产品":"XXXX用品","颜色":"紫色","数量":"100",},

]

需要转换表格为:

python3 如何实现这种复杂的表格排列

伊谢尔伦伊谢尔伦2875日前696

全員に返信(3)返信します

  • 高洛峰

    高洛峰2017-04-18 10:30:30

    これはpandas groupbyを使用して可能です。コードは参考用です

    リーリー

    返事
    0
  • 高洛峰

    高洛峰2017-04-18 10:30:30

    まずセルを順番に並べてから、セルを結合します。

    返事
    0
  • 阿神

    阿神2017-04-18 10:30:30

    Excel を操作するには、次のようなライブラリが必要です。 openpyxl

    次に、このライブラリにデータを入力する方法とセルを結合する方法を確認します。

    http://openpyxl.readthedocs.i...

    返事
    0
  • キャンセル返事