\n \n \n \n\n",[],[124,142],"67cdaf0a-56ae-11f1-8e14-ee650bb23af1","favicon.svg","019e551a-5303-7301-b8d9-bc0e8f5aabf9",["D",1779544249028],"\n",[],[124,150],"67cdad8e-56ae-11f1-8e14-ee650bb23af1","components","019e551a-5303-7301-b8d9-b9274695fab5",["D",1779544249028],[162,163,164,165,166,167],[124,157],{"_36":208,"_13":209,"_65":210,"_67":158,"_69":70,"_71":211,"_73":74,"_38":212,"_17":110,"_77":78,"_79":213,"_81":51,"_82":-5,"_113":214,"_18":215},{"_36":200,"_13":201,"_65":202,"_67":158,"_69":70,"_71":203,"_73":74,"_38":204,"_17":76,"_77":78,"_79":205,"_81":51,"_82":-5,"_113":206,"_18":207},{"_36":192,"_13":193,"_65":194,"_67":158,"_69":70,"_71":195,"_73":74,"_38":196,"_17":76,"_77":78,"_79":197,"_81":51,"_82":-5,"_113":198,"_18":199},{"_36":184,"_13":185,"_65":186,"_67":158,"_69":70,"_71":187,"_73":74,"_38":188,"_17":76,"_77":78,"_79":189,"_81":51,"_82":-5,"_113":190,"_18":191},{"_36":176,"_13":177,"_65":178,"_67":158,"_69":70,"_71":179,"_73":74,"_38":180,"_17":76,"_77":78,"_79":181,"_81":51,"_82":-5,"_113":182,"_18":183},{"_36":168,"_13":169,"_65":170,"_67":158,"_69":70,"_71":171,"_73":74,"_38":172,"_17":76,"_77":78,"_79":173,"_81":51,"_82":-5,"_113":174,"_18":175},"12eccdc6-56af-11f1-9595-ee650bb23af1","TrainTab.tsx","12eccea2-56af-11f1-9595-ee650bb23af1",17,["D",1779544536190],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\n\nexport function TrainTab({\n datasetId, onSelectDataset, onComplete,\n}: {\n datasetId: number | null;\n onSelectDataset: (id: number) => void;\n onComplete: (trainingId: number) => void;\n}) {\n const [datasets, setDatasets] = useState([]);\n const [currentId, setCurrentId] = useState(datasetId);\n const [columns, setColumns] = useState([]);\n const [targetCol, setTargetCol] = useState(\"\");\n const [alpha, setAlpha] = useState(0.1);\n const [loading, setLoading] = useState(false);\n const [result, setResult] = useState(null);\n const [history, setHistory] = useState([]);\n\n useEffect(() => {\n fetch(\"/api/data/datasets\").then((r) => r.json()).then(setDatasets);\n fetch(\"/api/train/results\").then((r) => r.json()).then(setHistory);\n }, []);\n\n useEffect(() => { if (datasetId) setCurrentId(datasetId); }, [datasetId]);\n\n useEffect(() => {\n if (!currentId) return;\n fetch(`/api/data/datasets/${currentId}`)\n .then((r) => r.json())\n .then((d) => { setColumns(d.columns || []); setTargetCol(\"\"); });\n }, [currentId]);\n\n const handleTrain = async () => {\n if (!currentId || !targetCol) return;\n setLoading(true);\n setResult(null);\n try {\n const res = await fetch(\"/api/train/lasso\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ datasetId: currentId, targetColumn: targetCol, alpha }),\n });\n const data = await res.json();\n if (data.error) throw new Error(data.error);\n setResult(data);\n fetch(\"/api/train/results\").then((r) => r.json()).then(setHistory);\n } catch (err: any) {\n setResult({ error: err.message });\n }\n setLoading(false);\n };\n\n return (\n

🎯 LASSO 回归训练 (10折交叉验证)

\n 数据集\n { const v = +e.target.value; setCurrentId(v); onSelectDataset(v); }}\n class=\"border rounded-lg px-3 py-2 w-full\"\n >\n \n {datasets.map((ds: any) => (\n \n ))}\n \n

\n 目标变量 (Y)\n setTargetCol(e.target.value)}\n class=\"border rounded-lg px-3 py-2 w-full\"\n >\n \n {columns.map((col) => (\n \n ))}\n \n

\n 正则化参数 (α)\n setAlpha(+e.target.value)}\n step=\"0.01\" min=\"0.001\" max=\"10\"\n class=\"border rounded-lg px-3 py-2 w-full\"\n />\n

