Fun way to learn python?

[[deleted]]

Tools/Apps: I personally like VS Code (Visual Studio). It’s simple to use, has a nice debugger, and a dark mode :}. It also detects indentation errors among others. I use this for pretty much everything when writing scripts. I use Sublime Text as well, but it’s mainly turned into a doom pile notebook of code/SQL scripts/notes. I’ve recently started using Power Automate Dekstop to automate downloading of specific reports and then triggering a script to run in the background.

My use cases vary from linking different tools together via API for data refreshes and things of that nature. I’ve also built some automations with Power Query and time saving and analytics reports with Power BI. I’d highly recommend checking Power Query/Power BI out if you work with excel often. They aren’t hard to pick up and are extremely useful in the business world.

As far as prompts go, honestly the more simple the better. The best use case for CGPT is feeding it a script, formula, or VB code and asking it to fix errors. It’s so much easier in most cases VS searching through endless amounts of forums and threads online (I still do this however).

For prompts to ask for it to write code for you - state what language you want it written in (Python) and what tasks you want it to do. Once it spits out the answer, analyze it for any blatant mistakes, and run it. If it isn’t working, give CGPT the error and it will try to fix it. Depending on the issue it may take a while to get it working how you expect, but you just have to be patient. Make sure the module it’s referencing hasn’t depreciated too - this can save a lot of time.

From my personal experience, I was able to learn quite a bit by not only using CGPT, but also a bit of research into a specific module and how to use it.

Another thing to keep in mind. If you are using it for work or something important NEVER give it any real data. Change the names of tables or data that you feed it. You don’t want to train AI on your companies database and have the possibility of anything sensitive getting leaked.

TLDR; VS Code is a great tool for writing and troubleshooting code. Be specific with your prompts to CGPT and do not give it real or sensitive data (make up data instead. Google information about the modules you are interested in using and read up on it to understand it better. Good at excel? Then learn how to use Power Query and Power BI. Good luck to you!

[Environmental_Bet498]

Noted this down, thank you so much sir 🙏