从数据框格式的Pandas费用文件创建每日帐户日志

import pandas as pd
from datetime import datetime

df = pd.read_csv('费用文件.csv')

# 删除不需要的列
df = df.drop(['不需要的列1', '不需要的列2'], axis=1)

# 处理缺失值
df = df.fillna(0)

account_log = pd.DataFrame(columns=['日期', '费用', '操作'])

for index, row in df.iterrows():
    date = datetime.strptime(row['日期'], '%Y-%m-%d')
    if row['费用'] > 0:
        operation = '收入'
    else:
        operation = '支出'
    account_log = account_log.append({'日期': date, '费用': abs(row['费用']), '操作': operation}, ignore_index=True)

# 计算每日总收入和支出
daily_summary = account_log.groupby('日期').agg({'费用': 'sum'})

# 绘制收支趋势图
daily_summary.plot(kind='line', figsize=(10, 6))