Read time - 5 mins
If you’re wasting hours with manual processes in Excel, read on.
Working with data can be a nightmare.
Especially poorly formatted data that you’ve been handed by someone else!
Without realising, we can spend hours re-formatting data. Then we get to the end of the day, and we feel like we’ve got nothing done.
Yes, if you’re an Excel pro, you can probably speed up the process a bit.
But do the rest of your team know how to do this?
Wouldn’t it be nice if you could do the work once, and then hand it off to someone else who can click a few buttons and get the work done in 60 seconds?
So I set myself a task…
Creating a Python Spreadsheet App
The scenario:
- Supplier sends a CSV spreadsheet of poorly formatted data
- Individual spends an hour re-formatting and tidying up the data
- Very difficult to train other team members on how to follow the same process
The task:
- Use AI to create the Python code
- Automate the process
- Create an app that anyone can use to achieve the same thing
The tools:
- AI Chatbot
- Python
- Visual Studio Code
FYI - The AI model I used was GPT-4 at the time, and I used the Visual Studio Code desktop version.
If you can’t download applications, you can also use Google Colab, or GitHub Codespaces (VSC Online), you just might not be able to generate the app at the end.
Here’s the framework I used:
The Framework
1. Context
I always tend to start with a simple question to set the context.
|