Automate Boring Office Tasks with ChatGPT and Python

2024 ж. 20 Мам.
503 916 Рет қаралды

Tired of spending hours on tedious office tasks? In this video, I'll show you how to use ChatGPT and Python to automate some of those boring tasks. We'll be looking at automating Outlook, creating PowerPoint presentations, generating charts from Excel data, and manipulating PDFs.
First up, we'll go over how to use ChatGPT and Python to automate tasks in Outlook like sending emails to a list of recipients pulled from an Excel file. Then we'll move on to using ChatGPT and Python to create slides and add text and images to them for PowerPoint presentations.
Next, we'll look at how to use ChatGPT and Python to create interactive charts based on data from an Excel file. And lastly, we'll cover how to use ChatGPT and Python to automate PDF tasks like merging multiple documents.
As a bonus, we'll also take a look at how to use ChatGPT to write emails for you so you don't have to.
Overall, this video will give you a good idea of how you can use ChatGPT and Python to automate some of those repetitive tasks that take up so much of your time.
🌎 𝗥𝗘𝗦𝗢𝗨𝗥𝗖𝗘𝗦:
The code and files can be found here: github.com/Sven-Bo/automate-o...
The website with links to all ChatGPT prompts: automate-office-chatgpt.strea...
⭐ 𝗧𝗜𝗠𝗘𝗦𝗧𝗔𝗠𝗣𝗦:
00:00 - Intro
00:33 - 1. Example: Distribute Excel files with Outlook
03:21 - 2. Example: Automate PowerPoint
06:13 - 3. Example: Create an interactive chart from Excel data
07:07 - 4. Example: Merge PDFs
08:44 - 5. Example: Write Emails
09:14 - 6. Example: Create a Streamlit website
09:45 - Outro
◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️
𝗖𝗢𝗡𝗡𝗘𝗖𝗧 𝗪𝗜𝗧𝗛 𝗠𝗘:
🌎 Website: pythonandvba.com
📝 GitHub: github.com/Sven-Bo
⭐ Discord: pythonandvba.com/discord
▶️ Subscribe: kzhead.info?sub...
🎉 𝗙𝗥𝗘𝗘 𝗘𝘅𝗰𝗲𝗹 𝗔𝗱𝗱-𝗶𝗻 𝘁𝗼 𝗯𝗼𝗼𝘀𝘁 𝘆𝗼𝘂𝗿 𝗽𝗿𝗼𝗱𝘂𝗰𝘁𝗶𝘃𝗶𝘁𝘆
Get it here: pythonandvba.com/mytoolbelt
📚 𝗥𝗲𝘀𝗼𝘂𝗿𝗰𝗲𝘀 𝗳𝗼𝗿 𝗹𝗲𝗮𝗿𝗻𝗶𝗻𝗴 𝗩𝗕𝗔 & 𝗣𝘆𝘁𝗵𝗼𝗻
Check out my recommendations: pythonandvba.com/resources
☕ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲❓
If you want to support this channel, you can buy me a coffee here:
pythonandvba.com/coffee-donation

