*What do you think of ChatGPT? Have you tried it before? Let me know in the comments!* All the code snippets, files and ChatGPT prompts used in this video can be found here ⤵ github.com/Sven-Bo/excel-automation-with-chatgpt
@@raymondthompson4920 Perfect question for ChatGPT :) Here is the answer: The steps to install Python depend on the operating system you are using. Here are the general steps: For Windows: Go to the official Python website: www.python.org/downloads/ Click on the "Download Python" button. Scroll down to the "Python Releases for Windows" section and click on the link for the latest version of Python. Scroll down again and select the appropriate installer based on your Windows version (32-bit or 64-bit). Run the installer and follow the installation steps. Make sure to select "Add Python to PATH" during the installation process. For Mac OS: Go to the official Python website: www.python.org/downloads/ Click on the "Download Python" button. Scroll down to the "Python Releases for Mac OS X" section and click on the link for the latest version of Python. Scroll down and select the macOS installer package. Run the installer and follow the installation steps. For Linux: Open a terminal window. Check if Python is already installed by typing python3 or python into the terminal. If Python is installed, the version number will be displayed. If not, proceed to the next step. Install Python using your package manager. For example, on Ubuntu or Debian, you can type sudo apt-get install python3 to install Python 3. After installing Python, you can run it by typing python or python3 in the terminal, depending on the version you installed.
@Coding Is Fun: nothing else with your video (other already said enough), but just can’t help to ask: what video editing software you use to create these? Thanks!
Thank you for your video. I have tried it for a variety of things; python code for Blender, Windows command line and a week before Xmas I had a mental block when I needed to make a PPT presentation at work. I asked it how to make a PPT about this specific topic. A 20 point step by step instructions came back that followed with a smug smile on my face 😉. It was like having a PA
Thanks for watching the video and taking the time to leave a comment. 👍 It feels like having a personal assistant, exactly. Besides coding, I also sometimes use it to help me write emails.
I’ve never coded in Python before and actually haven’t written any code since the mid 90s.. and that was in Fortran. I just got Python and an editor installed and tried your 5th example and am so amazed by this (and that I got it to work). Thank you! Your videos are opening so many mental doors.
I appreciate you sharing the video and your support. Glad you enjoyed it and found it helpful. I'll definitely keep cranking out more content like this. Thanks for watching! 👍
I've used ChatGPT for alot VBA code, but seeing this, looks like I'm in for alot of fun when I start using it for Python Excel Automation and when creating GUI for the automation tools, and packaging them into executable .exe files. I especially like the ChatGPT comparison with your soluiton using dictionary for the find and replace code. Also using CHATGPT for refactoring code too is very nice Overall your videos are so good and neat. I SUBSCRIBED! Great work youre doing. What I noticed from your videos is asking CHATGPT the right prompt questions is key, and ability to break it down into clear concise instructions. Thank you, Thank you, Thank you 😊👍
Welcome aboard! 🎉 I'm happy to hear that you found the video helpful, and you are absolutely right - formulating a good prompt is the hardest part. Happy coding! :)
Thanks for watching my video and for the feedback! Appreciate it. And thanks for supporting my channel and being a part of the community. It means a lot to me. 👍💪
Awesome video, would be interesting how far you could take this, based on how much input you could pass in to ChatGPT. Could it write a whole system with multiple classes and functions?
Thanks for checking out the video and leaving a comment. I think writing a whole system with multiple classes and functions is definitely possible with ChatGPT! I'd recommend giving it a try and seeing how far you can take it. Happy coding and good luck! ✌
Wow this is amazing! But also somewhat frightening. I mean, imagine 10 years ago we wouldn't have thought to have an AI tool doing things like this for us and yet it's already there. Imagine what is it gonna look like in 10 years? I remember hearing people say 'programming jobs are never going to be replaced with AI'. Yet it seems the need for human programmers might decline faster than for many blue collar workers it seems 😅
Thanks for watching! 👍 Yeah, it's definitely wild to think about how far AI and automation have come in such a short time. It will be interesting to see how it continues to shape the job market and the way we work.
I see you have switched to the dark side with VS Code 😜 it's so good lately with integrated notebooks as well 😃Thanks for the video, gonna experiment with chatGPT myself!
Haha, the "dark side" is actually pretty great! I've been using it at work for a while now and I really like it. The integrated notebooks are a game changer. I mainly use Atom only for my screen recordings. Have fun with ChatGPT! 🔥
Hey Max, thanks for checking out the video! I was just curious to see how my solution compared to ones written in Python, but feel free to try it out yourself too. I've uploaded the ChatGPT prompts on GitHub, so you can just swap out 'Python' for 'VBA' and give it a shot. Happy coding and have fun!
Thanks so much for watching the video and leaving a comment! Your request is definitely noted. However, I get a ton of requests for custom solutions and, as much as I'd love to help everyone out, I just don't have the time in my schedule to develop and test all of them. I hope you can understand. Happy Coding!
Imagine Chat gpt with combination of metaverse, stable diffusion and DallE...... outcome will be it can create its own code, video tutorials....Most of the jobs become absolute which includes teachers, lawyers, software engineers,doctors(to some extent permitted by law), real estate agents, tellers, quant traders, financial analysts.........you name it .... Jobs will definitely not go to zero but 90% reduction in every sector is inevitable!
Chat GPT will be the best teacher to explain and give us pratical code. Most of the jobs become absolute which includes teachers, lawyers, software engineers,doctors(to some extent permitted by law), real estate agents, tellers, quant traders, financial analysts.........you name it .... Jobs will definitely not go to zero but 90% reduction in every sector is inevitable!
Ummmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmm what is happening why did I go to college?
@@CodingIsFun Well I can at least tell you you're acting as a very useful NLP-chatbot assisted coding channel. Probably means you'll be helping an even faster growing audience imo!
*What do you think of ChatGPT? Have you tried it before? Let me know in the comments!*
All the code snippets, files and ChatGPT prompts used in this video can be found here ⤵
github.com/Sven-Bo/excel-automation-with-chatgpt
How do I install python to do your example
@@raymondthompson4920 Perfect question for ChatGPT :) Here is the answer:
The steps to install Python depend on the operating system you are using. Here are the general steps:
For Windows:
Go to the official Python website: www.python.org/downloads/
Click on the "Download Python" button.
Scroll down to the "Python Releases for Windows" section and click on the link for the latest version of Python.
Scroll down again and select the appropriate installer based on your Windows version (32-bit or 64-bit).
Run the installer and follow the installation steps. Make sure to select "Add Python to PATH" during the installation process.
For Mac OS:
Go to the official Python website: www.python.org/downloads/
Click on the "Download Python" button.
Scroll down to the "Python Releases for Mac OS X" section and click on the link for the latest version of Python.
Scroll down and select the macOS installer package.
Run the installer and follow the installation steps.
For Linux:
Open a terminal window.
Check if Python is already installed by typing python3 or python into the terminal. If Python is installed, the version number will be displayed. If not, proceed to the next step.
Install Python using your package manager. For example, on Ubuntu or Debian, you can type sudo apt-get install python3 to install Python 3.
After installing Python, you can run it by typing python or python3 in the terminal, depending on the version you installed.
@Coding Is Fun: nothing else with your video (other already said enough), but just can’t help to ask: what video editing software you use to create these? Thanks!
I@@TrungLuu-World I am using Camtasia. Cheers, Sven ✌
Thank you for your video. I have tried it for a variety of things; python code for Blender, Windows command line and a week before Xmas I had a mental block when I needed to make a PPT presentation at work. I asked it how to make a PPT about this specific topic. A 20 point step by step instructions came back that followed with a smug smile on my face 😉. It was like having a PA
Thanks for watching the video and taking the time to leave a comment. 👍 It feels like having a personal assistant, exactly. Besides coding, I also sometimes use it to help me write emails.
I’ve never coded in Python before and actually haven’t written any code since the mid 90s.. and that was in Fortran. I just got Python and an editor installed and tried your 5th example and am so amazed by this (and that I got it to work). Thank you! Your videos are opening so many mental doors.
Hi Joe Davis 👋 Thank you for taking the time to watch my video and share your feedback. Happy Coding! :)
@@CodingIsFun ❤
This is a great video to show the potential of ChatGPT and python automation! I'm sharing it as we speak. Keep it up, bro!
I appreciate you sharing the video and your support. Glad you enjoyed it and found it helpful. I'll definitely keep cranking out more content like this. Thanks for watching! 👍
What i understand is, You will have to write the Right question into the CHAT GPT to get a Right Python code..
Your videos are awesome boss 👍
Thank you for tuning in! Indeed, crafting the perfect prompt can be quite the challenge 😅
I've used ChatGPT for alot VBA code, but seeing this, looks like I'm in for alot of fun when I start using it for Python Excel Automation and when creating GUI for the automation tools, and packaging them into executable .exe files.
I especially like the ChatGPT comparison with your soluiton using dictionary for the find and replace code. Also using CHATGPT for refactoring code too is very nice Overall your videos are so good and neat. I SUBSCRIBED! Great work youre doing. What I noticed from your videos is asking CHATGPT the right prompt questions is key, and ability to break it down into clear concise instructions. Thank you, Thank you, Thank you
😊👍
Welcome aboard! 🎉 I'm happy to hear that you found the video helpful, and you are absolutely right - formulating a good prompt is the hardest part. Happy coding! :)
That's awesome, thanks for sharing ❤️
An absolute pleasure, very happy to hear that you liked the video!
Excellent man ! Thank you !
Thanks for the positive feedback! Appreciate you taking the time to leave a comment.
Awesome bro! Keep up the good work! ❤
Great insights Sven!
Thanks for watching my video and for the feedback! Appreciate it. And thanks for supporting my channel and being a part of the community. It means a lot to me. 👍💪
Wonderful job! Thank you.
Glad you liked it. Thanks for watching and taking the time to leave a comment! 😍
Amazing job. Thanks for information
My pleasure! Appreciate you taking the time to watch and leave a comment.
Amazing video, thanks!
Glad you liked it. Thanks for watching and taking the time to leave a comment!
Good start ! learnt few things thats non AI and AI. Basic lesson need to keep exploring more 👋😊
Thanks for watching and keep exploring! 👍
Great video!!
Thank you! 👍
This was really cool and subscribed! Thanks. Would love to see using Python OCR capabilities w ChatGPT to ingest PDFs.
Thank you for watching the video & your suggestion. 👍
Awesome video, would be interesting how far you could take this, based on how much input you could pass in to ChatGPT. Could it write a whole system with multiple classes and functions?
Thanks for checking out the video and leaving a comment. I think writing a whole system with multiple classes and functions is definitely possible with ChatGPT! I'd recommend giving it a try and seeing how far you can take it. Happy coding and good luck! ✌
This is a very interesting video
Thanks for watching and for your comment! I'm glad you found the video interesting. 👍
Wow this is amazing! But also somewhat frightening. I mean, imagine 10 years ago we wouldn't have thought to have an AI tool doing things like this for us and yet it's already there. Imagine what is it gonna look like in 10 years?
I remember hearing people say 'programming jobs are never going to be replaced with AI'. Yet it seems the need for human programmers might decline faster than for many blue collar workers it seems 😅
Thanks for watching! 👍 Yeah, it's definitely wild to think about how far AI and automation have come in such a short time. It will be interesting to see how it continues to shape the job market and the way we work.
I see you have switched to the dark side with VS Code 😜 it's so good lately with integrated notebooks as well 😃Thanks for the video, gonna experiment with chatGPT myself!
Haha, the "dark side" is actually pretty great! I've been using it at work for a while now and I really like it. The integrated notebooks are a game changer. I mainly use Atom only for my screen recordings. Have fun with ChatGPT! 🔥
Thx ur video
You're very welcome! Thank you for watching the video and for the first comment! 🏆🎉
Love it! You have an interesting German / Indian accent😮
Thanks for watching! :)
Thanks for your video. I am having trouble with my excel file, so I will use it to solve this. Hope that everything will be okay.
My pleasure! Appreciate you taking the time to watch and leave a comment. Good luck with your Excel problem! 👍
@@CodingIsFun It's really fantastic. It gives me the way to do it easily.
Nice video. What VS Code theme are you using?
Thank you! I am using "Cobalt2".
great video! Why didnt you do this in VBA? Collegues might need this automation tool and have not installed python.
Thanks for your insights!
Hey Max, thanks for checking out the video! I was just curious to see how my solution compared to ones written in Python, but feel free to try it out yourself too. I've uploaded the ChatGPT prompts on GitHub, so you can just swap out 'Python' for 'VBA' and give it a shot. Happy coding and have fun!
@@CodingIsFun thanks!!
Is there a version of this video where you go even slower and help with Python installation; running panda installation in python editor etc etc. :D
Nope, sorry! 😅
Good
Thanks
ИИ пишет код на уровне джуниора или даже мидла. Правда штука будет не бесплатной после тестирования
Thanks for watching any your comment. I'm also guessing that it won't be free forever.
how to create automated excel to check router wds bridging channel with the help of selenium
Thanks so much for watching the video and leaving a comment! Your request is definitely noted. However, I get a ton of requests for custom solutions and, as much as I'd love to help everyone out, I just don't have the time in my schedule to develop and test all of them. I hope you can understand. Happy Coding!
Imagine Chat gpt with combination of metaverse, stable diffusion and DallE...... outcome will be it can create its own code, video tutorials....Most of the jobs become absolute which includes teachers, lawyers, software engineers,doctors(to some extent permitted by law), real estate agents, tellers, quant traders, financial analysts.........you name it .... Jobs will definitely not go to zero but 90% reduction in every sector is inevitable!
Thanks for takin' the time to watch the video and leaving your thoughts. Yeah, let's see what the future brings 😬
My opinion? ChatGPT is great! And you are cute! 😀
Thank you! 👍
Am I going to lose my job to ChatGPT? ,🤣
Same here. Will people still watch Excel automation tutorial on UA-cam? 😅
Chat GPT will be the best teacher to explain and give us pratical code. Most of the jobs become absolute which includes teachers, lawyers, software engineers,doctors(to some extent permitted by law), real estate agents, tellers, quant traders, financial analysts.........you name it .... Jobs will definitely not go to zero but 90% reduction in every sector is inevitable!
Ummmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmm
what is happening why did I go to college?
lol I remember to have fun
I had a similar question in my mind - why did I start a UA-cam coding channel? 😅
@@CodingIsFun Well I can at least tell you you're acting as a very useful NLP-chatbot assisted coding channel. Probably means you'll be helping an even faster growing audience imo!