Achieving More With Less: Django’s adventure with ChatGPT
Richard Jiang, FRM, MBA
Data-driven balance sheet optimisation - risk and treasury management
With last minute change to the road trip and skyrocketing rebooking cost, Django had a new plan for his upcoming long weekend - tackle the growing pile of data and analysis files on his laptop.
"Wouldn’t it be the best if I could drop these files into a cloud, let them auto-process, and have everything neatly in one place?," Django thought. “Python is my go-to, but which platform will offer seamless data processing, without compromising on security?"
That’s when he decided to pull in ChatGPT, his recent digital assistant.?
The chat was like having coffee with a friend who knows it all. They compared several offering in the market, and landed on Google Worksheet API, Cloud Bucket, Cloud Functions, Apps script, and navigated the maze of credentials. And of course, there is always a seat for Django’s trusty buddy, Python’s Panda library.
But, to be honest, there were bumps along the way. Integrating multiple CSV files was like mixing oil and water. After some brainstorming and tweaks, they managed to streamline the process. Then came the challenge of managing secure access. Took a few rounds of trial and error, but they got there.
领英推荐
By the end of Monday, the magic happened. Django’s data was organized in a single google worksheet, with a neat little audit trail showing where the data came from. Original files were uploaded and archived to the cloud, ready for the further development of this small project.
The journey had its moments, but it was ChatGPT’s parting words that struck: "Venturing into the vast domain of technology can be challenging, but with curiosity and collaboration, wonders can be achieved."?
An adventure could happen without a plan. We can either mop, or just make the journey a little better, for the hiccups teach us, challenges push us, and our digital friend is here to help.