Пікірлер
  • *What do you think of ChatGPT? Have you been able to automate any tasks using it? 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/automate-office-tasks-using-chatgpt-python 👉 automate-office-chatgpt.streamlit.app/

    @CodingIsFun@CodingIsFun Жыл бұрын
    • I'm stronger day by day.Thanks for promoting me. Stay with chatGPT official channel.

      @servicekingbd@servicekingbd Жыл бұрын
    • I want to automate my world so I can spend time where life matters, people. ❤ Thank you for sharing your knowledge 📖 of how we can become free of these monotonous task we are ALL doing manually. A friend if mine who is studying for her masters cried of joy when I introduced her to chatGPT. 🤯

      @WirelessGus@WirelessGus Жыл бұрын
    • how about using python to automate microsoft teams messaging monitoring and automatic responses?

      @maxpanicmovies@maxpanicmovies Жыл бұрын
    • How about 365 copilot

      @carkawalakhatulistiwa@carkawalakhatulistiwa Жыл бұрын
    • @@carkawalakhatulistiwa What about it?

      @CodingIsFun@CodingIsFun Жыл бұрын
  • "ChatGPT, fix the algorithm so Sven's videos are back at the top of my feed. And then do my job for me. Please?"

    @bc4198@bc4198 Жыл бұрын
    • Happy to have you back in the comments! Cheers for checking out the video! 👍

      @CodingIsFun@CodingIsFun Жыл бұрын
  • It’s amazing. Previously people say talk is cheap, show me the code. From now on, code is cheap, let me know what you need

    @stevenyu6835@stevenyu6835 Жыл бұрын
    • Thanks for takin' the time to watch and leave a comment, much appreciated.

      @CodingIsFun@CodingIsFun Жыл бұрын
  • Great video! for someone who has a little bit of idea of what he wants, ChatGPT is a game changer. Thanks again for the video !

    @AdrlanCC@AdrlanCC Жыл бұрын
    • Happy to hear that it was useful; thank you for taking the time to leave a comment and for watching the video! 👍

      @CodingIsFun@CodingIsFun Жыл бұрын
    • @@CodingIsFun is it possible to generate a code that searches in the pdf files for a certain word and when it finds that word to rename and save the file with the found name? for example I have a Shop and I want after I scan the invoices from customers ,to rename them and save them with the name of the invoice. 🤔

      @AdrlanCC@AdrlanCC Жыл бұрын
    • @@AdrlanCC Why not simply trying it out? 😃

      @CodingIsFun@CodingIsFun Жыл бұрын
    • @@CodingIsFun I will 😀 but I wasn't sure how to write the prompt.

      @AdrlanCC@AdrlanCC Жыл бұрын
  • Your videos are great as they highlight that for the vast majority of the cases, it's the user's responsibility for the effectiveness of chatGPT in understanding the task. Python works great with chatGPT, though I cannot say the same about VBA.

    @chamamemestre@chamamemestre Жыл бұрын
    • Thanks for the positive feedback and watching the videos! Appreciate you taking the time to leave a comment. 👍

      @CodingIsFun@CodingIsFun Жыл бұрын
    • Yep. You need proper "Prompt Engineering" for this to work smoothly

      @Soheil-ev6ls@Soheil-ev6ls Жыл бұрын
  • The step-by-step breakdown of each process is incredibly helpful. I can already imagine the amount of time and effort this automation will save. Thank you for sharing these valuable insights and empowering us to reclaim our time from mundane tasks.

    @JordChase999@JordChase99911 ай бұрын
    • Happy to hear that it was useful; thank you for taking the time to leave a comment and for watching the video!

      @CodingIsFun@CodingIsFun11 ай бұрын
  • you are giving it very precise directions, probably getting better results from that

    @dont-want-no-wrench@dont-want-no-wrench Жыл бұрын
    • Thank you for tuning in. Indeed, I found that I achieved better results when I composed clear and precise prompts.

      @CodingIsFun@CodingIsFun Жыл бұрын
  • Amazing time we live in. Thanks for sharing!

    @Katsiarina1@Katsiarina1 Жыл бұрын
    • Thanks for the kind words and watching the video! Yeah, technology is pretty amazing these days. 🤯

      @CodingIsFun@CodingIsFun Жыл бұрын
  • One of the better videos on using chat GPT. I'm sure coding this apps would have taken more time than writing the prompt but you still had to be very specific.

    @Isaac-eh6uu@Isaac-eh6uu Жыл бұрын
    • Thanks for watching and leaving your thoughts. You're absolutely right, creating and tweaking the prompts took me some time.😊👍

      @CodingIsFun@CodingIsFun Жыл бұрын
  • Twist, GPT sends an email to your manager that fires you instead and replaces your job with AI.

    @gringadoor5385@gringadoor5385 Жыл бұрын
    • 😳😢

      @CodingIsFun@CodingIsFun Жыл бұрын
    • When you use it, your productivity can shoot up. It's just a tool. While Luddite coders are busy throwing their clogs into the machinery to "prove" that it doesn't work, their smart colleagues will master the tech and prove that THEY do work - and are more productive. So you are right in that the Luddites and Les Saboteurs will lose their jobs. Good - they hold their employers and their colleagues back... so 1970s. Meanwhile - this week - I've used it to re-create a lost program which had been written in VBASICA. Without AI, it had not been cost-effective to do it. I'm currently using it to create new apps which add value directly to the customer experience, none of which have been cost-effective to attempt until now. And it will not replace the Prompt Engineers, because Artificial Intelligence is a misnomer. It is no more intelligent than the box of tools in my garage, some of which were probably used by my Great Grandfather to build railway coaches in the same workshop where Stevenson's Rocket had been serviced. Just as a furniture maker or sculptor could use my tools to create amazing things, I can't because I don't have the skills. Aristotle knew the difference between us - an artificer needs ability, a teacher, and practice. He forgot to mention the tools. Nobody else can write the apps I am creating - they don't know what I have learnt. AI does - but doesn't know it. It needs me to be creative.

      @lindsayheyes925@lindsayheyes925 Жыл бұрын
    • 😂😂😂

      @bala6390@bala6390 Жыл бұрын
    • Or even bigger twist, the AI controls someone into making a robot with its database on it, then it kills your boss ,then being your boss it kills you.

      @ninjacat8113@ninjacat811311 ай бұрын
    • Hires homeless man to enter prompt

      @EtchedinHistory-lu4iw@EtchedinHistory-lu4iw11 ай бұрын
  • PDF editing!!! you've made my day.

    @arch.blender1178@arch.blender1178 Жыл бұрын
    • Glad I could help! Thanks for watching! 💪

      @CodingIsFun@CodingIsFun Жыл бұрын
  • Excellent and informative video. I imagine that in the future, one will be able to train AI tools to handle entire workflows independently. I can imagine that for workflows such as you demonstrate here, but also things like month-end billing and accounts payable handling and many more. We will tell the tool to define a month-end billing process that meets our requirements and to execute that process every month or at whatever interval is appropriate. If you are a small business owner that has had trouble finding and keeping a good bookkeeper, that would be a godsend.

    @franksampson477@franksampson477 Жыл бұрын
    • Thanks for checking out the video and sharing your thoughts. I'm curious to see what the future holds, and I can imagine that AI tools will be able to handle entire workflows independently in the future, like you said. 🤯

      @CodingIsFun@CodingIsFun Жыл бұрын
    • If you're a small business owner, your time is probably better invested using Zapier or something similar to integrate your various systems. Or even get a consultant to do it for you. And no, I would not trust this tech to try to run my bookkeeping system or dispatch program for me. At all. And that is because I can't code and I'm not going to start putting things into those systems which I don't really know what they're doing. I might get a consultant to do it for me, but those are yet to be available.

      @maghambor@maghambor Жыл бұрын
    • ​@@CodingIsFun My bet is that this will be achieved in the near future, through integration with Microsoft Power Automate.

      @Soheil-ev6ls@Soheil-ev6ls Жыл бұрын
    • ​@@maghambor Are you saying consultants are yet to be available? There's plenty of Automation consultancies out there.

      @Soheil-ev6ls@Soheil-ev6ls Жыл бұрын
    • @@Soheil-ev6ls Probably likely. But currently this is all a giant playground with very few serious implementations for companies. But give it a year or two and it will have changed the world.

      @maghambor@maghambor Жыл бұрын
  • Boss: Thanks for the automation! Now we'll hire a high schooler to do it part-time and you can pick up your final paycheck. Good Luck!

    @stopthink9000@stopthink9000 Жыл бұрын
    • 😅

      @CodingIsFun@CodingIsFun Жыл бұрын
  • This video gave me so many more ideas I hadn’t even thought of to automate several of my boring tasks 😂 thanks a bunch!

    @jagotiberan2181@jagotiberan218111 ай бұрын
    • Glad you liked it. Thanks for watching. :)

      @CodingIsFun@CodingIsFun11 ай бұрын
  • What a great video, from XU considering going back to school for a another Bachelor's in computer science and I'm fascinated by what chat GPT will do to the process of applying technology to tasks

    @shday4@shday4 Жыл бұрын
    • Thanks for leaving a comment and for taking the time to watch! Glad you liked it. 👍

      @CodingIsFun@CodingIsFun Жыл бұрын
  • I'm stronger day by day.Thanks for promoting me. Stay with chatGPT official channel.

    @servicekingbd@servicekingbd Жыл бұрын
    • Cheers for checkin' out the video and leavin' a comment.

      @CodingIsFun@CodingIsFun Жыл бұрын
  • Awesome video once again!

    @gurdeepsingh1975@gurdeepsingh1975 Жыл бұрын
    • Glad you liked it! Thanks for watching and taking the time to leave a comment! 💪

      @CodingIsFun@CodingIsFun Жыл бұрын
  • Excellent information, thanks!

    @cristian15154@cristian15154 Жыл бұрын
    • Glad to hear you liked it! Thank you for commenting and watching. 👍

      @CodingIsFun@CodingIsFun Жыл бұрын
  • Ooohhh awesome!! Thanks for sharing!

    @kavinyudhitia@kavinyudhitia Жыл бұрын
    • Thanks for the positive feedback! Appreciate you taking the time to leave a comment. 👍

      @CodingIsFun@CodingIsFun Жыл бұрын
  • Thank you for this amazing step-by-step clip. I started using ChatGPT a few months ago to help me with similar scripts, but you've provided great examples that will reduce the number of errors I was receiving. Keep them coming please.

    @tochtzin@tochtzin10 ай бұрын
    • Glad it was helpful! Thanks for watching and taking the time to leave a comment

      @CodingIsFun@CodingIsFun10 ай бұрын
  • Excellent video, thank you.

    @RiminiVirage@RiminiVirage Жыл бұрын
    • Glad to hear you liked it! Thank you for commenting and watching.

      @CodingIsFun@CodingIsFun Жыл бұрын
  • Hardcore awesome thank you so much! Thank you ❤️ very nice tutorials, such tutorial where can every office person can profit are awesome 👍

    @CNCPRINTBLOGSPOT@CNCPRINTBLOGSPOT Жыл бұрын
    • Glad to hear you liked it! Thank you for commenting and watching. ✌

      @CodingIsFun@CodingIsFun Жыл бұрын
  • yesterday, i was seeing your video of making a form template with pysimplegui and thought you should come up with ChatGPT... and now will watch this video of yours..

    @11111shruti@11111shruti Жыл бұрын
    • Maybe I should do a video on how to use ChatGPT with PySimpleGUI 😅 Anyways, thanks for watching and taking the time to leave a comment - I appreciate it! 💪

      @CodingIsFun@CodingIsFun Жыл бұрын
  • Insane. Thank you man

    @cheerskeule7440@cheerskeule7440 Жыл бұрын
    • My pleasure! Appreciate you taking the time to watch and leave a comment. :)

      @CodingIsFun@CodingIsFun Жыл бұрын
  • Great tutorial! I gave it a thumbs up. I noticed that you got a few deprecation warnings in your examples. One of the limitations of ChatGPT as noted by the developers is limited knowledge of world events after 2021. Perhaps this also implies that it doesn't have knowledge of any Python libraries updated after 2021? I know it doesn't do web crawling so I'm not sure how it could know of new updates to Python libraries. Regardless, it's a great tool.

    @tylerpotts4304@tylerpotts4304 Жыл бұрын
    • Thanks for watching and for giving the tutorial a thumbs up! I also noticed the Python depreciation and future warning as pointed out in the video. And yes, ChatGPT's knowledge is only current up to 2021, so any updates to Python libraries that came out after that, it's not aware of.

      @CodingIsFun@CodingIsFun Жыл бұрын
    • I used the DAN promt. Asked it to summarize a WSJ link and it did so. Chat has connection , just needs the right promt.

      @MrBernaln2@MrBernaln2 Жыл бұрын
    • @@MrBernaln2 Was your WSJ article from 2021 or earlier?

      @tylerpotts4304@tylerpotts4304 Жыл бұрын
  • Thank you very much Sven awesome content as always. Are you working with MS 356 or Office 2021? Will I be better off buying one over the other to run this automation with python?

    @zkiyyeller3525@zkiyyeller3525 Жыл бұрын
    • Thanks for watching! Happy to hear that you liked this video too. I am currently using Office 2016, but the version of Office you use for Python automation does not matter. Either version will work.

      @CodingIsFun@CodingIsFun Жыл бұрын
    • @@CodingIsFun Thank you so much! You are an inspiration Sir!

      @zkiyyeller3525@zkiyyeller3525 Жыл бұрын
  • Great tutorial as always. Thank you very much!

    @user-li7mq5hp9g@user-li7mq5hp9g Жыл бұрын
    • Glad you liked it! *Thanks for watching!* 👍

      @CodingIsFun@CodingIsFun Жыл бұрын
  • This is awesome!

    @joseg3102@joseg3102Ай бұрын
    • Thanks! 🙏 Cheers, Sven ✌️

      @CodingIsFun@CodingIsFun23 күн бұрын
  • thanks for sharing your knowledge. #respect 🤝

    @WirelessGus@WirelessGus Жыл бұрын
    • My pleasure! Appreciate you taking the time to watch and leave a comment. 👍

      @CodingIsFun@CodingIsFun Жыл бұрын
  • Fantastic. So curious to see where we will be in a couple of years

    @videoanalyzers@videoanalyzers Жыл бұрын
    • Thanks for watching. I'm excited for what's to come as well!

      @CodingIsFun@CodingIsFun Жыл бұрын
  • Wow. You are so good at teaching

    @jalrox123@jalrox123 Жыл бұрын
    • Thanks for the kind words! I am glad you enjoyed it. 👍

      @CodingIsFun@CodingIsFun Жыл бұрын
  • Amazing decodes

    @rp5047@rp5047 Жыл бұрын
    • Thanks for checkin' out the video and leavin' a comment, much appreciated.

      @CodingIsFun@CodingIsFun Жыл бұрын
  • This may be a silly question, but I am completely new to coding. When you copy the code and paste it into an empty python file, how do you get that? Is it a program that runs python files? What exactly do I need to download to run the code? Thanks!

    @gregory4290@gregory4290 Жыл бұрын
    • Thanks for watching. You would need to install Python on your machine first. To install and run Python: - Go to the official Python website (python.org) and download the latest version of Python (Python 3 is recommended) - Run the installation file and follow the on-screen instructions - Verify the installation by opening the terminal or command prompt and typing "python" - If the installation was successful, you will see the Python prompt (>>>) indicating that Python is ready to use - Open a text editor and type in your Python code - Save the file with a .py extension (e.g., "hello.py") - Open a terminal or command prompt and navigate to the directory where you saved the file - Type "python filename.py" (replace "filename" with the name of your file) and press enter I hope it helps! :)

      @CodingIsFun@CodingIsFun Жыл бұрын
    • OMG!

      @leventguner8882@leventguner888210 ай бұрын
  • thank you for this awesome video

    @AmrAtef_CRE@AmrAtef_CRE5 ай бұрын
    • My pleasure! Appreciate you taking the time to watch and leave a comment.

      @CodingIsFun@CodingIsFun5 ай бұрын
  • hi sir, thank you for sharing these, it very helpful. what video editor app that you use? especially to zoom the video like in 03:54

    @huseinramadhan6156@huseinramadhan61565 ай бұрын
    • Thanks for watching. I am using camtasia.

      @CodingIsFun@CodingIsFun5 ай бұрын
  • hello, thanks a lot! inspiring !!

    @hyo1106@hyo11063 ай бұрын
    • Glad to hear you liked it! Thank you for commenting and watching. Cheers, Sven ✌️

      @CodingIsFun@CodingIsFun3 ай бұрын
  • Thank You Bro 👍👍👍👍👍

    @driouichelmahdi@driouichelmahdi Жыл бұрын
    • An absolute pleasure! Thanks for watching and the first comment! 🎉🚀

      @CodingIsFun@CodingIsFun Жыл бұрын
  • Great video! Very good demonstration.

    @happy2u91221@happy2u91221 Жыл бұрын
    • Thanks for leaving a comment and for taking the time to watch! Glad you liked it.

      @CodingIsFun@CodingIsFun Жыл бұрын
  • Sven: Chat, write the script for a KZhead video on automating boring stuff with ChatGPT and Python that will cause the viewers to like the video, and subscribe to the channel.” ChatGPT: Easy-peasy…

    @ashleybasson5664@ashleybasson5664 Жыл бұрын
    • Haha 😂 Exactly like this 😅

      @CodingIsFun@CodingIsFun Жыл бұрын
  • Wow . This brought lot of solution to my offce problem.thnx

    @phindilemandzendze3611@phindilemandzendze3611 Жыл бұрын
    • Happy to hear that it was useful; thank you for taking the time to leave a comment and for watching the video!

      @CodingIsFun@CodingIsFun Жыл бұрын
  • Very impressive!

    @sachin.tandon@sachin.tandon11 ай бұрын
    • Glad you liked it. Thanks for watching.

      @CodingIsFun@CodingIsFun11 ай бұрын
  • This is fantastic

    @FinanciallySavvyParent@FinanciallySavvyParent Жыл бұрын
    • Thanks for leaving a comment and for taking the time to watch! Glad you liked it. 😃

      @CodingIsFun@CodingIsFun Жыл бұрын
  • Great video! thanks for sharing Im not developper, which app do you use to past the chatgpt's code please

    @arhennam6477@arhennam6477 Жыл бұрын
    • Thanks for watching. In the video, I used VS Code.

      @CodingIsFun@CodingIsFun Жыл бұрын
  • What do you recommend for a beginner, i would like to learn data science!, is it goodnidea to do a bootcamp on.line or to selfstudy without bootcamp?

    @d4tset785@d4tset785 Жыл бұрын
    • Hey there! Both ways have their merits. I personally did a 9-week full-time Data Science bootcamp at Le Wagon, which I found really helpful. However, it does come at a cost. On the other hand, if you're self-disciplined, self-study using resources like Kaggle, Coursera, or DataCamp can be a cost-effective option. Decide based on your learning style and budget. Happy learning! 💻📈📚

      @CodingIsFun@CodingIsFun Жыл бұрын
  • Hi. Just setting out on my Python journey but how have you set that up? Are you running it through Idle Shell? Thanks

    @TomCoutfit@TomCoutfit Жыл бұрын
    • Thanks for watching. To install Python: Download the Python installer from official website ( www.python.org/downloads/ ), run it, select "Add Python to PATH" option, then hit "Install Now". Once done, install the required dependencies using pip: Open your Command Prompt or Terminal, type "pip install " and hit enter. I hope it helps! Happy Coding!

      @CodingIsFun@CodingIsFun Жыл бұрын
    • why you ask him? ask ChatGPT LOL (it really works like that)

      @user-yj3mf1dk7b@user-yj3mf1dk7b Жыл бұрын
  • Amazing!

    @georgeolivares6952@georgeolivares6952 Жыл бұрын
    • Glad you liked it. Thanks for watching. :)

      @CodingIsFun@CodingIsFun Жыл бұрын
  • Thanks a lot

    @javshah105@javshah105 Жыл бұрын
    • My pleasure! Thanks for watching :)

      @CodingIsFun@CodingIsFun Жыл бұрын
  • Man this is spooky 😂, chatgpt is kicking arse on all fronts

    @circuitmasters5258@circuitmasters5258 Жыл бұрын
    • 😬

      @CodingIsFun@CodingIsFun Жыл бұрын
  • Awesome tutorial, thanks!

    @youri655@youri655 Жыл бұрын
    • Glad to hear you liked it! Thank you for commenting and watching. 👍

      @CodingIsFun@CodingIsFun Жыл бұрын
  • Hi great video I do not know how to use python can you explain briefly where are you drop that code in to initiate the emails to be created?

    @mazz777@mazz777 Жыл бұрын
    • Thank you for watching the video. To get started, you will need to install Python on your computer. Once that is done, you can create a Python script in the same folder as your email distribution list (stored in an Excel file). From there, simply run the script and the emails will be generated.

      @CodingIsFun@CodingIsFun Жыл бұрын
    • @@CodingIsFun And if you are not sure how to install Python on your computer, just ask ChatGPT! For example, I typed: "How to install python on Windows 11?" and it gave me detailed instructions in 5 steps with the proper link to the right website to get the installer. This thing is really cool if you make good use of it!

      @gildaslefur2435@gildaslefur2435 Жыл бұрын
  • I love asking it to come up with a plausible code audit report for some code it spit out earlier. let it make the report and then say "sounds good, go ahead" without even reading it and see what it comes back with. Boy does it love error handling.

    @rentacowisgoogle@rentacowisgoogle Жыл бұрын
    • Thanks for watching the video. It's always great to see how ChatGPT handles different tasks. Glad you're having fun with it! 👍

      @CodingIsFun@CodingIsFun Жыл бұрын
  • I wanted to maximize the use of ChatGPT in coding and I believe this is a good stepping stone on how it actually can be done. Subscribed!

    @Ilovemesumgravy@Ilovemesumgravy2 ай бұрын
    • Welcome aboard and happy coding/prompting! 🎉 Cheers, Sven ✌️

      @CodingIsFun@CodingIsFun2 ай бұрын
  • What if I have multiple pdf files all having information about a visitor. I need to copy the name and other related things from the pdf and paste it into Excel which is tedious and I want it automated. The visitors are 107 and so to copy paste there specific information is boring

    @reflectedthoughts3376@reflectedthoughts33768 ай бұрын
    • 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!

      @CodingIsFun@CodingIsFun8 ай бұрын
  • thanks for the video, I tried the code to merge PDF but it was shown as error ModuleNotFoundError: No module named 'PyPDF2'. How can I fix this?

    @minhngo154@minhngo154 Жыл бұрын
    • Thanks for watching. Please have a look here: chatgpt-static.s3.amazonaws.com/chats/gq12619.html

      @CodingIsFun@CodingIsFun Жыл бұрын
  • Sir can we use it to make karoke of original songs or combine songs to make mashups?

    @divz2646@divz2646 Жыл бұрын
    • Thanks for watching. Just give it a try and ask chatGPT. Happy Coding! :)

      @CodingIsFun@CodingIsFun Жыл бұрын
  • Have you tried substituting Powershell for Python?

    @AndrewRoberts11@AndrewRoberts11 Жыл бұрын
    • Thanks for watching. At work, I also Powershell and Batch scripts. Mainly because they are integrated in Windows.

      @CodingIsFun@CodingIsFun Жыл бұрын
  • Can you make a video about a google map bot that send messages to a list of google map companies urls stored in google sheet please. ( Chat option hiden in desktop and visible only in apps ) using python.

    @yiktube@yiktube Жыл бұрын
    • Thank you for watching the video & your suggestion.

      @CodingIsFun@CodingIsFun Жыл бұрын
  • I tried to automate outlook printing email attachments but the code never works.

    @AllNamesAreTakenROFL@AllNamesAreTakenROFL Жыл бұрын
    • Thanks for watching. I'd like to suggest that you consider modifying your prompt. Sometimes, the wording of a prompt can make a big difference in the response that is generated. By making a few changes, you may be able to get a response that works.

      @CodingIsFun@CodingIsFun Жыл бұрын
  • You can add to the salary increase letter an "Or, I am quitting for I will have many other job offers based on what I have done for your company"

    @dfkgjdflkg@dfkgjdflkg Жыл бұрын
    • ...but in anycase, thanks for watching the video :)

      @CodingIsFun@CodingIsFun Жыл бұрын
  • How do you feed it the XLSX File? I don't understand this part

    @whoslappedthepie@whoslappedthepie Жыл бұрын
    • I am not feeding the Excel file. I am just describing where my data is located

      @CodingIsFun@CodingIsFun Жыл бұрын
  • It's fascinating that it repeatedly uses deprecated libraries/functions despite "knowing" that they are deprecated and "knowing" the equivalent non-deprecated method. I'm not sure what to make of this. Is this deliberate to make it more human or a strange flaw? Does ChatGPT generally make mistakes and only figure out the correct answer if the mistake is pointed out to it?

    @youtubeuser1052@youtubeuser1052 Жыл бұрын
    • Thanks for watching. I asked ChatGPT about it. Here is the answer: "As an AI language model, ChatGPT generates code based on patterns it has learned from large datasets of existing code. While it has been trained to use the most up-to-date libraries and functions, it may still generate code with deprecated libraries/functions due to various factors. ChatGPT generally strives to generate correct code, but like any tool, it may make mistakes. If you notice issues with the generated code, it's a good idea to review and update it as necessary." I then asked the following: Can you explain how you are able to provide the correct code even when the generated code is deprecated? Here is the answer: "As an AI language model, ChatGPT has access to a vast amount of information from a diverse range of sources, including documentation, code repositories, and programming guides. This allows me to know the correct code even when the generated code is deprecated."

      @CodingIsFun@CodingIsFun Жыл бұрын
    • @@CodingIsFun I tried it out for a couple of tasks I'd been thinking about lately and there does seem to be a pattern of generating incorrect code and when I point out the error ChatGPT replies with "you're right, here's the correct code". I think also, if you ask it to do something impossible it gives an incorrect answer instead of admitting it's impossible

      @youtubeuser1052@youtubeuser1052 Жыл бұрын
  • Which operating system are you using?

    @Brovha@Brovha Жыл бұрын
    • Windows

      @CodingIsFun@CodingIsFun Жыл бұрын
    • @Coding Is Fun wow thank you so much for the reply

      @Brovha@Brovha Жыл бұрын
  • Is there any code to automatically copying incoming certain whatsapp messages to another program like excel or word?

    @Xceedch667@Xceedch667 Жыл бұрын
    • Thanks for watching! I'm not sure if there's existing code for what you need, but you'll probably need the WhatsApp API to make it happen. Good luck with your project and have fun coding!

      @CodingIsFun@CodingIsFun Жыл бұрын
  • how does the AI enters your PC data and analyze It

    @plamenaleksandrov9063@plamenaleksandrov9063 Жыл бұрын
    • It doesn't. As shown in the video, you need to be specific with your prompt about the file/data location.

      @CodingIsFun@CodingIsFun Жыл бұрын
  • In which software i have to paste the codes to generate the results?

    @Traveltoexplore675@Traveltoexplore67511 ай бұрын
    • Thanks for watching. You need to have Python installed and you can use any text editor you like. I have used VS code in the video.

      @CodingIsFun@CodingIsFun11 ай бұрын
  • Wish I knew this when I had to stitch 500+ pdf pages together

    @kevinsmall5232@kevinsmall52328 ай бұрын
    • Next time then ;)

      @CodingIsFun@CodingIsFun8 ай бұрын
  • How can I make the same thing as in 1st Example but to send automatically at certain date?

    @vExXn1@vExXn1 Жыл бұрын
    • Thanks for watching. That is an excellent question also for ChatGPT ;) 👉 ibb.co/f0FWFBh

      @CodingIsFun@CodingIsFun Жыл бұрын
  • Hey can you make a video where we can automate data entry tasks having different pdf format and needs to be added on CRM website.

    @AishaKhan-ev2tk@AishaKhan-ev2tk2 ай бұрын
    • Thanks for watching and your suggestion! Cheers, Sven ✌️

      @CodingIsFun@CodingIsFunАй бұрын
  • Please tell, where are you copying and pasting the chatgpt provided codes

    @abhijeetsingh2472@abhijeetsingh24724 ай бұрын
    • In VS Code

      @CodingIsFun@CodingIsFun4 ай бұрын
  • amazing, can you write a code to do the same thing with Macbook default mail app on mac? I created a code and can do it, but it doesnt attach any attachments to it :(

    @mehrabanbarimani@mehrabanbarimani Жыл бұрын
    • Thank you for watching! If you're working with macOS, keep in mind that the code may require some tweaking to work properly. Unfortunately, I don't have a Mac at the moment, so I'm unable to test it out for you.

      @CodingIsFun@CodingIsFun Жыл бұрын
    • @@CodingIsFun Thanks for reading my comment and replying so quickly. There are ways to setup a macos though like hyper-v or setting up a vm. I appreciate if you let me know once you get a hold of MacOs. 👍

      @mehrabanbarimani@mehrabanbarimani Жыл бұрын
    • @@CodingIsFun Or maybe you know some proper youtube channel you can guide me to? Thank you.

      @mehrabanbarimani@mehrabanbarimani Жыл бұрын
  • Can chatGPT access files on the computer?

    @nikhil-di3vn@nikhil-di3vn Жыл бұрын
    • No, it cannot.

      @CodingIsFun@CodingIsFun Жыл бұрын
  • Finally, did you get your raise?

    @thepragmatic6383@thepragmatic6383 Жыл бұрын
    • Working on it! 😬

      @CodingIsFun@CodingIsFun Жыл бұрын
  • The only thing missing are the cmd statements to get those library and venv setup

    @picklenickil@picklenickil Жыл бұрын
    • Thanks for watching. You can actually ask ChatGPT for each prompt how to install any third party package and how to set up a virtual env.

      @CodingIsFun@CodingIsFun Жыл бұрын
    • @@CodingIsFun yes, that's true for most packages, but chatGPT of10 invents packages. Example I was trying to make an Android widget that draws over other apps, in react native. I knew it could be done in flutter but team loves react. It very confidently suggested some npm packages that seemed legit and we agreed on them. Later we found out that none of them existed.

      @picklenickil@picklenickil Жыл бұрын
  • But video is superb

    @jarosaw4013@jarosaw4013 Жыл бұрын
    • Thank you very much! :)

      @CodingIsFun@CodingIsFun Жыл бұрын
  • Can you make a video on how to use all these techniques in streamlit apps, Specifically, how to print a streamlit page to a pdf?

    @ibaha411@ibaha41111 ай бұрын
    • Thank you for watching the video & your suggestion.

      @CodingIsFun@CodingIsFun11 ай бұрын
    • @CodingIsFun, do you know if it’s doable to print a streamlit page to a pdf file?

      @ibaha411@ibaha41111 ай бұрын
  • Are u from Austria

    @sayhi2kojo1@sayhi2kojo1 Жыл бұрын
    • Nope, from Germany

      @CodingIsFun@CodingIsFun Жыл бұрын
    • @@CodingIsFun at least I was close

      @sayhi2kojo1@sayhi2kojo1 Жыл бұрын
  • So, It’s time to search new job. If chatGpt can do such kind of codes .Then what will be the task of programmers? 🤔🤔🤔

    @hellofrombd1960@hellofrombd1960 Жыл бұрын
    • Thanks for watching the video! It could be also a tool to help us do our jobs better. 😅 Let's see what the future brings us 💪

      @CodingIsFun@CodingIsFun Жыл бұрын
    • @@CodingIsFun : i agree. think that it will accelerate the development faster. mediocre and low level coding will take a hit.

      @11111shruti@11111shruti Жыл бұрын
    • Given how many people fail to properly use Google, I am certain they'll also fail to user ChatGPT or any other AI that may come... The way it was done in the video is some of the best case cenarios. Code written in Python and someone with a programmers mindset, detailing each step exactly how it should be

      @ohnitiel@ohnitiel Жыл бұрын
    • @@ohnitiel When I first started using Excel and ChatGPT together, I kept it simple. But as I started tackling more "complex" tasks, I found it easier to break 'em down into smaller chunks and give detailed instructions for each step. And who knows, maybe as these models get better and better, they'll be able to handle more general prompts..

      @CodingIsFun@CodingIsFun Жыл бұрын
    • AI will not make u jobless, a person using AI will.

      @aliaffan88@aliaffan88 Жыл бұрын
  • Praise ChatGPT

    @jerry27syd@jerry27syd Жыл бұрын
    • 👍

      @CodingIsFun@CodingIsFun Жыл бұрын
  • Power of god

    @nathanaelaaron8292@nathanaelaaron8292 Жыл бұрын
    • Thank you for watching the video and taking the time to leave a comment!

      @CodingIsFun@CodingIsFun Жыл бұрын
  • Why use Python instead of Visual Basic for Applications? VBA is already integrated with Office.

    @se6369@se6369 Жыл бұрын
    • Thanks for watching. Here is my opinion about it: kzhead.info/sun/esmRYMttkZxqhKs/bejne.html Also, I have done a similar video using ChatGPT to generate VBA code. You can find the video here: kzhead.info/sun/dKmgqtZ9kIuYoo0/bejne.html

      @CodingIsFun@CodingIsFun Жыл бұрын
    • @@CodingIsFun Thanks!

      @se6369@se6369 Жыл бұрын
  • Thanks, my manager is now daily receiving around 1000 emails for salary increase untill he replies with *approved* and a signature. Kindly Regards

    @KimYoungUn69@KimYoungUn69 Жыл бұрын
    • You are welcome!

      @CodingIsFun@CodingIsFun Жыл бұрын
  • FYI, it was a deprecation warning, not depreciation.

    @RobertLoPinto@RobertLoPinto Жыл бұрын
    • Thanks for the hint. You are absolutely right - I mispronounced it.

      @CodingIsFun@CodingIsFun Жыл бұрын
    • @@CodingIsFun No worries. I've been in many team meetings where even my lead developer made the same error. I guess it's better to have said depreciate instead of defecate!

      @RobertLoPinto@RobertLoPinto Жыл бұрын
  • omg!!!

    @yashikalanjewar6857@yashikalanjewar685710 ай бұрын
    • 🤯

      @CodingIsFun@CodingIsFun10 ай бұрын
  • Content warnings are probably because you're potentially uploading personal data to ChatGPT.

    @Bobberg90@Bobberg908 ай бұрын
    • Hmm, but I did not upload any personal information 🤔

      @CodingIsFun@CodingIsFun8 ай бұрын
  • What inspires you to make these vids?

    @hannaha.2917@hannaha.2917 Жыл бұрын
    • Hey Hannah, thanks for watching! I enjoy sharing awesome tools like ChatGPT, Python, and VBA, along with my learning experiences. It's all about making things simpler and learning new skills together! ✌

      @CodingIsFun@CodingIsFun Жыл бұрын
  • Am I the only one who gets the message from Chat GPT that it's busy? I was having fun seeing what it could do then one day.. "Thanks but we have all the users we can handle come back later". :(

    @elsheep6951@elsheep6951 Жыл бұрын
    • Nope, that sometimes happens

      @CodingIsFun@CodingIsFun Жыл бұрын
  • Höre ich da deutsch raus?🤔

    @Melvin_bec@Melvin_bec8 ай бұрын
    • Jopp, ich bin Deutscher

      @CodingIsFun@CodingIsFun8 ай бұрын
    • @@CodingIsFun Den Akzent hört man leicht raus😂 aber gutes Video

      @Melvin_bec@Melvin_bec8 ай бұрын
    • @@Melvin_bec Danke!

      @CodingIsFun@CodingIsFun8 ай бұрын
  • wow, you're so gorgeous!

    @ThePolaroid669@ThePolaroid669 Жыл бұрын
    • Thank you!

      @CodingIsFun@CodingIsFun Жыл бұрын
  • Lol, people are already afraid of hackers - now we won't even get to use computers anymore 😆. 🤬 Now I scared myself 😞

    @bc4198@bc4198 Жыл бұрын
    • 😬

      @CodingIsFun@CodingIsFun Жыл бұрын
  • Kann es sein das du eigentlich deutsch sprichst?

    @3V1TW1N@3V1TW1N Жыл бұрын
    • Japp, ich bin Deutscher

      @CodingIsFun@CodingIsFun Жыл бұрын
  • Here is a revolutionary solution instead. Stop DEFINING work as boring, work and work related stuff is most of our lives.

    @steeneugenpoulsen8174@steeneugenpoulsen8174 Жыл бұрын
    • Thanks for watching and throwing in your two cents.

      @CodingIsFun@CodingIsFun Жыл бұрын
  • Amazing, time to say bye to programming jobs.

    @Lnd2345@Lnd2345 Жыл бұрын
    • Thanks! Let's see how it develops 😅

      @CodingIsFun@CodingIsFun Жыл бұрын
    • Unless you are typing query in Google while coding multiple times. Need to keep up and innovate uplift from monotonous boring tasks. You need to be ready to challenge up yourself

      @maulikmadhavi@maulikmadhavi Жыл бұрын
  • I think many of these videos are made by people who don't actually have current systems to work within and they tend to be generic. I would, for example, need a specific system to speak with another specific system and it's just fast doing it manually than learning how to code. So no, this tech is not where it needs to be and the people, like you, promoting it, don't understand what type of prompts people like me need. The tech is getting there but due to lack of collaboration between companies with the needs for it and people knowing how to write prompts and code, it's still probably 1-2 years away from making a difference just looking at it from where I'm sitting.

    @maghambor@maghambor Жыл бұрын
    • Thanks for watching and throwin' in your two cents.

      @CodingIsFun@CodingIsFun Жыл бұрын
  • Imagine my boss finding out 😇😇

    @sabitridevisonthalia8213@sabitridevisonthalia8213 Жыл бұрын
    • 🤫

      @CodingIsFun@CodingIsFun Жыл бұрын
  • Deprecation. Not depreciation. Pronounced deprekation.

    @crc0889@crc0889 Жыл бұрын
    • Thank you very much for the hint. I appreciate it! 👍

      @CodingIsFun@CodingIsFun Жыл бұрын
    • @@CodingIsFun thank you for your video! I love the ingenuity.

      @crc0889@crc0889 Жыл бұрын
  • Are you deutsch

    @vincent1237@vincent1237 Жыл бұрын
    • Ja!

      @CodingIsFun@CodingIsFun Жыл бұрын
  • Don’t it’s asking for trouble the tasks maybe boring but I rather do boring than trust ai.

    @garethde-witt6433@garethde-witt6433 Жыл бұрын
    • Thanks for giving the video a watch and leaving your thoughts!

      @CodingIsFun@CodingIsFun Жыл бұрын
  • I can see many jobs will disappear sooner of later!

    @MohammadKareem-kd2pz@MohammadKareem-kd2pz Жыл бұрын
    • 😬

      @CodingIsFun@CodingIsFun Жыл бұрын
  • Unemployment will be soaring lol

    @hmmm8158@hmmm8158 Жыл бұрын
    • 😬

      @CodingIsFun@CodingIsFun Жыл бұрын
  • Why make a simple Excel chart when you can write a page of instructions for ChatGPT and then copy and paste python code and then execute it? Wow, much easier…

    @mutantlabor@mutantlabor Жыл бұрын
    • Thanks for watching and throwin' in your two cents.

      @CodingIsFun@CodingIsFun Жыл бұрын
KZhead