I've had Python on my radar for about a year and a half, but I've had so much other stuff to learn as well - database design, ETL fundamentals, statistics, etc. Because of that, I haven't given it much attention until I started my new job a few months ago. So far I've only been able to dedicate a few hours a week to learning and building out small scripts. I just finished going through Automate the Boring Stuff this week after getting through most of Jose Portilla's Python bootcamp.
My clients use a digital survey platform that's really tedious to get data out of. The platform has a public API and an FTP protocol, but I knew that automating API requests would be the better way to go. In the past, I've used APIs via different BI platform UIs that helped you generate scripts, but I've never written the script myself.
Today, I started my first big project. I'm generating the API call, parsing the JSON, and dumping the data into a csv (eventually I will send this directly to a MySQL database) all with Python. The best part is that I'm writing it all myself - much to my chagrin (or benefit?), I couldn't find any prewritten scripts.
I'm so grateful for this community that's constantly encouraging and supportive of itself. I'm still working through the script but I'd be happy to share it for a review once I get it on my (currently empty) Github assuming I'm allowed to put it up.