CSV数据透视表生成器：加载文件选择行列字段、多种聚合方式、表格化展示、一键导出

🖥️ 运行效果

🚀 实例简介

一款基于Python Tkinter的CSV数据透视表生成工具。用户可以加载CSV文件，选择行字段、列字段和值字段，支持多种聚合方式（sum/mean/count/max/min），自动生成数据透视表并以表格形式展示，支持一键导出CSV。

💻 核心代码

#!/usr/bin/env python3
# -*- coding: utf-8 -*-
"""
CSV数据透视表生成器
功能：加载CSV文件，选择行列字段和聚合值，生成数据透视表并导出
"""
import tkinter as tk
from tkinter import ttk, filedialog, messagebox
import pandas as pd
import os

CHINESE_FONT = "WenQuanYi Zen Hei"

class PivotTableApp:
    def __init__(self, root):
        self.root = root
        self.root.title("CSV数据透视表生成器")
        self.root.geometry("900x650")
        self.df = None
        self.pivot_df = None
        
        # 主框架
        main_frame = tk.Frame(root, padx=10, pady=10)
        main_frame.pack(fill=tk.BOTH, expand=True)
        
        # 顶部控制区
        top_frame = tk.LabelFrame(main_frame, text="数据加载与配置", padx=10, pady=10,
                                   font=(CHINESE_FONT, 11))
        top_frame.pack(fill=tk.X, pady=5)
        
        # 文件选择
        file_frame = tk.Frame(top_frame)
        file_frame.pack(fill=tk.X, pady=5)
        tk.Button(file_frame, text="选择CSV文件", command=self.load_file,
                  font=(CHINESE_FONT, 10)).pack(side=tk.LEFT, padx=5)
        self.file_label = tk.Label(file_frame, text="未选择文件", font=(CHINESE_FONT, 10))
        self.file_label.pack(side=tk.LEFT, padx=10)
        
        # 字段配置
        config_frame = tk.Frame(top_frame)
        config_frame.pack(fill=tk.X, pady=10)
        
        tk.Label(config_frame, text="行字段:", font=(CHINESE_FONT, 10)).grid(row=0, column=0, padx=5)
        self.row_var = tk.StringVar()
        self.row_combo = ttk.Combobox(config_frame, textvariable=self.row_var, state="readonly", width=20)
        self.row_combo.grid(row=0, column=1, padx=5)
        
        tk.Label(config_frame, text="列字段:", font=(CHINESE_FONT, 10)).grid(row=0, column=2, padx=5)
        self.col_var = tk.StringVar()
        self.col_combo = ttk.Combobox(config_frame, textvariable=self.col_var, state="readonly", width=20)
        self.col_combo.grid(row=0, column=3, padx=5)
        
        tk.Label(config_frame, text="值字段:", font=(CHINESE_FONT, 10)).grid(row=0, column=4, padx=5)
        self.val_var = tk.StringVar()
        self.val_combo = ttk.Combobox(config_frame, textvariable=self.val_var, state="readonly", width=20)
        self.val_combo.grid(row=0, column=5, padx=5)
        
        tk.Label(config_frame, text="聚合方式:", font=(CHINESE_FONT, 10)).grid(row=1, column=0, padx=5, pady=5)
        self.agg_var = tk.StringVar(value="sum")
        agg_combo = ttk.Combobox(config_frame, textvariable=self.agg_var,
                                  values=["sum", "mean", "count", "max", "min"], state="readonly", width=20)
        agg_combo.grid(row=1, column=1, padx=5, pady=5)
        
        tk.Button(config_frame, text="生成透视表", command=self.generate_pivot,
                  font=(CHINESE_FONT, 10, "bold")).grid(row=1, column=2, columnspan=2, padx=5, pady=5)
        tk.Button(config_frame, text="导出CSV", command=self.export_csv,
                  font=(CHINESE_FONT, 10)).grid(row=1, column=4, columnspan=2, padx=5, pady=5)
        
        # 结果展示区
        result_frame = tk.LabelFrame(main_frame, text="透视表结果", padx=10, pady=10,
                                      font=(CHINESE_FONT, 11))
        result_frame.pack(fill=tk.BOTH, expand=True, pady=5)
        
        # Treeview表格
        columns_frame = tk.Frame(result_frame)
        columns_frame.pack(fill=tk.BOTH, expand=True)
        
        self.tree = ttk.Treeview(columns_frame, show="headings")
        self.tree.pack(side=tk.LEFT, fill=tk.BOTH, expand=True)
        

💡 适用场景

办公自动化、数据分析、快速原型开发