The Claude Playbook Top Engineers Use
Work smarter. Ship faster.
AI won't replace great developers—but developers who know how to use AI will outperform those who don't. The gap is growing every day.
Unlock 50+ practical Claude coding tips, real-world workflows, and productivity hacks inspired by the way Anthropic engineers build software.
Messy data is one of those quiet time-drains nobody warns you about. You export a spreadsheet, and suddenly the dates are in three formats, the numbers have stray dollar signs, and there are duplicate rows you never asked for. Today we walk through a simple way to hand that cleanup to ChatGPT, then round out with four tools worth a look. Let's get into it.
Today's Productivity
Clean and prep messy data with ChatGPT
Raw exports rarely arrive ready to use. Instead of fixing formatting by hand, you can describe the problems and let ChatGPT return a cleaned file, along with a note on exactly what it changed. Here is the workflow.
Step one: Upload your CSV or spreadsheet into ChatGPT.
Step two: Give it a clear prompt describing what is wrong and what you want back. Something like the prompt below works well.
Clean @file name.csv
What's wrong:
dates are mixed between MM/DD/YYYY and YYYY-MM-DD
currency values include $, commas, and blank cells
a few duplicate customer rows came from repeated exports
region and category names use several aliases
there are pasted summary rows mixed into the data
What I want:
write a cleaned CSV and keep the original file unchanged
use one date format
keep blank currency cells blank
preserve source row IDs when possible
add a short data-quality note with rows you changed, removed, or could not clean confidently
Step three: Wait for the cleaned CSV, then read the data-quality note to see every change, removal, or flagged row before you trust it.
Step four: Download the file and use it for analysis, reporting, or importing into your other tools.
One caveat: always spot-check the output against your original. ChatGPT is fast, but it can misread an edge case, so the data-quality note is there to keep you honest, not to replace a quick review.
Today's Trends Tool
Four tools catching our attention this week.
Lemon turns spoken thoughts into clear, well-structured prompts across your AI apps, and claims to be far quicker than typing them out. Handy if you think faster than you type, though voice tools can stumble on jargon.
Neato rewrites vague prompts into sharper, expert-level ones. A useful nudge when you know what you want but not quite how to ask for it.
Photo2Video turns a photo, illustration, or plain text prompt into finished motion. Worth a try for quick social clips, with the usual caveat that AI video still needs a human eye.
Chatcut lets you edit video through ChatGPT on desktop and web, no prior editing experience required. Promising for anyone put off by traditional editing software.
What 200K+ Engineers Read to Stay Ahead
Your GitHub stars won't save you if you're behind on tech trends.
That's why over 200K engineers read The Code to spot what's coming next.
Get curated tech news, tools, and insights twice a week
Learn about emerging trends you can leverage at work in just 5 mins a day
Become the engineer who always knows what's next