Automate Boring Office Tasks with ChatGPT and Python

Поделиться
HTML-код
  • Опубликовано: 27 май 2024
  • 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: ruclips.net/user/CodingIsFun?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

Комментарии • 275

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

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

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

  • @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 11 месяцев назад

      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 11 месяцев назад

      Hires homeless man to enter prompt

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

  • @jagotiberan2181
    @jagotiberan2181 11 месяцев назад +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  11 месяцев назад

      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!

  • @arch.blender1178
    @arch.blender1178 Год назад +2

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

    • @CodingIsFun
      @CodingIsFun  Год назад

      Glad I could help! Thanks for watching! 💪

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

  • @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.😊👍

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

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

  • @cristian15154
    @cristian15154 Год назад +2

    Excellent information, thanks!

    • @CodingIsFun
      @CodingIsFun  Год назад

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

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

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

  • @RiminiVirage
    @RiminiVirage Год назад +2

    Excellent video, thank you.

    • @CodingIsFun
      @CodingIsFun  Год назад

      Glad to hear you liked it! Thank you for commenting and 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.

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

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

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

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

  • @tochtzin
    @tochtzin 11 месяцев назад +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

  • @user-li7mq5hp9g
    @user-li7mq5hp9g Год назад +3

    Great tutorial as always. Thank you very much!

    • @CodingIsFun
      @CodingIsFun  Год назад +1

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

  • @WirelessGus
    @WirelessGus Год назад +2

    thanks for sharing your knowledge. #respect 🤝

    • @CodingIsFun
      @CodingIsFun  Год назад

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

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

  • @joseg3102
    @joseg3102 Месяц назад +1

    This is awesome!

    • @CodingIsFun
      @CodingIsFun  Месяц назад

      Thanks! 🙏 Cheers, Sven ✌️

  • @rp5047
    @rp5047 Год назад +1

    Amazing decodes

    • @CodingIsFun
      @CodingIsFun  Год назад

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

  • @jalrox123
    @jalrox123 Год назад +1

    Wow. You are so good at teaching

    • @CodingIsFun
      @CodingIsFun  Год назад

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

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

  • @AmrAtef_CRE
    @AmrAtef_CRE 5 месяцев назад

    thank you for this awesome video

    • @CodingIsFun
      @CodingIsFun  5 месяцев назад

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

  • @hyo1106
    @hyo1106 3 месяца назад

    hello, thanks a lot! inspiring !!

    • @CodingIsFun
      @CodingIsFun  3 месяца назад

      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 11 месяцев назад

    Very impressive!

    • @CodingIsFun
      @CodingIsFun  11 месяцев назад

      Glad you liked it. Thanks for watching.

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

  • @circuitmasters5258
    @circuitmasters5258 Год назад +1

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

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

  • @FinanciallySavvyParent
    @FinanciallySavvyParent Год назад

    This is fantastic

    • @CodingIsFun
      @CodingIsFun  Год назад

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

  • @driouichelmahdi
    @driouichelmahdi Год назад +1

    Thank You Bro 👍👍👍👍👍

    • @CodingIsFun
      @CodingIsFun  Год назад

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

  • @ashleybasson5664
    @ashleybasson5664 Год назад +4

    Sven: Chat, write the script for a RUclips 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 😅

  • @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 :)

  • @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 10 месяцев назад

      OMG!

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

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

  • @huseinramadhan6156
    @huseinramadhan6156 5 месяцев назад

    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  5 месяцев назад

      Thanks for watching. I am using camtasia.

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

  • @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  2 месяца назад

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

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

  • @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 :)

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

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

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

  • @thepragmatic6383
    @thepragmatic6383 Год назад +1

    Finally, did you get your raise?

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

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

  • @Traveltoexplore675
    @Traveltoexplore675 11 месяцев назад

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

    • @CodingIsFun
      @CodingIsFun  11 месяцев назад +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.

  • @reflectedthoughts3376
    @reflectedthoughts3376 8 месяцев назад

    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  8 месяцев назад

      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!

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

  • @abhijeetsingh2472
    @abhijeetsingh2472 4 месяца назад

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

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

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

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

  • @AishaKhan-ev2tk
    @AishaKhan-ev2tk 2 месяца назад

    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  Месяц назад

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

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

  • @nikhil-di3vn
    @nikhil-di3vn Год назад +1

    Can chatGPT access files on the computer?

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

  • @ibaha411
    @ibaha411 11 месяцев назад

    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  11 месяцев назад +1

      Thank you for watching the video & your suggestion.

    • @ibaha411
      @ibaha411 11 месяцев назад

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

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

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

  • @kevinsmall5232
    @kevinsmall5232 9 месяцев назад

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

  • @jarosaw4013
    @jarosaw4013 Год назад +1

    But video is superb

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

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

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

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

  • @sayhi2kojo1
    @sayhi2kojo1 Год назад +1

    Are u from Austria

  • @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: ruclips.net/video/GeX0g5Zj4Qs/видео.html
      Also, I have done a similar video using ChatGPT to generate VBA code. You can find the video here: ruclips.net/video/AEgzrEYYboU/видео.html

    • @se6369
      @se6369 Год назад

      @@CodingIsFun Thanks!

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

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

  • @yashikalanjewar6857
    @yashikalanjewar6857 10 месяцев назад

    omg!!!

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

  • @sabitridevisonthalia8213
    @sabitridevisonthalia8213 Год назад

    Imagine my boss finding out 😇😇

  • @bc4198
    @bc4198 Год назад +1

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

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

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

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

  • @3V1TW1N
    @3V1TW1N Год назад

    Kann es sein das du eigentlich deutsch sprichst?

  • @Bobberg90
    @Bobberg90 8 месяцев назад

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

    • @CodingIsFun
      @CodingIsFun  8 месяцев назад

      Hmm, but I did not upload any personal information 🤔

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

  • @ThePolaroid669
    @ThePolaroid669 Год назад

    wow, you're so gorgeous!

  • @hmmm8158
    @hmmm8158 Год назад +1

    Unemployment will be soaring lol

  • @MohammadKareem-kd2pz
    @MohammadKareem-kd2pz Год назад +1

    I can see many jobs will disappear sooner of later!

  • @vincent1237
    @vincent1237 Год назад +1

    Are you deutsch

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

  • @crc0889
    @crc0889 Год назад +1

    Deprecation. Not depreciation.
    Pronounced deprekation.

    • @CodingIsFun
      @CodingIsFun  Год назад +1

      Thank you very much for the hint. I appreciate it! 👍

    • @crc0889
      @crc0889 Год назад

      @@CodingIsFun thank you for your video! I love the ingenuity.

  • @mutantlabor
    @mutantlabor Год назад

    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…

    • @CodingIsFun
      @CodingIsFun  Год назад

      Thanks for watching and throwin' in your two cents.