I need a straightforward script that automatically pulls medication cost and other detail from openprescribing.net/dmd. Input: simple text file with the code of the drug I want output: simple Excel or csv file I plan to run the app monthly. Scope • Access openprescribing.net/dmd url with appended drug code (from input file). • Extract every relevant column—drug name, pack size, price, date stamp, and any other cost fields shown on the page or in its underlying JSON. • Output to a single .xlsx workbook, one sheet per run (timestamped) or one rolling sheet with an updated “last refreshed” column—whichever keeps the file lightweight and easy to read. Automation • Provide a runnable Python script (requests + pandas/BeautifulSoup/Scrapy—your choice) with clear comments. • Include a short README explaining setup and how to schedule a monthly job with Windows Task Scheduler or a Linux cron. Acceptance • First delivery: script, README, and a sample Excel file generated from the latest data. • I’ll test it on my machine; once it runs end-to-end and the Excel structure matches the sample, the job is complete. This is a focused data-extraction task, so please keep the solution lean—no heavyweight frameworks unless they truly simplify the job.