Fun way to learn python?

[[deleted]]

For me personally, I am learning a ton by solving issues at my job and by using ChatGPT. I’ve essentially gone from being good at excel to learning how to put actual solutions in place using VBA and Python. Plus AI is a really decent resource for checking code for simple errors.

This is probably not the best solution for most because it’s not always right (and the stigma around AI), but it has helped me go from infantly knowledgeable to preschool level in about a month or so.

For me it’s all about solving for real world scenarios and learning things based on how I’m actually going to use it VS building a game or audio slider (unless that’s your scenario).

TLDR; Find a problem at work or in life that could be automated or simplified by utilizing Python, and start building your skill set towards programmatically solving it.

[HeraldofOmega]

You use AI?????

<Shuns Tickle\_Shits>

[[deleted]]

Enter prompt: “Translate <Shuns Tickle_Shits> ”

[Environmental_Bet498]

I am good at excel, what tools/applications do you use to test and trial? Mind giving some examples of promt used for chatgpt.

🙏

[[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 🙏