13Topic 13 of 16
Everyday tasks
Practical jobs: spreadsheets, transcripts, summaries, data analysis with AI.
- 13.01 Clean Up Messy Spreadsheet Data with ChatGPT Upload the CSV to ChatGPT data analysis, describe the mess once, and get back a cleaned file plus a repeatable formula or script. Limits and traps. 3 min
- 13.02 How to Analyze a CSV with ChatGPT Data Analysis Upload a spreadsheet, get it cleaned, charted, and summarized — plus the limits worth knowing before you trust the numbers. 3 min
- 13.03 How to Summarize a PDF Locally with Ollama Extract PDF text with pypdf, chunk it, summarize each chunk through the local Ollama API, and merge — about 30 lines, nothing uploaded. 3 min
- 13.04 How to Summarize a YouTube Video with AI Pull the transcript with yt-dlp --convert-subs srt, then hand the .srt file to Claude or ChatGPT with a prompt that gives you timestamps, not mush. 3 min
Keep going