ALT SQL contributor challenge with illustrative input. Posts: user 7 published twice, 9 hidden, 12 published. Comments: 7 published, 9 published, 15 hidden, 18 published. Return user_id for anyone with a published post OR comment, once per user, sorted ascending. The answer is withheld. Official LDS logo, Let's Data Science and letsdatascience.com appear below.

ALT Pandas slice example with sorted unique index labels 10, 20, 30, 40, positions 0, 1, 2, 3, and values A, B, C, D. df.loc[10:30] returns A, B, C because its stop label is included. df.iloc[0:2] returns A, B because its stop position is excluded. Official LDS logo, Let's Data Science and letsdatascience.com appear in the footer.

ALT Python recall challenge with an illustrative Python 3 example: a = [[1], [2]]; b = a.copy(); b[0].append(9); b.append([3]). Predict a and b before running the code, and explain which objects each append changes. Blank answer boxes withhold the solution. The footer shows the official LDS logo, Let's Data Science and letsdatascience.com.

ALT Illustrative ML feature timeline: value 2 at 09:55 is eligible for a 10:00 prediction; value 7 at 10:05 is future data. Assume immediate availability. Data Engineer portfolio evidence is an as-of join test excluding the future row. ML Engineer evidence is re-evaluation on corrected features. Responsibilities overlap. Official LDS logo, Let's Data Science and letsdatascience.com appear below.

ALT LLM prompt experiment assignment check. For an illustrative test with one prompt variant per user, user 17 receives A, B, A across three turns in the broken trace and A, A, A in the stable trace. Audit user ID, experiment ID and prompt version. This checks assignment only and does not identify a winning prompt. Official LDS logo, Let's Data Science and letsdatascience.com appear in the footer.

ALT Illustrative fine-tuning data check: held-out name Rex, primary name Milo, story 'Milo helped REX cross the river.' The primary-name check misses the leak; the whole-row check finds REX and rejects the row. Scan request, story and primary name using whole-word matching that ignores case, before writing splits. Official LDS logo, Let's Data Science and letsdatascience.com appear in the footer.

ALT AI portfolio test, labeled conceptual illustration with a mock ticket tool. Approved action: close_ticket(ticket_id=42). Proposed execution: close_ticket(ticket_id=99). The target changed. Expected trace: argument mismatch, block tool call, request new approval. Assert that close_ticket was not called. Keep the approved action, attempted action and tool-call log. Official LDS logo, Let's Data Science and letsdatascience.com appear in the footer.

ALT LoRA architecture for one illustrative linear layer. Input x splits into frozen W0, 4096 by 4096, and trainable A, 16 by 4096, then B, 4096 by 16, scaled by alpha/r. The two outputs add to y. A and B contain 131,072 trainable parameters versus 16,777,216 in the full matrix, 128 times fewer for this layer. These counts do not measure total GPU memory or speed. Official LDS logo, Let's Data Science and letsdatascience.com appear below.

ALT Analytics engineering comparison using illustrative data. Orders (order_id, customer_id) are (101,7) and (102,99); customers are 7 and 8. Unique order IDs pass because 101 and 102 differ. The customer relationship fails because ID 99 is missing from customers. A passing uniqueness test does not prove a valid relationship. Portfolio task: keep this failing case with your tests. The official LDS logo, Let's Data Science and letsdatascience.com appear in the footer.

ALT Two-panel comic explaining k-nearest-neighbors classification. The closest example has label A, followed by two B neighbors. With uniform weights and no distance ties, k=1 predicts A; k=3 predicts B by two votes to one. The lesson is to check k and the voting rule before explaining a prediction. This is an illustrative example, not an accuracy comparison. Official LDS logo, Let's Data Science and letsdatascience.com appear in the footer.

ALT Illustrative embedding search example: query (1,0), candidate A (3,4), candidate B (2,0). Raw dot scores are 3 for A and 2 for B, ranking A first. Cosine scores are 0.60 for A and 1.00 for B, ranking B first. Unit normalization gives A=(0.6,0.8) and B=(1,0), so dot product equals cosine. Check the model's recommended metric and normalization. Official LDS logo, Let's Data Science and letsdatascience.com appear in the footer.

ALT Next-token training worked example with illustrative token IDs [17, 42, 9, 31]. Input tokens[:-1] is [17, 42, 9]; target tokens[1:] is [42, 9, 31]. Arrows connect each input position to its next-token target. At input position 2, the visible prefix [17, 42] predicts 9. Positions are 1-based, with no start or end tokens added. Check the first and last pair before training. Official LDS logo, Let's Data Science and letsdatascience.com appear below.

ALT Python challenge: keep each user's history separate. Illustrative playback_sessions rows (session_id, user_id, watch_seconds): (4,102,300), (1,101,40), (6,102,120), (3,101,60), (2,102,900), (5,101,20). Within each user, sort by session_id and average the current and previous session. Use NaN until that user has two sessions. Return rows sorted by user_id then session_id. What should user_rolling_avg contain? The official LDS logo, Let's Data Science and letsdatascience.com appear below.

ALT LEFT JOIN worked example with illustrative data. Customers 1, 2 and 3; customer 1 has a paid order, customer 2 a pending order, and customer 3 none. Adding AND o.status = 'paid' to ON returns 1 paid, 2 NULL and 3 NULL. Adding WHERE o.status = 'paid' returns only 1 paid. ON decides matches; WHERE filters joined rows. Official LDS logo, Let's Data Science and letsdatascience.com appear below.

ALT Statistics recall challenge: the same four learners take a quiz before and after training. Illustrative scores out of 100: A 60 to 68, B 80 to 81, C 70 to 76, D 90 to 92. Choose a paired or unpaired t-test and name the unit of analysis. Assume the relevant t-test assumptions hold. The footer shows the official LDS logo, Let's Data Science and letsdatascience.com.

ALT One AI reranker, two tests. Applied Scientist: compare relevance with reranking on versus off, keeping queries, candidates and relevance labels fixed; produce a quality comparison and failure examples. ML Engineer: compare low and high request load with the same model version; report tail latency and errors. This is an illustrative project and responsibilities overlap. Official LDS logo, Let's Data Science and letsdatascience.com appear in the footer.