Automate Boring Office Tasks with ChatGPT and Python

แชร์
ฝัง
  • เผยแพร่เมื่อ 22 มิ.ย. 2024
  • 👉 Explore All My Excel Solutions: pythonandvba.com/solutions
    𝗗𝗘𝗦𝗖𝗥𝗜𝗣𝗧𝗜𝗢𝗡
    ▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
    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
    𝗧𝗢𝗢𝗟𝗦 𝗔𝗡𝗗 𝗥𝗘𝗦𝗢𝗨𝗥𝗖𝗘𝗦
    ▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
    🆓【𝗙𝗥𝗘𝗘】Excel Add-in (𝗠𝘆𝗧𝗼𝗼𝗹𝗕𝗲𝗹𝘁): pythonandvba.com/mytoolbelt
    📊 Data Visualization Excel Add-In (𝗚𝗿𝗮𝗳𝗹𝘆): pythonandvba.com/grafly
    🤪 Fun Emoji Excel Add-In (𝗘𝗺𝗼𝗷𝗶𝗳𝘆): pythonandvba.com/emojify
    📑 Excel Templates: pythonandvba.com/go/excel-tem...
    🎓 My Courses: pythonandvba.com/go/courses
    📚 Books, Tools, and More: pythonandvba.com/resources
    𝗖𝗢𝗡𝗡𝗘𝗖𝗧 𝗪𝗜𝗧𝗛 𝗠𝗘
    ▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
    🔗 LinkedIn: / sven-bosau
    📸 Instagram: / codingisfun_official
    💻 GitHub: github.com/Sven-Bo
    💬 Discord: pythonandvba.com/discord
    📬 Contact: pythonandvba.com/contact
    ☕ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲?
    If you want to support this channel, you can buy me a coffee here:
    ▶ pythonandvba.com/coffee-donation

