TELEGRAMSPOT LOOKUP PRACTICE

Turn one lesson into a result: match product codes to prices.
This is original fictional practice data, not a real shop or price list.

YOUR TASK
Use products.csv to fill a price for each code in requests.csv.
Keep the request order. If a code is missing, leave the price blank and
write NOT FOUND. A missing price is not zero.

SPREADSHEET TRACK
Open the two CSV files and copy their columns into separate areas or sheets.
Use an exact-match lookup from your lesson. Treat product codes as text.
Then compare your four result rows with expected.csv.

PYTHON TRACK
Use this after learning loops, dictionaries and basic file reading.
Read the two CSV files with Python's built-in csv module. Match each code,
then print code, price and status in the original request order.
Reference: https://docs.python.org/3/library/csv.html

TRY BEFORE OPENING THE ANSWER
reference.py is a complete answer, including the duplicate-code extension.
Extract the kit to one folder. With Python 3 installed, run:
  python reference.py
Some systems use python3 instead. It reads the two CSV files beside itself
and prints the answer. It does not download anything or change your files.
The answer was run locally with Python 3.12.10 on October 13, 2026.

EXTEND IT
1. Add P105, a product name and a price to products.csv. Request P105.
2. Repeat an existing request. Keep both results in the same order.
3. Add a second P101 with a different price. Report DUPLICATE CODE instead
   of silently choosing one. The supplied expected.csv covers only the
   original data; your extended results should change.

ON A PHONE
Read the data and predict the four results first. The desktop Python track
can wait until you have a Python environment. There is no paid tool needed
for this exercise and no requirement to upload data to an AI service.

SAVE YOUR NEXT STEP
Source lesson: [link]
I can now: [the result I reproduced]
I still need to fix: [one specific case]
Next attempt: [one action]

Created by TelegramSpot. You may use and adapt this practice kit.