\n \n {loading ? \"训练中...\" : \"🚀 开始训练\"}\n \n

\n\n {result && !result.error && (\n

训练结果

{result.selectedCount}

筛选特征数 / {result.totalFeatures}

{result.rSquared?.toFixed(4)}

R²

{result.meanCvScore?.toFixed(4)}

平均 CV R²

{result.alpha}

α 参数

\n\n

筛选的特征及系数:

\n \n \n \n \n \n \n \n \n \n \n \n \n {result.selectedFeatures?.map((f: string) => (\n \n \n \n \n ))}\n \n

特征	系数
截距 (Intercept)	{result.intercept?.toFixed(6)}
{f}	\n 0 ? \"text-green-700\" : \"text-red-700\"}>\n {result.coefficients[f]?.toFixed(6)}\n \n

\n\n

10折交叉验证分数:

\n {result.cvScores?.map((s: number, i: number) => (\n 0 ? 'bg-green-100 text-green-700' : 'bg-red-100 text-red-700'}`}>\n Fold{i + 1}: {s.toFixed(4)}\n \n ))}\n

\n\n onComplete(result.trainingId as number)}\n class=\"px-6 py-2.5 bg-blue-600 text-white rounded-lg hover:bg-blue-700 transition font-medium\"\n >\n 📈 进入回归分析 →\n \n

\n )}\n\n {result?.error && (\n

❌ {result.error}

\n )}\n\n {history.length > 0 && (\n

📋 训练历史

\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n {history.map((h: any) => (\n \n \n \n \n \n \n \n \n \n \n ))}\n \n

ID	目标变量	方法	α	筛选特征	CV R²	时间	操作
{h.id}	{h.target_column}	{h.method}	{h.alpha}	{h.selected_features?.length \|\| 0}	{h.mean_cv_score?.toFixed(4)}	{h.created_at}	\n \n

\n )}\n

\n );\n}\n",[],[124,157,169],"23acf0b4-56af-11f1-9595-ee650bb23af1","RegressionTab.tsx","23acf172-56af-11f1-9595-ee650bb23af1",18,["D",1779544564292],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\n\nexport function RegressionTab({\n datasetId, trainingId, onSelectModel,\n}: {\n datasetId: number | null;\n trainingId: number | null;\n onSelectModel: (modelId: number) => void;\n}) {\n const [training, setTraining] = useState(null);\n const [results, setResults] = useState([]);\n const [recommended, setRecommended] = useState(null);\n const [loading, setLoading] = useState(false);\n const [models, setModels] = useState([]);\n const [message, setMessage] = useState(\"\");\n\n useEffect(() => {\n fetch(\"/api/regression/models\").then((r) => r.json()).then(setModels);\n }, []);\n\n useEffect(() => {\n if (!trainingId) return;\n fetch(`/api/train/results/${trainingId}`)\n .then((r) => r.json())\n .then(setTraining);\n }, [trainingId]);\n\n const handleAnalyze = async () => {\n if (!training || !datasetId) return;\n setLoading(true);\n setMessage(\"\");\n try {\n const res = await fetch(\"/api/regression/analyze\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({\n datasetId,\n targetColumn: training.target_column,\n features: training.selected_features,\n trainingId,\n }),\n });\n const data = await res.json();\n if (data.error) throw new Error(data.error);\n setResults(data.results || []);\n setRecommended(data.recommended);\n setMessage(\"✅ 回归分析完成!\");\n fetch(\"/api/regression/models\").then((r) => r.json()).then(setModels);\n } catch (err: any) {\n setMessage(`❌ ${err.message}`);\n }\n setLoading(false);\n };\n\n return (\n

📈 多元回归分析

\n {training ? (\n

训练ID: {training.id} | 目标变量: {training.target_column}

筛选特征: {training.selected_features?.join(\", \")}

\n \n {loading ? \"分析中...\" : \"🔬 执行多种回归分析\"}\n \n {message &&

{message}

}\n

\n ) : (\n

请先在「数据训练」步骤完成 LASSO 训练，筛选变量后进入此步骤。

\n )}\n

\n\n {recommended && (\n

\n 🏆\n

推荐模型: {recommended.method}

\n {recommended.equation}\n

{recommended.rSquared?.toFixed(4)}

R²

{recommended.adjRSquared?.toFixed(4)}

调整 R²

{recommended.mse?.toFixed(4)}

MSE

{recommended.mae?.toFixed(4)}

MAE

\n )}\n\n {results.length > 0 && (\n

所有回归方法对比

\n \n \n \n \n \n \n \n \n \n \n \n \n {results.map((r: any, i: number) => (\n \n \n \n \n \n \n \n \n ))}\n \n

方法	R²	调整 R²	MSE	MAE	回归方程
\n {r.method}\n {r === recommended && 推荐}\n	{r.rSquared?.toFixed(4) ?? '-'}	{r.adjRSquared?.toFixed(4) ?? '-'}	{r.mse?.toFixed(4) ?? '-'}	{r.mae?.toFixed(4) ?? '-'}	{r.equation \|\| r.error \|\| '-'}

\n )}\n\n {models.length > 0 && (\n

📦 已保存的模型

\n \n \n \n \n \n \n \n \n \n \n \n \n {models.map((m: any) => (\n \n \n \n \n \n \n \n \n ))}\n \n

ID	方法	目标	R²	推荐	操作
{m.id}	{m.method}	{m.target}	{m.adj_r_squared?.toFixed(4)}	{m.is_recommended ? \"🏆\" : \"\"}	\n \n

\n )}\n

\n );\n}\n",[],[124,157,177],"ff74a7e6-56ae-11f1-a0c4-ee650bb23af1","PreprocessTab.tsx","ff74a8cc-56ae-11f1-a0c4-ee650bb23af1",16,["D",1779544503515],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\n\ninterface ColAnalysis {\n column: string; total: number; missing: number; unique: number; isNumeric: boolean;\n min?: number; max?: number; mean?: number; median?: number;\n}\n\nexport function PreprocessTab({\n datasetId, onSelectDataset, onComplete,\n}: {\n datasetId: number | null;\n onSelectDataset: (id: number) => void;\n onComplete: (id: number) => void;\n}) {\n const [datasets, setDatasets] = useState([]);\n const [currentId, setCurrentId] = useState(datasetId);\n const [analysis, setAnalysis] = useState([]);\n const [loading, setLoading] = useState(false);\n const [message, setMessage] = useState(\"\");\n const [deduplicate, setDeduplicate] = useState(false);\n const [fillMethods, setFillMethods] = useState>({});\n const [dropCols, setDropCols] = useState>(new Set());\n\n useEffect(() => {\n fetch(\"/api/data/datasets\").then((r) => r.json()).then(setDatasets);\n }, []);\n\n useEffect(() => { if (datasetId) { setCurrentId(datasetId); } }, [datasetId]);\n\n useEffect(() => {\n if (!currentId) return;\n setLoading(true);\n fetch(`/api/preprocess/preview/${currentId}`)\n .then((r) => r.json())\n .then((data) => { setAnalysis(data.analysis || []); setLoading(false); })\n .catch(() => setLoading(false));\n }, [currentId]);\n\n const handleApply = async () => {\n if (!currentId) return;\n setLoading(true);\n setMessage(\"\");\n try {\n const fillMissing: Record = {};\n for (const [col, method] of Object.entries(fillMethods)) {\n if (method && method !== \"none\") fillMissing[col] = method;\n }\n const res = await fetch(\"/api/preprocess/apply\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({\n datasetId: currentId,\n operations: {\n deduplicate,\n fillMissing: Object.keys(fillMissing).length ? fillMissing : undefined,\n dropColumns: dropCols.size ? [...dropCols] : undefined,\n },\n }),\n });\n const data = await res.json();\n if (data.error) throw new Error(data.error);\n setMessage(`✅ 预处理完成! 新数据集 ID: ${data.id}, ${data.rows} 行, ${data.columns.length} 列`);\n onComplete(data.id as number);\n } catch (err: any) {\n setMessage(`❌ ${err.message}`);\n }\n setLoading(false);\n };\n\n const toggleDrop = (col: string) => {\n const next = new Set(dropCols);\n next.has(col) ? next.delete(col) : next.add(col);\n setDropCols(next);\n };\n\n return (\n

🔧 数据预处理

\n 选择数据集\n { const v = +e.target.value; setCurrentId(v); onSelectDataset(v); }}\n class=\"border rounded-lg px-3 py-2 min-w-[200px]\"\n >\n \n {datasets.map((ds: any) => (\n \n ))}\n \n

\n \n setDeduplicate(!deduplicate)} class=\"rounded\" />\n 去重\n \n

\n\n {analysis.length > 0 && (\n

列分析 & 配置

\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n {analysis.map((col) => (\n \n \n \n \n \n \n \n \n \n \n \n ))}\n \n

列名	类型	总数	缺失	唯一值	范围	均值	缺失处理	删除列
{col.column}	\n \n {col.isNumeric ? \"数值\" : \"文本\"}\n \n	{col.total}	\n {col.missing > 0 ? {col.missing} : 0}\n	{col.unique}	\n {col.isNumeric ? `${col.min?.toFixed(2)} ~ ${col.max?.toFixed(2)}` : \"-\"}\n	\n {col.isNumeric ? col.mean?.toFixed(2) : \"-\"}\n	\n {col.missing > 0 && col.isNumeric ? (\n setFillMethods({ ...fillMethods, [col.column]: e.target.value })}\n class=\"border rounded px-2 py-1 text-xs\"\n >\n \n \n \n \n \n \n ) : col.missing > 0 ? (\n setFillMethods({ ...fillMethods, [col.column]: e.target.value })}\n class=\"border rounded px-2 py-1 text-xs\"\n >\n \n \n \n ) : -}\n	\n toggleDrop(col.column)}\n class=\"rounded cursor-pointer\"\n />\n

\n\n

\n \n {loading ? \"处理中...\" : \"✅ 执行预处理\"}\n \n

\n {message &&

{message}

}\n

\n )}\n

\n );\n}\n",[],[124,157,185],"3b88daf4-56af-11f1-9595-ee650bb23af1","PredictTab.tsx","3b88dbe4-56af-11f1-9595-ee650bb23af1",19,["D",1779544604322],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\n\nexport function PredictTab({ modelId }: { modelId: number | null }) {\n const [pages, setPages] = useState([]);\n const [activePage, setActivePage] = useState(null);\n const [inputs, setInputs] = useState>({});\n const [prediction, setPrediction] = useState(null);\n const [history, setHistory] = useState([]);\n const [accuracy, setAccuracy] = useState(null);\n const [newPageName, setNewPageName] = useState(\"\");\n const [newPageDesc, setNewPageDesc] = useState(\"\");\n const [showCreate, setShowCreate] = useState(false);\n const [createModelId, setCreateModelId] = useState(modelId);\n const [models, setModels] = useState([]);\n const [actualInputs, setActualInputs] = useState>({});\n\n useEffect(() => {\n loadPages();\n fetch(\"/api/regression/models\").then((r) => r.json()).then(setModels);\n }, []);\n\n useEffect(() => {\n if (modelId) { setCreateModelId(modelId); setShowCreate(true); }\n }, [modelId]);\n\n const loadPages = () => fetch(\"/api/predict/pages\").then((r) => r.json()).then(setPages);\n\n const handleCreatePage = async () => {\n if (!createModelId || !newPageName) return;\n const res = await fetch(\"/api/predict/pages\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ modelId: createModelId, name: newPageName, description: newPageDesc }),\n });\n const data = await res.json();\n if (!data.error) {\n setShowCreate(false);\n setNewPageName(\"\");\n setNewPageDesc(\"\");\n loadPages();\n }\n };\n\n const openPage = async (pageId: number) => {\n const res = await fetch(`/api/predict/pages/${pageId}`);\n const data = await res.json();\n setActivePage(data);\n setInputs({});\n setPrediction(null);\n loadHistory(pageId);\n loadAccuracy(pageId);\n };\n\n const loadHistory = async (pageId: number) => {\n const res = await fetch(`/api/predict/history/${pageId}`);\n setHistory(await res.json());\n };\n\n const loadAccuracy = async (pageId: number) => {\n const res = await fetch(`/api/predict/accuracy/${pageId}`);\n setAccuracy(await res.json());\n };\n\n const handlePredict = async () => {\n if (!activePage) return;\n const numInputs: Record = {};\n for (const f of activePage.features) {\n if (!inputs[f] || isNaN(+inputs[f])) return alert(`请输入有效的 ${f} 值`);\n numInputs[f] = +inputs[f];\n }\n const res = await fetch(\"/api/predict/run\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ pageId: activePage.id, inputs: numInputs }),\n });\n const data = await res.json();\n setPrediction(data);\n loadHistory(activePage.id);\n };\n\n const handleActualSubmit = async (predictionId: number) => {\n const val = actualInputs[predictionId];\n if (!val || isNaN(+val)) return;\n await fetch(`/api/predict/actual/${predictionId}`, {\n method: \"PUT\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ actualValue: +val }),\n });\n setActualInputs((prev) => { const next = { ...prev }; delete next[predictionId]; return next; });\n if (activePage) {\n loadHistory(activePage.id);\n loadAccuracy(activePage.id);\n }\n };\n\n return (\n

\n {/* Create page panel */}\n

🔮 回归预测

\n \n

\n\n {showCreate && (\n

\n 选择模型\n \n

\n 页面名称\n setNewPageName(e.target.value)} placeholder=\"例：房价预测\" class=\"border rounded px-3 py-2 w-full text-sm\" />\n

\n \n

\n )}\n\n {/* Page list */}\n {pages.length > 0 ? (\n

\n {pages.map((p: any) => (\n openPage(p.id)}\n class={`text-left border rounded-lg p-4 hover:border-blue-400 transition ${activePage?.id === p.id ? 'border-blue-500 bg-blue-50' : ''}`}\n >\n

{p.name}

{p.method} | {p.target}

R² = {p.r_squared?.toFixed(4)}

\n \n ))}\n

\n ) : (\n

暂无预测页面，请选择模型创建

\n )}\n

\n\n {/* Active prediction page */}\n {activePage && (\n

{activePage.name}

方法: {activePage.method} | 目标: {activePage.target}

{activePage.equation}

\n\n

\n {activePage.features?.map((f: string) => (\n

\n {f}\n setInputs({ ...inputs, [f]: e.target.value })}\n class=\"border rounded-lg px-3 py-2 w-full\"\n placeholder={`输入 ${f}`}\n />\n

\n ))}\n

\n \n\n {prediction && !prediction.error && (\n

{prediction.target} 预测值

{prediction.predicted?.toFixed(4)}

\n )}\n

\n )}\n\n {/* Accuracy stats */}\n {activePage && accuracy && accuracy.count > 0 && (\n

📊 预测准确性统计 ({accuracy.count} 条已验证)

{accuracy.mae?.toFixed(4)}

MAE

{accuracy.rmse?.toFixed(4)}

RMSE

{accuracy.mse?.toFixed(4)}

MSE

{accuracy.mape?.toFixed(2)}%

MAPE

{accuracy.meanError?.toFixed(4)}

平均误差

\n )}\n\n {/* Prediction history */}\n {activePage && history.length > 0 && (\n

📋 预测历史

\n \n \n \n \n \n \n \n \n \n \n \n \n {history.map((h: any) => (\n \n \n \n \n \n \n \n \n ))}\n \n

时间	输入	预测值	实际值	误差	操作
{h.created_at}	\n {Object.entries(h.input_json \|\| {}).map(([k, v]) => `${k}=${v}`).join(\", \")}\n	{h.predicted_value?.toFixed(4)}	\n {h.actual_value != null ? (\n {h.actual_value.toFixed(4)}\n ) : (\n \n setActualInputs({ ...actualInputs, [h.id]: e.target.value })}\n class=\"border rounded px-2 py-1 w-24 text-xs\"\n placeholder=\"输入实际值\"\n />\n \n \n )}\n	\n {h.error != null ? (\n {h.error.toFixed(4)}\n ) : \"-\"}\n	\n {h.actual_value != null ? \"✅\" : \"待验证\"}\n

\n )}\n

\n );\n}\n",[],[124,157,193],"ee274b56-56ae-11f1-8274-ee650bb23af1","DataTab.tsx","ee274c0a-56ae-11f1-8274-ee650bb23af1",15,["D",1779544474498],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\n\ninterface Dataset {\n id: number;\n name: string;\n source: string;\n row_count: number;\n col_count: number;\n columns_json: string;\n created_at: string;\n}\n\nexport function DataTab({ onSelectDataset }: { onSelectDataset: (id: number) => void }) {\n const [datasets, setDatasets] = useState([]);\n const [uploading, setUploading] = useState(false);\n const [message, setMessage] = useState(\"\");\n const [showJson, setShowJson] = useState(false);\n const [jsonInput, setJsonInput] = useState('');\n const [jsonName, setJsonName] = useState('');\n const [preview, setPreview] = useState(null);\n\n const loadDatasets = async () => {\n const res = await fetch(\"/api/data/datasets\");\n setDatasets(await res.json());\n };\n\n useEffect(() => { loadDatasets(); }, []);\n\n const handleUpload = async (e: React.ChangeEvent) => {\n const file = (e.target as any).files?.[0];\n if (!file) return;\n setUploading(true);\n setMessage(\"\");\n try {\n const formData = new FormData();\n formData.append(\"file\", file);\n const res = await fetch(\"/api/data/upload\", { method: \"POST\", body: formData });\n const data = await res.json();\n if (data.error) throw new Error(data.error);\n setMessage(`✅ 上传成功: ${data.rows} 行, ${data.columns.length} 列`);\n loadDatasets();\n } catch (err: any) {\n setMessage(`❌ 上传失败: ${err.message}`);\n }\n setUploading(false);\n };\n\n const handleJsonImport = async () => {\n try {\n const parsed = JSON.parse(jsonInput);\n const data = Array.isArray(parsed) ? parsed : [parsed];\n const res = await fetch(\"/api/data/import-json\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ name: jsonName || \"json_import\", data }),\n });\n const result = await res.json();\n if (result.error) throw new Error(result.error);\n setMessage(`✅ 导入成功: ${result.rows} 行`);\n setShowJson(false);\n setJsonInput(\"\");\n loadDatasets();\n } catch (err: any) {\n setMessage(`❌ 导入失败: ${err.message}`);\n }\n };\n\n const handleDelete = async (id: number) => {\n if (!confirm(\"确认删除此数据集？\")) return;\n await fetch(`/api/data/datasets/${id}`, { method: \"DELETE\" });\n loadDatasets();\n };\n\n const handlePreview = async (id: number) => {\n const res = await fetch(`/api/data/datasets/${id}`);\n setPreview(await res.json());\n };\n\n return (\n

📥 数据上传

\n \n 📁\n {uploading ? \"上传中...\" : \"上传 Excel 文件\"}\n \n \n setShowJson(!showJson)}\n class=\"px-5 py-3 bg-green-600 text-white rounded-lg hover:bg-green-700 transition\"\n >\n 📋 JSON 数据导入\n \n

\n {message &&

{message}

}\n

\n\n {showJson && (\n

JSON 数据导入

\n setJsonName(e.target.value)}\n class=\"w-full border rounded-lg px-3 py-2 mb-3\"\n />\n setJsonInput(e.target.value)}\n class=\"w-full border rounded-lg px-3 py-2 h-40 font-mono text-sm\"\n />\n \n

\n )}\n\n

📂 数据集列表

\n {datasets.length === 0 ? (\n

暂无数据集，请上传数据

\n ) : (\n

\n \n \n \n \n \n \n \n \n \n \n \n \n \n {datasets.map((ds) => (\n \n \n \n \n \n \n \n \n \n ))}\n \n

ID	名称	来源	行数	列数	创建时间	操作
{ds.id}	{ds.name}	\n \n {ds.source === 'upload' ? '上传' : ds.source === 'preprocessed' ? '预处理' : ds.source}\n \n	{ds.row_count}	{ds.col_count}	{ds.created_at}	\n \n \n \n \n \n

\n )}\n

\n\n {preview && (\n

数据预览 - {preview.name || '数据集'}

\n \n

\n \n \n \n \n {(preview.columns || []).map((col: string) => (\n \n ))}\n \n \n \n {(preview.rows || []).slice(0, 50).map((row: any, i: number) => (\n \n \n {(preview.columns || []).map((col: string) => (\n \n ))}\n \n ))}\n \n

#	{col}
{row.index}	{String(row.data[col] ?? '')}

显示前 50 行 / 共 {preview.rows?.length || 0} 行

\n )}\n

\n );\n}\n",[],[124,157,201],"dbdc3e0c-56ae-11f1-9595-ee650bb23af1","App.tsx","019e551a-5302-73ad-8589-62cc6807635a",14,["D",1779544443801],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState } from \"https://esm.sh/react@18.2.0\";\nimport { DataTab } from \"./DataTab.tsx\";\nimport { PreprocessTab } from \"./PreprocessTab.tsx\";\nimport { TrainTab } from \"./TrainTab.tsx\";\nimport { RegressionTab } from \"./RegressionTab.tsx\";\nimport { PredictTab } from \"./PredictTab.tsx\";\n\nconst TABS = [\n { id: \"data\", label: \"📊 数据采集\", icon: \"1\" },\n { id: \"preprocess\", label: \"🔧 数据预处理\", icon: \"2\" },\n { id: \"train\", label: \"🎯 数据训练\", icon: \"3\" },\n { id: \"regression\", label: \"📈 回归分析\", icon: \"4\" },\n { id: \"predict\", label: \"🔮 回归预测\", icon: \"5\" },\n] as const;\n\nexport function App() {\n const [activeTab, setActiveTab] = useState(\"data\");\n const [selectedDatasetId, setSelectedDatasetId] = useState(null);\n const [selectedTrainingId, setSelectedTrainingId] = useState(null);\n const [selectedModelId, setSelectedModelId] = useState(null);\n\n return (\n

\n {/* Header */}\n

\n 📐\n

回归分析平台

\n v1.0\n

\n 查看源码\n

\n\n {/* Tab Navigation */}\n

\n {TABS.map((tab) => (\n setActiveTab(tab.id)}\n class={`px-5 py-3 text-sm whitespace-nowrap transition-all border-b-2 ${\n activeTab === tab.id\n ? \"tab-active border-blue-500\"\n : \"border-transparent text-gray-500 hover:text-gray-700 hover:border-gray-300\"\n }`}\n >\n \n {tab.icon}\n {tab.label}\n \n \n ))}\n

\n\n {/* Content */}\n

\n {activeTab === \"data\" && (\n { setSelectedDatasetId(id); setActiveTab(\"preprocess\"); }}\n />\n )}\n {activeTab === \"preprocess\" && (\n { setSelectedDatasetId(id); setActiveTab(\"train\"); }}\n />\n )}\n {activeTab === \"train\" && (\n { setSelectedTrainingId(tid); setActiveTab(\"regression\"); }}\n />\n )}\n {activeTab === \"regression\" && (\n { setSelectedModelId(mid); setActiveTab(\"predict\"); }}\n />\n )}\n {activeTab === \"predict\" && (\n \n )}\n

\n );\n}\n",[],[124,157,209],["D",1779544263876],[219,220,221],[19],{"_36":91,"_13":92,"_65":93,"_67":68,"_69":70,"_71":94,"_73":74,"_38":228,"_17":76,"_77":96,"_79":-5,"_81":51,"_82":-5,"_113":229,"_18":230},{"_36":84,"_13":85,"_65":86,"_67":68,"_69":70,"_71":87,"_73":74,"_38":225,"_17":76,"_77":78,"_79":89,"_81":51,"_82":-5,"_113":226,"_18":227},{"_36":63,"_13":64,"_65":66,"_67":68,"_69":70,"_71":72,"_73":74,"_38":222,"_17":76,"_77":78,"_79":80,"_81":51,"_82":-5,"_113":223,"_18":224},["D",1779544325014],[],[19,64],["D",1779544274151],[],[19,85],["D",1779544266458],[231,232,233,234,235],[19,92],{"_36":268,"_13":269,"_65":270,"_67":93,"_69":70,"_71":271,"_73":74,"_38":272,"_17":108,"_77":78,"_79":273,"_81":51,"_82":-5,"_113":274,"_18":275},{"_36":260,"_13":261,"_65":262,"_67":93,"_69":70,"_71":263,"_73":74,"_38":264,"_17":108,"_77":78,"_79":265,"_81":51,"_82":-5,"_113":266,"_18":267},{"_36":252,"_13":253,"_65":254,"_67":93,"_69":70,"_71":255,"_73":74,"_38":256,"_17":110,"_77":78,"_79":257,"_81":51,"_82":-5,"_113":258,"_18":259},{"_36":244,"_13":245,"_65":246,"_67":93,"_69":70,"_71":247,"_73":74,"_38":248,"_17":76,"_77":78,"_79":249,"_81":51,"_82":-5,"_113":250,"_18":251},{"_36":236,"_13":237,"_65":238,"_67":93,"_69":70,"_71":239,"_73":74,"_38":240,"_17":110,"_77":78,"_79":241,"_81":51,"_82":-5,"_113":242,"_18":243},"5a4bec38-56af-11f1-be57-ee650bb23af1","train.ts","b61de396-56ae-11f1-9595-ee650bb23af1",24,["D",1779544655902],"import { Hono } from \"npm:hono\";\nimport { sqlite } from \"../db.ts\";\nimport { lassoRegression, kFoldCV } from \"../math.ts\";\n\nexport const trainRoutes = new Hono();\n\n// Run LASSO training with 10-fold CV\ntrainRoutes.post(\"/lasso\", async (c) => {\n try {\n const { datasetId, targetColumn, alpha = 0.1 } = await c.req.json<{\n datasetId: number;\n targetColumn: string;\n alpha?: number;\n }>();\n\n // Load data\n const ds = await sqlite.execute({ sql: \"SELECT * FROM datasets WHERE id = ?\", args: [datasetId] });\n if (!ds.rows.length) return c.json({ error: \"Dataset not found\" }, 404);\n\n const columns: string[] = JSON.parse((ds.rows[0] as any).columns_json);\n if (!columns.includes(targetColumn)) return c.json({ error: \"Target column not found\" }, 400);\n\n const rowsResult = await sqlite.execute({\n sql: \"SELECT data_json FROM dataset_rows WHERE dataset_id = ? ORDER BY row_index\",\n args: [datasetId],\n });\n const rawData = rowsResult.rows.map((r: any) => JSON.parse(r.data_json));\n\n // Build numeric matrix\n const features = columns.filter((c) => c !== targetColumn);\n const numericFeatures = features.filter((col) => {\n return rawData.every((row: any) => {\n const v = row[col];\n return v !== null && v !== undefined && v !== \"\" && !isNaN(Number(v));\n });\n });\n\n if (numericFeatures.length === 0) return c.json({ error: \"No numeric features found\" }, 400);\n\n const X = rawData.map((row: any) => numericFeatures.map((col) => Number(row[col])));\n const y = rawData.map((row: any) => Number(row[targetColumn]));\n\n // Run LASSO\n const result = lassoRegression(X, y, alpha);\n\n // 10-fold CV\n const cv = kFoldCV(X, y, 10, (Xt, yt) => lassoRegression(Xt, yt, alpha));\n\n // Selected features (non-zero coefficients)\n const selectedFeatures = numericFeatures.filter((_, i) => Math.abs(result.coefficients[i]) > 1e-10);\n const selectedCoeffs = result.coefficients.filter((c) => Math.abs(c) > 1e-10);\n\n // Save training result\n const saveResult = await sqlite.execute({\n sql: `INSERT INTO training_results (dataset_id, target_column, method, alpha, selected_features, cv_scores, mean_cv_score, coefficients)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?)`,\n args: [\n datasetId,\n targetColumn,\n \"lasso\",\n alpha,\n JSON.stringify(selectedFeatures),\n JSON.stringify(cv.scores),\n cv.meanScore,\n JSON.stringify(Object.fromEntries(selectedFeatures.map((f, i) => [f, selectedCoeffs[i]]))),\n ],\n });\n\n return c.json({\n trainingId: Number(saveResult.lastInsertRowid),\n method: \"lasso\",\n alpha,\n allFeatures: numericFeatures,\n selectedFeatures,\n coefficients: Object.fromEntries(selectedFeatures.map((f, i) => [f, selectedCoeffs[i]])),\n intercept: result.intercept,\n rSquared: result.rSquared,\n cvScores: cv.scores,\n meanCvScore: cv.meanScore,\n totalFeatures: numericFeatures.length,\n selectedCount: selectedFeatures.length,\n });\n } catch (err: any) {\n return c.json({ error: err.message }, 500);\n }\n});\n\n// Get training results\ntrainRoutes.get(\"/results\", async (c) => {\n const result = await sqlite.execute(\"SELECT * FROM training_results ORDER BY created_at DESC\");\n return c.json(result.rows.map((r: any) => ({\n ...r,\n selected_features: JSON.parse(r.selected_features || \"[]\"),\n cv_scores: JSON.parse(r.cv_scores || \"[]\"),\n coefficients: JSON.parse(r.coefficients || \"{}\"),\n })));\n});\n\ntrainRoutes.get(\"/results/:id\", async (c) => {\n const id = c.req.param(\"id\");\n const result = await sqlite.execute({ sql: \"SELECT * FROM training_results WHERE id = ?\", args: [+id] });\n if (!result.rows.length) return c.json({ error: \"Not found\" }, 404);\n const r: any = result.rows[0];\n return c.json({\n ...r,\n selected_features: JSON.parse(r.selected_features || \"[]\"),\n cv_scores: JSON.parse(r.cv_scores || \"[]\"),\n coefficients: JSON.parse(r.coefficients || \"{}\"),\n });\n});\n",[],[19,92,237],"beda32f0-56ae-11f1-b03a-ee650bb23af1","regression.ts","beda3390-56ae-11f1-b03a-ee650bb23af1",10,["D",1779544395133],"import { Hono } from \"npm:hono\";\nimport { sqlite } from \"../db.ts\";\nimport {\n olsRegression,\n ridgeRegression,\n lassoRegression,\n elasticNetRegression,\n formatEquation,\n type RegressionResult,\n} from \"../math.ts\";\n\nexport const regressionRoutes = new Hono();\n\n// Run multiple regression methods on selected features\nregressionRoutes.post(\"/analyze\", async (c) => {\n try {\n const { datasetId, targetColumn, features, trainingId } = await c.req.json<{\n datasetId: number;\n targetColumn: string;\n features: string[];\n trainingId?: number;\n }>();\n\n // Load data\n const rowsResult = await sqlite.execute({\n sql: \"SELECT data_json FROM dataset_rows WHERE dataset_id = ? ORDER BY row_index\",\n args: [datasetId],\n });\n const rawData = rowsResult.rows.map((r: any) => JSON.parse(r.data_json));\n const X = rawData.map((row: any) => features.map((col) => Number(row[col])));\n const y = rawData.map((row: any) => Number(row[targetColumn]));\n\n // Run multiple regression methods\n const methods: { name: string; fn: () => RegressionResult }[] = [\n { name: \"OLS\", fn: () => olsRegression(X, y) },\n { name: \"Ridge (λ=0.1)\", fn: () => ridgeRegression(X, y, 0.1) },\n { name: \"Ridge (λ=1.0)\", fn: () => ridgeRegression(X, y, 1.0) },\n { name: \"LASSO (λ=0.01)\", fn: () => lassoRegression(X, y, 0.01) },\n { name: \"LASSO (λ=0.1)\", fn: () => lassoRegression(X, y, 0.1) },\n { name: \"ElasticNet (λ=0.1, α=0.5)\", fn: () => elasticNetRegression(X, y, 0.1, 0.5) },\n ];\n\n const results = [];\n for (const m of methods) {\n try {\n const result = m.fn();\n const equation = formatEquation(targetColumn, features, result.coefficients, result.intercept);\n results.push({\n method: m.name,\n rSquared: result.rSquared,\n adjRSquared: result.adjRSquared,\n mse: result.mse,\n mae: result.mae,\n coefficients: Object.fromEntries(features.map((f, i) => [f, result.coefficients[i]])),\n intercept: result.intercept,\n equation,\n });\n } catch {\n results.push({ method: m.name, error: \"Failed to compute\" });\n }\n }\n\n // Sort by adj R² and recommend best\n const valid = results.filter((r: any) => !r.error && r.adjRSquared != null);\n valid.sort((a: any, b: any) => b.adjRSquared - a.adjRSquared);\n const recommended = valid[0];\n\n // Save all models\n for (const r of valid) {\n const isRec = r === recommended ? 1 : 0;\n await sqlite.execute({\n sql: `INSERT INTO regression_models (training_id, dataset_id, method, equation, coefficients, intercept, r_squared, adj_r_squared, mse, mae, features, target, is_recommended)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n args: [\n trainingId || null,\n datasetId,\n (r as any).method,\n (r as any).equation,\n JSON.stringify((r as any).coefficients),\n (r as any).intercept,\n (r as any).rSquared,\n (r as any).adjRSquared,\n (r as any).mse,\n (r as any).mae,\n JSON.stringify(features),\n targetColumn,\n isRec,\n ],\n });\n }\n\n return c.json({ results, recommended: recommended ? { ...recommended, isRecommended: true } : null });\n } catch (err: any) {\n return c.json({ error: err.message }, 500);\n }\n});\n\n// Get all models\nregressionRoutes.get(\"/models\", async (c) => {\n const result = await sqlite.execute(\"SELECT * FROM regression_models ORDER BY adj_r_squared DESC\");\n return c.json(\n result.rows.map((r: any) => ({\n ...r,\n coefficients: JSON.parse(r.coefficients || \"{}\"),\n features: JSON.parse(r.features || \"[]\"),\n })),\n );\n});\n\n// Get single model\nregressionRoutes.get(\"/models/:id\", async (c) => {\n const id = c.req.param(\"id\");\n const result = await sqlite.execute({ sql: \"SELECT * FROM regression_models WHERE id = ?\", args: [+id] });\n if (!result.rows.length) return c.json({ error: \"Not found\" }, 404);\n const r: any = result.rows[0];\n return c.json({\n ...r,\n coefficients: JSON.parse(r.coefficients || \"{}\"),\n features: JSON.parse(r.features || \"[]\"),\n });\n});\n",[],[19,92,245],"57704ab8-56af-11f1-8305-ee650bb23af1","preprocess.ts","ac479fc4-56ae-11f1-8228-ee650bb23af1",23,["D",1779544651129],"import { Hono } from \"npm:hono\";\nimport { sqlite } from \"../db.ts\";\nimport { mean, median, mode } from \"../math.ts\";\n\nexport const preprocessRoutes = new Hono();\n\n// Get preprocess preview\npreprocessRoutes.get(\"/preview/:datasetId\", async (c) => {\n const datasetId = +c.req.param(\"datasetId\");\n const ds = await sqlite.execute({ sql: \"SELECT * FROM datasets WHERE id = ?\", args: [datasetId] });\n if (!ds.rows.length) return c.json({ error: \"Dataset not found\" }, 404);\n\n const rowsResult = await sqlite.execute({\n sql: \"SELECT data_json FROM dataset_rows WHERE dataset_id = ? ORDER BY row_index\",\n args: [datasetId],\n });\n const data = rowsResult.rows.map((r: any) => JSON.parse(r.data_json));\n const columns = JSON.parse((ds.rows[0] as any).columns_json);\n\n // Analyze each column\n const analysis = columns.map((col: string) => {\n const values = data.map((row: any) => row[col]);\n const nonNull = values.filter((v: any) => v !== null && v !== undefined && v !== \"\");\n const nullCount = values.length - nonNull.length;\n const unique = new Set(nonNull).size;\n const isNumeric = nonNull.length > 0 && nonNull.every((v: any) => !isNaN(Number(v)));\n\n let stats: any = { total: values.length, missing: nullCount, unique, isNumeric };\n if (isNumeric && nonNull.length > 0) {\n const nums = nonNull.map(Number);\n stats.min = Math.min(...nums);\n stats.max = Math.max(...nums);\n stats.mean = mean(nums);\n stats.median = median(nums);\n }\n return { column: col, ...stats };\n });\n\n return c.json({ datasetId, columns, rowCount: data.length, analysis });\n});\n\n// Apply preprocessing\npreprocessRoutes.post(\"/apply\", async (c) => {\n try {\n const body = await c.req.json<{\n datasetId: number;\n operations: {\n deduplicate?: boolean;\n fillMissing?: Record;\n dropColumns?: string[];\n groupBy?: { column: string; agg: Record };\n };\n }>();\n\n const { datasetId, operations } = body;\n const ds = await sqlite.execute({ sql: \"SELECT * FROM datasets WHERE id = ?\", args: [datasetId] });\n if (!ds.rows.length) return c.json({ error: \"Dataset not found\" }, 404);\n\n const rowsResult = await sqlite.execute({\n sql: \"SELECT data_json FROM dataset_rows WHERE dataset_id = ? ORDER BY row_index\",\n args: [datasetId],\n });\n let data: Record[] = rowsResult.rows.map((r: any) => JSON.parse(r.data_json));\n let columns: string[] = JSON.parse((ds.rows[0] as any).columns_json);\n\n // 1) Drop columns\n if (operations.dropColumns?.length) {\n columns = columns.filter((c) => !operations.dropColumns!.includes(c));\n data = data.map((row) => {\n const newRow: any = {};\n columns.forEach((col) => (newRow[col] = row[col]));\n return newRow;\n });\n }\n\n // 2) Deduplicate\n if (operations.deduplicate) {\n const seen = new Set();\n data = data.filter((row) => {\n const key = JSON.stringify(columns.map((c) => row[c]));\n if (seen.has(key)) return false;\n seen.add(key);\n return true;\n });\n }\n\n // 3) Fill missing values\n if (operations.fillMissing) {\n for (const [col, method] of Object.entries(operations.fillMissing)) {\n const nonNull = data\n .map((row) => row[col])\n .filter((v) => v !== null && v !== undefined && v !== \"\");\n\n if (method === \"drop\") {\n data = data.filter((row) => row[col] !== null && row[col] !== undefined && row[col] !== \"\");\n continue;\n }\n\n const isNumeric = nonNull.every((v) => !isNaN(Number(v)));\n if (!isNumeric) continue;\n\n const nums = nonNull.map(Number);\n let fillValue: number;\n if (method === \"mean\") fillValue = mean(nums);\n else if (method === \"median\") fillValue = median(nums);\n else fillValue = mode(nums);\n\n data = data.map((row) => ({\n ...row,\n [col]: row[col] === null || row[col] === undefined || row[col] === \"\" ? fillValue : row[col],\n }));\n }\n }\n\n // 4) Group by\n if (operations.groupBy) {\n const { column: groupCol, agg } = operations.groupBy;\n const groups: Record[]> = {};\n data.forEach((row) => {\n const key = String(row[groupCol] ?? \"null\");\n if (!groups[key]) groups[key] = [];\n groups[key].push(row);\n });\n\n data = Object.entries(groups).map(([key, rows]) => {\n const result: any = { [groupCol]: key };\n for (const [col, fn] of Object.entries(agg)) {\n const vals = rows.map((r) => Number(r[col])).filter((v) => !isNaN(v));\n if (fn === \"sum\") result[col] = vals.reduce((a, b) => a + b, 0);\n else if (fn === \"mean\") result[col] = vals.length ? mean(vals) : 0;\n else if (fn === \"count\") result[col] = vals.length;\n else if (fn === \"min\") result[col] = vals.length ? Math.min(...vals) : 0;\n else if (fn === \"max\") result[col] = vals.length ? Math.max(...vals) : 0;\n }\n return result;\n });\n columns = Object.keys(data[0] || {});\n }\n\n // Save processed data as new dataset\n const newName = (ds.rows[0] as any).name + \"_processed\";\n const newDs = await sqlite.execute({\n sql: \"INSERT INTO datasets (name, source, row_count, col_count, columns_json) VALUES (?, ?, ?, ?, ?)\",\n args: [newName, \"preprocessed\", data.length, columns.length, JSON.stringify(columns)],\n });\n const newId = Number(newDs.lastInsertRowid);\n\n const batchSize = 50;\n for (let i = 0; i < data.length; i += batchSize) {\n const batch = data.slice(i, i + batchSize);\n await sqlite.batch(\n batch.map((row, idx) => ({\n sql: \"INSERT INTO dataset_rows (dataset_id, row_index, data_json) VALUES (?, ?, ?)\",\n args: [newId, i + idx, JSON.stringify(row)],\n })),\n );\n }\n\n return c.json({ id: newId, name: newName, rows: data.length, columns });\n } catch (err: any) {\n return c.json({ error: err.message }, 500);\n }\n});\n",[],[19,92,253],"5e7da90e-56af-11f1-a47c-ee650bb23af1","predict.ts","cd8b3d76-56ae-11f1-8274-ee650bb23af1",26,["D",1779544662965],"import { Hono } from \"npm:hono\";\nimport { sqlite } from \"../db.ts\";\n\nexport const predictRoutes = new Hono();\n\n// Create a prediction page from a model\npredictRoutes.post(\"/pages\", async (c) => {\n try {\n const { modelId, name, description } = await c.req.json<{\n modelId: number;\n name: string;\n description?: string;\n }>();\n const model = await sqlite.execute({ sql: \"SELECT * FROM regression_models WHERE id = ?\", args: [modelId] });\n if (!model.rows.length) return c.json({ error: \"Model not found\" }, 404);\n\n const result = await sqlite.execute({\n sql: \"INSERT INTO prediction_pages (model_id, name, description) VALUES (?, ?, ?)\",\n args: [modelId, name, description || \"\"],\n });\n return c.json({ id: Number(result.lastInsertRowid), modelId, name });\n } catch (err: any) {\n return c.json({ error: err.message }, 500);\n }\n});\n\n// List prediction pages\npredictRoutes.get(\"/pages\", async (c) => {\n const result = await sqlite.execute(`\n SELECT p.*, m.equation, m.method, m.features, m.target, m.coefficients, m.intercept, m.r_squared\n FROM prediction_pages p\n JOIN regression_models m ON p.model_id = m.id\n WHERE p.is_active = 1\n ORDER BY p.created_at DESC\n `);\n return c.json(\n result.rows.map((r: any) => ({\n ...r,\n features: JSON.parse(r.features || \"[]\"),\n coefficients: JSON.parse(r.coefficients || \"{}\"),\n })),\n );\n});\n\n// Get single page\npredictRoutes.get(\"/pages/:id\", async (c) => {\n const id = c.req.param(\"id\");\n const result = await sqlite.execute({\n sql: `SELECT p.*, m.equation, m.method, m.features, m.target, m.coefficients, m.intercept, m.r_squared, m.adj_r_squared\n FROM prediction_pages p\n JOIN regression_models m ON p.model_id = m.id\n WHERE p.id = ?`,\n args: [+id],\n });\n if (!result.rows.length) return c.json({ error: \"Not found\" }, 404);\n const r: any = result.rows[0];\n return c.json({\n ...r,\n features: JSON.parse(r.features || \"[]\"),\n coefficients: JSON.parse(r.coefficients || \"{}\"),\n });\n});\n\n// Make a prediction\npredictRoutes.post(\"/run\", async (c) => {\n try {\n const { pageId, inputs } = await c.req.json<{\n pageId: number;\n inputs: Record;\n }>();\n\n // Get page & model\n const page = await sqlite.execute({\n sql: `SELECT p.*, m.coefficients, m.intercept, m.features, m.target\n FROM prediction_pages p JOIN regression_models m ON p.model_id = m.id WHERE p.id = ?`,\n args: [pageId],\n });\n if (!page.rows.length) return c.json({ error: \"Page not found\" }, 404);\n\n const r: any = page.rows[0];\n const coefficients: Record = JSON.parse(r.coefficients);\n const features: string[] = JSON.parse(r.features);\n const intercept: number = r.intercept;\n\n // Compute prediction\n let predicted = intercept;\n for (const f of features) {\n if (inputs[f] === undefined) return c.json({ error: `Missing input: ${f}` }, 400);\n predicted += coefficients[f] * inputs[f];\n }\n\n // Save prediction\n const saveResult = await sqlite.execute({\n sql: \"INSERT INTO predictions (page_id, model_id, input_json, predicted_value) VALUES (?, ?, ?, ?)\",\n args: [pageId, r.model_id, JSON.stringify(inputs), predicted],\n });\n\n return c.json({\n predictionId: Number(saveResult.lastInsertRowid),\n predicted,\n inputs,\n target: r.target,\n });\n } catch (err: any) {\n return c.json({ error: err.message }, 500);\n }\n});\n\n// Update actual value for a prediction\npredictRoutes.put(\"/actual/:predictionId\", async (c) => {\n try {\n const predictionId = +c.req.param(\"predictionId\");\n const { actualValue } = await c.req.json<{ actualValue: number }>();\n\n const pred = await sqlite.execute({\n sql: \"SELECT predicted_value FROM predictions WHERE id = ?\",\n args: [predictionId],\n });\n if (!pred.rows.length) return c.json({ error: \"Prediction not found\" }, 404);\n\n const predicted = (pred.rows[0] as any).predicted_value;\n const error = actualValue - predicted;\n\n await sqlite.execute({\n sql: \"UPDATE predictions SET actual_value = ?, error = ? WHERE id = ?\",\n args: [actualValue, error, predictionId],\n });\n\n return c.json({ predictionId, predicted, actual: actualValue, error });\n } catch (err: any) {\n return c.json({ error: err.message }, 500);\n }\n});\n\n// Get predictions history for a page\npredictRoutes.get(\"/history/:pageId\", async (c) => {\n const pageId = c.req.param(\"pageId\");\n const result = await sqlite.execute({\n sql: `SELECT * FROM predictions WHERE page_id = ? ORDER BY created_at DESC LIMIT 200`,\n args: [+pageId],\n });\n return c.json(\n result.rows.map((r: any) => ({\n ...r,\n input_json: JSON.parse(r.input_json || \"{}\"),\n })),\n );\n});\n\n// Get accuracy stats for a page\npredictRoutes.get(\"/accuracy/:pageId\", async (c) => {\n const pageId = c.req.param(\"pageId\");\n const result = await sqlite.execute({\n sql: \"SELECT predicted_value, actual_value, error FROM predictions WHERE page_id = ? AND actual_value IS NOT NULL\",\n args: [+pageId],\n });\n\n const rows: any[] = result.rows;\n if (!rows.length) return c.json({ message: \"No actual values recorded yet\", count: 0 });\n\n const errors = rows.map((r) => r.error);\n const absErrors = errors.map(Math.abs);\n const mape = rows.reduce((s: number, r: any) => {\n return s + (r.actual_value !== 0 ? Math.abs(r.error / r.actual_value) : 0);\n }, 0) / rows.length * 100;\n\n const meanErr = errors.reduce((a: number, b: number) => a + b, 0) / errors.length;\n const mae = absErrors.reduce((a: number, b: number) => a + b, 0) / absErrors.length;\n const mse = errors.reduce((s: number, e: number) => s + e * e, 0) / errors.length;\n const rmse = Math.sqrt(mse);\n\n return c.json({\n count: rows.length,\n meanError: meanErr,\n mae,\n mse,\n rmse,\n mape: mape,\n });\n});\n",[],[19,92,261],"54f21e06-56af-11f1-be57-ee650bb23af1","data.ts","9f8e0a2a-56ae-11f1-8228-ee650bb23af1",22,["D",1779544646951],"import { Hono } from \"npm:hono\";\nimport { sqlite } from \"../db.ts\";\nimport * as XLSX from \"npm:xlsx@0.18.5\";\n\nexport const dataRoutes = new Hono();\n\n// List all datasets\ndataRoutes.get(\"/datasets\", async (c) => {\n const result = await sqlite.execute(\"SELECT * FROM datasets ORDER BY created_at DESC\");\n return c.json(result.rows);\n});\n\n// Get dataset detail with rows\ndataRoutes.get(\"/datasets/:id\", async (c) => {\n const id = c.req.param(\"id\");\n const ds = await sqlite.execute({ sql: \"SELECT * FROM datasets WHERE id = ?\", args: [+id] });\n if (!ds.rows.length) return c.json({ error: \"Not found\" }, 404);\n const rows = await sqlite.execute({\n sql: \"SELECT row_index, data_json FROM dataset_rows WHERE dataset_id = ? ORDER BY row_index LIMIT 500\",\n args: [+id],\n });\n return c.json({\n ...ds.rows[0],\n columns: JSON.parse((ds.rows[0] as any).columns_json || \"[]\"),\n rows: rows.rows.map((r: any) => ({ index: r.row_index, data: JSON.parse(r.data_json) })),\n });\n});\n\n// Upload Excel file\ndataRoutes.post(\"/upload\", async (c) => {\n try {\n const formData = await c.req.formData();\n const file = formData.get(\"file\") as File;\n if (!file) return c.json({ error: \"No file provided\" }, 400);\n\n const buffer = await file.arrayBuffer();\n const workbook = XLSX.read(new Uint8Array(buffer), { type: \"array\" });\n const sheetName = workbook.SheetNames[0];\n const sheet = workbook.Sheets[sheetName];\n const jsonData: Record[] = XLSX.utils.sheet_to_json(sheet);\n\n if (!jsonData.length) return c.json({ error: \"Empty file\" }, 400);\n\n const columns = Object.keys(jsonData[0]);\n const name = file.name.replace(/\\.[^.]+$/, \"\");\n\n // Insert dataset metadata\n const dsResult = await sqlite.execute({\n sql: \"INSERT INTO datasets (name, source, row_count, col_count, columns_json) VALUES (?, ?, ?, ?, ?)\",\n args: [name, \"upload\", jsonData.length, columns.length, JSON.stringify(columns)],\n });\n const datasetId = Number(dsResult.lastInsertRowid);\n\n // Insert rows in batches\n const batchSize = 50;\n for (let i = 0; i < jsonData.length; i += batchSize) {\n const batch = jsonData.slice(i, i + batchSize);\n await sqlite.batch(\n batch.map((row, idx) => ({\n sql: \"INSERT INTO dataset_rows (dataset_id, row_index, data_json) VALUES (?, ?, ?)\",\n args: [datasetId, i + idx, JSON.stringify(row)],\n })),\n );\n }\n\n return c.json({ id: Number(datasetId), name, rows: jsonData.length, columns });\n } catch (err: any) {\n return c.json({ error: err.message }, 500);\n }\n});\n\n// Manual data input / SQL-like import\ndataRoutes.post(\"/import-json\", async (c) => {\n try {\n const { name, data } = await c.req.json<{ name: string; data: Record[] }>();\n if (!data?.length) return c.json({ error: \"No data\" }, 400);\n\n const columns = Object.keys(data[0]);\n const dsResult = await sqlite.execute({\n sql: \"INSERT INTO datasets (name, source, row_count, col_count, columns_json) VALUES (?, ?, ?, ?, ?)\",\n args: [name || \"imported\", \"json\", data.length, columns.length, JSON.stringify(columns)],\n });\n const datasetId = Number(dsResult.lastInsertRowid);\n\n const batchSize = 50;\n for (let i = 0; i < data.length; i += batchSize) {\n const batch = data.slice(i, i + batchSize);\n await sqlite.batch(\n batch.map((row, idx) => ({\n sql: \"INSERT INTO dataset_rows (dataset_id, row_index, data_json) VALUES (?, ?, ?)\",\n args: [datasetId, i + idx, JSON.stringify(row)],\n })),\n );\n }\n\n return c.json({ id: datasetId, name, rows: data.length, columns });\n } catch (err: any) {\n return c.json({ error: err.message }, 500);\n }\n});\n\n// Delete dataset\ndataRoutes.delete(\"/datasets/:id\", async (c) => {\n const id = c.req.param(\"id\");\n await sqlite.batch([\n { sql: \"DELETE FROM dataset_rows WHERE dataset_id = ?\", args: [+id] },\n { sql: \"DELETE FROM datasets WHERE id = ?\", args: [+id] },\n ]);\n return c.json({ ok: true });\n});\n",[],[19,92,269],"67c409f0-56ae-11f1-8e14-ee650bb23af1",["D",1779544249028],"legacyEnvVars","httpPrivacy","description","Starter template with client-side React & Hono server","imageUrl","userId","6edec025-959e-47c2-ad6f-9a1be3b237f3","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","024eb136-bcd1-41e7-a89c-4a73af7907c6","tursoName","67c409f056ae11f18e14ee650bb23af1","tursoHostname","67c409f056ae11f18e14ee650bb23af1-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789492855745],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_323":319},"org",{"_11":12,"_317":-5,"_318":319,"_283":284,"_320":321,"_322":51},"branch",{"_17":263,"_13":16,"_36":70,"_42":276,"_45":37,"_46":313,"_314":53,"_315":43,"_316":57,"_58":14,"_54":12},88,"forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18ycGhUZFFQaG9weDBrQXdjMkZZVlNVRmh4cHkifQ","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_36":276,"_13":14,"_38":433,"_49":-5,"_278":51,"_52":53,"_279":53,"_280":281,"_282":-5,"_283":284,"_285":107,"_286":74,"_287":-5,"_288":-5,"_289":76,"_56":290,"_291":292,"_293":294,"_295":434,"_297":-5,"_298":299,"_300":299,"_301":302,"_303":302,"_304":302,"_305":299,"_306":299,"_307":435,"_309":436,"_311":437,"_50":51},[367,376,387,388],"files",[367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388],"counts",{"_358":76,"_359":110,"_360":76,"_35":361,"_362":363},[352,353,354],{"_36":98,"_69":70,"_65":68,"_13":19,"_79":-5,"_77":96,"_17":76,"_67":-5,"_38":350,"_71":34,"_82":-5,"_18":351},"upstreamProject",{"_36":43,"_13":59,"_280":281,"_282":347,"_52":53,"_307":348},"upstreamBranch",{"_36":37,"_38":345,"_40":346,"_13":16,"_42":43,"_17":44,"_45":-5,"_46":-5,"_47":48,"_49":-5,"_50":51,"_52":53,"_54":55,"_56":57,"_58":59},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1740674013689],["D",1785420707976],"https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/64dc00cc-94d9-47dd-81b1-dde02610d900/square512?exp=1789534799&sig=2fe932419d898cd124d0961cab25a5a9c3bd76c8b30cb3b9e71257c7b34e60a2",{"_11":55,"_323":349},"https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/129cab32-3bd7-4c3e-f39b-f12900c76100/square512?exp=1789534799&sig=94d49ad984a50880ef894a3794e08842e7b9b626be771ff48da114d7d9a149ed",["D",1779544263876],[19],{"_36":91,"_13":92,"_65":93,"_67":68,"_69":70,"_71":94,"_73":74,"_38":95,"_17":76,"_77":96,"_79":-5,"_81":51,"_82":-5,"_18":357},{"_36":84,"_13":85,"_65":86,"_67":68,"_69":70,"_71":87,"_73":74,"_38":88,"_17":76,"_77":78,"_79":89,"_81":51,"_82":-5,"_18":356},{"_36":63,"_13":64,"_65":66,"_67":68,"_69":70,"_71":72,"_73":74,"_38":75,"_17":76,"_77":78,"_79":80,"_81":51,"_82":-5,"_18":355},[19,64],[19,85],[19,92],"pulls","branches","forks",{"_364":76,"_366":76},"connections",{"_364":76,"_365":76},"count","unfilledCount","emptyCount",{"_36":98,"_13":19,"_65":68,"_67":-5,"_69":70,"_71":34,"_73":74,"_38":216,"_17":76,"_77":96,"_79":-5,"_81":51,"_82":-5,"_113":431,"_18":432},{"_36":91,"_13":92,"_65":93,"_67":68,"_69":70,"_71":94,"_73":74,"_38":228,"_17":76,"_77":96,"_79":-5,"_81":51,"_82":-5,"_113":429,"_18":430},{"_36":268,"_13":269,"_65":270,"_67":93,"_69":70,"_71":271,"_73":74,"_38":272,"_17":108,"_77":78,"_79":273,"_81":51,"_82":-5,"_113":427,"_18":428},{"_36":260,"_13":261,"_65":262,"_67":93,"_69":70,"_71":263,"_73":74,"_38":264,"_17":108,"_77":78,"_79":265,"_81":51,"_82":-5,"_113":425,"_18":426},{"_36":252,"_13":253,"_65":254,"_67":93,"_69":70,"_71":255,"_73":74,"_38":256,"_17":110,"_77":78,"_79":257,"_81":51,"_82":-5,"_113":423,"_18":424},{"_36":244,"_13":245,"_65":246,"_67":93,"_69":70,"_71":247,"_73":74,"_38":248,"_17":76,"_77":78,"_79":249,"_81":51,"_82":-5,"_113":421,"_18":422},{"_36":236,"_13":237,"_65":238,"_67":93,"_69":70,"_71":239,"_73":74,"_38":240,"_17":110,"_77":78,"_79":241,"_81":51,"_82":-5,"_113":419,"_18":420},{"_36":84,"_13":85,"_65":86,"_67":68,"_69":70,"_71":87,"_73":74,"_38":225,"_17":76,"_77":78,"_79":89,"_81":51,"_82":-5,"_113":417,"_18":418},{"_36":63,"_13":64,"_65":66,"_67":68,"_69":70,"_71":72,"_73":74,"_38":222,"_17":76,"_77":78,"_79":80,"_81":51,"_82":-5,"_113":415,"_18":416},{"_36":123,"_13":124,"_65":125,"_67":-5,"_69":70,"_71":110,"_73":74,"_38":126,"_17":76,"_77":96,"_79":-5,"_81":51,"_82":-5,"_113":413,"_18":414},{"_36":156,"_13":157,"_65":158,"_67":125,"_69":70,"_71":110,"_73":74,"_38":159,"_17":76,"_77":96,"_79":-5,"_81":51,"_82":-5,"_113":411,"_18":412},{"_36":208,"_13":209,"_65":210,"_67":158,"_69":70,"_71":211,"_73":74,"_38":212,"_17":110,"_77":78,"_79":213,"_81":51,"_82":-5,"_113":409,"_18":410},{"_36":200,"_13":201,"_65":202,"_67":158,"_69":70,"_71":203,"_73":74,"_38":204,"_17":76,"_77":78,"_79":205,"_81":51,"_82":-5,"_113":407,"_18":408},{"_36":192,"_13":193,"_65":194,"_67":158,"_69":70,"_71":195,"_73":74,"_38":196,"_17":76,"_77":78,"_79":197,"_81":51,"_82":-5,"_113":405,"_18":406},{"_36":184,"_13":185,"_65":186,"_67":158,"_69":70,"_71":187,"_73":74,"_38":188,"_17":76,"_77":78,"_79":189,"_81":51,"_82":-5,"_113":403,"_18":404},{"_36":176,"_13":177,"_65":178,"_67":158,"_69":70,"_71":179,"_73":74,"_38":180,"_17":76,"_77":78,"_79":181,"_81":51,"_82":-5,"_113":401,"_18":402},{"_36":168,"_13":169,"_65":170,"_67":158,"_69":70,"_71":171,"_73":74,"_38":172,"_17":76,"_77":78,"_79":173,"_81":51,"_82":-5,"_113":399,"_18":400},{"_36":149,"_13":150,"_65":151,"_67":125,"_69":70,"_71":110,"_73":74,"_38":152,"_17":76,"_77":24,"_79":153,"_81":51,"_82":-5,"_113":397,"_18":398},{"_36":141,"_13":142,"_65":143,"_67":125,"_69":70,"_71":144,"_73":74,"_38":145,"_17":110,"_77":24,"_79":146,"_81":51,"_82":-5,"_113":395,"_18":396},{"_36":133,"_13":134,"_65":135,"_67":125,"_69":70,"_71":136,"_73":74,"_38":137,"_17":110,"_77":78,"_79":138,"_81":51,"_82":-5,"_113":393,"_18":394},{"_36":116,"_13":117,"_65":118,"_67":-5,"_69":70,"_71":110,"_73":74,"_38":119,"_17":76,"_77":24,"_79":120,"_81":51,"_82":-5,"_113":391,"_18":392},{"_36":105,"_13":106,"_65":107,"_67":-5,"_69":70,"_71":108,"_73":74,"_38":109,"_17":110,"_77":111,"_79":112,"_81":51,"_82":-5,"_113":389,"_18":390},[],[106],[],[117],[],[124,134],[],[124,142],[],[124,150],[],[124,157,169],[],[124,157,177],[],[124,157,185],[],[124,157,193],[],[124,157,201],[],[124,157,209],[378,379,380,381,382,383],[124,157],[377,384,385,386],[124],[],[19,64],[],[19,85],[],[19,92,237],[],[19,92,245],[],[19,92,253],[],[19,92,261],[],[19,92,269],[369,370,371,372,373],[19,92],[368,374,375],[19],["D",1779544249028],["D",1789492855745],{"_11":12,"_323":319},{"_11":12,"_317":-5,"_318":319,"_283":284,"_320":321,"_322":51},{"_17":263,"_13":16,"_36":70,"_42":276,"_45":37,"_46":313,"_314":53,"_315":43,"_316":57,"_58":14,"_54":12},"ctx",{"_307":-5,"_342":471,"_472":473,"_474":475,"_476":51,"_477":51,"_478":51,"_479":74,"_480":-5,"_481":-7,"_482":-7,"_483":76,"_484":51,"_485":51,"_486":-5,"_487":51,"_488":51,"_489":51,"_490":-5},"ENV",{"_442":443,"_444":445,"_446":16,"_447":448,"_449":450,"_451":452,"_453":454,"_455":456,"_457":458,"_459":460,"_461":462,"_463":464,"_465":466,"_467":468,"_469":470},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]