BestPromptFinder

Python: Download a CSV From a URL

Quality, usefulness and confidence are AI evaluations out of 100 — not user ratings. Community results come from visitors' "worked / didn't work" votes below. How scoring works →

The prompt

Write a production-ready Python function that downloads a CSV file from a URL and saves it locally.

Requirements
- Signature: `download_csv(url: str, dest_path: str, timeout: int = 30) -> str` returning the saved path.
- Use `requests` with streaming (`iter_content`, 1 MB chunks) so large files don't load into memory.
- Raise a clear exception with the status code on non-2xx responses; handle timeouts and connection errors.
- Write to a temporary file first, then rename, so a failed download never leaves a half file.
- Create parent folders if missing.

Output
1. The function with docstring and type hints.
2. A short usage example.
3. How to load the result into pandas (`pd.read_csv`), including an encoding fallback.
4. Two pytest tests using a mocked response.

Why this prompt

• AI-graded 94/100 for quality and structure
• Written for GPT-5.6

Source

Created by BestPromptFinder — editorial prompt, not user-generated. See our content & source policy.

Related Coding prompts