中級者向け No.078
CSVグラフダッシュボード
CSVをpandasで集計しmatplotlibで棒・折れ線・円・散布図を動的に切り替えて表示するツール。
📋 目次
1. アプリ概要
CSVをpandasで集計しmatplotlibで棒・折れ線・円・散布図を動的に切り替えて表示するツール。
このアプリはdataカテゴリの実践的なPythonアプリです。使用ライブラリは tkinter（標準ライブラリ）・pandas・matplotlib、難易度は ★★★ です。
Pythonの豊富なライブラリを活用することで、実用的なアプリを短いコードで実装できます。ソースコードをコピーして実行し、仕組みを理解したうえでカスタマイズに挑戦してみてください。
GUIアプリ開発はプログラミングの楽しさを実感できる最も効果的な学習方法のひとつです。変数・関数・クラス・イベント処理などの重要な概念が自然と身につきます。
2. 機能一覧
- CSVグラフダッシュボードのメイン機能
- 直感的なGUIインターフェース
- 入力値のバリデーション
- エラーハンドリング
- 結果の見やすい表示
- クリア機能付き
3. 事前準備・環境
動作確認環境
Python 3.10 以上 / Windows・Mac・Linux すべて対応
以下の環境で動作確認しています。
- Python 3.10 以上
- OS: Windows 10/11・macOS 12+・Ubuntu 20.04+
インストールが必要なライブラリ
pip install matplotlib pandas4. 完全なソースコード
コードのコピー方法
右上の「コピー」ボタンをクリックするとコードをクリップボードにコピーできます。
app078.py
import tkinter as tk
from tkinter import ttk, messagebox, filedialog
import csv
import threading
try:
import matplotlib
matplotlib.use("TkAgg")
from matplotlib.figure import Figure
from matplotlib.backends.backend_tkagg import FigureCanvasTkAgg, NavigationToolbar2Tk
MATPLOTLIB_AVAILABLE = True
except ImportError:
MATPLOTLIB_AVAILABLE = False
class App078:
"""CSVグラフダッシュボード"""
CHART_TYPES = ["折れ線", "棒グラフ", "散布図", "面グラフ", "円グラフ", "ヒストグラム"]
COLORS = ["#4fc3f7", "#ef5350", "#26a69a", "#ffa726", "#ab47bc",
"#66bb6a", "#ec407a", "#29b6f6", "#ffca28", "#8d6e63"]
def __init__(self, root):
self.root = root
self.root.title("CSVグラフダッシュボード")
self.root.geometry("1050x660")
self.root.configure(bg="#1e1e1e")
self._headers = []
self._rows = []
self._build_ui()
def _build_ui(self):
header = tk.Frame(self.root, bg="#252526", pady=6)
header.pack(fill=tk.X)
tk.Label(header, text="📊 CSVグラフダッシュボード",
font=("Noto Sans JP", 12, "bold"),
bg="#252526", fg="#4fc3f7").pack(side=tk.LEFT, padx=12)
if not MATPLOTLIB_AVAILABLE:
tk.Label(self.root,
text="⚠ matplotlib が未インストールです (pip install matplotlib)",
bg="#fff3cd", fg="#856404", font=("Arial", 9),
anchor="w", padx=8).pack(fill=tk.X)
# ツールバー
tb = tk.Frame(self.root, bg="#2d2d2d", pady=4)
tb.pack(fill=tk.X)
ttk.Button(tb, text="📂 CSV読み込み",
command=self._open_csv).pack(side=tk.LEFT, padx=4)
ttk.Button(tb, text="▶ グラフ描画",
command=self._draw).pack(side=tk.LEFT, padx=4)
ttk.Button(tb, text="💾 グラフ保存",
command=self._save_chart).pack(side=tk.LEFT, padx=4)
# メインエリア
paned = ttk.PanedWindow(self.root, orient=tk.HORIZONTAL)
paned.pack(fill=tk.BOTH, expand=True, padx=4, pady=4)
# 左パネル: データ設定
left = tk.Frame(paned, bg="#1e1e1e", width=280)
paned.add(left, weight=0)
# グラフ設定
cfg = tk.LabelFrame(left, text="グラフ設定", bg="#252526",
fg="#ccc", font=("Arial", 9), padx=6, pady=6)
cfg.pack(fill=tk.X, padx=4, pady=4)
tk.Label(cfg, text="グラフ種別:", bg="#252526", fg="#ccc",
font=("Arial", 9)).grid(row=0, column=0, sticky="w")
self.chart_type_var = tk.StringVar(value="折れ線")
ttk.Combobox(cfg, textvariable=self.chart_type_var,
values=self.CHART_TYPES, state="readonly",
width=12).grid(row=0, column=1, padx=4, pady=2)
tk.Label(cfg, text="X軸 (列):", bg="#252526", fg="#ccc",
font=("Arial", 9)).grid(row=1, column=0, sticky="w")
self.xcol_var = tk.StringVar()
self.xcol_cb = ttk.Combobox(cfg, textvariable=self.xcol_var,
state="readonly", width=12)
self.xcol_cb.grid(row=1, column=1, padx=4, pady=2)
tk.Label(cfg, text="Y軸 (列):", bg="#252526", fg="#ccc",
font=("Arial", 9)).grid(row=2, column=0, sticky="w")
self.ycol_var = tk.StringVar()
self.ycol_cb = ttk.Combobox(cfg, textvariable=self.ycol_var,
state="readonly", width=12)
self.ycol_cb.grid(row=2, column=1, padx=4, pady=2)
tk.Label(cfg, text="タイトル:", bg="#252526", fg="#ccc",
font=("Arial", 9)).grid(row=3, column=0, sticky="w")
self.title_var = tk.StringVar(value="CSVデータグラフ")
ttk.Entry(cfg, textvariable=self.title_var,
width=14).grid(row=3, column=1, padx=4, pady=2)
self.grid_var = tk.BooleanVar(value=True)
tk.Checkbutton(cfg, text="グリッド表示", variable=self.grid_var,
bg="#252526", fg="#ccc", selectcolor="#3c3c3c",
activebackground="#252526").grid(
row=4, column=0, columnspan=2, sticky="w")
self.legend_var = tk.BooleanVar(value=True)
tk.Checkbutton(cfg, text="凡例表示", variable=self.legend_var,
bg="#252526", fg="#ccc", selectcolor="#3c3c3c",
activebackground="#252526").grid(
row=5, column=0, columnspan=2, sticky="w")
# 複数Y列選択
tk.Label(left, text="Y軸 複数選択 (Ctrl+クリック):",
bg="#1e1e1e", fg="#888", font=("Arial", 8)).pack(
anchor="w", padx=4, pady=(8, 0))
self.ycols_listbox = tk.Listbox(left, selectmode=tk.MULTIPLE,
bg="#0d1117", fg="#c9d1d9",
font=("Arial", 9), height=6,
relief=tk.FLAT,
selectbackground="#1f6feb")
self.ycols_listbox.pack(fill=tk.X, padx=4)
# データプレビュー
tk.Label(left, text="データプレビュー", bg="#1e1e1e", fg="#888",
font=("Arial", 8)).pack(anchor="w", padx=4, pady=(8, 0))
preview_cols = ("col", "type", "sample")
self.preview_tree = ttk.Treeview(left, columns=preview_cols,
show="headings", height=6)
self.preview_tree.heading("col", text="列名")
self.preview_tree.heading("type", text="型")
self.preview_tree.heading("sample", text="サンプル")
self.preview_tree.column("col", width=80)
self.preview_tree.column("type", width=50)
self.preview_tree.column("sample", width=100)
self.preview_tree.pack(fill=tk.X, padx=4)
# 右パネル: グラフ
right = tk.Frame(paned, bg="#0d1117")
paned.add(right, weight=1)
if MATPLOTLIB_AVAILABLE:
self.fig = Figure(facecolor="#0d1117")
self.ax = self.fig.add_subplot(111)
self.mpl_canvas = FigureCanvasTkAgg(self.fig, master=right)
toolbar = NavigationToolbar2Tk(self.mpl_canvas, right)
toolbar.update()
toolbar.pack(side=tk.TOP, fill=tk.X)
self.mpl_canvas.get_tk_widget().pack(fill=tk.BOTH, expand=True)
else:
tk.Label(right, text="matplotlib が必要です",
bg="#0d1117", fg="#555").pack(expand=True)
self.status_var = tk.StringVar(value="CSVファイルを読み込んでください")
tk.Label(self.root, textvariable=self.status_var,
bg="#252526", fg="#858585", font=("Arial", 9),
anchor="w", padx=8).pack(fill=tk.X, side=tk.BOTTOM)
def _open_csv(self):
path = filedialog.askopenfilename(
filetypes=[("CSV", "*.csv"), ("TSV", "*.tsv"), ("すべて", "*.*")])
if not path:
return
try:
enc = "utf-8-sig"
with open(path, encoding=enc, errors="replace", newline="") as f:
reader = csv.reader(f)
rows = list(reader)
if not rows:
messagebox.showwarning("警告", "空のファイルです")
return
self._headers = rows[0]
self._rows = rows[1:]
self._update_columns()
self.status_var.set(
f"読み込み: {path} ({len(self._rows)} 行 × {len(self._headers)} 列)")
except Exception as e:
messagebox.showerror("エラー", str(e))
def _update_columns(self):
headers = self._headers
self.xcol_cb["values"] = headers
self.ycol_cb["values"] = headers
if headers:
self.xcol_var.set(headers[0])
self.ycol_var.set(headers[-1] if len(headers) > 1 else headers[0])
self.ycols_listbox.delete(0, tk.END)
for h in headers:
self.ycols_listbox.insert(tk.END, h)
# プレビュー
self.preview_tree.delete(*self.preview_tree.get_children())
for i, h in enumerate(headers):
col_vals = [r[i] for r in self._rows if i < len(r)]
sample = col_vals[0] if col_vals else ""
try:
float(sample)
dtype = "数値"
except ValueError:
dtype = "文字"
self.preview_tree.insert("", tk.END,
values=(h, dtype, sample[:20]))
def _get_col_values(self, col_name):
"""列名から数値リストを返す (変換できない場合はインデックス)"""
if col_name not in self._headers:
return []
idx = self._headers.index(col_name)
raw = [r[idx] if idx < len(r) else "" for r in self._rows]
try:
return [float(v.replace(",", "")) for v in raw]
except (ValueError, AttributeError):
return raw # 文字列のまま返す
def _draw(self):
if not MATPLOTLIB_AVAILABLE:
messagebox.showerror("エラー", "pip install matplotlib")
return
if not self._rows:
messagebox.showwarning("警告", "先にCSVを読み込んでください")
return
threading.Thread(target=self._do_draw, daemon=True).start()
def _do_draw(self):
self.root.after(0, self._render_chart)
def _render_chart(self):
chart_type = self.chart_type_var.get()
x_col = self.xcol_var.get()
x_vals = self._get_col_values(x_col)
# 複数Y列を取得 (リストボックス選択 or 単一)
sel = self.ycols_listbox.curselection()
if sel:
y_cols = [self._headers[i] for i in sel if i < len(self._headers)]
else:
y_cols = [self.ycol_var.get()]
self.ax.clear()
self.ax.set_facecolor("#0d1117")
if chart_type == "円グラフ":
y_vals = self._get_col_values(y_cols[0])
try:
vals = [float(v) for v in y_vals]
labels = [str(v) for v in x_vals]
self.ax.pie(vals, labels=labels[:len(vals)],
colors=self.COLORS,
autopct="%1.1f%%", startangle=90,
textprops={"color": "#c9d1d9", "fontsize": 7})
except Exception as e:
self.status_var.set(f"描画エラー: {e}")
elif chart_type == "ヒストグラム":
y_vals = self._get_col_values(y_cols[0])
try:
vals = [float(v) for v in y_vals]
self.ax.hist(vals, bins=20, color=self.COLORS[0], edgecolor="#0d1117")
except Exception as e:
self.status_var.set(f"描画エラー: {e}")
else:
for i, y_col in enumerate(y_cols):
y_vals = self._get_col_values(y_col)
color = self.COLORS[i % len(self.COLORS)]
try:
xn = [float(v) for v in x_vals]
except (ValueError, TypeError):
xn = list(range(len(x_vals)))
try:
yn = [float(v) for v in y_vals]
except (ValueError, TypeError):
continue
n = min(len(xn), len(yn))
xn, yn = xn[:n], yn[:n]
if chart_type == "折れ線":
self.ax.plot(xn, yn, color=color, label=y_col, linewidth=1.5)
elif chart_type == "棒グラフ":
self.ax.bar([x + i*0.15 for x in xn], yn,
width=0.15, color=color, label=y_col)
elif chart_type == "散布図":
self.ax.scatter(xn, yn, color=color, label=y_col, s=20)
elif chart_type == "面グラフ":
self.ax.fill_between(xn, yn, alpha=0.4, color=color, label=y_col)
self.ax.plot(xn, yn, color=color, linewidth=1)
# スタイリング
self.ax.set_title(self.title_var.get(), color="#c9d1d9", fontsize=11)
self.ax.set_xlabel(x_col, color="#8b949e", fontsize=9)
self.ax.tick_params(colors="#8b949e", labelsize=7)
for spine in self.ax.spines.values():
spine.set_edgecolor("#30363d")
if self.grid_var.get():
self.ax.grid(True, color="#21262d", linewidth=0.5)
if self.legend_var.get() and chart_type not in ("円グラフ", "ヒストグラム"):
self.ax.legend(facecolor="#161b22", edgecolor="#30363d",
labelcolor="#c9d1d9", fontsize=8)
self.fig.tight_layout()
self.mpl_canvas.draw()
self.status_var.set(f"描画完了: {chart_type} X={x_col} Y={', '.join(y_cols)}")
def _save_chart(self):
if not MATPLOTLIB_AVAILABLE:
return
path = filedialog.asksaveasfilename(
initialfile="chart.png",
defaultextension=".png",
filetypes=[("PNG", "*.png"), ("SVG", "*.svg"), ("PDF", "*.pdf")])
if not path:
return
try:
self.fig.savefig(path, facecolor="#0d1117", dpi=150)
self.status_var.set(f"保存完了: {path}")
except Exception as e:
messagebox.showerror("エラー", str(e))
if __name__ == "__main__":
root = tk.Tk()
app = App078(root)
root.mainloop()
5. コード解説
CSVグラフダッシュボードのコードを詳しく解説します。クラスベースの設計で各機能を整理して実装しています。
クラス設計とコンストラクタ
App078クラスにアプリの全機能をまとめています。__init__でウィンドウ設定、_build_ui()でUI構築、process()でメイン処理を担当します。責任の分離により、コードが読みやすくなります。
import tkinter as tk
from tkinter import ttk, messagebox, filedialog
import csv
import threading
try:
import matplotlib
matplotlib.use("TkAgg")
from matplotlib.figure import Figure
from matplotlib.backends.backend_tkagg import FigureCanvasTkAgg, NavigationToolbar2Tk
MATPLOTLIB_AVAILABLE = True
except ImportError:
MATPLOTLIB_AVAILABLE = False
class App078:
"""CSVグラフダッシュボード"""
CHART_TYPES = ["折れ線", "棒グラフ", "散布図", "面グラフ", "円グラフ", "ヒストグラム"]
COLORS = ["#4fc3f7", "#ef5350", "#26a69a", "#ffa726", "#ab47bc",
"#66bb6a", "#ec407a", "#29b6f6", "#ffca28", "#8d6e63"]
def __init__(self, root):
self.root = root
self.root.title("CSVグラフダッシュボード")
self.root.geometry("1050x660")
self.root.configure(bg="#1e1e1e")
self._headers = []
self._rows = []
self._build_ui()
def _build_ui(self):
header = tk.Frame(self.root, bg="#252526", pady=6)
header.pack(fill=tk.X)
tk.Label(header, text="📊 CSVグラフダッシュボード",
font=("Noto Sans JP", 12, "bold"),
bg="#252526", fg="#4fc3f7").pack(side=tk.LEFT, padx=12)
if not MATPLOTLIB_AVAILABLE:
tk.Label(self.root,
text="⚠ matplotlib が未インストールです (pip install matplotlib)",
bg="#fff3cd", fg="#856404", font=("Arial", 9),
anchor="w", padx=8).pack(fill=tk.X)
# ツールバー
tb = tk.Frame(self.root, bg="#2d2d2d", pady=4)
tb.pack(fill=tk.X)
ttk.Button(tb, text="📂 CSV読み込み",
command=self._open_csv).pack(side=tk.LEFT, padx=4)
ttk.Button(tb, text="▶ グラフ描画",
command=self._draw).pack(side=tk.LEFT, padx=4)
ttk.Button(tb, text="💾 グラフ保存",
command=self._save_chart).pack(side=tk.LEFT, padx=4)
# メインエリア
paned = ttk.PanedWindow(self.root, orient=tk.HORIZONTAL)
paned.pack(fill=tk.BOTH, expand=True, padx=4, pady=4)
# 左パネル: データ設定
left = tk.Frame(paned, bg="#1e1e1e", width=280)
paned.add(left, weight=0)
# グラフ設定
cfg = tk.LabelFrame(left, text="グラフ設定", bg="#252526",
fg="#ccc", font=("Arial", 9), padx=6, pady=6)
cfg.pack(fill=tk.X, padx=4, pady=4)
tk.Label(cfg, text="グラフ種別:", bg="#252526", fg="#ccc",
font=("Arial", 9)).grid(row=0, column=0, sticky="w")
self.chart_type_var = tk.StringVar(value="折れ線")
ttk.Combobox(cfg, textvariable=self.chart_type_var,
values=self.CHART_TYPES, state="readonly",
width=12).grid(row=0, column=1, padx=4, pady=2)
tk.Label(cfg, text="X軸 (列):", bg="#252526", fg="#ccc",
font=("Arial", 9)).grid(row=1, column=0, sticky="w")
self.xcol_var = tk.StringVar()
self.xcol_cb = ttk.Combobox(cfg, textvariable=self.xcol_var,
state="readonly", width=12)
self.xcol_cb.grid(row=1, column=1, padx=4, pady=2)
tk.Label(cfg, text="Y軸 (列):", bg="#252526", fg="#ccc",
font=("Arial", 9)).grid(row=2, column=0, sticky="w")
self.ycol_var = tk.StringVar()
self.ycol_cb = ttk.Combobox(cfg, textvariable=self.ycol_var,
state="readonly", width=12)
self.ycol_cb.grid(row=2, column=1, padx=4, pady=2)
tk.Label(cfg, text="タイトル:", bg="#252526", fg="#ccc",
font=("Arial", 9)).grid(row=3, column=0, sticky="w")
self.title_var = tk.StringVar(value="CSVデータグラフ")
ttk.Entry(cfg, textvariable=self.title_var,
width=14).grid(row=3, column=1, padx=4, pady=2)
self.grid_var = tk.BooleanVar(value=True)
tk.Checkbutton(cfg, text="グリッド表示", variable=self.grid_var,
bg="#252526", fg="#ccc", selectcolor="#3c3c3c",
activebackground="#252526").grid(
row=4, column=0, columnspan=2, sticky="w")
self.legend_var = tk.BooleanVar(value=True)
tk.Checkbutton(cfg, text="凡例表示", variable=self.legend_var,
bg="#252526", fg="#ccc", selectcolor="#3c3c3c",
activebackground="#252526").grid(
row=5, column=0, columnspan=2, sticky="w")
# 複数Y列選択
tk.Label(left, text="Y軸 複数選択 (Ctrl+クリック):",
bg="#1e1e1e", fg="#888", font=("Arial", 8)).pack(
anchor="w", padx=4, pady=(8, 0))
self.ycols_listbox = tk.Listbox(left, selectmode=tk.MULTIPLE,
bg="#0d1117", fg="#c9d1d9",
font=("Arial", 9), height=6,
relief=tk.FLAT,
selectbackground="#1f6feb")
self.ycols_listbox.pack(fill=tk.X, padx=4)
# データプレビュー
tk.Label(left, text="データプレビュー", bg="#1e1e1e", fg="#888",
font=("Arial", 8)).pack(anchor="w", padx=4, pady=(8, 0))
preview_cols = ("col", "type", "sample")
self.preview_tree = ttk.Treeview(left, columns=preview_cols,
show="headings", height=6)
self.preview_tree.heading("col", text="列名")
self.preview_tree.heading("type", text="型")
self.preview_tree.heading("sample", text="サンプル")
self.preview_tree.column("col", width=80)
self.preview_tree.column("type", width=50)
self.preview_tree.column("sample", width=100)
self.preview_tree.pack(fill=tk.X, padx=4)
# 右パネル: グラフ
right = tk.Frame(paned, bg="#0d1117")
paned.add(right, weight=1)
if MATPLOTLIB_AVAILABLE:
self.fig = Figure(facecolor="#0d1117")
self.ax = self.fig.add_subplot(111)
self.mpl_canvas = FigureCanvasTkAgg(self.fig, master=right)
toolbar = NavigationToolbar2Tk(self.mpl_canvas, right)
toolbar.update()
toolbar.pack(side=tk.TOP, fill=tk.X)
self.mpl_canvas.get_tk_widget().pack(fill=tk.BOTH, expand=True)
else:
tk.Label(right, text="matplotlib が必要です",
bg="#0d1117", fg="#555").pack(expand=True)
self.status_var = tk.StringVar(value="CSVファイルを読み込んでください")
tk.Label(self.root, textvariable=self.status_var,
bg="#252526", fg="#858585", font=("Arial", 9),
anchor="w", padx=8).pack(fill=tk.X, side=tk.BOTTOM)
def _open_csv(self):
path = filedialog.askopenfilename(
filetypes=[("CSV", "*.csv"), ("TSV", "*.tsv"), ("すべて", "*.*")])
if not path:
return
try:
enc = "utf-8-sig"
with open(path, encoding=enc, errors="replace", newline="") as f:
reader = csv.reader(f)
rows = list(reader)
if not rows:
messagebox.showwarning("警告", "空のファイルです")
return
self._headers = rows[0]
self._rows = rows[1:]
self._update_columns()
self.status_var.set(
f"読み込み: {path} ({len(self._rows)} 行 × {len(self._headers)} 列)")
except Exception as e:
messagebox.showerror("エラー", str(e))
def _update_columns(self):
headers = self._headers
self.xcol_cb["values"] = headers
self.ycol_cb["values"] = headers
if headers:
self.xcol_var.set(headers[0])
self.ycol_var.set(headers[-1] if len(headers) > 1 else headers[0])
self.ycols_listbox.delete(0, tk.END)
for h in headers:
self.ycols_listbox.insert(tk.END, h)
# プレビュー
self.preview_tree.delete(*self.preview_tree.get_children())
for i, h in enumerate(headers):
col_vals = [r[i] for r in self._rows if i < len(r)]
sample = col_vals[0] if col_vals else ""
try:
float(sample)
dtype = "数値"
except ValueError:
dtype = "文字"
self.preview_tree.insert("", tk.END,
values=(h, dtype, sample[:20]))
def _get_col_values(self, col_name):
"""列名から数値リストを返す (変換できない場合はインデックス)"""
if col_name not in self._headers:
return []
idx = self._headers.index(col_name)
raw = [r[idx] if idx < len(r) else "" for r in self._rows]
try:
return [float(v.replace(",", "")) for v in raw]
except (ValueError, AttributeError):
return raw # 文字列のまま返す
def _draw(self):
if not MATPLOTLIB_AVAILABLE:
messagebox.showerror("エラー", "pip install matplotlib")
return
if not self._rows:
messagebox.showwarning("警告", "先にCSVを読み込んでください")
return
threading.Thread(target=self._do_draw, daemon=True).start()
def _do_draw(self):
self.root.after(0, self._render_chart)
def _render_chart(self):
chart_type = self.chart_type_var.get()
x_col = self.xcol_var.get()
x_vals = self._get_col_values(x_col)
# 複数Y列を取得 (リストボックス選択 or 単一)
sel = self.ycols_listbox.curselection()
if sel:
y_cols = [self._headers[i] for i in sel if i < len(self._headers)]
else:
y_cols = [self.ycol_var.get()]
self.ax.clear()
self.ax.set_facecolor("#0d1117")
if chart_type == "円グラフ":
y_vals = self._get_col_values(y_cols[0])
try:
vals = [float(v) for v in y_vals]
labels = [str(v) for v in x_vals]
self.ax.pie(vals, labels=labels[:len(vals)],
colors=self.COLORS,
autopct="%1.1f%%", startangle=90,
textprops={"color": "#c9d1d9", "fontsize": 7})
except Exception as e:
self.status_var.set(f"描画エラー: {e}")
elif chart_type == "ヒストグラム":
y_vals = self._get_col_values(y_cols[0])
try:
vals = [float(v) for v in y_vals]
self.ax.hist(vals, bins=20, color=self.COLORS[0], edgecolor="#0d1117")
except Exception as e:
self.status_var.set(f"描画エラー: {e}")
else:
for i, y_col in enumerate(y_cols):
y_vals = self._get_col_values(y_col)
color = self.COLORS[i % len(self.COLORS)]
try:
xn = [float(v) for v in x_vals]
except (ValueError, TypeError):
xn = list(range(len(x_vals)))
try:
yn = [float(v) for v in y_vals]
except (ValueError, TypeError):
continue
n = min(len(xn), len(yn))
xn, yn = xn[:n], yn[:n]
if chart_type == "折れ線":
self.ax.plot(xn, yn, color=color, label=y_col, linewidth=1.5)
elif chart_type == "棒グラフ":
self.ax.bar([x + i*0.15 for x in xn], yn,
width=0.15, color=color, label=y_col)
elif chart_type == "散布図":
self.ax.scatter(xn, yn, color=color, label=y_col, s=20)
elif chart_type == "面グラフ":
self.ax.fill_between(xn, yn, alpha=0.4, color=color, label=y_col)
self.ax.plot(xn, yn, color=color, linewidth=1)
# スタイリング
self.ax.set_title(self.title_var.get(), color="#c9d1d9", fontsize=11)
self.ax.set_xlabel(x_col, color="#8b949e", fontsize=9)
self.ax.tick_params(colors="#8b949e", labelsize=7)
for spine in self.ax.spines.values():
spine.set_edgecolor("#30363d")
if self.grid_var.get():
self.ax.grid(True, color="#21262d", linewidth=0.5)
if self.legend_var.get() and chart_type not in ("円グラフ", "ヒストグラム"):
self.ax.legend(facecolor="#161b22", edgecolor="#30363d",
labelcolor="#c9d1d9", fontsize=8)
self.fig.tight_layout()
self.mpl_canvas.draw()
self.status_var.set(f"描画完了: {chart_type} X={x_col} Y={', '.join(y_cols)}")
def _save_chart(self):
if not MATPLOTLIB_AVAILABLE:
return
path = filedialog.asksaveasfilename(
initialfile="chart.png",
defaultextension=".png",
filetypes=[("PNG", "*.png"), ("SVG", "*.svg"), ("PDF", "*.pdf")])
if not path:
return
try:
self.fig.savefig(path, facecolor="#0d1117", dpi=150)
self.status_var.set(f"保存完了: {path}")
except Exception as e:
messagebox.showerror("エラー", str(e))
if __name__ == "__main__":
root = tk.Tk()
app = App078(root)
root.mainloop()
UIレイアウトの構築
LabelFrameで入力エリアと結果エリアを視覚的に分けています。pack()で縦に並べ、expand=Trueで結果エリアが画面いっぱいに広がるよう設定しています。
import tkinter as tk
from tkinter import ttk, messagebox, filedialog
import csv
import threading
try:
import matplotlib
matplotlib.use("TkAgg")
from matplotlib.figure import Figure
from matplotlib.backends.backend_tkagg import FigureCanvasTkAgg, NavigationToolbar2Tk
MATPLOTLIB_AVAILABLE = True
except ImportError:
MATPLOTLIB_AVAILABLE = False
class App078:
"""CSVグラフダッシュボード"""
CHART_TYPES = ["折れ線", "棒グラフ", "散布図", "面グラフ", "円グラフ", "ヒストグラム"]
COLORS = ["#4fc3f7", "#ef5350", "#26a69a", "#ffa726", "#ab47bc",
"#66bb6a", "#ec407a", "#29b6f6", "#ffca28", "#8d6e63"]
def __init__(self, root):
self.root = root
self.root.title("CSVグラフダッシュボード")
self.root.geometry("1050x660")
self.root.configure(bg="#1e1e1e")
self._headers = []
self._rows = []
self._build_ui()
def _build_ui(self):
header = tk.Frame(self.root, bg="#252526", pady=6)
header.pack(fill=tk.X)
tk.Label(header, text="📊 CSVグラフダッシュボード",
font=("Noto Sans JP", 12, "bold"),
bg="#252526", fg="#4fc3f7").pack(side=tk.LEFT, padx=12)
if not MATPLOTLIB_AVAILABLE:
tk.Label(self.root,
text="⚠ matplotlib が未インストールです (pip install matplotlib)",
bg="#fff3cd", fg="#856404", font=("Arial", 9),
anchor="w", padx=8).pack(fill=tk.X)
# ツールバー
tb = tk.Frame(self.root, bg="#2d2d2d", pady=4)
tb.pack(fill=tk.X)
ttk.Button(tb, text="📂 CSV読み込み",
command=self._open_csv).pack(side=tk.LEFT, padx=4)
ttk.Button(tb, text="▶ グラフ描画",
command=self._draw).pack(side=tk.LEFT, padx=4)
ttk.Button(tb, text="💾 グラフ保存",
command=self._save_chart).pack(side=tk.LEFT, padx=4)
# メインエリア
paned = ttk.PanedWindow(self.root, orient=tk.HORIZONTAL)
paned.pack(fill=tk.BOTH, expand=True, padx=4, pady=4)
# 左パネル: データ設定
left = tk.Frame(paned, bg="#1e1e1e", width=280)
paned.add(left, weight=0)
# グラフ設定
cfg = tk.LabelFrame(left, text="グラフ設定", bg="#252526",
fg="#ccc", font=("Arial", 9), padx=6, pady=6)
cfg.pack(fill=tk.X, padx=4, pady=4)
tk.Label(cfg, text="グラフ種別:", bg="#252526", fg="#ccc",
font=("Arial", 9)).grid(row=0, column=0, sticky="w")
self.chart_type_var = tk.StringVar(value="折れ線")
ttk.Combobox(cfg, textvariable=self.chart_type_var,
values=self.CHART_TYPES, state="readonly",
width=12).grid(row=0, column=1, padx=4, pady=2)
tk.Label(cfg, text="X軸 (列):", bg="#252526", fg="#ccc",
font=("Arial", 9)).grid(row=1, column=0, sticky="w")
self.xcol_var = tk.StringVar()
self.xcol_cb = ttk.Combobox(cfg, textvariable=self.xcol_var,
state="readonly", width=12)
self.xcol_cb.grid(row=1, column=1, padx=4, pady=2)
tk.Label(cfg, text="Y軸 (列):", bg="#252526", fg="#ccc",
font=("Arial", 9)).grid(row=2, column=0, sticky="w")
self.ycol_var = tk.StringVar()
self.ycol_cb = ttk.Combobox(cfg, textvariable=self.ycol_var,
state="readonly", width=12)
self.ycol_cb.grid(row=2, column=1, padx=4, pady=2)
tk.Label(cfg, text="タイトル:", bg="#252526", fg="#ccc",
font=("Arial", 9)).grid(row=3, column=0, sticky="w")
self.title_var = tk.StringVar(value="CSVデータグラフ")
ttk.Entry(cfg, textvariable=self.title_var,
width=14).grid(row=3, column=1, padx=4, pady=2)
self.grid_var = tk.BooleanVar(value=True)
tk.Checkbutton(cfg, text="グリッド表示", variable=self.grid_var,
bg="#252526", fg="#ccc", selectcolor="#3c3c3c",
activebackground="#252526").grid(
row=4, column=0, columnspan=2, sticky="w")
self.legend_var = tk.BooleanVar(value=True)
tk.Checkbutton(cfg, text="凡例表示", variable=self.legend_var,
bg="#252526", fg="#ccc", selectcolor="#3c3c3c",
activebackground="#252526").grid(
row=5, column=0, columnspan=2, sticky="w")
# 複数Y列選択
tk.Label(left, text="Y軸 複数選択 (Ctrl+クリック):",
bg="#1e1e1e", fg="#888", font=("Arial", 8)).pack(
anchor="w", padx=4, pady=(8, 0))
self.ycols_listbox = tk.Listbox(left, selectmode=tk.MULTIPLE,
bg="#0d1117", fg="#c9d1d9",
font=("Arial", 9), height=6,
relief=tk.FLAT,
selectbackground="#1f6feb")
self.ycols_listbox.pack(fill=tk.X, padx=4)
# データプレビュー
tk.Label(left, text="データプレビュー", bg="#1e1e1e", fg="#888",
font=("Arial", 8)).pack(anchor="w", padx=4, pady=(8, 0))
preview_cols = ("col", "type", "sample")
self.preview_tree = ttk.Treeview(left, columns=preview_cols,
show="headings", height=6)
self.preview_tree.heading("col", text="列名")
self.preview_tree.heading("type", text="型")
self.preview_tree.heading("sample", text="サンプル")
self.preview_tree.column("col", width=80)
self.preview_tree.column("type", width=50)
self.preview_tree.column("sample", width=100)
self.preview_tree.pack(fill=tk.X, padx=4)
# 右パネル: グラフ
right = tk.Frame(paned, bg="#0d1117")
paned.add(right, weight=1)
if MATPLOTLIB_AVAILABLE:
self.fig = Figure(facecolor="#0d1117")
self.ax = self.fig.add_subplot(111)
self.mpl_canvas = FigureCanvasTkAgg(self.fig, master=right)
toolbar = NavigationToolbar2Tk(self.mpl_canvas, right)
toolbar.update()
toolbar.pack(side=tk.TOP, fill=tk.X)
self.mpl_canvas.get_tk_widget().pack(fill=tk.BOTH, expand=True)
else:
tk.Label(right, text="matplotlib が必要です",
bg="#0d1117", fg="#555").pack(expand=True)
self.status_var = tk.StringVar(value="CSVファイルを読み込んでください")
tk.Label(self.root, textvariable=self.status_var,
bg="#252526", fg="#858585", font=("Arial", 9),
anchor="w", padx=8).pack(fill=tk.X, side=tk.BOTTOM)
def _open_csv(self):
path = filedialog.askopenfilename(
filetypes=[("CSV", "*.csv"), ("TSV", "*.tsv"), ("すべて", "*.*")])
if not path:
return
try:
enc = "utf-8-sig"
with open(path, encoding=enc, errors="replace", newline="") as f:
reader = csv.reader(f)
rows = list(reader)
if not rows:
messagebox.showwarning("警告", "空のファイルです")
return
self._headers = rows[0]
self._rows = rows[1:]
self._update_columns()
self.status_var.set(
f"読み込み: {path} ({len(self._rows)} 行 × {len(self._headers)} 列)")
except Exception as e:
messagebox.showerror("エラー", str(e))
def _update_columns(self):
headers = self._headers
self.xcol_cb["values"] = headers
self.ycol_cb["values"] = headers
if headers:
self.xcol_var.set(headers[0])
self.ycol_var.set(headers[-1] if len(headers) > 1 else headers[0])
self.ycols_listbox.delete(0, tk.END)
for h in headers:
self.ycols_listbox.insert(tk.END, h)
# プレビュー
self.preview_tree.delete(*self.preview_tree.get_children())
for i, h in enumerate(headers):
col_vals = [r[i] for r in self._rows if i < len(r)]
sample = col_vals[0] if col_vals else ""
try:
float(sample)
dtype = "数値"
except ValueError:
dtype = "文字"
self.preview_tree.insert("", tk.END,
values=(h, dtype, sample[:20]))
def _get_col_values(self, col_name):
"""列名から数値リストを返す (変換できない場合はインデックス)"""
if col_name not in self._headers:
return []
idx = self._headers.index(col_name)
raw = [r[idx] if idx < len(r) else "" for r in self._rows]
try:
return [float(v.replace(",", "")) for v in raw]
except (ValueError, AttributeError):
return raw # 文字列のまま返す
def _draw(self):
if not MATPLOTLIB_AVAILABLE:
messagebox.showerror("エラー", "pip install matplotlib")
return
if not self._rows:
messagebox.showwarning("警告", "先にCSVを読み込んでください")
return
threading.Thread(target=self._do_draw, daemon=True).start()
def _do_draw(self):
self.root.after(0, self._render_chart)
def _render_chart(self):
chart_type = self.chart_type_var.get()
x_col = self.xcol_var.get()
x_vals = self._get_col_values(x_col)
# 複数Y列を取得 (リストボックス選択 or 単一)
sel = self.ycols_listbox.curselection()
if sel:
y_cols = [self._headers[i] for i in sel if i < len(self._headers)]
else:
y_cols = [self.ycol_var.get()]
self.ax.clear()
self.ax.set_facecolor("#0d1117")
if chart_type == "円グラフ":
y_vals = self._get_col_values(y_cols[0])
try:
vals = [float(v) for v in y_vals]
labels = [str(v) for v in x_vals]
self.ax.pie(vals, labels=labels[:len(vals)],
colors=self.COLORS,
autopct="%1.1f%%", startangle=90,
textprops={"color": "#c9d1d9", "fontsize": 7})
except Exception as e:
self.status_var.set(f"描画エラー: {e}")
elif chart_type == "ヒストグラム":
y_vals = self._get_col_values(y_cols[0])
try:
vals = [float(v) for v in y_vals]
self.ax.hist(vals, bins=20, color=self.COLORS[0], edgecolor="#0d1117")
except Exception as e:
self.status_var.set(f"描画エラー: {e}")
else:
for i, y_col in enumerate(y_cols):
y_vals = self._get_col_values(y_col)
color = self.COLORS[i % len(self.COLORS)]
try:
xn = [float(v) for v in x_vals]
except (ValueError, TypeError):
xn = list(range(len(x_vals)))
try:
yn = [float(v) for v in y_vals]
except (ValueError, TypeError):
continue
n = min(len(xn), len(yn))
xn, yn = xn[:n], yn[:n]
if chart_type == "折れ線":
self.ax.plot(xn, yn, color=color, label=y_col, linewidth=1.5)
elif chart_type == "棒グラフ":
self.ax.bar([x + i*0.15 for x in xn], yn,
width=0.15, color=color, label=y_col)
elif chart_type == "散布図":
self.ax.scatter(xn, yn, color=color, label=y_col, s=20)
elif chart_type == "面グラフ":
self.ax.fill_between(xn, yn, alpha=0.4, color=color, label=y_col)
self.ax.plot(xn, yn, color=color, linewidth=1)
# スタイリング
self.ax.set_title(self.title_var.get(), color="#c9d1d9", fontsize=11)
self.ax.set_xlabel(x_col, color="#8b949e", fontsize=9)
self.ax.tick_params(colors="#8b949e", labelsize=7)
for spine in self.ax.spines.values():
spine.set_edgecolor("#30363d")
if self.grid_var.get():
self.ax.grid(True, color="#21262d", linewidth=0.5)
if self.legend_var.get() and chart_type not in ("円グラフ", "ヒストグラム"):
self.ax.legend(facecolor="#161b22", edgecolor="#30363d",
labelcolor="#c9d1d9", fontsize=8)
self.fig.tight_layout()
self.mpl_canvas.draw()
self.status_var.set(f"描画完了: {chart_type} X={x_col} Y={', '.join(y_cols)}")
def _save_chart(self):
if not MATPLOTLIB_AVAILABLE:
return
path = filedialog.asksaveasfilename(
initialfile="chart.png",
defaultextension=".png",
filetypes=[("PNG", "*.png"), ("SVG", "*.svg"), ("PDF", "*.pdf")])
if not path:
return
try:
self.fig.savefig(path, facecolor="#0d1117", dpi=150)
self.status_var.set(f"保存完了: {path}")
except Exception as e:
messagebox.showerror("エラー", str(e))
if __name__ == "__main__":
root = tk.Tk()
app = App078(root)
root.mainloop()
イベント処理
ボタンのcommand引数でクリックイベントを、bind('
import tkinter as tk
from tkinter import ttk, messagebox, filedialog
import csv
import threading
try:
import matplotlib
matplotlib.use("TkAgg")
from matplotlib.figure import Figure
from matplotlib.backends.backend_tkagg import FigureCanvasTkAgg, NavigationToolbar2Tk
MATPLOTLIB_AVAILABLE = True
except ImportError:
MATPLOTLIB_AVAILABLE = False
class App078:
"""CSVグラフダッシュボード"""
CHART_TYPES = ["折れ線", "棒グラフ", "散布図", "面グラフ", "円グラフ", "ヒストグラム"]
COLORS = ["#4fc3f7", "#ef5350", "#26a69a", "#ffa726", "#ab47bc",
"#66bb6a", "#ec407a", "#29b6f6", "#ffca28", "#8d6e63"]
def __init__(self, root):
self.root = root
self.root.title("CSVグラフダッシュボード")
self.root.geometry("1050x660")
self.root.configure(bg="#1e1e1e")
self._headers = []
self._rows = []
self._build_ui()
def _build_ui(self):
header = tk.Frame(self.root, bg="#252526", pady=6)
header.pack(fill=tk.X)
tk.Label(header, text="📊 CSVグラフダッシュボード",
font=("Noto Sans JP", 12, "bold"),
bg="#252526", fg="#4fc3f7").pack(side=tk.LEFT, padx=12)
if not MATPLOTLIB_AVAILABLE:
tk.Label(self.root,
text="⚠ matplotlib が未インストールです (pip install matplotlib)",
bg="#fff3cd", fg="#856404", font=("Arial", 9),
anchor="w", padx=8).pack(fill=tk.X)
# ツールバー
tb = tk.Frame(self.root, bg="#2d2d2d", pady=4)
tb.pack(fill=tk.X)
ttk.Button(tb, text="📂 CSV読み込み",
command=self._open_csv).pack(side=tk.LEFT, padx=4)
ttk.Button(tb, text="▶ グラフ描画",
command=self._draw).pack(side=tk.LEFT, padx=4)
ttk.Button(tb, text="💾 グラフ保存",
command=self._save_chart).pack(side=tk.LEFT, padx=4)
# メインエリア
paned = ttk.PanedWindow(self.root, orient=tk.HORIZONTAL)
paned.pack(fill=tk.BOTH, expand=True, padx=4, pady=4)
# 左パネル: データ設定
left = tk.Frame(paned, bg="#1e1e1e", width=280)
paned.add(left, weight=0)
# グラフ設定
cfg = tk.LabelFrame(left, text="グラフ設定", bg="#252526",
fg="#ccc", font=("Arial", 9), padx=6, pady=6)
cfg.pack(fill=tk.X, padx=4, pady=4)
tk.Label(cfg, text="グラフ種別:", bg="#252526", fg="#ccc",
font=("Arial", 9)).grid(row=0, column=0, sticky="w")
self.chart_type_var = tk.StringVar(value="折れ線")
ttk.Combobox(cfg, textvariable=self.chart_type_var,
values=self.CHART_TYPES, state="readonly",
width=12).grid(row=0, column=1, padx=4, pady=2)
tk.Label(cfg, text="X軸 (列):", bg="#252526", fg="#ccc",
font=("Arial", 9)).grid(row=1, column=0, sticky="w")
self.xcol_var = tk.StringVar()
self.xcol_cb = ttk.Combobox(cfg, textvariable=self.xcol_var,
state="readonly", width=12)
self.xcol_cb.grid(row=1, column=1, padx=4, pady=2)
tk.Label(cfg, text="Y軸 (列):", bg="#252526", fg="#ccc",
font=("Arial", 9)).grid(row=2, column=0, sticky="w")
self.ycol_var = tk.StringVar()
self.ycol_cb = ttk.Combobox(cfg, textvariable=self.ycol_var,
state="readonly", width=12)
self.ycol_cb.grid(row=2, column=1, padx=4, pady=2)
tk.Label(cfg, text="タイトル:", bg="#252526", fg="#ccc",
font=("Arial", 9)).grid(row=3, column=0, sticky="w")
self.title_var = tk.StringVar(value="CSVデータグラフ")
ttk.Entry(cfg, textvariable=self.title_var,
width=14).grid(row=3, column=1, padx=4, pady=2)
self.grid_var = tk.BooleanVar(value=True)
tk.Checkbutton(cfg, text="グリッド表示", variable=self.grid_var,
bg="#252526", fg="#ccc", selectcolor="#3c3c3c",
activebackground="#252526").grid(
row=4, column=0, columnspan=2, sticky="w")
self.legend_var = tk.BooleanVar(value=True)
tk.Checkbutton(cfg, text="凡例表示", variable=self.legend_var,
bg="#252526", fg="#ccc", selectcolor="#3c3c3c",
activebackground="#252526").grid(
row=5, column=0, columnspan=2, sticky="w")
# 複数Y列選択
tk.Label(left, text="Y軸 複数選択 (Ctrl+クリック):",
bg="#1e1e1e", fg="#888", font=("Arial", 8)).pack(
anchor="w", padx=4, pady=(8, 0))
self.ycols_listbox = tk.Listbox(left, selectmode=tk.MULTIPLE,
bg="#0d1117", fg="#c9d1d9",
font=("Arial", 9), height=6,
relief=tk.FLAT,
selectbackground="#1f6feb")
self.ycols_listbox.pack(fill=tk.X, padx=4)
# データプレビュー
tk.Label(left, text="データプレビュー", bg="#1e1e1e", fg="#888",
font=("Arial", 8)).pack(anchor="w", padx=4, pady=(8, 0))
preview_cols = ("col", "type", "sample")
self.preview_tree = ttk.Treeview(left, columns=preview_cols,
show="headings", height=6)
self.preview_tree.heading("col", text="列名")
self.preview_tree.heading("type", text="型")
self.preview_tree.heading("sample", text="サンプル")
self.preview_tree.column("col", width=80)
self.preview_tree.column("type", width=50)
self.preview_tree.column("sample", width=100)
self.preview_tree.pack(fill=tk.X, padx=4)
# 右パネル: グラフ
right = tk.Frame(paned, bg="#0d1117")
paned.add(right, weight=1)
if MATPLOTLIB_AVAILABLE:
self.fig = Figure(facecolor="#0d1117")
self.ax = self.fig.add_subplot(111)
self.mpl_canvas = FigureCanvasTkAgg(self.fig, master=right)
toolbar = NavigationToolbar2Tk(self.mpl_canvas, right)
toolbar.update()
toolbar.pack(side=tk.TOP, fill=tk.X)
self.mpl_canvas.get_tk_widget().pack(fill=tk.BOTH, expand=True)
else:
tk.Label(right, text="matplotlib が必要です",
bg="#0d1117", fg="#555").pack(expand=True)
self.status_var = tk.StringVar(value="CSVファイルを読み込んでください")
tk.Label(self.root, textvariable=self.status_var,
bg="#252526", fg="#858585", font=("Arial", 9),
anchor="w", padx=8).pack(fill=tk.X, side=tk.BOTTOM)
def _open_csv(self):
path = filedialog.askopenfilename(
filetypes=[("CSV", "*.csv"), ("TSV", "*.tsv"), ("すべて", "*.*")])
if not path:
return
try:
enc = "utf-8-sig"
with open(path, encoding=enc, errors="replace", newline="") as f:
reader = csv.reader(f)
rows = list(reader)
if not rows:
messagebox.showwarning("警告", "空のファイルです")
return
self._headers = rows[0]
self._rows = rows[1:]
self._update_columns()
self.status_var.set(
f"読み込み: {path} ({len(self._rows)} 行 × {len(self._headers)} 列)")
except Exception as e:
messagebox.showerror("エラー", str(e))
def _update_columns(self):
headers = self._headers
self.xcol_cb["values"] = headers
self.ycol_cb["values"] = headers
if headers:
self.xcol_var.set(headers[0])
self.ycol_var.set(headers[-1] if len(headers) > 1 else headers[0])
self.ycols_listbox.delete(0, tk.END)
for h in headers:
self.ycols_listbox.insert(tk.END, h)
# プレビュー
self.preview_tree.delete(*self.preview_tree.get_children())
for i, h in enumerate(headers):
col_vals = [r[i] for r in self._rows if i < len(r)]
sample = col_vals[0] if col_vals else ""
try:
float(sample)
dtype = "数値"
except ValueError:
dtype = "文字"
self.preview_tree.insert("", tk.END,
values=(h, dtype, sample[:20]))
def _get_col_values(self, col_name):
"""列名から数値リストを返す (変換できない場合はインデックス)"""
if col_name not in self._headers:
return []
idx = self._headers.index(col_name)
raw = [r[idx] if idx < len(r) else "" for r in self._rows]
try:
return [float(v.replace(",", "")) for v in raw]
except (ValueError, AttributeError):
return raw # 文字列のまま返す
def _draw(self):
if not MATPLOTLIB_AVAILABLE:
messagebox.showerror("エラー", "pip install matplotlib")
return
if not self._rows:
messagebox.showwarning("警告", "先にCSVを読み込んでください")
return
threading.Thread(target=self._do_draw, daemon=True).start()
def _do_draw(self):
self.root.after(0, self._render_chart)
def _render_chart(self):
chart_type = self.chart_type_var.get()
x_col = self.xcol_var.get()
x_vals = self._get_col_values(x_col)
# 複数Y列を取得 (リストボックス選択 or 単一)
sel = self.ycols_listbox.curselection()
if sel:
y_cols = [self._headers[i] for i in sel if i < len(self._headers)]
else:
y_cols = [self.ycol_var.get()]
self.ax.clear()
self.ax.set_facecolor("#0d1117")
if chart_type == "円グラフ":
y_vals = self._get_col_values(y_cols[0])
try:
vals = [float(v) for v in y_vals]
labels = [str(v) for v in x_vals]
self.ax.pie(vals, labels=labels[:len(vals)],
colors=self.COLORS,
autopct="%1.1f%%", startangle=90,
textprops={"color": "#c9d1d9", "fontsize": 7})
except Exception as e:
self.status_var.set(f"描画エラー: {e}")
elif chart_type == "ヒストグラム":
y_vals = self._get_col_values(y_cols[0])
try:
vals = [float(v) for v in y_vals]
self.ax.hist(vals, bins=20, color=self.COLORS[0], edgecolor="#0d1117")
except Exception as e:
self.status_var.set(f"描画エラー: {e}")
else:
for i, y_col in enumerate(y_cols):
y_vals = self._get_col_values(y_col)
color = self.COLORS[i % len(self.COLORS)]
try:
xn = [float(v) for v in x_vals]
except (ValueError, TypeError):
xn = list(range(len(x_vals)))
try:
yn = [float(v) for v in y_vals]
except (ValueError, TypeError):
continue
n = min(len(xn), len(yn))
xn, yn = xn[:n], yn[:n]
if chart_type == "折れ線":
self.ax.plot(xn, yn, color=color, label=y_col, linewidth=1.5)
elif chart_type == "棒グラフ":
self.ax.bar([x + i*0.15 for x in xn], yn,
width=0.15, color=color, label=y_col)
elif chart_type == "散布図":
self.ax.scatter(xn, yn, color=color, label=y_col, s=20)
elif chart_type == "面グラフ":
self.ax.fill_between(xn, yn, alpha=0.4, color=color, label=y_col)
self.ax.plot(xn, yn, color=color, linewidth=1)
# スタイリング
self.ax.set_title(self.title_var.get(), color="#c9d1d9", fontsize=11)
self.ax.set_xlabel(x_col, color="#8b949e", fontsize=9)
self.ax.tick_params(colors="#8b949e", labelsize=7)
for spine in self.ax.spines.values():
spine.set_edgecolor("#30363d")
if self.grid_var.get():
self.ax.grid(True, color="#21262d", linewidth=0.5)
if self.legend_var.get() and chart_type not in ("円グラフ", "ヒストグラム"):
self.ax.legend(facecolor="#161b22", edgecolor="#30363d",
labelcolor="#c9d1d9", fontsize=8)
self.fig.tight_layout()
self.mpl_canvas.draw()
self.status_var.set(f"描画完了: {chart_type} X={x_col} Y={', '.join(y_cols)}")
def _save_chart(self):
if not MATPLOTLIB_AVAILABLE:
return
path = filedialog.asksaveasfilename(
initialfile="chart.png",
defaultextension=".png",
filetypes=[("PNG", "*.png"), ("SVG", "*.svg"), ("PDF", "*.pdf")])
if not path:
return
try:
self.fig.savefig(path, facecolor="#0d1117", dpi=150)
self.status_var.set(f"保存完了: {path}")
except Exception as e:
messagebox.showerror("エラー", str(e))
if __name__ == "__main__":
root = tk.Tk()
app = App078(root)
root.mainloop()
Textウィジェットでの結果表示
tk.Textウィジェットをstate=DISABLED（読み取り専用）で作成し、更新時はNORMALに変更してinsert()で内容を書き込み、再びDISABLEDに戻します。
import tkinter as tk
from tkinter import ttk, messagebox, filedialog
import csv
import threading
try:
import matplotlib
matplotlib.use("TkAgg")
from matplotlib.figure import Figure
from matplotlib.backends.backend_tkagg import FigureCanvasTkAgg, NavigationToolbar2Tk
MATPLOTLIB_AVAILABLE = True
except ImportError:
MATPLOTLIB_AVAILABLE = False
class App078:
"""CSVグラフダッシュボード"""
CHART_TYPES = ["折れ線", "棒グラフ", "散布図", "面グラフ", "円グラフ", "ヒストグラム"]
COLORS = ["#4fc3f7", "#ef5350", "#26a69a", "#ffa726", "#ab47bc",
"#66bb6a", "#ec407a", "#29b6f6", "#ffca28", "#8d6e63"]
def __init__(self, root):
self.root = root
self.root.title("CSVグラフダッシュボード")
self.root.geometry("1050x660")
self.root.configure(bg="#1e1e1e")
self._headers = []
self._rows = []
self._build_ui()
def _build_ui(self):
header = tk.Frame(self.root, bg="#252526", pady=6)
header.pack(fill=tk.X)
tk.Label(header, text="📊 CSVグラフダッシュボード",
font=("Noto Sans JP", 12, "bold"),
bg="#252526", fg="#4fc3f7").pack(side=tk.LEFT, padx=12)
if not MATPLOTLIB_AVAILABLE:
tk.Label(self.root,
text="⚠ matplotlib が未インストールです (pip install matplotlib)",
bg="#fff3cd", fg="#856404", font=("Arial", 9),
anchor="w", padx=8).pack(fill=tk.X)
# ツールバー
tb = tk.Frame(self.root, bg="#2d2d2d", pady=4)
tb.pack(fill=tk.X)
ttk.Button(tb, text="📂 CSV読み込み",
command=self._open_csv).pack(side=tk.LEFT, padx=4)
ttk.Button(tb, text="▶ グラフ描画",
command=self._draw).pack(side=tk.LEFT, padx=4)
ttk.Button(tb, text="💾 グラフ保存",
command=self._save_chart).pack(side=tk.LEFT, padx=4)
# メインエリア
paned = ttk.PanedWindow(self.root, orient=tk.HORIZONTAL)
paned.pack(fill=tk.BOTH, expand=True, padx=4, pady=4)
# 左パネル: データ設定
left = tk.Frame(paned, bg="#1e1e1e", width=280)
paned.add(left, weight=0)
# グラフ設定
cfg = tk.LabelFrame(left, text="グラフ設定", bg="#252526",
fg="#ccc", font=("Arial", 9), padx=6, pady=6)
cfg.pack(fill=tk.X, padx=4, pady=4)
tk.Label(cfg, text="グラフ種別:", bg="#252526", fg="#ccc",
font=("Arial", 9)).grid(row=0, column=0, sticky="w")
self.chart_type_var = tk.StringVar(value="折れ線")
ttk.Combobox(cfg, textvariable=self.chart_type_var,
values=self.CHART_TYPES, state="readonly",
width=12).grid(row=0, column=1, padx=4, pady=2)
tk.Label(cfg, text="X軸 (列):", bg="#252526", fg="#ccc",
font=("Arial", 9)).grid(row=1, column=0, sticky="w")
self.xcol_var = tk.StringVar()
self.xcol_cb = ttk.Combobox(cfg, textvariable=self.xcol_var,
state="readonly", width=12)
self.xcol_cb.grid(row=1, column=1, padx=4, pady=2)
tk.Label(cfg, text="Y軸 (列):", bg="#252526", fg="#ccc",
font=("Arial", 9)).grid(row=2, column=0, sticky="w")
self.ycol_var = tk.StringVar()
self.ycol_cb = ttk.Combobox(cfg, textvariable=self.ycol_var,
state="readonly", width=12)
self.ycol_cb.grid(row=2, column=1, padx=4, pady=2)
tk.Label(cfg, text="タイトル:", bg="#252526", fg="#ccc",
font=("Arial", 9)).grid(row=3, column=0, sticky="w")
self.title_var = tk.StringVar(value="CSVデータグラフ")
ttk.Entry(cfg, textvariable=self.title_var,
width=14).grid(row=3, column=1, padx=4, pady=2)
self.grid_var = tk.BooleanVar(value=True)
tk.Checkbutton(cfg, text="グリッド表示", variable=self.grid_var,
bg="#252526", fg="#ccc", selectcolor="#3c3c3c",
activebackground="#252526").grid(
row=4, column=0, columnspan=2, sticky="w")
self.legend_var = tk.BooleanVar(value=True)
tk.Checkbutton(cfg, text="凡例表示", variable=self.legend_var,
bg="#252526", fg="#ccc", selectcolor="#3c3c3c",
activebackground="#252526").grid(
row=5, column=0, columnspan=2, sticky="w")
# 複数Y列選択
tk.Label(left, text="Y軸 複数選択 (Ctrl+クリック):",
bg="#1e1e1e", fg="#888", font=("Arial", 8)).pack(
anchor="w", padx=4, pady=(8, 0))
self.ycols_listbox = tk.Listbox(left, selectmode=tk.MULTIPLE,
bg="#0d1117", fg="#c9d1d9",
font=("Arial", 9), height=6,
relief=tk.FLAT,
selectbackground="#1f6feb")
self.ycols_listbox.pack(fill=tk.X, padx=4)
# データプレビュー
tk.Label(left, text="データプレビュー", bg="#1e1e1e", fg="#888",
font=("Arial", 8)).pack(anchor="w", padx=4, pady=(8, 0))
preview_cols = ("col", "type", "sample")
self.preview_tree = ttk.Treeview(left, columns=preview_cols,
show="headings", height=6)
self.preview_tree.heading("col", text="列名")
self.preview_tree.heading("type", text="型")
self.preview_tree.heading("sample", text="サンプル")
self.preview_tree.column("col", width=80)
self.preview_tree.column("type", width=50)
self.preview_tree.column("sample", width=100)
self.preview_tree.pack(fill=tk.X, padx=4)
# 右パネル: グラフ
right = tk.Frame(paned, bg="#0d1117")
paned.add(right, weight=1)
if MATPLOTLIB_AVAILABLE:
self.fig = Figure(facecolor="#0d1117")
self.ax = self.fig.add_subplot(111)
self.mpl_canvas = FigureCanvasTkAgg(self.fig, master=right)
toolbar = NavigationToolbar2Tk(self.mpl_canvas, right)
toolbar.update()
toolbar.pack(side=tk.TOP, fill=tk.X)
self.mpl_canvas.get_tk_widget().pack(fill=tk.BOTH, expand=True)
else:
tk.Label(right, text="matplotlib が必要です",
bg="#0d1117", fg="#555").pack(expand=True)
self.status_var = tk.StringVar(value="CSVファイルを読み込んでください")
tk.Label(self.root, textvariable=self.status_var,
bg="#252526", fg="#858585", font=("Arial", 9),
anchor="w", padx=8).pack(fill=tk.X, side=tk.BOTTOM)
def _open_csv(self):
path = filedialog.askopenfilename(
filetypes=[("CSV", "*.csv"), ("TSV", "*.tsv"), ("すべて", "*.*")])
if not path:
return
try:
enc = "utf-8-sig"
with open(path, encoding=enc, errors="replace", newline="") as f:
reader = csv.reader(f)
rows = list(reader)
if not rows:
messagebox.showwarning("警告", "空のファイルです")
return
self._headers = rows[0]
self._rows = rows[1:]
self._update_columns()
self.status_var.set(
f"読み込み: {path} ({len(self._rows)} 行 × {len(self._headers)} 列)")
except Exception as e:
messagebox.showerror("エラー", str(e))
def _update_columns(self):
headers = self._headers
self.xcol_cb["values"] = headers
self.ycol_cb["values"] = headers
if headers:
self.xcol_var.set(headers[0])
self.ycol_var.set(headers[-1] if len(headers) > 1 else headers[0])
self.ycols_listbox.delete(0, tk.END)
for h in headers:
self.ycols_listbox.insert(tk.END, h)
# プレビュー
self.preview_tree.delete(*self.preview_tree.get_children())
for i, h in enumerate(headers):
col_vals = [r[i] for r in self._rows if i < len(r)]
sample = col_vals[0] if col_vals else ""
try:
float(sample)
dtype = "数値"
except ValueError:
dtype = "文字"
self.preview_tree.insert("", tk.END,
values=(h, dtype, sample[:20]))
def _get_col_values(self, col_name):
"""列名から数値リストを返す (変換できない場合はインデックス)"""
if col_name not in self._headers:
return []
idx = self._headers.index(col_name)
raw = [r[idx] if idx < len(r) else "" for r in self._rows]
try:
return [float(v.replace(",", "")) for v in raw]
except (ValueError, AttributeError):
return raw # 文字列のまま返す
def _draw(self):
if not MATPLOTLIB_AVAILABLE:
messagebox.showerror("エラー", "pip install matplotlib")
return
if not self._rows:
messagebox.showwarning("警告", "先にCSVを読み込んでください")
return
threading.Thread(target=self._do_draw, daemon=True).start()
def _do_draw(self):
self.root.after(0, self._render_chart)
def _render_chart(self):
chart_type = self.chart_type_var.get()
x_col = self.xcol_var.get()
x_vals = self._get_col_values(x_col)
# 複数Y列を取得 (リストボックス選択 or 単一)
sel = self.ycols_listbox.curselection()
if sel:
y_cols = [self._headers[i] for i in sel if i < len(self._headers)]
else:
y_cols = [self.ycol_var.get()]
self.ax.clear()
self.ax.set_facecolor("#0d1117")
if chart_type == "円グラフ":
y_vals = self._get_col_values(y_cols[0])
try:
vals = [float(v) for v in y_vals]
labels = [str(v) for v in x_vals]
self.ax.pie(vals, labels=labels[:len(vals)],
colors=self.COLORS,
autopct="%1.1f%%", startangle=90,
textprops={"color": "#c9d1d9", "fontsize": 7})
except Exception as e:
self.status_var.set(f"描画エラー: {e}")
elif chart_type == "ヒストグラム":
y_vals = self._get_col_values(y_cols[0])
try:
vals = [float(v) for v in y_vals]
self.ax.hist(vals, bins=20, color=self.COLORS[0], edgecolor="#0d1117")
except Exception as e:
self.status_var.set(f"描画エラー: {e}")
else:
for i, y_col in enumerate(y_cols):
y_vals = self._get_col_values(y_col)
color = self.COLORS[i % len(self.COLORS)]
try:
xn = [float(v) for v in x_vals]
except (ValueError, TypeError):
xn = list(range(len(x_vals)))
try:
yn = [float(v) for v in y_vals]
except (ValueError, TypeError):
continue
n = min(len(xn), len(yn))
xn, yn = xn[:n], yn[:n]
if chart_type == "折れ線":
self.ax.plot(xn, yn, color=color, label=y_col, linewidth=1.5)
elif chart_type == "棒グラフ":
self.ax.bar([x + i*0.15 for x in xn], yn,
width=0.15, color=color, label=y_col)
elif chart_type == "散布図":
self.ax.scatter(xn, yn, color=color, label=y_col, s=20)
elif chart_type == "面グラフ":
self.ax.fill_between(xn, yn, alpha=0.4, color=color, label=y_col)
self.ax.plot(xn, yn, color=color, linewidth=1)
# スタイリング
self.ax.set_title(self.title_var.get(), color="#c9d1d9", fontsize=11)
self.ax.set_xlabel(x_col, color="#8b949e", fontsize=9)
self.ax.tick_params(colors="#8b949e", labelsize=7)
for spine in self.ax.spines.values():
spine.set_edgecolor("#30363d")
if self.grid_var.get():
self.ax.grid(True, color="#21262d", linewidth=0.5)
if self.legend_var.get() and chart_type not in ("円グラフ", "ヒストグラム"):
self.ax.legend(facecolor="#161b22", edgecolor="#30363d",
labelcolor="#c9d1d9", fontsize=8)
self.fig.tight_layout()
self.mpl_canvas.draw()
self.status_var.set(f"描画完了: {chart_type} X={x_col} Y={', '.join(y_cols)}")
def _save_chart(self):
if not MATPLOTLIB_AVAILABLE:
return
path = filedialog.asksaveasfilename(
initialfile="chart.png",
defaultextension=".png",
filetypes=[("PNG", "*.png"), ("SVG", "*.svg"), ("PDF", "*.pdf")])
if not path:
return
try:
self.fig.savefig(path, facecolor="#0d1117", dpi=150)
self.status_var.set(f"保存完了: {path}")
except Exception as e:
messagebox.showerror("エラー", str(e))
if __name__ == "__main__":
root = tk.Tk()
app = App078(root)
root.mainloop()
例外処理とエラーハンドリング
try-exceptでValueErrorとExceptionを捕捉し、messagebox.showerror()でエラーメッセージを表示します。予期しないエラーも処理することで、アプリの堅牢性が向上します。
import tkinter as tk
from tkinter import ttk, messagebox, filedialog
import csv
import threading
try:
import matplotlib
matplotlib.use("TkAgg")
from matplotlib.figure import Figure
from matplotlib.backends.backend_tkagg import FigureCanvasTkAgg, NavigationToolbar2Tk
MATPLOTLIB_AVAILABLE = True
except ImportError:
MATPLOTLIB_AVAILABLE = False
class App078:
"""CSVグラフダッシュボード"""
CHART_TYPES = ["折れ線", "棒グラフ", "散布図", "面グラフ", "円グラフ", "ヒストグラム"]
COLORS = ["#4fc3f7", "#ef5350", "#26a69a", "#ffa726", "#ab47bc",
"#66bb6a", "#ec407a", "#29b6f6", "#ffca28", "#8d6e63"]
def __init__(self, root):
self.root = root
self.root.title("CSVグラフダッシュボード")
self.root.geometry("1050x660")
self.root.configure(bg="#1e1e1e")
self._headers = []
self._rows = []
self._build_ui()
def _build_ui(self):
header = tk.Frame(self.root, bg="#252526", pady=6)
header.pack(fill=tk.X)
tk.Label(header, text="📊 CSVグラフダッシュボード",
font=("Noto Sans JP", 12, "bold"),
bg="#252526", fg="#4fc3f7").pack(side=tk.LEFT, padx=12)
if not MATPLOTLIB_AVAILABLE:
tk.Label(self.root,
text="⚠ matplotlib が未インストールです (pip install matplotlib)",
bg="#fff3cd", fg="#856404", font=("Arial", 9),
anchor="w", padx=8).pack(fill=tk.X)
# ツールバー
tb = tk.Frame(self.root, bg="#2d2d2d", pady=4)
tb.pack(fill=tk.X)
ttk.Button(tb, text="📂 CSV読み込み",
command=self._open_csv).pack(side=tk.LEFT, padx=4)
ttk.Button(tb, text="▶ グラフ描画",
command=self._draw).pack(side=tk.LEFT, padx=4)
ttk.Button(tb, text="💾 グラフ保存",
command=self._save_chart).pack(side=tk.LEFT, padx=4)
# メインエリア
paned = ttk.PanedWindow(self.root, orient=tk.HORIZONTAL)
paned.pack(fill=tk.BOTH, expand=True, padx=4, pady=4)
# 左パネル: データ設定
left = tk.Frame(paned, bg="#1e1e1e", width=280)
paned.add(left, weight=0)
# グラフ設定
cfg = tk.LabelFrame(left, text="グラフ設定", bg="#252526",
fg="#ccc", font=("Arial", 9), padx=6, pady=6)
cfg.pack(fill=tk.X, padx=4, pady=4)
tk.Label(cfg, text="グラフ種別:", bg="#252526", fg="#ccc",
font=("Arial", 9)).grid(row=0, column=0, sticky="w")
self.chart_type_var = tk.StringVar(value="折れ線")
ttk.Combobox(cfg, textvariable=self.chart_type_var,
values=self.CHART_TYPES, state="readonly",
width=12).grid(row=0, column=1, padx=4, pady=2)
tk.Label(cfg, text="X軸 (列):", bg="#252526", fg="#ccc",
font=("Arial", 9)).grid(row=1, column=0, sticky="w")
self.xcol_var = tk.StringVar()
self.xcol_cb = ttk.Combobox(cfg, textvariable=self.xcol_var,
state="readonly", width=12)
self.xcol_cb.grid(row=1, column=1, padx=4, pady=2)
tk.Label(cfg, text="Y軸 (列):", bg="#252526", fg="#ccc",
font=("Arial", 9)).grid(row=2, column=0, sticky="w")
self.ycol_var = tk.StringVar()
self.ycol_cb = ttk.Combobox(cfg, textvariable=self.ycol_var,
state="readonly", width=12)
self.ycol_cb.grid(row=2, column=1, padx=4, pady=2)
tk.Label(cfg, text="タイトル:", bg="#252526", fg="#ccc",
font=("Arial", 9)).grid(row=3, column=0, sticky="w")
self.title_var = tk.StringVar(value="CSVデータグラフ")
ttk.Entry(cfg, textvariable=self.title_var,
width=14).grid(row=3, column=1, padx=4, pady=2)
self.grid_var = tk.BooleanVar(value=True)
tk.Checkbutton(cfg, text="グリッド表示", variable=self.grid_var,
bg="#252526", fg="#ccc", selectcolor="#3c3c3c",
activebackground="#252526").grid(
row=4, column=0, columnspan=2, sticky="w")
self.legend_var = tk.BooleanVar(value=True)
tk.Checkbutton(cfg, text="凡例表示", variable=self.legend_var,
bg="#252526", fg="#ccc", selectcolor="#3c3c3c",
activebackground="#252526").grid(
row=5, column=0, columnspan=2, sticky="w")
# 複数Y列選択
tk.Label(left, text="Y軸 複数選択 (Ctrl+クリック):",
bg="#1e1e1e", fg="#888", font=("Arial", 8)).pack(
anchor="w", padx=4, pady=(8, 0))
self.ycols_listbox = tk.Listbox(left, selectmode=tk.MULTIPLE,
bg="#0d1117", fg="#c9d1d9",
font=("Arial", 9), height=6,
relief=tk.FLAT,
selectbackground="#1f6feb")
self.ycols_listbox.pack(fill=tk.X, padx=4)
# データプレビュー
tk.Label(left, text="データプレビュー", bg="#1e1e1e", fg="#888",
font=("Arial", 8)).pack(anchor="w", padx=4, pady=(8, 0))
preview_cols = ("col", "type", "sample")
self.preview_tree = ttk.Treeview(left, columns=preview_cols,
show="headings", height=6)
self.preview_tree.heading("col", text="列名")
self.preview_tree.heading("type", text="型")
self.preview_tree.heading("sample", text="サンプル")
self.preview_tree.column("col", width=80)
self.preview_tree.column("type", width=50)
self.preview_tree.column("sample", width=100)
self.preview_tree.pack(fill=tk.X, padx=4)
# 右パネル: グラフ
right = tk.Frame(paned, bg="#0d1117")
paned.add(right, weight=1)
if MATPLOTLIB_AVAILABLE:
self.fig = Figure(facecolor="#0d1117")
self.ax = self.fig.add_subplot(111)
self.mpl_canvas = FigureCanvasTkAgg(self.fig, master=right)
toolbar = NavigationToolbar2Tk(self.mpl_canvas, right)
toolbar.update()
toolbar.pack(side=tk.TOP, fill=tk.X)
self.mpl_canvas.get_tk_widget().pack(fill=tk.BOTH, expand=True)
else:
tk.Label(right, text="matplotlib が必要です",
bg="#0d1117", fg="#555").pack(expand=True)
self.status_var = tk.StringVar(value="CSVファイルを読み込んでください")
tk.Label(self.root, textvariable=self.status_var,
bg="#252526", fg="#858585", font=("Arial", 9),
anchor="w", padx=8).pack(fill=tk.X, side=tk.BOTTOM)
def _open_csv(self):
path = filedialog.askopenfilename(
filetypes=[("CSV", "*.csv"), ("TSV", "*.tsv"), ("すべて", "*.*")])
if not path:
return
try:
enc = "utf-8-sig"
with open(path, encoding=enc, errors="replace", newline="") as f:
reader = csv.reader(f)
rows = list(reader)
if not rows:
messagebox.showwarning("警告", "空のファイルです")
return
self._headers = rows[0]
self._rows = rows[1:]
self._update_columns()
self.status_var.set(
f"読み込み: {path} ({len(self._rows)} 行 × {len(self._headers)} 列)")
except Exception as e:
messagebox.showerror("エラー", str(e))
def _update_columns(self):
headers = self._headers
self.xcol_cb["values"] = headers
self.ycol_cb["values"] = headers
if headers:
self.xcol_var.set(headers[0])
self.ycol_var.set(headers[-1] if len(headers) > 1 else headers[0])
self.ycols_listbox.delete(0, tk.END)
for h in headers:
self.ycols_listbox.insert(tk.END, h)
# プレビュー
self.preview_tree.delete(*self.preview_tree.get_children())
for i, h in enumerate(headers):
col_vals = [r[i] for r in self._rows if i < len(r)]
sample = col_vals[0] if col_vals else ""
try:
float(sample)
dtype = "数値"
except ValueError:
dtype = "文字"
self.preview_tree.insert("", tk.END,
values=(h, dtype, sample[:20]))
def _get_col_values(self, col_name):
"""列名から数値リストを返す (変換できない場合はインデックス)"""
if col_name not in self._headers:
return []
idx = self._headers.index(col_name)
raw = [r[idx] if idx < len(r) else "" for r in self._rows]
try:
return [float(v.replace(",", "")) for v in raw]
except (ValueError, AttributeError):
return raw # 文字列のまま返す
def _draw(self):
if not MATPLOTLIB_AVAILABLE:
messagebox.showerror("エラー", "pip install matplotlib")
return
if not self._rows:
messagebox.showwarning("警告", "先にCSVを読み込んでください")
return
threading.Thread(target=self._do_draw, daemon=True).start()
def _do_draw(self):
self.root.after(0, self._render_chart)
def _render_chart(self):
chart_type = self.chart_type_var.get()
x_col = self.xcol_var.get()
x_vals = self._get_col_values(x_col)
# 複数Y列を取得 (リストボックス選択 or 単一)
sel = self.ycols_listbox.curselection()
if sel:
y_cols = [self._headers[i] for i in sel if i < len(self._headers)]
else:
y_cols = [self.ycol_var.get()]
self.ax.clear()
self.ax.set_facecolor("#0d1117")
if chart_type == "円グラフ":
y_vals = self._get_col_values(y_cols[0])
try:
vals = [float(v) for v in y_vals]
labels = [str(v) for v in x_vals]
self.ax.pie(vals, labels=labels[:len(vals)],
colors=self.COLORS,
autopct="%1.1f%%", startangle=90,
textprops={"color": "#c9d1d9", "fontsize": 7})
except Exception as e:
self.status_var.set(f"描画エラー: {e}")
elif chart_type == "ヒストグラム":
y_vals = self._get_col_values(y_cols[0])
try:
vals = [float(v) for v in y_vals]
self.ax.hist(vals, bins=20, color=self.COLORS[0], edgecolor="#0d1117")
except Exception as e:
self.status_var.set(f"描画エラー: {e}")
else:
for i, y_col in enumerate(y_cols):
y_vals = self._get_col_values(y_col)
color = self.COLORS[i % len(self.COLORS)]
try:
xn = [float(v) for v in x_vals]
except (ValueError, TypeError):
xn = list(range(len(x_vals)))
try:
yn = [float(v) for v in y_vals]
except (ValueError, TypeError):
continue
n = min(len(xn), len(yn))
xn, yn = xn[:n], yn[:n]
if chart_type == "折れ線":
self.ax.plot(xn, yn, color=color, label=y_col, linewidth=1.5)
elif chart_type == "棒グラフ":
self.ax.bar([x + i*0.15 for x in xn], yn,
width=0.15, color=color, label=y_col)
elif chart_type == "散布図":
self.ax.scatter(xn, yn, color=color, label=y_col, s=20)
elif chart_type == "面グラフ":
self.ax.fill_between(xn, yn, alpha=0.4, color=color, label=y_col)
self.ax.plot(xn, yn, color=color, linewidth=1)
# スタイリング
self.ax.set_title(self.title_var.get(), color="#c9d1d9", fontsize=11)
self.ax.set_xlabel(x_col, color="#8b949e", fontsize=9)
self.ax.tick_params(colors="#8b949e", labelsize=7)
for spine in self.ax.spines.values():
spine.set_edgecolor("#30363d")
if self.grid_var.get():
self.ax.grid(True, color="#21262d", linewidth=0.5)
if self.legend_var.get() and chart_type not in ("円グラフ", "ヒストグラム"):
self.ax.legend(facecolor="#161b22", edgecolor="#30363d",
labelcolor="#c9d1d9", fontsize=8)
self.fig.tight_layout()
self.mpl_canvas.draw()
self.status_var.set(f"描画完了: {chart_type} X={x_col} Y={', '.join(y_cols)}")
def _save_chart(self):
if not MATPLOTLIB_AVAILABLE:
return
path = filedialog.asksaveasfilename(
initialfile="chart.png",
defaultextension=".png",
filetypes=[("PNG", "*.png"), ("SVG", "*.svg"), ("PDF", "*.pdf")])
if not path:
return
try:
self.fig.savefig(path, facecolor="#0d1117", dpi=150)
self.status_var.set(f"保存完了: {path}")
except Exception as e:
messagebox.showerror("エラー", str(e))
if __name__ == "__main__":
root = tk.Tk()
app = App078(root)
root.mainloop()
6. ステップバイステップガイド
このアプリをゼロから自分で作る手順を解説します。コードをコピーするだけでなく、実際に手順を追って自分で書いてみましょう。
-
1ファイルを作成する
新しいファイルを作成して app078.py と保存します。
-
2クラスの骨格を作る
App078クラスを定義し、__init__とmainloop()の最小構成を作ります。
-
3タイトルバーを作る
Frameを使ってカラーバー付きのタイトルエリアを作ります。
-
4入力フォームを実装する
LabelFrameとEntryウィジェットで入力エリアを作ります。
-
5処理ロジックを実装する
_execute()メソッドにメインロジックを実装します。
-
6結果表示を実装する
TextウィジェットかLabelに結果を表示する_show_result()を実装します。
-
7エラー処理を追加する
try-exceptとmessageboxでエラーハンドリングを追加します。
7. カスタマイズアイデア
基本機能を習得したら、以下のカスタマイズに挑戦してみましょう。
💡 ダークモードを追加する
bg色・fg色を辞書で管理し、ボタン1つでダークモード・ライトモードを切り替えられるようにしましょう。
💡 データの保存機能
処理結果をCSV・TXTファイルに保存する機能を追加しましょう。filedialog.asksaveasfilename()でファイル保存ダイアログが使えます。
💡 設定ダイアログ
フォントサイズや色などの設定をユーザーが変更できるオプションダイアログを追加しましょう。
8. よくある問題と解決法
❌ 日本語フォントが表示されない
原因：システムに日本語フォントが見つからない場合があります。
解決法：font引数を省略するかシステムに合ったフォントを指定してください。
❌ ライブラリのインポートエラー
原因：必要なライブラリがインストールされていません。
解決法：pip install コマンドで必要なライブラリをインストールしてください。 (pip install pandas matplotlib)
❌ ウィンドウサイズが合わない
原因：画面解像度や表示スケールによって異なる場合があります。
解決法：root.geometry()で適切なサイズに調整してください。
9. 練習問題
アプリの理解を深めるための練習問題です。
-
課題1：機能拡張
CSVグラフダッシュボードに新しい機能を1つ追加してみましょう。
-
課題2：UIの改善
色・フォント・レイアウトを変更して、より使いやすいUIにカスタマイズしましょう。
-
課題3：保存機能の追加
処理結果をファイルに保存する機能を追加しましょう。