ความคิดเห็น • 279

  • @CodingIsFun
    @CodingIsFun  ปีที่แล้ว +17

    *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/

    • @servicekingbd
      @servicekingbd ปีที่แล้ว +2

      I'm stronger day by day.Thanks for promoting me. Stay with chatGPT official channel.

    • @WirelessGus
      @WirelessGus ปีที่แล้ว

      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. 🤯

    • @maxpanicmovies
      @maxpanicmovies ปีที่แล้ว

      how about using python to automate microsoft teams messaging monitoring and automatic responses?

    • @carkawalakhatulistiwa
      @carkawalakhatulistiwa ปีที่แล้ว

      How about 365 copilot

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว

      @@carkawalakhatulistiwa What about it?

  • @AdrlanCC
    @AdrlanCC ปีที่แล้ว +9

    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 !

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว

      Happy to hear that it was useful; thank you for taking the time to leave a comment and for watching the video! 👍

    • @AdrlanCC
      @AdrlanCC ปีที่แล้ว

      @@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. 🤔

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว

      @@AdrlanCC Why not simply trying it out? 😃

    • @AdrlanCC
      @AdrlanCC ปีที่แล้ว

      @@CodingIsFun I will 😀 but I wasn't sure how to write the prompt.

  • @dont-want-no-wrench
    @dont-want-no-wrench ปีที่แล้ว +3

    you are giving it very precise directions, probably getting better results from that

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว +1

      Thank you for tuning in. Indeed, I found that I achieved better results when I composed clear and precise prompts.

  • @Isaac-eh6uu
    @Isaac-eh6uu ปีที่แล้ว +5

    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.

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว +1

      Thanks for watching and leaving your thoughts. You're absolutely right, creating and tweaking the prompts took me some time.😊👍

  • @jagotiberan2181
    @jagotiberan2181 ปีที่แล้ว +2

    This video gave me so many more ideas I hadn’t even thought of to automate several of my boring tasks 😂 thanks a bunch!

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว

      Glad you liked it. Thanks for watching. :)

  • @JordChase999
    @JordChase999 ปีที่แล้ว +5

    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.

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว

      Happy to hear that it was useful; thank you for taking the time to leave a comment and for watching the video!

  • @chamamemestre
    @chamamemestre ปีที่แล้ว +10

    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.

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว +1

      Thanks for the positive feedback and watching the videos! Appreciate you taking the time to leave a comment. 👍

    • @Soheil-ev6ls
      @Soheil-ev6ls ปีที่แล้ว +1

      Yep. You need proper "Prompt Engineering" for this to work smoothly

  • @Katsiarina1
    @Katsiarina1 ปีที่แล้ว +6

    Amazing time we live in. Thanks for sharing!

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว +1

      Thanks for the kind words and watching the video! Yeah, technology is pretty amazing these days. 🤯

  • @arch.blender1178
    @arch.blender1178 ปีที่แล้ว +2

    PDF editing!!! you've made my day.

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว

      Glad I could help! Thanks for watching! 💪

  • @franksampson477
    @franksampson477 ปีที่แล้ว +29

    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.

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว +1

      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. 🤯

    • @maghambor
      @maghambor ปีที่แล้ว

      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.

    • @Soheil-ev6ls
      @Soheil-ev6ls ปีที่แล้ว

      ​@@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.

    • @maghambor
      @maghambor ปีที่แล้ว

      @@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.

  • @shday4
    @shday4 ปีที่แล้ว +3

    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

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว

      Thanks for leaving a comment and for taking the time to watch! Glad you liked it. 👍

  • @cristian15154
    @cristian15154 ปีที่แล้ว +2

    Excellent information, thanks!

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว

      Glad to hear you liked it! Thank you for commenting and watching. 👍

  • @gurdeepsingh1975
    @gurdeepsingh1975 ปีที่แล้ว +2

    Awesome video once again!

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว +1

      Glad you liked it! Thanks for watching and taking the time to leave a comment! 💪

  • @CNCPRINTBLOGSPOT
    @CNCPRINTBLOGSPOT ปีที่แล้ว +2

    Hardcore awesome thank you so much! Thank you ❤️ very nice tutorials, such tutorial where can every office person can profit are awesome 👍

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว +1

      Glad to hear you liked it! Thank you for commenting and watching. ✌

  • @RiminiVirage
    @RiminiVirage ปีที่แล้ว +2

    Excellent video, thank you.

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว

      Glad to hear you liked it! Thank you for commenting and watching.

  • @11111shruti
    @11111shruti ปีที่แล้ว +2

    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..

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว +2

      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! 💪

  • @cheerskeule7440
    @cheerskeule7440 ปีที่แล้ว +1

    Insane. Thank you man

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว

      My pleasure! Appreciate you taking the time to watch and leave a comment. :)

  • @kavinyudhitia
    @kavinyudhitia ปีที่แล้ว +1

    Ooohhh awesome!! Thanks for sharing!

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว

      Thanks for the positive feedback! Appreciate you taking the time to leave a comment. 👍

  • @stevenyu6835
    @stevenyu6835 ปีที่แล้ว +10

    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

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว +2

      Thanks for takin' the time to watch and leave a comment, much appreciated.

  • @user-li7mq5hp9g
    @user-li7mq5hp9g ปีที่แล้ว +3

    Great tutorial as always. Thank you very much!

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว +1

      Glad you liked it! *Thanks for watching!* 👍

  • @bc4198
    @bc4198 ปีที่แล้ว +26

    "ChatGPT, fix the algorithm so Sven's videos are back at the top of my feed. And then do my job for me. Please?"

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว +2

      Happy to have you back in the comments! Cheers for checking out the video! 👍

  • @tochtzin
    @tochtzin ปีที่แล้ว +1

    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.

    • @CodingIsFun
      @CodingIsFun  11 หลายเดือนก่อน

      Glad it was helpful! Thanks for watching and taking the time to leave a comment

  • @stopthink9000
    @stopthink9000 ปีที่แล้ว +3

    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!

  • @joseg3102
    @joseg3102 2 หลายเดือนก่อน +1

    This is awesome!

    • @CodingIsFun
      @CodingIsFun  หลายเดือนก่อน

      Thanks! 🙏 Cheers, Sven ✌️

  • @servicekingbd
    @servicekingbd ปีที่แล้ว +4

    I'm stronger day by day.Thanks for promoting me. Stay with chatGPT official channel.

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว

      Cheers for checkin' out the video and leavin' a comment.

  • @WirelessGus
    @WirelessGus ปีที่แล้ว +2

    thanks for sharing your knowledge. #respect 🤝

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว

      My pleasure! Appreciate you taking the time to watch and leave a comment. 👍

  • @jalrox123
    @jalrox123 ปีที่แล้ว +1

    Wow. You are so good at teaching

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว

      Thanks for the kind words! I am glad you enjoyed it. 👍

  • @videoanalyzers
    @videoanalyzers ปีที่แล้ว +2

    Fantastic. So curious to see where we will be in a couple of years

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว

      Thanks for watching. I'm excited for what's to come as well!

  • @happy2u91221
    @happy2u91221 ปีที่แล้ว +3

    Great video! Very good demonstration.

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว +1

      Thanks for leaving a comment and for taking the time to watch! Glad you liked it.

  • @rp5047
    @rp5047 ปีที่แล้ว +1

    Amazing decodes

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว

      Thanks for checkin' out the video and leavin' a comment, much appreciated.

  • @AmrAtef_CRE
    @AmrAtef_CRE 6 หลายเดือนก่อน

    thank you for this awesome video

    • @CodingIsFun
      @CodingIsFun  6 หลายเดือนก่อน

      My pleasure! Appreciate you taking the time to watch and leave a comment.

  • @gringadoor5385
    @gringadoor5385 ปีที่แล้ว +83

    Twist, GPT sends an email to your manager that fires you instead and replaces your job with AI.

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว +6

      😳😢

    • @lindsayheyes925
      @lindsayheyes925 ปีที่แล้ว

      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.

    • @bala6390
      @bala6390 ปีที่แล้ว

      😂😂😂

    • @ninjacat8113
      @ninjacat8113 ปีที่แล้ว

      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.

    • @EtchedinHistory-lu4iw
      @EtchedinHistory-lu4iw ปีที่แล้ว

      Hires homeless man to enter prompt

  • @hyo1106
    @hyo1106 4 หลายเดือนก่อน

    hello, thanks a lot! inspiring !!

    • @CodingIsFun
      @CodingIsFun  4 หลายเดือนก่อน

      Glad to hear you liked it! Thank you for commenting and watching. Cheers, Sven ✌️

  • @tylerpotts4304
    @tylerpotts4304 ปีที่แล้ว +11

    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.

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว +2

      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.

    • @MrBernaln2
      @MrBernaln2 ปีที่แล้ว +1

      I used the DAN promt. Asked it to summarize a WSJ link and it did so. Chat has connection , just needs the right promt.

    • @tylerpotts4304
      @tylerpotts4304 ปีที่แล้ว +1

      @@MrBernaln2 Was your WSJ article from 2021 or earlier?

  • @youri655
    @youri655 ปีที่แล้ว +2

    Awesome tutorial, thanks!

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว +1

      Glad to hear you liked it! Thank you for commenting and watching. 👍

  • @sachin.tandon
    @sachin.tandon ปีที่แล้ว

    Very impressive!

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว

      Glad you liked it. Thanks for watching.

  • @FinanciallySavvyParent
    @FinanciallySavvyParent ปีที่แล้ว

    This is fantastic

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว

      Thanks for leaving a comment and for taking the time to watch! Glad you liked it. 😃

  • @zkiyyeller3525
    @zkiyyeller3525 ปีที่แล้ว +3

    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?

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว +3

      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.

    • @zkiyyeller3525
      @zkiyyeller3525 ปีที่แล้ว +1

      @@CodingIsFun Thank you so much! You are an inspiration Sir!

  • @phindilemandzendze3611
    @phindilemandzendze3611 ปีที่แล้ว

    Wow . This brought lot of solution to my offce problem.thnx

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว

      Happy to hear that it was useful; thank you for taking the time to leave a comment and for watching the video!

  • @driouichelmahdi
    @driouichelmahdi ปีที่แล้ว +1

    Thank You Bro 👍👍👍👍👍

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว

      An absolute pleasure! Thanks for watching and the first comment! 🎉🚀

  • @georgeolivares6952
    @georgeolivares6952 ปีที่แล้ว

    Amazing!

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว

      Glad you liked it. Thanks for watching. :)

  • @javshah105
    @javshah105 ปีที่แล้ว

    Thanks a lot

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว +1

      My pleasure! Thanks for watching :)

  • @circuitmasters5258
    @circuitmasters5258 ปีที่แล้ว +1

    Man this is spooky 😂, chatgpt is kicking arse on all fronts

  • @Ilovemesumgravy
    @Ilovemesumgravy 3 หลายเดือนก่อน

    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!

    • @CodingIsFun
      @CodingIsFun  3 หลายเดือนก่อน

      Welcome aboard and happy coding/prompting! 🎉 Cheers, Sven ✌️

  • @ashleybasson5664
    @ashleybasson5664 ปีที่แล้ว +4

    Sven: Chat, write the script for a TH-cam 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…

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว

      Haha 😂 Exactly like this 😅

  • @gregory4290
    @gregory4290 ปีที่แล้ว +6

    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!

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว +4

      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! :)

    • @leventguner8882
      @leventguner8882 11 หลายเดือนก่อน

      OMG!

  • @huseinramadhan6156
    @huseinramadhan6156 6 หลายเดือนก่อน

    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

    • @CodingIsFun
      @CodingIsFun  6 หลายเดือนก่อน

      Thanks for watching. I am using camtasia.

  • @rentacowisgoogle
    @rentacowisgoogle ปีที่แล้ว +3

    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.

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว

      Thanks for watching the video. It's always great to see how ChatGPT handles different tasks. Glad you're having fun with it! 👍

  • @arhennam6477
    @arhennam6477 ปีที่แล้ว

    Great video! thanks for sharing
    Im not developper, which app do you use to past the chatgpt's code please

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว

      Thanks for watching. In the video, I used VS Code.

  • @TomCoutfit
    @TomCoutfit ปีที่แล้ว +1

    Hi. Just setting out on my Python journey but how have you set that up? Are you running it through Idle Shell? Thanks

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว

      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!

    • @user-yj3mf1dk7b
      @user-yj3mf1dk7b ปีที่แล้ว +1

      why you ask him? ask ChatGPT LOL
      (it really works like that)

  • @mazz777
    @mazz777 ปีที่แล้ว +2

    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?

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว +2

      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.

    • @gildaslefur2435
      @gildaslefur2435 ปีที่แล้ว +1

      @@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!

  • @d4tset785
    @d4tset785 ปีที่แล้ว

    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?

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว +1

      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! 💻📈📚

  • @AndrewRoberts11
    @AndrewRoberts11 ปีที่แล้ว +2

    Have you tried substituting Powershell for Python?

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว +1

      Thanks for watching. At work, I also Powershell and Batch scripts. Mainly because they are integrated in Windows.

  • @minhngo154
    @minhngo154 ปีที่แล้ว +2

    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?

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว

      Thanks for watching. Please have a look here: chatgpt-static.s3.amazonaws.com/chats/gq12619.html

  • @yiktube
    @yiktube ปีที่แล้ว +2

    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.

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว

      Thank you for watching the video & your suggestion.

  • @divz2646
    @divz2646 ปีที่แล้ว

    Sir can we use it to make karoke of original songs or combine songs to make mashups?

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว +1

      Thanks for watching. Just give it a try and ask chatGPT. Happy Coding! :)

  • @dfkgjdflkg
    @dfkgjdflkg ปีที่แล้ว +1

    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"

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว

      ...but in anycase, thanks for watching the video :)

  • @thepragmatic6383
    @thepragmatic6383 ปีที่แล้ว +1

    Finally, did you get your raise?

  • @whoslappedthepie
    @whoslappedthepie ปีที่แล้ว +1

    How do you feed it the XLSX File? I don't understand this part

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว +1

      I am not feeding the Excel file. I am just describing where my data is located

  • @Brovha
    @Brovha ปีที่แล้ว +1

    Which operating system are you using?

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว +1

      Windows

    • @Brovha
      @Brovha ปีที่แล้ว

      @Coding Is Fun wow thank you so much for the reply

  • @Traveltoexplore675
    @Traveltoexplore675 ปีที่แล้ว

    In which software i have to paste the codes to generate the results?

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว +1

      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.

  • @vExXn1
    @vExXn1 ปีที่แล้ว

    How can I make the same thing as in 1st Example but to send automatically at certain date?

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว

      Thanks for watching. That is an excellent question also for ChatGPT ;)
      👉 ibb.co/f0FWFBh

  • @AishaKhan-ev2tk
    @AishaKhan-ev2tk 3 หลายเดือนก่อน

    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.

    • @CodingIsFun
      @CodingIsFun  2 หลายเดือนก่อน

      Thanks for watching and your suggestion! Cheers, Sven ✌️

  • @Xceedch667
    @Xceedch667 ปีที่แล้ว

    Is there any code to automatically copying incoming certain whatsapp messages to another program like excel or word?

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว

      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!

  • @picklenickil
    @picklenickil ปีที่แล้ว

    The only thing missing are the cmd statements to get those library and venv setup

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว +1

      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.

    • @picklenickil
      @picklenickil ปีที่แล้ว

      @@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.

  • @abhijeetsingh2472
    @abhijeetsingh2472 5 หลายเดือนก่อน

    Please tell, where are you copying and pasting the chatgpt provided codes

    • @CodingIsFun
      @CodingIsFun  5 หลายเดือนก่อน

      In VS Code

  • @reflectedthoughts3376
    @reflectedthoughts3376 9 หลายเดือนก่อน

    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

    • @CodingIsFun
      @CodingIsFun  9 หลายเดือนก่อน

      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!

  • @nikhil-di3vn
    @nikhil-di3vn ปีที่แล้ว +1

    Can chatGPT access files on the computer?

  • @mehrabanbarimani
    @mehrabanbarimani ปีที่แล้ว +1

    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 :(

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว +1

      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.

    • @mehrabanbarimani
      @mehrabanbarimani ปีที่แล้ว

      @@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.

  • @AllNamesAreTakenROFL
    @AllNamesAreTakenROFL ปีที่แล้ว +2

    I tried to automate outlook printing email attachments but the code never works.

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว

      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.

  • @jarosaw4013
    @jarosaw4013 ปีที่แล้ว +1

    But video is superb

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว

      Thank you very much! :)

  • @plamenaleksandrov9063
    @plamenaleksandrov9063 ปีที่แล้ว +1

    how does the AI enters your PC data and analyze It

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว +1

      It doesn't. As shown in the video, you need to be specific with your prompt about the file/data location.

  • @h2nrlc
    @h2nrlc 6 วันที่ผ่านมา

    i wonder if im running in javascript
    is it possible? i nver try it before

    • @CodingIsFun
      @CodingIsFun  6 วันที่ผ่านมา

      Thanks for watching. Sorry, but I am not sure what you mean. Cheers, Sven ✌️

    • @h2nrlc
      @h2nrlc 5 วันที่ผ่านมา

      @@CodingIsFun i mean i made command to chatgpt to get the script but in javascript languange

  • @ibaha411
    @ibaha411 ปีที่แล้ว

    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?

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว +1

      Thank you for watching the video & your suggestion.

    • @ibaha411
      @ibaha411 ปีที่แล้ว

      @CodingIsFun, do you know if it’s doable to print a streamlit page to a pdf file?

  • @youtubeuser1052
    @youtubeuser1052 ปีที่แล้ว

    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?

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว

      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."

    • @youtubeuser1052
      @youtubeuser1052 ปีที่แล้ว

      @@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

  • @RobertLoPinto
    @RobertLoPinto ปีที่แล้ว +1

    FYI, it was a deprecation warning, not depreciation.

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว +1

      Thanks for the hint. You are absolutely right - I mispronounced it.

    • @RobertLoPinto
      @RobertLoPinto ปีที่แล้ว

      @@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!

  • @sayhi2kojo1
    @sayhi2kojo1 ปีที่แล้ว +1

    Are u from Austria

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว +1

      Nope, from Germany

    • @sayhi2kojo1
      @sayhi2kojo1 ปีที่แล้ว

      @@CodingIsFun at least I was close

  • @hellofrombd1960
    @hellofrombd1960 ปีที่แล้ว +5

    So, It’s time to search new job. If chatGpt can do such kind of codes .Then what will be the task of programmers? 🤔🤔🤔

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว

      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 💪

    • @11111shruti
      @11111shruti ปีที่แล้ว +1

      @@CodingIsFun : i agree. think that it will accelerate the development faster. mediocre and low level coding will take a hit.

    • @ohnitiel
      @ohnitiel ปีที่แล้ว

      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

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว +3

      @@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..

    • @aliaffan88
      @aliaffan88 ปีที่แล้ว +7

      AI will not make u jobless, a person using AI will.

  • @kevinsmall5232
    @kevinsmall5232 9 หลายเดือนก่อน

    Wish I knew this when I had to stitch 500+ pdf pages together

    • @CodingIsFun
      @CodingIsFun  9 หลายเดือนก่อน

      Next time then ;)

  • @se6369
    @se6369 ปีที่แล้ว

    Why use Python instead of Visual Basic for Applications? VBA is already integrated with Office.

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว +1

      Thanks for watching. Here is my opinion about it: th-cam.com/video/GeX0g5Zj4Qs/w-d-xo.html
      Also, I have done a similar video using ChatGPT to generate VBA code. You can find the video here: th-cam.com/video/AEgzrEYYboU/w-d-xo.html

    • @se6369
      @se6369 ปีที่แล้ว

      @@CodingIsFun Thanks!

  • @hannaha.2917
    @hannaha.2917 ปีที่แล้ว

    What inspires you to make these vids?

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว

      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! ✌

  • @jerry27syd
    @jerry27syd ปีที่แล้ว

    Praise ChatGPT

  • @nathanaelaaron8292
    @nathanaelaaron8292 ปีที่แล้ว +1

    Power of god

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว

      Thank you for watching the video and taking the time to leave a comment!

  • @KimYoungUn69
    @KimYoungUn69 ปีที่แล้ว +1

    Thanks, my manager is now daily receiving around 1000 emails for salary increase untill he replies with *approved* and a signature. Kindly Regards

  • @3V1TW1N
    @3V1TW1N ปีที่แล้ว

    Kann es sein das du eigentlich deutsch sprichst?

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว

      Japp, ich bin Deutscher

  • @Melvin_bec
    @Melvin_bec 9 หลายเดือนก่อน

    Höre ich da deutsch raus?🤔

    • @CodingIsFun
      @CodingIsFun  9 หลายเดือนก่อน +1

      Jopp, ich bin Deutscher

    • @Melvin_bec
      @Melvin_bec 9 หลายเดือนก่อน

      @@CodingIsFun Den Akzent hört man leicht raus😂 aber gutes Video

    • @CodingIsFun
      @CodingIsFun  9 หลายเดือนก่อน

      @@Melvin_bec Danke!

  • @vincent1237
    @vincent1237 ปีที่แล้ว +1

    Are you deutsch

  • @elsheep6951
    @elsheep6951 ปีที่แล้ว +1

    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". :(

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว +1

      Nope, that sometimes happens

  • @yashikalanjewar6857
    @yashikalanjewar6857 11 หลายเดือนก่อน

    omg!!!

  • @steeneugenpoulsen8174
    @steeneugenpoulsen8174 ปีที่แล้ว +1

    Here is a revolutionary solution instead. Stop DEFINING work as boring, work and work related stuff is most of our lives.

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว

      Thanks for watching and throwing in your two cents.

  • @Lnd2345
    @Lnd2345 ปีที่แล้ว +1

    Amazing, time to say bye to programming jobs.

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว

      Thanks! Let's see how it develops 😅

    • @maulikmadhavi
      @maulikmadhavi ปีที่แล้ว

      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

  • @Bobberg90
    @Bobberg90 9 หลายเดือนก่อน

    Content warnings are probably because you're potentially uploading personal data to ChatGPT.

    • @CodingIsFun
      @CodingIsFun  9 หลายเดือนก่อน

      Hmm, but I did not upload any personal information 🤔

  • @bc4198
    @bc4198 ปีที่แล้ว +1

    Lol, people are already afraid of hackers - now we won't even get to use computers anymore 😆.
    🤬 Now I scared myself 😞

  • @ThePolaroid669
    @ThePolaroid669 ปีที่แล้ว

    wow, you're so gorgeous!

  • @maghambor
    @maghambor ปีที่แล้ว

    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.

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว +1

      Thanks for watching and throwin' in your two cents.

  • @sabitridevisonthalia8213
    @sabitridevisonthalia8213 ปีที่แล้ว

    Imagine my boss finding out 😇😇

  • @garethde-witt6433
    @garethde-witt6433 ปีที่แล้ว

    Don’t it’s asking for trouble the tasks maybe boring but I rather do boring than trust ai.

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว +1

      Thanks for giving the video a watch and leaving your thoughts!

  • @agape_99
    @agape_99 ปีที่แล้ว +1

    Sub

    • @CodingIsFun
      @CodingIsFun  ปีที่แล้ว +1

      Welcome aboard and thanks for watching the video!

  • @MohammadKareem-kd2pz
    @MohammadKareem-kd2pz ปีที่แล้ว +1

    I can see many jobs will disappear sooner of later!

  • @hmmm8158
    @hmmm8158 ปีที่แล้ว +1

    Unemployment will be soaring lol