diff options
| -rw-r--r-- | SI/Dashboard.md | 27 | ||||
| -rw-r--r-- | SI/Resource/Data Science/Machine Learning/Machine Learning.md | 14 | ||||
| -rw-r--r-- | SI/Resource/Data Science/SQL/MySQL.md | 28 |
3 files changed, 49 insertions, 20 deletions
diff --git a/SI/Dashboard.md b/SI/Dashboard.md index 43dabd0..ea9865e 100644 --- a/SI/Dashboard.md +++ b/SI/Dashboard.md @@ -12,33 +12,30 @@ cssclasses: # Dashboard -## Contents - -### Table of contents - -<!-- toc --> - - ### š [House]() + - š° Budget - [[Q1 2024]] - - ## š Grocery - - lš³ Transaction - - hello -- ### š¤ Personal - - - ## š”[Archive](file:////Users/si/Documents/SI/Archive) - - ## āļø [Area](file:////Users/si/Documents/SI/Area) - - ## š [Projects](file:////Users/si/Documents/SI/Project) - - ## š [Resource](file:////Users/si/Documents/SI/Resource) + - #### š Grocery + - š³ Transaction + +- ### š¤ [Personal]() + + - #### š”[Archive](file:////Users/si/Documents/SI/Archive) + - #### āļø [Area](file:////Users/si/Documents/SI/Area) + - #### š [Projects](file:////Users/si/Documents/SI/Project) + - #### š [Resource](file:////Users/si/Documents/SI/Resource) - ā
[To-do](file:////Users/si/Documents/SI/To-do) `$=dv.list(dv.pages('"To-do"').sort(f=>f.file.name,"desc").limit(4).file.link)` - ### š¢ [School]() + - š [Class]() `$=dv.list(dv.pages('"Resource"').sort(f=>f.file.mtime.ts,"desc").limit(4).file.link)` - š¼ [Project]() - āļø [Assignment]() `$=dv.list(dv.pages('#assignment').sort(f=>f.file.mtime.ts,"desc").file.link)` + - ### š§ Life Progress ```dataviewjs diff --git a/SI/Resource/Data Science/Machine Learning/Machine Learning.md b/SI/Resource/Data Science/Machine Learning/Machine Learning.md index 7d39736..6dbb5e8 100644 --- a/SI/Resource/Data Science/Machine Learning/Machine Learning.md +++ b/SI/Resource/Data Science/Machine Learning/Machine Learning.md @@ -10,19 +10,21 @@ tags: # Machine Learning +## Definition + Machine Learning (ML) is a subset of artificial intelligence (AI) that focuses on the development of systems and algorithms that can learn from and make decisions or predictions based on data. The core idea is to enable a machine to make intelligent decisions or predictions without being explicitly programmed to perform the task. -## Machine +### Machine Machine is a model or a function derived from data given by human -## Learning +### Learning Learning is to find the best model represented data, meaning optimization of parameter - Optimization of parameter: By statistical method or [[Gradient descent | gradient descent]] -## Goal +### Goal [[Optimization]]: Find optimal parameters @@ -30,7 +32,9 @@ Learning is to find the best model represented data, meaning optimization of par - A model with the smallest difference between predictions $\hat{y}$ and actual values $y$ - A model parameter makes the smallest loss -## Supervised Learning +## Types of learning + +### Supervised Learning 1. [[Regression]] - [[Linear Regression]] and [[Nonlinear Regression]] @@ -46,7 +50,7 @@ Learning is to find the best model represented data, meaning optimization of par - [[Bagging]] - [[Boosting]] -## Unsupervised Learning +### Unsupervised Learning 1. [[Preprocessing]] - [[Principal Component Analysis]] ([[Principal Component Analysis |PCA]]) diff --git a/SI/Resource/Data Science/SQL/MySQL.md b/SI/Resource/Data Science/SQL/MySQL.md index 992ea5d..abec6ec 100644 --- a/SI/Resource/Data Science/SQL/MySQL.md +++ b/SI/Resource/Data Science/SQL/MySQL.md @@ -19,6 +19,34 @@ tags: <!-- toc --> +- [Variables](#variables) +- [Table](#table) +- [DDL (Data Definition Language) - CREATE, ALTER, DROP, TRUNCATE](#ddl-data-definition-language---create-alter-drop-truncate) +- [DML (Data Manipulation Language): UPDATE commands (UPDATE, INSERT, DELETE) & Query command (SELECT)](#dml-data-manipulation-language-update-commands-update-insert-delete--query-command-select) + - [UPDATE commands](#update-commands) + - [Query command](#query-command) + - [FROM clause](#from-clause) + - [ORDER BY](#order-by) + - [LIMIT](#limit) + - [WHERE clause: Condition / Predicates](#where-clause-condition--predicates) + - [Filtering](#filtering) + - [Functions](#functions) + - [Date](#date) + - [Date Format](#date-format) + - [GROUP BY](#group-by) + - [Division & Analysis](#division--analysis) + - [Division](#division) + - [Before/After](#beforeafter) + - [Border](#border) + - [Merge](#merge) + - [Sub Query / Temporary Table](#sub-query--temporary-table) + - [Multi Columns](#multi-columns) + - [Uni Column & Uni Data](#uni-column--uni-data) + - [VIEW / WITH](#view--with) + - [Custom Function](#custom-function) + +<!-- tocstop --> + ## Variables ```sql |