๐Ÿง  Daily Study Log [2025-08-02]
From SQL theory to public leaderboard tuning โ€” today was about deepening fundamentals and refining experimental pipelines.


๐Ÿงช Competition โ€” Electricity Usage Forecasting (DACON)

Three new experiments focused on segmentation and weighted ensemble tuning.

19. Model Per Building Type

Trained separate models for each building type to better reflect distinct patterns.

Building Type Validation SMAPE
Hotel 15.1100
Commercial 5.3154
Hospital 7.5401
School 9.7351
Others 21.6569
Apartment 29.2067
Research Lab 12.0202
Department Store 14.3794
IDC (Telco) 3.7473
Public 10.9071

โ†’ Public LB: 76.7876 (aggregated submission)


20. Weighted Voting Regressor (Optuna-Tuned)

Applied manual weights (XGB: 0.5, LGBM: 0.3, GBR: 0.2) after tuning each model individually with Optuna.


21. Time-Split Voting Models

Segmented data by time of day:

Trained separate VotingRegressor for each to reflect different load patterns.


๐Ÿ“ SQL Study

Focused on TCL (Transaction Control Language) and DCL (Data Control Language):


๐Ÿ’ก Project Idea โ€” AI Pottery Assistant

Proposed a creative concept: an intelligent assistant that analyzes pottery shapes, designs, and user prompts to assist in creative ceramic design.

๐Ÿ”— View full idea


๐Ÿ“„ Paper Review โ€” Explainable Skeletal Assessment for Martial Arts

โœ… Finished Day 4: Experiments, Results, and SHAP-based interpretation.

Key Takeaways:

๐Ÿ”— View summary


๐Ÿงช Personal Project โ€” bass_seeker

Moved away from Spotify API and focused on audio-feature-based recommendation using .wav data.
Tested extraction pipeline using librosa and spectral centroid/bandwidth.
๐Ÿ“ Project: bass_seeker


๐Ÿค Research Club โ€” Taekwondo Poomsae Evaluation

Set new direction: RLHF-based quantitative evaluation of Taekwondo forms.

Highlights:

๐Ÿ“Œ Read the full summary (in local repo)


โœ… TL;DR

๐Ÿ“ Idea: AI Pottery Assistant โ€” creativity aid for ceramic design
๐Ÿ“ SQL: TCL & DCL studied
๐Ÿ“ Competition: 3 advanced ensemble experiments submitted (Best SMAPE: 11.2358)
๐Ÿ“ Paper: Martial Arts scoring pipeline review completed
๐Ÿ“ Projects: bass_seeker progressed โ€” audio-based pipeline working
๐Ÿ“ Study Group: RLHF-based Taekwondo scoring system planning initiated