用python分析家庭理财历史记录

import pandas as pd
# 读取理财历史记录数据
df = pd.read_csv('financial_data.csv')
# 数据清洗，去除重复数据
df.drop_duplicates(inplace=True)
# 处理缺失值
df.fillna(0, inplace=True)
# 格式转换
df['amount'] = df['amount'].astype(float)
df['date'] = pd.to_datetime(df['date'])

import matplotlib.pyplot as plt
# 绘制每月支出趋势图
monthly_expenses = df.groupby(df['date'].dt.to_period('M'))['amount'].sum()
monthly_expenses.plot(kind='line')
plt.xlabel('Date')
plt.ylabel('Expenses')
plt.title('Monthly Expenses Trend')
plt.show()

import tkinter as tk
from tkinter import messagebox, filedialog
import pandas as pd
import matplotlib.pyplot as plt
from matplotlib.backends.backend_tkagg import FigureCanvasTkAgg
# 处理数据并生成财务分析报告
def analyze_financial_data(file_path, encoding='utf-8'):
    df = pd.read_csv(file_path, encoding=encoding)
    
    # 计算总支出和平均每日支出
    total_expenses = df['amount'].sum()
    average_daily_expenses = total_expenses / len(df['date'].unique())
    
    # 绘制支出趋势图
    fig1, ax1 = plt.subplots()
    daily_expenses = df.groupby('date')['amount'].sum()
    daily_expenses.plot(kind='line', ax=ax1)
    ax1.set_xlabel('Date')
    ax1.set_ylabel('Expenses')
    ax1.set_title('Daily Expenses Trend')
    
    # 绘制支出类别占比饼图
    fig2, ax2 = plt.subplots()
    category_expenses = df.groupby('category')['amount'].sum()
    category_expenses.plot(kind='pie', autopct='%1.1f%%', ax=ax2)
    ax2.set_title('Expense Distribution by Category')
    
    return total_expenses, average_daily_expenses, fig1, fig2
# 根据分析结果给出建议
def give_financial_advice(average_daily_expenses):
    advice = ""
    if average_daily_expenses > 50:
        advice = "您的平均每日支出较高，请注意节制消费，合理规划支出。"
    else:
        advice = "您的平均每日支出较为理想，继续保持良好的财务习惯。"
    return advice
# 创建界面
def create_gui():
    root = tk.Tk()
    root.title('家庭理财历史记录分析')
    # 选择文件按钮
    def select_file():
        file_path = filedialog.askopenfilename(filetypes=[('CSV Files', '*.csv')])
        if file_path:
            total_expenses, average_daily_expenses, fig1, fig2 = analyze_financial_data(file_path)
            advice = give_financial_advice(average_daily_expenses)
            canvas = FigureCanvasTkAgg(fig1, master=root)
            canvas.draw()
            canvas.get_tk_widget().pack(side=tk.LEFT, padx=10)
            canvas2 = FigureCanvasTkAgg(fig2, master=root)
            canvas2.draw()
            canvas2.get_tk_widget().pack(side=tk.LEFT, padx=10)
            advice_label.config(text=advice)
    select_file_btn = tk.Button(root, text='选择CSV文件', command=select_file)
    select_file_btn.pack(pady=10)
    advice_label = tk.Label(root, text='', wraplength=400)
    advice_label.pack(pady=10)
    root.mainloop()
# 主程序入口
if __name__ == '__main__':
    create_gui()

date,category,amount
2024-01-01,Catering,50
2024-01-01,traffic,20
2024-01-02,shopping,100
2024-01-02,entertainment,30
2024-01-03,Catering,40
2024-01-03,traffic,15