Telegram Web Link
Excel Vs SQL Vs Python
❀6πŸ‘3
Basic SQL Commands
❀2
πŸ“š Data Science Riddle

Why do we use Batch Normalization?
Anonymous Quiz
32%
Speeds up training
40%
Prevents overfitting
8%
Adds non-linearity
20%
Reduces dataset size
❀3
LLM Cheatsheet
❀5
πŸ“š Data Science Riddle

Your object detection model misses small objects. Easiest fix?
Anonymous Quiz
24%
Use larger input images
27%
Add more classes
35%
Reduce learning rate
14%
Train longer
πŸ€– AI that creates AI: ASI-ARCH finds 106 new SOTA architectures

ASI-ARCH β€” experimental ASI that autonomously researches and designs neural nets. It hypothesizes, codes, trains & tests models.

πŸ’‘ Scale:
1,773 experiments β†’ 20,000+ GPU-hours.
Stage 1 (20M params, 1B tokens): 1,350 candidates beat DeltaNet.
Stage 2 (340M params): 400 models β†’ 106 SOTA winners.
Top 5 trained on 15B tokens vs Mamba2 & Gated DeltaNet.

πŸ“Š Results:
PathGateFusionNet: 48.51 avg (Mamba2: 47.84, Gated DeltaNet: 47.32).
BoolQ: 60.58 vs 60.12 (Gated DeltaNet).
Consistent gains across tasks.
πŸ” Insights:
Prefers proven tools (gating, convs), refines them iteratively.
Ideas come from: 51.7% literature, 38.2% self-analysis, 10.1% originality.
SOTA share: self-analysis ↑ to 44.8%, literature ↓ to 48.6%.

@datascience_bds
❀3
πŸš€ Databricks Tip: REPLACE vs MERGE

When updating Delta tables, you’ve got two powerful options:

πŸ”Ή REPLACE TABLE … ON
πŸ“š Like throwing away the entire library and rebuilding it.
- Drops the old table & recreates it.
- Schema + data = fully replaced.
- ⚑ Super fast but destructive (old data gone).
- βœ… Best for full refreshes or schema changes.

πŸ”Ή MERGE
πŸ“– Like updating only the books that changed.
- Works row by row.
- Updates, inserts, or deletes specific records.
- πŸ” Preserves unchanged data.
- βœ… Best for incremental updates or CDC (Change Data Capture).

βš–οΈ Key Difference
- REPLACE = Start fresh with a new table.
- MERGE = Surgically update rows without losing the rest.

πŸ‘‰ Rule of thumb:
Use REPLACE for full rebuilds,
Use MERGE for incremental upserts.

#Databricks #DeltaLake
❀1
2025/10/22 09:57:25
Back to Top
HTML Embed Code: