中級者向け No.23
支出トラッカー（グラフ付き）
カテゴリ別の支出をmatplotlibで円グラフ・棒グラフ表示するアプリ。データ可視化の実践的な活用例を学びます。
📋 目次
1. アプリ概要
カテゴリ別の支出をmatplotlibで円グラフ・棒グラフ表示するアプリ。データ可視化の実践的な活用例を学びます。
このアプリは中級カテゴリに分類される実践的なGUIアプリです。使用ライブラリは tkinter（標準ライブラリ）・matplotlib で、難易度は ★★☆ です。
Pythonでは tkinter を使うことで、クロスプラットフォームなGUIアプリを簡単に作成できます。このアプリを通じて、ウィジェットの配置・イベント処理・データ管理など、GUI開発の実践的なスキルを習得できます。
ソースコードは完全な動作状態で提供しており、コピーしてそのまま実行できます。まずは実行して動作を確認し、その後コードを読んで仕組みを理解していきましょう。カスタマイズセクションでは機能拡張のアイデアも紹介しています。
GUIアプリ開発は、プログラミングの楽しさを実感できる最も効果的な学習方法のひとつです。アプリを作ることで、変数・関数・クラス・イベント処理など、プログラミングの重要な概念が自然と身についていきます。このアプリをきっかけに、オリジナルアプリの開発にも挑戦してみてください。
2. 機能一覧
- 支出トラッカー（グラフ付き）のメイン機能
- 直感的なGUIインターフェース
- 入力値のバリデーション
- エラーハンドリング
- 結果の見やすい表示
- キーボードショートカット対応
3. 事前準備・環境
動作確認環境
Python 3.10 以上 / Windows・Mac・Linux すべて対応
以下の環境で動作確認しています。
- Python 3.10 以上
- OS: Windows 10/11・macOS 12+・Ubuntu 20.04+
インストールが必要なライブラリ
pip install matplotlib4. 完全なソースコード
コードのコピー方法
右上の「コピー」ボタンをクリックするとコードをクリップボードにコピーできます。
app23.py
import tkinter as tk
from tkinter import ttk, messagebox
import sqlite3
import os
from datetime import datetime, date
from calendar import month_abbr
try:
import matplotlib
matplotlib.use("TkAgg")
from matplotlib.figure import Figure
from matplotlib.backends.backend_tkagg import FigureCanvasTkAgg
import matplotlib.pyplot as plt
MATPLOTLIB_AVAILABLE = True
except ImportError:
MATPLOTLIB_AVAILABLE = False
class App23:
"""支出トラッカー（グラフ付き）"""
DB_PATH = os.path.join(os.path.dirname(__file__), "expenses.db")
CATEGORIES = ["食費", "交通費", "娯楽", "衣類", "医療", "光熱費",
"通信費", "教育", "住居", "その他"]
def __init__(self, root):
self.root = root
self.root.title("支出トラッカー（グラフ付き）")
self.root.geometry("960x640")
self.root.configure(bg="#f8f9fc")
self._init_db()
self._build_ui()
self._load_expenses()
self._update_charts()
if not MATPLOTLIB_AVAILABLE:
messagebox.showwarning(
"ライブラリ未インストール",
"matplotlib が必要です。\n"
"pip install matplotlib でインストールしてください。")
def _init_db(self):
self.conn = sqlite3.connect(self.DB_PATH)
self.conn.execute("""
CREATE TABLE IF NOT EXISTS expenses (
id INTEGER PRIMARY KEY AUTOINCREMENT,
date TEXT NOT NULL,
amount REAL NOT NULL,
category TEXT,
description TEXT,
type TEXT DEFAULT 'expense'
)
""")
self.conn.commit()
if not self.conn.execute("SELECT 1 FROM expenses").fetchone():
import random
today = date.today()
for i in range(30):
d = date(today.year, today.month, min(i+1, 28))
self.conn.execute(
"INSERT INTO expenses (date,amount,category,description,type) "
"VALUES (?,?,?,?,?)",
(str(d),
random.randint(100, 8000),
self.CATEGORIES[i % len(self.CATEGORIES)],
"サンプルデータ", "expense"))
self.conn.commit()
def _build_ui(self):
title_frame = tk.Frame(self.root, bg="#4caf50", pady=10)
title_frame.pack(fill=tk.X)
tk.Label(title_frame, text="💹 支出トラッカー",
font=("Noto Sans JP", 15, "bold"),
bg="#4caf50", fg="white").pack(side=tk.LEFT, padx=12)
# フィルター
filter_f = tk.Frame(self.root, bg="#e8f5e9", pady=6)
filter_f.pack(fill=tk.X)
tk.Label(filter_f, text="年:", bg="#e8f5e9").pack(side=tk.LEFT, padx=8)
self.year_var = tk.IntVar(value=date.today().year)
ttk.Spinbox(filter_f, from_=2000, to=2100,
textvariable=self.year_var, width=6,
command=lambda: (self._load_expenses(), self._update_charts())
).pack(side=tk.LEFT, padx=4)
tk.Label(filter_f, text="月:", bg="#e8f5e9").pack(side=tk.LEFT, padx=(8, 4))
self.month_var = tk.IntVar(value=date.today().month)
ttk.Spinbox(filter_f, from_=1, to=12,
textvariable=self.month_var, width=4,
command=lambda: (self._load_expenses(), self._update_charts())
).pack(side=tk.LEFT, padx=4)
tk.Label(filter_f, text="カテゴリ:", bg="#e8f5e9").pack(side=tk.LEFT, padx=(12, 4))
self.cat_var = tk.StringVar(value="すべて")
cat_cb = ttk.Combobox(filter_f, textvariable=self.cat_var,
values=["すべて"] + self.CATEGORIES,
state="readonly", width=10)
cat_cb.pack(side=tk.LEFT)
cat_cb.bind("<<ComboboxSelected>>",
lambda e: (self._load_expenses(), self._update_charts()))
# サマリーカード
summary_f = tk.Frame(self.root, bg="#f8f9fc")
summary_f.pack(fill=tk.X, padx=8, pady=4)
self.summary_labels = {}
for key, color in [("支出合計", "#e53935"), ("収入合計", "#43a047"),
("残高", "#1976d2"), ("件数", "#fb8c00")]:
c = tk.Frame(summary_f, bg=color, padx=10, pady=6)
c.pack(side=tk.LEFT, fill=tk.X, expand=True, padx=4)
tk.Label(c, text=key, bg=color, fg="white",
font=("Arial", 9)).pack()
lbl = tk.Label(c, text="¥0", bg=color, fg="white",
font=("Arial", 14, "bold"))
lbl.pack()
self.summary_labels[key] = lbl
paned = ttk.PanedWindow(self.root, orient=tk.HORIZONTAL)
paned.pack(fill=tk.BOTH, expand=True, padx=4, pady=4)
# 左: データ入力 + 一覧
left = tk.Frame(paned, bg="#f8f9fc")
# 入力フォーム
input_f = ttk.LabelFrame(left, text="支出入力", padding=8)
input_f.pack(fill=tk.X, pady=(0, 6))
form_inner = tk.Frame(input_f, bg=input_f.cget("background"))
form_inner.pack(fill=tk.X)
labels = [("日付", "date", str(date.today())),
("金額", "amount", ""),
("カテゴリ", None, ""),
("説明", "desc", "")]
for i, (lbl, attr, default) in enumerate(labels):
tk.Label(form_inner, text=f"{lbl}:",
bg=form_inner.cget("bg")).grid(row=i, column=0, sticky="w", pady=2)
if lbl == "カテゴリ":
self.new_cat_var = tk.StringVar(value=self.CATEGORIES[0])
ttk.Combobox(form_inner, textvariable=self.new_cat_var,
values=self.CATEGORIES, state="readonly",
width=12).grid(row=i, column=1, padx=6, sticky="w")
else:
var = tk.StringVar(value=default)
ttk.Entry(form_inner, textvariable=var, width=16).grid(
row=i, column=1, padx=6, sticky="w")
setattr(self, f"{attr}_var", var)
self.type_var = tk.StringVar(value="expense")
type_f = tk.Frame(input_f, bg=input_f.cget("background"))
type_f.pack(fill=tk.X, pady=2)
for val, lbl in [("expense", "支出"), ("income", "収入")]:
ttk.Radiobutton(type_f, text=lbl, variable=self.type_var,
value=val).pack(side=tk.LEFT, padx=8)
btn_f = tk.Frame(input_f, bg=input_f.cget("background"))
btn_f.pack(fill=tk.X)
ttk.Button(btn_f, text="➕ 追加", command=self._add_expense).pack(side=tk.LEFT, padx=4)
ttk.Button(btn_f, text="🗑️ 削除", command=self._delete_expense).pack(side=tk.LEFT, padx=4)
# 一覧
list_f = ttk.LabelFrame(left, text="一覧", padding=4)
list_f.pack(fill=tk.BOTH, expand=True)
cols = ("date", "amount", "category", "description", "type")
self.tree = ttk.Treeview(list_f, columns=cols, show="headings", height=12)
for c, h, w in [("date", "日付", 90), ("amount", "金額", 80),
("category", "カテゴリ", 80), ("description", "説明", 120),
("type", "種別", 50)]:
self.tree.heading(c, text=h)
self.tree.column(c, width=w, minwidth=40)
sb = ttk.Scrollbar(list_f, command=self.tree.yview)
self.tree.configure(yscrollcommand=sb.set)
sb.pack(side=tk.RIGHT, fill=tk.Y)
self.tree.pack(fill=tk.BOTH, expand=True)
self.tree.tag_configure("income", foreground="#43a047")
self.tree.tag_configure("expense", foreground="#e53935")
paned.add(left, weight=2)
# 右: グラフ
right = tk.Frame(paned, bg="#f8f9fc")
if MATPLOTLIB_AVAILABLE:
self.fig = Figure(figsize=(6, 7), dpi=90, facecolor="#f8f9fc")
self.ax_pie = self.fig.add_subplot(211)
self.ax_bar = self.fig.add_subplot(212)
self.fig.subplots_adjust(hspace=0.4)
self.chart_canvas = FigureCanvasTkAgg(self.fig, master=right)
self.chart_canvas.get_tk_widget().pack(fill=tk.BOTH, expand=True)
paned.add(right, weight=3)
self.status_var = tk.StringVar(value="")
tk.Label(self.root, textvariable=self.status_var,
bg="#dde", font=("Arial", 9), anchor="w", padx=8
).pack(fill=tk.X, side=tk.BOTTOM)
def _load_expenses(self):
year = self.year_var.get()
month = self.month_var.get()
cat = self.cat_var.get()
prefix = f"{year}-{month:02d}"
sql = ("SELECT id,date,amount,category,description,type "
"FROM expenses WHERE date LIKE ?")
params = [f"{prefix}%"]
if cat != "すべて":
sql += " AND category=?"
params.append(cat)
sql += " ORDER BY date DESC"
rows = self.conn.execute(sql, params).fetchall()
self.tree.delete(*self.tree.get_children())
total_exp = total_inc = 0
for row in rows:
rid, d, amt, c, desc, t = row
tag = "income" if t == "income" else "expense"
self.tree.insert("", "end", iid=str(rid),
values=(d, f"¥{amt:,.0f}", c, desc or "", t),
tags=(tag,))
if t == "income":
total_inc += amt
else:
total_exp += amt
self.summary_labels["支出合計"].config(text=f"¥{total_exp:,.0f}")
self.summary_labels["収入合計"].config(text=f"¥{total_inc:,.0f}")
self.summary_labels["残高"].config(text=f"¥{total_inc-total_exp:,.0f}")
self.summary_labels["件数"].config(text=f"{len(rows)} 件")
self.status_var.set(f"{prefix} {len(rows)} 件")
def _update_charts(self):
if not MATPLOTLIB_AVAILABLE:
return
year = self.year_var.get()
month = self.month_var.get()
prefix = f"{year}-{month:02d}"
rows = self.conn.execute(
"SELECT category, SUM(amount) FROM expenses "
"WHERE date LIKE ? AND type='expense' GROUP BY category",
(f"{prefix}%",)).fetchall()
# 円グラフ
self.ax_pie.clear()
if rows:
labels = [r[0] for r in rows]
sizes = [r[1] for r in rows]
self.ax_pie.pie(sizes, labels=labels, autopct="%1.1f%%",
startangle=90)
self.ax_pie.set_title(f"{year}年{month}月 カテゴリ別支出",
fontsize=10)
# 棒グラフ（月次推移）
self.ax_bar.clear()
monthly = []
for m in range(1, 13):
p = f"{year}-{m:02d}"
total = self.conn.execute(
"SELECT COALESCE(SUM(amount),0) FROM expenses "
"WHERE date LIKE ? AND type='expense'",
(f"{p}%",)).fetchone()[0]
monthly.append(total)
months = list(range(1, 13))
bars = self.ax_bar.bar(months, monthly, color="#4caf50", alpha=0.8)
self.ax_bar.set_xticks(months)
self.ax_bar.set_xticklabels([f"{m}月" for m in months], fontsize=7)
self.ax_bar.set_title(f"{year}年 月次支出推移", fontsize=10)
self.fig.tight_layout()
self.chart_canvas.draw()
def _add_expense(self):
try:
amt = float(self.amount_var.get().replace(",", ""))
except ValueError:
messagebox.showerror("エラー", "金額を正しく入力してください")
return
self.conn.execute(
"INSERT INTO expenses (date,amount,category,description,type) "
"VALUES (?,?,?,?,?)",
(self.date_var.get(), amt, self.new_cat_var.get(),
self.desc_var.get(), self.type_var.get()))
self.conn.commit()
self._load_expenses()
self._update_charts()
self.amount_var.set("")
self.desc_var.set("")
def _delete_expense(self):
sel = self.tree.selection()
if not sel:
return
if messagebox.askyesno("確認", "削除しますか?"):
for item in sel:
self.conn.execute("DELETE FROM expenses WHERE id=?", (int(item),))
self.conn.commit()
self._load_expenses()
self._update_charts()
if __name__ == "__main__":
root = tk.Tk()
app = App23(root)
root.mainloop()
5. コード解説
支出トラッカー（グラフ付き）のコードを詳しく解説します。クラスベースの設計で各機能を整理して実装しています。
クラス設計とコンストラクタ
App23クラスにアプリの全機能をまとめています。__init__メソッドでウィンドウの基本設定を行い、_build_ui()でUI構築、process()でメイン処理を担当します。この分離により、各メソッドの責任が明確になりコードが読みやすくなります。
import tkinter as tk
from tkinter import ttk, messagebox
import sqlite3
import os
from datetime import datetime, date
from calendar import month_abbr
try:
import matplotlib
matplotlib.use("TkAgg")
from matplotlib.figure import Figure
from matplotlib.backends.backend_tkagg import FigureCanvasTkAgg
import matplotlib.pyplot as plt
MATPLOTLIB_AVAILABLE = True
except ImportError:
MATPLOTLIB_AVAILABLE = False
class App23:
"""支出トラッカー（グラフ付き）"""
DB_PATH = os.path.join(os.path.dirname(__file__), "expenses.db")
CATEGORIES = ["食費", "交通費", "娯楽", "衣類", "医療", "光熱費",
"通信費", "教育", "住居", "その他"]
def __init__(self, root):
self.root = root
self.root.title("支出トラッカー（グラフ付き）")
self.root.geometry("960x640")
self.root.configure(bg="#f8f9fc")
self._init_db()
self._build_ui()
self._load_expenses()
self._update_charts()
if not MATPLOTLIB_AVAILABLE:
messagebox.showwarning(
"ライブラリ未インストール",
"matplotlib が必要です。\n"
"pip install matplotlib でインストールしてください。")
def _init_db(self):
self.conn = sqlite3.connect(self.DB_PATH)
self.conn.execute("""
CREATE TABLE IF NOT EXISTS expenses (
id INTEGER PRIMARY KEY AUTOINCREMENT,
date TEXT NOT NULL,
amount REAL NOT NULL,
category TEXT,
description TEXT,
type TEXT DEFAULT 'expense'
)
""")
self.conn.commit()
if not self.conn.execute("SELECT 1 FROM expenses").fetchone():
import random
today = date.today()
for i in range(30):
d = date(today.year, today.month, min(i+1, 28))
self.conn.execute(
"INSERT INTO expenses (date,amount,category,description,type) "
"VALUES (?,?,?,?,?)",
(str(d),
random.randint(100, 8000),
self.CATEGORIES[i % len(self.CATEGORIES)],
"サンプルデータ", "expense"))
self.conn.commit()
def _build_ui(self):
title_frame = tk.Frame(self.root, bg="#4caf50", pady=10)
title_frame.pack(fill=tk.X)
tk.Label(title_frame, text="💹 支出トラッカー",
font=("Noto Sans JP", 15, "bold"),
bg="#4caf50", fg="white").pack(side=tk.LEFT, padx=12)
# フィルター
filter_f = tk.Frame(self.root, bg="#e8f5e9", pady=6)
filter_f.pack(fill=tk.X)
tk.Label(filter_f, text="年:", bg="#e8f5e9").pack(side=tk.LEFT, padx=8)
self.year_var = tk.IntVar(value=date.today().year)
ttk.Spinbox(filter_f, from_=2000, to=2100,
textvariable=self.year_var, width=6,
command=lambda: (self._load_expenses(), self._update_charts())
).pack(side=tk.LEFT, padx=4)
tk.Label(filter_f, text="月:", bg="#e8f5e9").pack(side=tk.LEFT, padx=(8, 4))
self.month_var = tk.IntVar(value=date.today().month)
ttk.Spinbox(filter_f, from_=1, to=12,
textvariable=self.month_var, width=4,
command=lambda: (self._load_expenses(), self._update_charts())
).pack(side=tk.LEFT, padx=4)
tk.Label(filter_f, text="カテゴリ:", bg="#e8f5e9").pack(side=tk.LEFT, padx=(12, 4))
self.cat_var = tk.StringVar(value="すべて")
cat_cb = ttk.Combobox(filter_f, textvariable=self.cat_var,
values=["すべて"] + self.CATEGORIES,
state="readonly", width=10)
cat_cb.pack(side=tk.LEFT)
cat_cb.bind("<<ComboboxSelected>>",
lambda e: (self._load_expenses(), self._update_charts()))
# サマリーカード
summary_f = tk.Frame(self.root, bg="#f8f9fc")
summary_f.pack(fill=tk.X, padx=8, pady=4)
self.summary_labels = {}
for key, color in [("支出合計", "#e53935"), ("収入合計", "#43a047"),
("残高", "#1976d2"), ("件数", "#fb8c00")]:
c = tk.Frame(summary_f, bg=color, padx=10, pady=6)
c.pack(side=tk.LEFT, fill=tk.X, expand=True, padx=4)
tk.Label(c, text=key, bg=color, fg="white",
font=("Arial", 9)).pack()
lbl = tk.Label(c, text="¥0", bg=color, fg="white",
font=("Arial", 14, "bold"))
lbl.pack()
self.summary_labels[key] = lbl
paned = ttk.PanedWindow(self.root, orient=tk.HORIZONTAL)
paned.pack(fill=tk.BOTH, expand=True, padx=4, pady=4)
# 左: データ入力 + 一覧
left = tk.Frame(paned, bg="#f8f9fc")
# 入力フォーム
input_f = ttk.LabelFrame(left, text="支出入力", padding=8)
input_f.pack(fill=tk.X, pady=(0, 6))
form_inner = tk.Frame(input_f, bg=input_f.cget("background"))
form_inner.pack(fill=tk.X)
labels = [("日付", "date", str(date.today())),
("金額", "amount", ""),
("カテゴリ", None, ""),
("説明", "desc", "")]
for i, (lbl, attr, default) in enumerate(labels):
tk.Label(form_inner, text=f"{lbl}:",
bg=form_inner.cget("bg")).grid(row=i, column=0, sticky="w", pady=2)
if lbl == "カテゴリ":
self.new_cat_var = tk.StringVar(value=self.CATEGORIES[0])
ttk.Combobox(form_inner, textvariable=self.new_cat_var,
values=self.CATEGORIES, state="readonly",
width=12).grid(row=i, column=1, padx=6, sticky="w")
else:
var = tk.StringVar(value=default)
ttk.Entry(form_inner, textvariable=var, width=16).grid(
row=i, column=1, padx=6, sticky="w")
setattr(self, f"{attr}_var", var)
self.type_var = tk.StringVar(value="expense")
type_f = tk.Frame(input_f, bg=input_f.cget("background"))
type_f.pack(fill=tk.X, pady=2)
for val, lbl in [("expense", "支出"), ("income", "収入")]:
ttk.Radiobutton(type_f, text=lbl, variable=self.type_var,
value=val).pack(side=tk.LEFT, padx=8)
btn_f = tk.Frame(input_f, bg=input_f.cget("background"))
btn_f.pack(fill=tk.X)
ttk.Button(btn_f, text="➕ 追加", command=self._add_expense).pack(side=tk.LEFT, padx=4)
ttk.Button(btn_f, text="🗑️ 削除", command=self._delete_expense).pack(side=tk.LEFT, padx=4)
# 一覧
list_f = ttk.LabelFrame(left, text="一覧", padding=4)
list_f.pack(fill=tk.BOTH, expand=True)
cols = ("date", "amount", "category", "description", "type")
self.tree = ttk.Treeview(list_f, columns=cols, show="headings", height=12)
for c, h, w in [("date", "日付", 90), ("amount", "金額", 80),
("category", "カテゴリ", 80), ("description", "説明", 120),
("type", "種別", 50)]:
self.tree.heading(c, text=h)
self.tree.column(c, width=w, minwidth=40)
sb = ttk.Scrollbar(list_f, command=self.tree.yview)
self.tree.configure(yscrollcommand=sb.set)
sb.pack(side=tk.RIGHT, fill=tk.Y)
self.tree.pack(fill=tk.BOTH, expand=True)
self.tree.tag_configure("income", foreground="#43a047")
self.tree.tag_configure("expense", foreground="#e53935")
paned.add(left, weight=2)
# 右: グラフ
right = tk.Frame(paned, bg="#f8f9fc")
if MATPLOTLIB_AVAILABLE:
self.fig = Figure(figsize=(6, 7), dpi=90, facecolor="#f8f9fc")
self.ax_pie = self.fig.add_subplot(211)
self.ax_bar = self.fig.add_subplot(212)
self.fig.subplots_adjust(hspace=0.4)
self.chart_canvas = FigureCanvasTkAgg(self.fig, master=right)
self.chart_canvas.get_tk_widget().pack(fill=tk.BOTH, expand=True)
paned.add(right, weight=3)
self.status_var = tk.StringVar(value="")
tk.Label(self.root, textvariable=self.status_var,
bg="#dde", font=("Arial", 9), anchor="w", padx=8
).pack(fill=tk.X, side=tk.BOTTOM)
def _load_expenses(self):
year = self.year_var.get()
month = self.month_var.get()
cat = self.cat_var.get()
prefix = f"{year}-{month:02d}"
sql = ("SELECT id,date,amount,category,description,type "
"FROM expenses WHERE date LIKE ?")
params = [f"{prefix}%"]
if cat != "すべて":
sql += " AND category=?"
params.append(cat)
sql += " ORDER BY date DESC"
rows = self.conn.execute(sql, params).fetchall()
self.tree.delete(*self.tree.get_children())
total_exp = total_inc = 0
for row in rows:
rid, d, amt, c, desc, t = row
tag = "income" if t == "income" else "expense"
self.tree.insert("", "end", iid=str(rid),
values=(d, f"¥{amt:,.0f}", c, desc or "", t),
tags=(tag,))
if t == "income":
total_inc += amt
else:
total_exp += amt
self.summary_labels["支出合計"].config(text=f"¥{total_exp:,.0f}")
self.summary_labels["収入合計"].config(text=f"¥{total_inc:,.0f}")
self.summary_labels["残高"].config(text=f"¥{total_inc-total_exp:,.0f}")
self.summary_labels["件数"].config(text=f"{len(rows)} 件")
self.status_var.set(f"{prefix} {len(rows)} 件")
def _update_charts(self):
if not MATPLOTLIB_AVAILABLE:
return
year = self.year_var.get()
month = self.month_var.get()
prefix = f"{year}-{month:02d}"
rows = self.conn.execute(
"SELECT category, SUM(amount) FROM expenses "
"WHERE date LIKE ? AND type='expense' GROUP BY category",
(f"{prefix}%",)).fetchall()
# 円グラフ
self.ax_pie.clear()
if rows:
labels = [r[0] for r in rows]
sizes = [r[1] for r in rows]
self.ax_pie.pie(sizes, labels=labels, autopct="%1.1f%%",
startangle=90)
self.ax_pie.set_title(f"{year}年{month}月 カテゴリ別支出",
fontsize=10)
# 棒グラフ（月次推移）
self.ax_bar.clear()
monthly = []
for m in range(1, 13):
p = f"{year}-{m:02d}"
total = self.conn.execute(
"SELECT COALESCE(SUM(amount),0) FROM expenses "
"WHERE date LIKE ? AND type='expense'",
(f"{p}%",)).fetchone()[0]
monthly.append(total)
months = list(range(1, 13))
bars = self.ax_bar.bar(months, monthly, color="#4caf50", alpha=0.8)
self.ax_bar.set_xticks(months)
self.ax_bar.set_xticklabels([f"{m}月" for m in months], fontsize=7)
self.ax_bar.set_title(f"{year}年 月次支出推移", fontsize=10)
self.fig.tight_layout()
self.chart_canvas.draw()
def _add_expense(self):
try:
amt = float(self.amount_var.get().replace(",", ""))
except ValueError:
messagebox.showerror("エラー", "金額を正しく入力してください")
return
self.conn.execute(
"INSERT INTO expenses (date,amount,category,description,type) "
"VALUES (?,?,?,?,?)",
(self.date_var.get(), amt, self.new_cat_var.get(),
self.desc_var.get(), self.type_var.get()))
self.conn.commit()
self._load_expenses()
self._update_charts()
self.amount_var.set("")
self.desc_var.set("")
def _delete_expense(self):
sel = self.tree.selection()
if not sel:
return
if messagebox.askyesno("確認", "削除しますか?"):
for item in sel:
self.conn.execute("DELETE FROM expenses WHERE id=?", (int(item),))
self.conn.commit()
self._load_expenses()
self._update_charts()
if __name__ == "__main__":
root = tk.Tk()
app = App23(root)
root.mainloop()
LabelFrameによるセクション分け
ttk.LabelFrame を使うことで、入力エリアと結果エリアを視覚的に分けられます。padding引数でフレーム内の余白を設定し、見やすいレイアウトを実現しています。
import tkinter as tk
from tkinter import ttk, messagebox
import sqlite3
import os
from datetime import datetime, date
from calendar import month_abbr
try:
import matplotlib
matplotlib.use("TkAgg")
from matplotlib.figure import Figure
from matplotlib.backends.backend_tkagg import FigureCanvasTkAgg
import matplotlib.pyplot as plt
MATPLOTLIB_AVAILABLE = True
except ImportError:
MATPLOTLIB_AVAILABLE = False
class App23:
"""支出トラッカー（グラフ付き）"""
DB_PATH = os.path.join(os.path.dirname(__file__), "expenses.db")
CATEGORIES = ["食費", "交通費", "娯楽", "衣類", "医療", "光熱費",
"通信費", "教育", "住居", "その他"]
def __init__(self, root):
self.root = root
self.root.title("支出トラッカー（グラフ付き）")
self.root.geometry("960x640")
self.root.configure(bg="#f8f9fc")
self._init_db()
self._build_ui()
self._load_expenses()
self._update_charts()
if not MATPLOTLIB_AVAILABLE:
messagebox.showwarning(
"ライブラリ未インストール",
"matplotlib が必要です。\n"
"pip install matplotlib でインストールしてください。")
def _init_db(self):
self.conn = sqlite3.connect(self.DB_PATH)
self.conn.execute("""
CREATE TABLE IF NOT EXISTS expenses (
id INTEGER PRIMARY KEY AUTOINCREMENT,
date TEXT NOT NULL,
amount REAL NOT NULL,
category TEXT,
description TEXT,
type TEXT DEFAULT 'expense'
)
""")
self.conn.commit()
if not self.conn.execute("SELECT 1 FROM expenses").fetchone():
import random
today = date.today()
for i in range(30):
d = date(today.year, today.month, min(i+1, 28))
self.conn.execute(
"INSERT INTO expenses (date,amount,category,description,type) "
"VALUES (?,?,?,?,?)",
(str(d),
random.randint(100, 8000),
self.CATEGORIES[i % len(self.CATEGORIES)],
"サンプルデータ", "expense"))
self.conn.commit()
def _build_ui(self):
title_frame = tk.Frame(self.root, bg="#4caf50", pady=10)
title_frame.pack(fill=tk.X)
tk.Label(title_frame, text="💹 支出トラッカー",
font=("Noto Sans JP", 15, "bold"),
bg="#4caf50", fg="white").pack(side=tk.LEFT, padx=12)
# フィルター
filter_f = tk.Frame(self.root, bg="#e8f5e9", pady=6)
filter_f.pack(fill=tk.X)
tk.Label(filter_f, text="年:", bg="#e8f5e9").pack(side=tk.LEFT, padx=8)
self.year_var = tk.IntVar(value=date.today().year)
ttk.Spinbox(filter_f, from_=2000, to=2100,
textvariable=self.year_var, width=6,
command=lambda: (self._load_expenses(), self._update_charts())
).pack(side=tk.LEFT, padx=4)
tk.Label(filter_f, text="月:", bg="#e8f5e9").pack(side=tk.LEFT, padx=(8, 4))
self.month_var = tk.IntVar(value=date.today().month)
ttk.Spinbox(filter_f, from_=1, to=12,
textvariable=self.month_var, width=4,
command=lambda: (self._load_expenses(), self._update_charts())
).pack(side=tk.LEFT, padx=4)
tk.Label(filter_f, text="カテゴリ:", bg="#e8f5e9").pack(side=tk.LEFT, padx=(12, 4))
self.cat_var = tk.StringVar(value="すべて")
cat_cb = ttk.Combobox(filter_f, textvariable=self.cat_var,
values=["すべて"] + self.CATEGORIES,
state="readonly", width=10)
cat_cb.pack(side=tk.LEFT)
cat_cb.bind("<<ComboboxSelected>>",
lambda e: (self._load_expenses(), self._update_charts()))
# サマリーカード
summary_f = tk.Frame(self.root, bg="#f8f9fc")
summary_f.pack(fill=tk.X, padx=8, pady=4)
self.summary_labels = {}
for key, color in [("支出合計", "#e53935"), ("収入合計", "#43a047"),
("残高", "#1976d2"), ("件数", "#fb8c00")]:
c = tk.Frame(summary_f, bg=color, padx=10, pady=6)
c.pack(side=tk.LEFT, fill=tk.X, expand=True, padx=4)
tk.Label(c, text=key, bg=color, fg="white",
font=("Arial", 9)).pack()
lbl = tk.Label(c, text="¥0", bg=color, fg="white",
font=("Arial", 14, "bold"))
lbl.pack()
self.summary_labels[key] = lbl
paned = ttk.PanedWindow(self.root, orient=tk.HORIZONTAL)
paned.pack(fill=tk.BOTH, expand=True, padx=4, pady=4)
# 左: データ入力 + 一覧
left = tk.Frame(paned, bg="#f8f9fc")
# 入力フォーム
input_f = ttk.LabelFrame(left, text="支出入力", padding=8)
input_f.pack(fill=tk.X, pady=(0, 6))
form_inner = tk.Frame(input_f, bg=input_f.cget("background"))
form_inner.pack(fill=tk.X)
labels = [("日付", "date", str(date.today())),
("金額", "amount", ""),
("カテゴリ", None, ""),
("説明", "desc", "")]
for i, (lbl, attr, default) in enumerate(labels):
tk.Label(form_inner, text=f"{lbl}:",
bg=form_inner.cget("bg")).grid(row=i, column=0, sticky="w", pady=2)
if lbl == "カテゴリ":
self.new_cat_var = tk.StringVar(value=self.CATEGORIES[0])
ttk.Combobox(form_inner, textvariable=self.new_cat_var,
values=self.CATEGORIES, state="readonly",
width=12).grid(row=i, column=1, padx=6, sticky="w")
else:
var = tk.StringVar(value=default)
ttk.Entry(form_inner, textvariable=var, width=16).grid(
row=i, column=1, padx=6, sticky="w")
setattr(self, f"{attr}_var", var)
self.type_var = tk.StringVar(value="expense")
type_f = tk.Frame(input_f, bg=input_f.cget("background"))
type_f.pack(fill=tk.X, pady=2)
for val, lbl in [("expense", "支出"), ("income", "収入")]:
ttk.Radiobutton(type_f, text=lbl, variable=self.type_var,
value=val).pack(side=tk.LEFT, padx=8)
btn_f = tk.Frame(input_f, bg=input_f.cget("background"))
btn_f.pack(fill=tk.X)
ttk.Button(btn_f, text="➕ 追加", command=self._add_expense).pack(side=tk.LEFT, padx=4)
ttk.Button(btn_f, text="🗑️ 削除", command=self._delete_expense).pack(side=tk.LEFT, padx=4)
# 一覧
list_f = ttk.LabelFrame(left, text="一覧", padding=4)
list_f.pack(fill=tk.BOTH, expand=True)
cols = ("date", "amount", "category", "description", "type")
self.tree = ttk.Treeview(list_f, columns=cols, show="headings", height=12)
for c, h, w in [("date", "日付", 90), ("amount", "金額", 80),
("category", "カテゴリ", 80), ("description", "説明", 120),
("type", "種別", 50)]:
self.tree.heading(c, text=h)
self.tree.column(c, width=w, minwidth=40)
sb = ttk.Scrollbar(list_f, command=self.tree.yview)
self.tree.configure(yscrollcommand=sb.set)
sb.pack(side=tk.RIGHT, fill=tk.Y)
self.tree.pack(fill=tk.BOTH, expand=True)
self.tree.tag_configure("income", foreground="#43a047")
self.tree.tag_configure("expense", foreground="#e53935")
paned.add(left, weight=2)
# 右: グラフ
right = tk.Frame(paned, bg="#f8f9fc")
if MATPLOTLIB_AVAILABLE:
self.fig = Figure(figsize=(6, 7), dpi=90, facecolor="#f8f9fc")
self.ax_pie = self.fig.add_subplot(211)
self.ax_bar = self.fig.add_subplot(212)
self.fig.subplots_adjust(hspace=0.4)
self.chart_canvas = FigureCanvasTkAgg(self.fig, master=right)
self.chart_canvas.get_tk_widget().pack(fill=tk.BOTH, expand=True)
paned.add(right, weight=3)
self.status_var = tk.StringVar(value="")
tk.Label(self.root, textvariable=self.status_var,
bg="#dde", font=("Arial", 9), anchor="w", padx=8
).pack(fill=tk.X, side=tk.BOTTOM)
def _load_expenses(self):
year = self.year_var.get()
month = self.month_var.get()
cat = self.cat_var.get()
prefix = f"{year}-{month:02d}"
sql = ("SELECT id,date,amount,category,description,type "
"FROM expenses WHERE date LIKE ?")
params = [f"{prefix}%"]
if cat != "すべて":
sql += " AND category=?"
params.append(cat)
sql += " ORDER BY date DESC"
rows = self.conn.execute(sql, params).fetchall()
self.tree.delete(*self.tree.get_children())
total_exp = total_inc = 0
for row in rows:
rid, d, amt, c, desc, t = row
tag = "income" if t == "income" else "expense"
self.tree.insert("", "end", iid=str(rid),
values=(d, f"¥{amt:,.0f}", c, desc or "", t),
tags=(tag,))
if t == "income":
total_inc += amt
else:
total_exp += amt
self.summary_labels["支出合計"].config(text=f"¥{total_exp:,.0f}")
self.summary_labels["収入合計"].config(text=f"¥{total_inc:,.0f}")
self.summary_labels["残高"].config(text=f"¥{total_inc-total_exp:,.0f}")
self.summary_labels["件数"].config(text=f"{len(rows)} 件")
self.status_var.set(f"{prefix} {len(rows)} 件")
def _update_charts(self):
if not MATPLOTLIB_AVAILABLE:
return
year = self.year_var.get()
month = self.month_var.get()
prefix = f"{year}-{month:02d}"
rows = self.conn.execute(
"SELECT category, SUM(amount) FROM expenses "
"WHERE date LIKE ? AND type='expense' GROUP BY category",
(f"{prefix}%",)).fetchall()
# 円グラフ
self.ax_pie.clear()
if rows:
labels = [r[0] for r in rows]
sizes = [r[1] for r in rows]
self.ax_pie.pie(sizes, labels=labels, autopct="%1.1f%%",
startangle=90)
self.ax_pie.set_title(f"{year}年{month}月 カテゴリ別支出",
fontsize=10)
# 棒グラフ（月次推移）
self.ax_bar.clear()
monthly = []
for m in range(1, 13):
p = f"{year}-{m:02d}"
total = self.conn.execute(
"SELECT COALESCE(SUM(amount),0) FROM expenses "
"WHERE date LIKE ? AND type='expense'",
(f"{p}%",)).fetchone()[0]
monthly.append(total)
months = list(range(1, 13))
bars = self.ax_bar.bar(months, monthly, color="#4caf50", alpha=0.8)
self.ax_bar.set_xticks(months)
self.ax_bar.set_xticklabels([f"{m}月" for m in months], fontsize=7)
self.ax_bar.set_title(f"{year}年 月次支出推移", fontsize=10)
self.fig.tight_layout()
self.chart_canvas.draw()
def _add_expense(self):
try:
amt = float(self.amount_var.get().replace(",", ""))
except ValueError:
messagebox.showerror("エラー", "金額を正しく入力してください")
return
self.conn.execute(
"INSERT INTO expenses (date,amount,category,description,type) "
"VALUES (?,?,?,?,?)",
(self.date_var.get(), amt, self.new_cat_var.get(),
self.desc_var.get(), self.type_var.get()))
self.conn.commit()
self._load_expenses()
self._update_charts()
self.amount_var.set("")
self.desc_var.set("")
def _delete_expense(self):
sel = self.tree.selection()
if not sel:
return
if messagebox.askyesno("確認", "削除しますか?"):
for item in sel:
self.conn.execute("DELETE FROM expenses WHERE id=?", (int(item),))
self.conn.commit()
self._load_expenses()
self._update_charts()
if __name__ == "__main__":
root = tk.Tk()
app = App23(root)
root.mainloop()
Entryウィジェットとイベントバインド
ttk.Entryで入力フィールドを作成します。bind('
import tkinter as tk
from tkinter import ttk, messagebox
import sqlite3
import os
from datetime import datetime, date
from calendar import month_abbr
try:
import matplotlib
matplotlib.use("TkAgg")
from matplotlib.figure import Figure
from matplotlib.backends.backend_tkagg import FigureCanvasTkAgg
import matplotlib.pyplot as plt
MATPLOTLIB_AVAILABLE = True
except ImportError:
MATPLOTLIB_AVAILABLE = False
class App23:
"""支出トラッカー（グラフ付き）"""
DB_PATH = os.path.join(os.path.dirname(__file__), "expenses.db")
CATEGORIES = ["食費", "交通費", "娯楽", "衣類", "医療", "光熱費",
"通信費", "教育", "住居", "その他"]
def __init__(self, root):
self.root = root
self.root.title("支出トラッカー（グラフ付き）")
self.root.geometry("960x640")
self.root.configure(bg="#f8f9fc")
self._init_db()
self._build_ui()
self._load_expenses()
self._update_charts()
if not MATPLOTLIB_AVAILABLE:
messagebox.showwarning(
"ライブラリ未インストール",
"matplotlib が必要です。\n"
"pip install matplotlib でインストールしてください。")
def _init_db(self):
self.conn = sqlite3.connect(self.DB_PATH)
self.conn.execute("""
CREATE TABLE IF NOT EXISTS expenses (
id INTEGER PRIMARY KEY AUTOINCREMENT,
date TEXT NOT NULL,
amount REAL NOT NULL,
category TEXT,
description TEXT,
type TEXT DEFAULT 'expense'
)
""")
self.conn.commit()
if not self.conn.execute("SELECT 1 FROM expenses").fetchone():
import random
today = date.today()
for i in range(30):
d = date(today.year, today.month, min(i+1, 28))
self.conn.execute(
"INSERT INTO expenses (date,amount,category,description,type) "
"VALUES (?,?,?,?,?)",
(str(d),
random.randint(100, 8000),
self.CATEGORIES[i % len(self.CATEGORIES)],
"サンプルデータ", "expense"))
self.conn.commit()
def _build_ui(self):
title_frame = tk.Frame(self.root, bg="#4caf50", pady=10)
title_frame.pack(fill=tk.X)
tk.Label(title_frame, text="💹 支出トラッカー",
font=("Noto Sans JP", 15, "bold"),
bg="#4caf50", fg="white").pack(side=tk.LEFT, padx=12)
# フィルター
filter_f = tk.Frame(self.root, bg="#e8f5e9", pady=6)
filter_f.pack(fill=tk.X)
tk.Label(filter_f, text="年:", bg="#e8f5e9").pack(side=tk.LEFT, padx=8)
self.year_var = tk.IntVar(value=date.today().year)
ttk.Spinbox(filter_f, from_=2000, to=2100,
textvariable=self.year_var, width=6,
command=lambda: (self._load_expenses(), self._update_charts())
).pack(side=tk.LEFT, padx=4)
tk.Label(filter_f, text="月:", bg="#e8f5e9").pack(side=tk.LEFT, padx=(8, 4))
self.month_var = tk.IntVar(value=date.today().month)
ttk.Spinbox(filter_f, from_=1, to=12,
textvariable=self.month_var, width=4,
command=lambda: (self._load_expenses(), self._update_charts())
).pack(side=tk.LEFT, padx=4)
tk.Label(filter_f, text="カテゴリ:", bg="#e8f5e9").pack(side=tk.LEFT, padx=(12, 4))
self.cat_var = tk.StringVar(value="すべて")
cat_cb = ttk.Combobox(filter_f, textvariable=self.cat_var,
values=["すべて"] + self.CATEGORIES,
state="readonly", width=10)
cat_cb.pack(side=tk.LEFT)
cat_cb.bind("<<ComboboxSelected>>",
lambda e: (self._load_expenses(), self._update_charts()))
# サマリーカード
summary_f = tk.Frame(self.root, bg="#f8f9fc")
summary_f.pack(fill=tk.X, padx=8, pady=4)
self.summary_labels = {}
for key, color in [("支出合計", "#e53935"), ("収入合計", "#43a047"),
("残高", "#1976d2"), ("件数", "#fb8c00")]:
c = tk.Frame(summary_f, bg=color, padx=10, pady=6)
c.pack(side=tk.LEFT, fill=tk.X, expand=True, padx=4)
tk.Label(c, text=key, bg=color, fg="white",
font=("Arial", 9)).pack()
lbl = tk.Label(c, text="¥0", bg=color, fg="white",
font=("Arial", 14, "bold"))
lbl.pack()
self.summary_labels[key] = lbl
paned = ttk.PanedWindow(self.root, orient=tk.HORIZONTAL)
paned.pack(fill=tk.BOTH, expand=True, padx=4, pady=4)
# 左: データ入力 + 一覧
left = tk.Frame(paned, bg="#f8f9fc")
# 入力フォーム
input_f = ttk.LabelFrame(left, text="支出入力", padding=8)
input_f.pack(fill=tk.X, pady=(0, 6))
form_inner = tk.Frame(input_f, bg=input_f.cget("background"))
form_inner.pack(fill=tk.X)
labels = [("日付", "date", str(date.today())),
("金額", "amount", ""),
("カテゴリ", None, ""),
("説明", "desc", "")]
for i, (lbl, attr, default) in enumerate(labels):
tk.Label(form_inner, text=f"{lbl}:",
bg=form_inner.cget("bg")).grid(row=i, column=0, sticky="w", pady=2)
if lbl == "カテゴリ":
self.new_cat_var = tk.StringVar(value=self.CATEGORIES[0])
ttk.Combobox(form_inner, textvariable=self.new_cat_var,
values=self.CATEGORIES, state="readonly",
width=12).grid(row=i, column=1, padx=6, sticky="w")
else:
var = tk.StringVar(value=default)
ttk.Entry(form_inner, textvariable=var, width=16).grid(
row=i, column=1, padx=6, sticky="w")
setattr(self, f"{attr}_var", var)
self.type_var = tk.StringVar(value="expense")
type_f = tk.Frame(input_f, bg=input_f.cget("background"))
type_f.pack(fill=tk.X, pady=2)
for val, lbl in [("expense", "支出"), ("income", "収入")]:
ttk.Radiobutton(type_f, text=lbl, variable=self.type_var,
value=val).pack(side=tk.LEFT, padx=8)
btn_f = tk.Frame(input_f, bg=input_f.cget("background"))
btn_f.pack(fill=tk.X)
ttk.Button(btn_f, text="➕ 追加", command=self._add_expense).pack(side=tk.LEFT, padx=4)
ttk.Button(btn_f, text="🗑️ 削除", command=self._delete_expense).pack(side=tk.LEFT, padx=4)
# 一覧
list_f = ttk.LabelFrame(left, text="一覧", padding=4)
list_f.pack(fill=tk.BOTH, expand=True)
cols = ("date", "amount", "category", "description", "type")
self.tree = ttk.Treeview(list_f, columns=cols, show="headings", height=12)
for c, h, w in [("date", "日付", 90), ("amount", "金額", 80),
("category", "カテゴリ", 80), ("description", "説明", 120),
("type", "種別", 50)]:
self.tree.heading(c, text=h)
self.tree.column(c, width=w, minwidth=40)
sb = ttk.Scrollbar(list_f, command=self.tree.yview)
self.tree.configure(yscrollcommand=sb.set)
sb.pack(side=tk.RIGHT, fill=tk.Y)
self.tree.pack(fill=tk.BOTH, expand=True)
self.tree.tag_configure("income", foreground="#43a047")
self.tree.tag_configure("expense", foreground="#e53935")
paned.add(left, weight=2)
# 右: グラフ
right = tk.Frame(paned, bg="#f8f9fc")
if MATPLOTLIB_AVAILABLE:
self.fig = Figure(figsize=(6, 7), dpi=90, facecolor="#f8f9fc")
self.ax_pie = self.fig.add_subplot(211)
self.ax_bar = self.fig.add_subplot(212)
self.fig.subplots_adjust(hspace=0.4)
self.chart_canvas = FigureCanvasTkAgg(self.fig, master=right)
self.chart_canvas.get_tk_widget().pack(fill=tk.BOTH, expand=True)
paned.add(right, weight=3)
self.status_var = tk.StringVar(value="")
tk.Label(self.root, textvariable=self.status_var,
bg="#dde", font=("Arial", 9), anchor="w", padx=8
).pack(fill=tk.X, side=tk.BOTTOM)
def _load_expenses(self):
year = self.year_var.get()
month = self.month_var.get()
cat = self.cat_var.get()
prefix = f"{year}-{month:02d}"
sql = ("SELECT id,date,amount,category,description,type "
"FROM expenses WHERE date LIKE ?")
params = [f"{prefix}%"]
if cat != "すべて":
sql += " AND category=?"
params.append(cat)
sql += " ORDER BY date DESC"
rows = self.conn.execute(sql, params).fetchall()
self.tree.delete(*self.tree.get_children())
total_exp = total_inc = 0
for row in rows:
rid, d, amt, c, desc, t = row
tag = "income" if t == "income" else "expense"
self.tree.insert("", "end", iid=str(rid),
values=(d, f"¥{amt:,.0f}", c, desc or "", t),
tags=(tag,))
if t == "income":
total_inc += amt
else:
total_exp += amt
self.summary_labels["支出合計"].config(text=f"¥{total_exp:,.0f}")
self.summary_labels["収入合計"].config(text=f"¥{total_inc:,.0f}")
self.summary_labels["残高"].config(text=f"¥{total_inc-total_exp:,.0f}")
self.summary_labels["件数"].config(text=f"{len(rows)} 件")
self.status_var.set(f"{prefix} {len(rows)} 件")
def _update_charts(self):
if not MATPLOTLIB_AVAILABLE:
return
year = self.year_var.get()
month = self.month_var.get()
prefix = f"{year}-{month:02d}"
rows = self.conn.execute(
"SELECT category, SUM(amount) FROM expenses "
"WHERE date LIKE ? AND type='expense' GROUP BY category",
(f"{prefix}%",)).fetchall()
# 円グラフ
self.ax_pie.clear()
if rows:
labels = [r[0] for r in rows]
sizes = [r[1] for r in rows]
self.ax_pie.pie(sizes, labels=labels, autopct="%1.1f%%",
startangle=90)
self.ax_pie.set_title(f"{year}年{month}月 カテゴリ別支出",
fontsize=10)
# 棒グラフ（月次推移）
self.ax_bar.clear()
monthly = []
for m in range(1, 13):
p = f"{year}-{m:02d}"
total = self.conn.execute(
"SELECT COALESCE(SUM(amount),0) FROM expenses "
"WHERE date LIKE ? AND type='expense'",
(f"{p}%",)).fetchone()[0]
monthly.append(total)
months = list(range(1, 13))
bars = self.ax_bar.bar(months, monthly, color="#4caf50", alpha=0.8)
self.ax_bar.set_xticks(months)
self.ax_bar.set_xticklabels([f"{m}月" for m in months], fontsize=7)
self.ax_bar.set_title(f"{year}年 月次支出推移", fontsize=10)
self.fig.tight_layout()
self.chart_canvas.draw()
def _add_expense(self):
try:
amt = float(self.amount_var.get().replace(",", ""))
except ValueError:
messagebox.showerror("エラー", "金額を正しく入力してください")
return
self.conn.execute(
"INSERT INTO expenses (date,amount,category,description,type) "
"VALUES (?,?,?,?,?)",
(self.date_var.get(), amt, self.new_cat_var.get(),
self.desc_var.get(), self.type_var.get()))
self.conn.commit()
self._load_expenses()
self._update_charts()
self.amount_var.set("")
self.desc_var.set("")
def _delete_expense(self):
sel = self.tree.selection()
if not sel:
return
if messagebox.askyesno("確認", "削除しますか?"):
for item in sel:
self.conn.execute("DELETE FROM expenses WHERE id=?", (int(item),))
self.conn.commit()
self._load_expenses()
self._update_charts()
if __name__ == "__main__":
root = tk.Tk()
app = App23(root)
root.mainloop()
Textウィジェットでの結果表示
結果表示にはtk.Textウィジェットを使います。state=tk.DISABLEDでユーザーが直接編集できないようにし、表示前にNORMALに切り替えてからinsert()で内容を更新します。
import tkinter as tk
from tkinter import ttk, messagebox
import sqlite3
import os
from datetime import datetime, date
from calendar import month_abbr
try:
import matplotlib
matplotlib.use("TkAgg")
from matplotlib.figure import Figure
from matplotlib.backends.backend_tkagg import FigureCanvasTkAgg
import matplotlib.pyplot as plt
MATPLOTLIB_AVAILABLE = True
except ImportError:
MATPLOTLIB_AVAILABLE = False
class App23:
"""支出トラッカー（グラフ付き）"""
DB_PATH = os.path.join(os.path.dirname(__file__), "expenses.db")
CATEGORIES = ["食費", "交通費", "娯楽", "衣類", "医療", "光熱費",
"通信費", "教育", "住居", "その他"]
def __init__(self, root):
self.root = root
self.root.title("支出トラッカー（グラフ付き）")
self.root.geometry("960x640")
self.root.configure(bg="#f8f9fc")
self._init_db()
self._build_ui()
self._load_expenses()
self._update_charts()
if not MATPLOTLIB_AVAILABLE:
messagebox.showwarning(
"ライブラリ未インストール",
"matplotlib が必要です。\n"
"pip install matplotlib でインストールしてください。")
def _init_db(self):
self.conn = sqlite3.connect(self.DB_PATH)
self.conn.execute("""
CREATE TABLE IF NOT EXISTS expenses (
id INTEGER PRIMARY KEY AUTOINCREMENT,
date TEXT NOT NULL,
amount REAL NOT NULL,
category TEXT,
description TEXT,
type TEXT DEFAULT 'expense'
)
""")
self.conn.commit()
if not self.conn.execute("SELECT 1 FROM expenses").fetchone():
import random
today = date.today()
for i in range(30):
d = date(today.year, today.month, min(i+1, 28))
self.conn.execute(
"INSERT INTO expenses (date,amount,category,description,type) "
"VALUES (?,?,?,?,?)",
(str(d),
random.randint(100, 8000),
self.CATEGORIES[i % len(self.CATEGORIES)],
"サンプルデータ", "expense"))
self.conn.commit()
def _build_ui(self):
title_frame = tk.Frame(self.root, bg="#4caf50", pady=10)
title_frame.pack(fill=tk.X)
tk.Label(title_frame, text="💹 支出トラッカー",
font=("Noto Sans JP", 15, "bold"),
bg="#4caf50", fg="white").pack(side=tk.LEFT, padx=12)
# フィルター
filter_f = tk.Frame(self.root, bg="#e8f5e9", pady=6)
filter_f.pack(fill=tk.X)
tk.Label(filter_f, text="年:", bg="#e8f5e9").pack(side=tk.LEFT, padx=8)
self.year_var = tk.IntVar(value=date.today().year)
ttk.Spinbox(filter_f, from_=2000, to=2100,
textvariable=self.year_var, width=6,
command=lambda: (self._load_expenses(), self._update_charts())
).pack(side=tk.LEFT, padx=4)
tk.Label(filter_f, text="月:", bg="#e8f5e9").pack(side=tk.LEFT, padx=(8, 4))
self.month_var = tk.IntVar(value=date.today().month)
ttk.Spinbox(filter_f, from_=1, to=12,
textvariable=self.month_var, width=4,
command=lambda: (self._load_expenses(), self._update_charts())
).pack(side=tk.LEFT, padx=4)
tk.Label(filter_f, text="カテゴリ:", bg="#e8f5e9").pack(side=tk.LEFT, padx=(12, 4))
self.cat_var = tk.StringVar(value="すべて")
cat_cb = ttk.Combobox(filter_f, textvariable=self.cat_var,
values=["すべて"] + self.CATEGORIES,
state="readonly", width=10)
cat_cb.pack(side=tk.LEFT)
cat_cb.bind("<<ComboboxSelected>>",
lambda e: (self._load_expenses(), self._update_charts()))
# サマリーカード
summary_f = tk.Frame(self.root, bg="#f8f9fc")
summary_f.pack(fill=tk.X, padx=8, pady=4)
self.summary_labels = {}
for key, color in [("支出合計", "#e53935"), ("収入合計", "#43a047"),
("残高", "#1976d2"), ("件数", "#fb8c00")]:
c = tk.Frame(summary_f, bg=color, padx=10, pady=6)
c.pack(side=tk.LEFT, fill=tk.X, expand=True, padx=4)
tk.Label(c, text=key, bg=color, fg="white",
font=("Arial", 9)).pack()
lbl = tk.Label(c, text="¥0", bg=color, fg="white",
font=("Arial", 14, "bold"))
lbl.pack()
self.summary_labels[key] = lbl
paned = ttk.PanedWindow(self.root, orient=tk.HORIZONTAL)
paned.pack(fill=tk.BOTH, expand=True, padx=4, pady=4)
# 左: データ入力 + 一覧
left = tk.Frame(paned, bg="#f8f9fc")
# 入力フォーム
input_f = ttk.LabelFrame(left, text="支出入力", padding=8)
input_f.pack(fill=tk.X, pady=(0, 6))
form_inner = tk.Frame(input_f, bg=input_f.cget("background"))
form_inner.pack(fill=tk.X)
labels = [("日付", "date", str(date.today())),
("金額", "amount", ""),
("カテゴリ", None, ""),
("説明", "desc", "")]
for i, (lbl, attr, default) in enumerate(labels):
tk.Label(form_inner, text=f"{lbl}:",
bg=form_inner.cget("bg")).grid(row=i, column=0, sticky="w", pady=2)
if lbl == "カテゴリ":
self.new_cat_var = tk.StringVar(value=self.CATEGORIES[0])
ttk.Combobox(form_inner, textvariable=self.new_cat_var,
values=self.CATEGORIES, state="readonly",
width=12).grid(row=i, column=1, padx=6, sticky="w")
else:
var = tk.StringVar(value=default)
ttk.Entry(form_inner, textvariable=var, width=16).grid(
row=i, column=1, padx=6, sticky="w")
setattr(self, f"{attr}_var", var)
self.type_var = tk.StringVar(value="expense")
type_f = tk.Frame(input_f, bg=input_f.cget("background"))
type_f.pack(fill=tk.X, pady=2)
for val, lbl in [("expense", "支出"), ("income", "収入")]:
ttk.Radiobutton(type_f, text=lbl, variable=self.type_var,
value=val).pack(side=tk.LEFT, padx=8)
btn_f = tk.Frame(input_f, bg=input_f.cget("background"))
btn_f.pack(fill=tk.X)
ttk.Button(btn_f, text="➕ 追加", command=self._add_expense).pack(side=tk.LEFT, padx=4)
ttk.Button(btn_f, text="🗑️ 削除", command=self._delete_expense).pack(side=tk.LEFT, padx=4)
# 一覧
list_f = ttk.LabelFrame(left, text="一覧", padding=4)
list_f.pack(fill=tk.BOTH, expand=True)
cols = ("date", "amount", "category", "description", "type")
self.tree = ttk.Treeview(list_f, columns=cols, show="headings", height=12)
for c, h, w in [("date", "日付", 90), ("amount", "金額", 80),
("category", "カテゴリ", 80), ("description", "説明", 120),
("type", "種別", 50)]:
self.tree.heading(c, text=h)
self.tree.column(c, width=w, minwidth=40)
sb = ttk.Scrollbar(list_f, command=self.tree.yview)
self.tree.configure(yscrollcommand=sb.set)
sb.pack(side=tk.RIGHT, fill=tk.Y)
self.tree.pack(fill=tk.BOTH, expand=True)
self.tree.tag_configure("income", foreground="#43a047")
self.tree.tag_configure("expense", foreground="#e53935")
paned.add(left, weight=2)
# 右: グラフ
right = tk.Frame(paned, bg="#f8f9fc")
if MATPLOTLIB_AVAILABLE:
self.fig = Figure(figsize=(6, 7), dpi=90, facecolor="#f8f9fc")
self.ax_pie = self.fig.add_subplot(211)
self.ax_bar = self.fig.add_subplot(212)
self.fig.subplots_adjust(hspace=0.4)
self.chart_canvas = FigureCanvasTkAgg(self.fig, master=right)
self.chart_canvas.get_tk_widget().pack(fill=tk.BOTH, expand=True)
paned.add(right, weight=3)
self.status_var = tk.StringVar(value="")
tk.Label(self.root, textvariable=self.status_var,
bg="#dde", font=("Arial", 9), anchor="w", padx=8
).pack(fill=tk.X, side=tk.BOTTOM)
def _load_expenses(self):
year = self.year_var.get()
month = self.month_var.get()
cat = self.cat_var.get()
prefix = f"{year}-{month:02d}"
sql = ("SELECT id,date,amount,category,description,type "
"FROM expenses WHERE date LIKE ?")
params = [f"{prefix}%"]
if cat != "すべて":
sql += " AND category=?"
params.append(cat)
sql += " ORDER BY date DESC"
rows = self.conn.execute(sql, params).fetchall()
self.tree.delete(*self.tree.get_children())
total_exp = total_inc = 0
for row in rows:
rid, d, amt, c, desc, t = row
tag = "income" if t == "income" else "expense"
self.tree.insert("", "end", iid=str(rid),
values=(d, f"¥{amt:,.0f}", c, desc or "", t),
tags=(tag,))
if t == "income":
total_inc += amt
else:
total_exp += amt
self.summary_labels["支出合計"].config(text=f"¥{total_exp:,.0f}")
self.summary_labels["収入合計"].config(text=f"¥{total_inc:,.0f}")
self.summary_labels["残高"].config(text=f"¥{total_inc-total_exp:,.0f}")
self.summary_labels["件数"].config(text=f"{len(rows)} 件")
self.status_var.set(f"{prefix} {len(rows)} 件")
def _update_charts(self):
if not MATPLOTLIB_AVAILABLE:
return
year = self.year_var.get()
month = self.month_var.get()
prefix = f"{year}-{month:02d}"
rows = self.conn.execute(
"SELECT category, SUM(amount) FROM expenses "
"WHERE date LIKE ? AND type='expense' GROUP BY category",
(f"{prefix}%",)).fetchall()
# 円グラフ
self.ax_pie.clear()
if rows:
labels = [r[0] for r in rows]
sizes = [r[1] for r in rows]
self.ax_pie.pie(sizes, labels=labels, autopct="%1.1f%%",
startangle=90)
self.ax_pie.set_title(f"{year}年{month}月 カテゴリ別支出",
fontsize=10)
# 棒グラフ（月次推移）
self.ax_bar.clear()
monthly = []
for m in range(1, 13):
p = f"{year}-{m:02d}"
total = self.conn.execute(
"SELECT COALESCE(SUM(amount),0) FROM expenses "
"WHERE date LIKE ? AND type='expense'",
(f"{p}%",)).fetchone()[0]
monthly.append(total)
months = list(range(1, 13))
bars = self.ax_bar.bar(months, monthly, color="#4caf50", alpha=0.8)
self.ax_bar.set_xticks(months)
self.ax_bar.set_xticklabels([f"{m}月" for m in months], fontsize=7)
self.ax_bar.set_title(f"{year}年 月次支出推移", fontsize=10)
self.fig.tight_layout()
self.chart_canvas.draw()
def _add_expense(self):
try:
amt = float(self.amount_var.get().replace(",", ""))
except ValueError:
messagebox.showerror("エラー", "金額を正しく入力してください")
return
self.conn.execute(
"INSERT INTO expenses (date,amount,category,description,type) "
"VALUES (?,?,?,?,?)",
(self.date_var.get(), amt, self.new_cat_var.get(),
self.desc_var.get(), self.type_var.get()))
self.conn.commit()
self._load_expenses()
self._update_charts()
self.amount_var.set("")
self.desc_var.set("")
def _delete_expense(self):
sel = self.tree.selection()
if not sel:
return
if messagebox.askyesno("確認", "削除しますか?"):
for item in sel:
self.conn.execute("DELETE FROM expenses WHERE id=?", (int(item),))
self.conn.commit()
self._load_expenses()
self._update_charts()
if __name__ == "__main__":
root = tk.Tk()
app = App23(root)
root.mainloop()
例外処理とmessagebox
try-except で ValueError と Exception を捕捉し、messagebox.showerror() でユーザーにわかりやすいエラーメッセージを表示します。入力バリデーションは必ず実装しましょう。
import tkinter as tk
from tkinter import ttk, messagebox
import sqlite3
import os
from datetime import datetime, date
from calendar import month_abbr
try:
import matplotlib
matplotlib.use("TkAgg")
from matplotlib.figure import Figure
from matplotlib.backends.backend_tkagg import FigureCanvasTkAgg
import matplotlib.pyplot as plt
MATPLOTLIB_AVAILABLE = True
except ImportError:
MATPLOTLIB_AVAILABLE = False
class App23:
"""支出トラッカー（グラフ付き）"""
DB_PATH = os.path.join(os.path.dirname(__file__), "expenses.db")
CATEGORIES = ["食費", "交通費", "娯楽", "衣類", "医療", "光熱費",
"通信費", "教育", "住居", "その他"]
def __init__(self, root):
self.root = root
self.root.title("支出トラッカー（グラフ付き）")
self.root.geometry("960x640")
self.root.configure(bg="#f8f9fc")
self._init_db()
self._build_ui()
self._load_expenses()
self._update_charts()
if not MATPLOTLIB_AVAILABLE:
messagebox.showwarning(
"ライブラリ未インストール",
"matplotlib が必要です。\n"
"pip install matplotlib でインストールしてください。")
def _init_db(self):
self.conn = sqlite3.connect(self.DB_PATH)
self.conn.execute("""
CREATE TABLE IF NOT EXISTS expenses (
id INTEGER PRIMARY KEY AUTOINCREMENT,
date TEXT NOT NULL,
amount REAL NOT NULL,
category TEXT,
description TEXT,
type TEXT DEFAULT 'expense'
)
""")
self.conn.commit()
if not self.conn.execute("SELECT 1 FROM expenses").fetchone():
import random
today = date.today()
for i in range(30):
d = date(today.year, today.month, min(i+1, 28))
self.conn.execute(
"INSERT INTO expenses (date,amount,category,description,type) "
"VALUES (?,?,?,?,?)",
(str(d),
random.randint(100, 8000),
self.CATEGORIES[i % len(self.CATEGORIES)],
"サンプルデータ", "expense"))
self.conn.commit()
def _build_ui(self):
title_frame = tk.Frame(self.root, bg="#4caf50", pady=10)
title_frame.pack(fill=tk.X)
tk.Label(title_frame, text="💹 支出トラッカー",
font=("Noto Sans JP", 15, "bold"),
bg="#4caf50", fg="white").pack(side=tk.LEFT, padx=12)
# フィルター
filter_f = tk.Frame(self.root, bg="#e8f5e9", pady=6)
filter_f.pack(fill=tk.X)
tk.Label(filter_f, text="年:", bg="#e8f5e9").pack(side=tk.LEFT, padx=8)
self.year_var = tk.IntVar(value=date.today().year)
ttk.Spinbox(filter_f, from_=2000, to=2100,
textvariable=self.year_var, width=6,
command=lambda: (self._load_expenses(), self._update_charts())
).pack(side=tk.LEFT, padx=4)
tk.Label(filter_f, text="月:", bg="#e8f5e9").pack(side=tk.LEFT, padx=(8, 4))
self.month_var = tk.IntVar(value=date.today().month)
ttk.Spinbox(filter_f, from_=1, to=12,
textvariable=self.month_var, width=4,
command=lambda: (self._load_expenses(), self._update_charts())
).pack(side=tk.LEFT, padx=4)
tk.Label(filter_f, text="カテゴリ:", bg="#e8f5e9").pack(side=tk.LEFT, padx=(12, 4))
self.cat_var = tk.StringVar(value="すべて")
cat_cb = ttk.Combobox(filter_f, textvariable=self.cat_var,
values=["すべて"] + self.CATEGORIES,
state="readonly", width=10)
cat_cb.pack(side=tk.LEFT)
cat_cb.bind("<<ComboboxSelected>>",
lambda e: (self._load_expenses(), self._update_charts()))
# サマリーカード
summary_f = tk.Frame(self.root, bg="#f8f9fc")
summary_f.pack(fill=tk.X, padx=8, pady=4)
self.summary_labels = {}
for key, color in [("支出合計", "#e53935"), ("収入合計", "#43a047"),
("残高", "#1976d2"), ("件数", "#fb8c00")]:
c = tk.Frame(summary_f, bg=color, padx=10, pady=6)
c.pack(side=tk.LEFT, fill=tk.X, expand=True, padx=4)
tk.Label(c, text=key, bg=color, fg="white",
font=("Arial", 9)).pack()
lbl = tk.Label(c, text="¥0", bg=color, fg="white",
font=("Arial", 14, "bold"))
lbl.pack()
self.summary_labels[key] = lbl
paned = ttk.PanedWindow(self.root, orient=tk.HORIZONTAL)
paned.pack(fill=tk.BOTH, expand=True, padx=4, pady=4)
# 左: データ入力 + 一覧
left = tk.Frame(paned, bg="#f8f9fc")
# 入力フォーム
input_f = ttk.LabelFrame(left, text="支出入力", padding=8)
input_f.pack(fill=tk.X, pady=(0, 6))
form_inner = tk.Frame(input_f, bg=input_f.cget("background"))
form_inner.pack(fill=tk.X)
labels = [("日付", "date", str(date.today())),
("金額", "amount", ""),
("カテゴリ", None, ""),
("説明", "desc", "")]
for i, (lbl, attr, default) in enumerate(labels):
tk.Label(form_inner, text=f"{lbl}:",
bg=form_inner.cget("bg")).grid(row=i, column=0, sticky="w", pady=2)
if lbl == "カテゴリ":
self.new_cat_var = tk.StringVar(value=self.CATEGORIES[0])
ttk.Combobox(form_inner, textvariable=self.new_cat_var,
values=self.CATEGORIES, state="readonly",
width=12).grid(row=i, column=1, padx=6, sticky="w")
else:
var = tk.StringVar(value=default)
ttk.Entry(form_inner, textvariable=var, width=16).grid(
row=i, column=1, padx=6, sticky="w")
setattr(self, f"{attr}_var", var)
self.type_var = tk.StringVar(value="expense")
type_f = tk.Frame(input_f, bg=input_f.cget("background"))
type_f.pack(fill=tk.X, pady=2)
for val, lbl in [("expense", "支出"), ("income", "収入")]:
ttk.Radiobutton(type_f, text=lbl, variable=self.type_var,
value=val).pack(side=tk.LEFT, padx=8)
btn_f = tk.Frame(input_f, bg=input_f.cget("background"))
btn_f.pack(fill=tk.X)
ttk.Button(btn_f, text="➕ 追加", command=self._add_expense).pack(side=tk.LEFT, padx=4)
ttk.Button(btn_f, text="🗑️ 削除", command=self._delete_expense).pack(side=tk.LEFT, padx=4)
# 一覧
list_f = ttk.LabelFrame(left, text="一覧", padding=4)
list_f.pack(fill=tk.BOTH, expand=True)
cols = ("date", "amount", "category", "description", "type")
self.tree = ttk.Treeview(list_f, columns=cols, show="headings", height=12)
for c, h, w in [("date", "日付", 90), ("amount", "金額", 80),
("category", "カテゴリ", 80), ("description", "説明", 120),
("type", "種別", 50)]:
self.tree.heading(c, text=h)
self.tree.column(c, width=w, minwidth=40)
sb = ttk.Scrollbar(list_f, command=self.tree.yview)
self.tree.configure(yscrollcommand=sb.set)
sb.pack(side=tk.RIGHT, fill=tk.Y)
self.tree.pack(fill=tk.BOTH, expand=True)
self.tree.tag_configure("income", foreground="#43a047")
self.tree.tag_configure("expense", foreground="#e53935")
paned.add(left, weight=2)
# 右: グラフ
right = tk.Frame(paned, bg="#f8f9fc")
if MATPLOTLIB_AVAILABLE:
self.fig = Figure(figsize=(6, 7), dpi=90, facecolor="#f8f9fc")
self.ax_pie = self.fig.add_subplot(211)
self.ax_bar = self.fig.add_subplot(212)
self.fig.subplots_adjust(hspace=0.4)
self.chart_canvas = FigureCanvasTkAgg(self.fig, master=right)
self.chart_canvas.get_tk_widget().pack(fill=tk.BOTH, expand=True)
paned.add(right, weight=3)
self.status_var = tk.StringVar(value="")
tk.Label(self.root, textvariable=self.status_var,
bg="#dde", font=("Arial", 9), anchor="w", padx=8
).pack(fill=tk.X, side=tk.BOTTOM)
def _load_expenses(self):
year = self.year_var.get()
month = self.month_var.get()
cat = self.cat_var.get()
prefix = f"{year}-{month:02d}"
sql = ("SELECT id,date,amount,category,description,type "
"FROM expenses WHERE date LIKE ?")
params = [f"{prefix}%"]
if cat != "すべて":
sql += " AND category=?"
params.append(cat)
sql += " ORDER BY date DESC"
rows = self.conn.execute(sql, params).fetchall()
self.tree.delete(*self.tree.get_children())
total_exp = total_inc = 0
for row in rows:
rid, d, amt, c, desc, t = row
tag = "income" if t == "income" else "expense"
self.tree.insert("", "end", iid=str(rid),
values=(d, f"¥{amt:,.0f}", c, desc or "", t),
tags=(tag,))
if t == "income":
total_inc += amt
else:
total_exp += amt
self.summary_labels["支出合計"].config(text=f"¥{total_exp:,.0f}")
self.summary_labels["収入合計"].config(text=f"¥{total_inc:,.0f}")
self.summary_labels["残高"].config(text=f"¥{total_inc-total_exp:,.0f}")
self.summary_labels["件数"].config(text=f"{len(rows)} 件")
self.status_var.set(f"{prefix} {len(rows)} 件")
def _update_charts(self):
if not MATPLOTLIB_AVAILABLE:
return
year = self.year_var.get()
month = self.month_var.get()
prefix = f"{year}-{month:02d}"
rows = self.conn.execute(
"SELECT category, SUM(amount) FROM expenses "
"WHERE date LIKE ? AND type='expense' GROUP BY category",
(f"{prefix}%",)).fetchall()
# 円グラフ
self.ax_pie.clear()
if rows:
labels = [r[0] for r in rows]
sizes = [r[1] for r in rows]
self.ax_pie.pie(sizes, labels=labels, autopct="%1.1f%%",
startangle=90)
self.ax_pie.set_title(f"{year}年{month}月 カテゴリ別支出",
fontsize=10)
# 棒グラフ（月次推移）
self.ax_bar.clear()
monthly = []
for m in range(1, 13):
p = f"{year}-{m:02d}"
total = self.conn.execute(
"SELECT COALESCE(SUM(amount),0) FROM expenses "
"WHERE date LIKE ? AND type='expense'",
(f"{p}%",)).fetchone()[0]
monthly.append(total)
months = list(range(1, 13))
bars = self.ax_bar.bar(months, monthly, color="#4caf50", alpha=0.8)
self.ax_bar.set_xticks(months)
self.ax_bar.set_xticklabels([f"{m}月" for m in months], fontsize=7)
self.ax_bar.set_title(f"{year}年 月次支出推移", fontsize=10)
self.fig.tight_layout()
self.chart_canvas.draw()
def _add_expense(self):
try:
amt = float(self.amount_var.get().replace(",", ""))
except ValueError:
messagebox.showerror("エラー", "金額を正しく入力してください")
return
self.conn.execute(
"INSERT INTO expenses (date,amount,category,description,type) "
"VALUES (?,?,?,?,?)",
(self.date_var.get(), amt, self.new_cat_var.get(),
self.desc_var.get(), self.type_var.get()))
self.conn.commit()
self._load_expenses()
self._update_charts()
self.amount_var.set("")
self.desc_var.set("")
def _delete_expense(self):
sel = self.tree.selection()
if not sel:
return
if messagebox.askyesno("確認", "削除しますか?"):
for item in sel:
self.conn.execute("DELETE FROM expenses WHERE id=?", (int(item),))
self.conn.commit()
self._load_expenses()
self._update_charts()
if __name__ == "__main__":
root = tk.Tk()
app = App23(root)
root.mainloop()
6. ステップバイステップガイド
このアプリをゼロから自分で作る手順を解説します。コードをコピーするだけでなく、実際に手順を追って自分で書いてみましょう。
-
1ファイルを作成する
新しいファイルを作成して app23.py と保存します。
-
2クラスの骨格を作る
App23クラスを定義し、__init__とmainloop()の最小構成を作ります。
-
3タイトルバーを作る
Frameを使ってカラーバー付きのタイトルエリアを作ります。
-
4入力フォームを実装する
LabelFrameとEntryウィジェットで入力エリアを作ります。
-
5処理ロジックを実装する
_calculate()メソッドに計算・処理ロジックを実装します。
-
6結果表示を実装する
TextウィジェットかLabelに結果を表示する_show_result()を実装します。
-
7エラー処理を追加する
try-exceptとmessageboxでエラーハンドリングを追加します。
7. カスタマイズアイデア
基本機能を習得したら、以下のカスタマイズに挑戦してみましょう。少しずつ機能を追加することで、Pythonのスキルが飛躍的に向上します。
💡 ダークモードを追加する
bg色・fg色を辞書で管理し、ボタン1つでダークモード・ライトモードを切り替えられるようにしましょう。
💡 データのエクスポート機能
計算結果をCSV・TXTファイルに保存するエクスポート機能を追加しましょう。filedialog.asksaveasfilename()でファイル保存ダイアログが使えます。
💡 入力履歴機能
以前の入力値を覚えておいてComboboxのドロップダウンで再選択できる履歴機能を追加しましょう。
8. よくある問題と解決法
❌ 日本語フォントが表示されない
原因：システムに日本語フォントが見つからない場合があります。
解決法：font引数を省略するかシステムに合ったフォントを指定してください。
❌ ウィンドウのサイズが変更できない
原因：resizable(False, False)が設定されています。
解決法：resizable(True, True)に変更してください。
9. 練習問題
アプリの理解を深めるための練習問題です。難易度順に挑戦してみてください。
-
課題1：機能拡張
支出トラッカー（グラフ付き）に新しい機能を1つ追加してみましょう。どんな機能があると便利か考えてから実装してください。
-
課題2：UIの改善
色・フォント・レイアウトを変更して、より使いやすいUIにカスタマイズしてみましょう。
-
課題3：保存機能の追加
入力値や計算結果をファイルに保存する機能を追加しましょう。jsonやcsvモジュールを使います。