I automated repetitive data cleaning tasks at work using ChatGPT API + Python.
- First, wrote a prompt explaining the desired output format to GPT-4
- Read an Excel file with a Python script, then called the API
- Wrote the results back to Excel
It took half a day to set up initially, but now I'm saving 4 hours every week. I once again realized the importance of prompt engineering.
I recommend this to anyone with similar concerns.