The PyCoach
The PyCoach
  • 84
  • 2 685 047
Data Cleaning in Python with Real-Life Dataset
To try everything Brilliant has to offer-free-for a full 30 days, visit brilliant.org/ThePyCoach . You’ll also get 20% off an annual premium subscription.
Dataset: github.com/thepycoach/data_preprocessing/tree/main
Cleaning data is one of the most common tasks data analysts and scientists have to do and in this tutorial, we’ll learn how to clean data using Python and Pandas
🔥 My FREE ChatGPT Cheat Sheet: frankandrade.ck.page/08c94cf1c1
My Courses
==========
🔥 Join My Automation Course in Python: www.udemy.com/course/automate-your-life-with-python/?referralCode=7FA8B361D7A92B03A8C3
🔥 Join My Python for Data Science Bootcamp: www.udemy.com/course/python-for-data-science-bootcamp-2022-from-zero-to-hero/?referralCode=649B94757CB7A3A4756F
🔥 8-hour Web Scraping Course in Python: www.udemy.com/course/web-scraping-course-in-python-bs4-selenium-and-scrapy/?referralCode=291C4D7FF6F683531933
💰 Make money by writing about AI, programming, data science or tech: thepycoach.teachable.com/p/medium
Support My Work
==============
💵 PayPal: www.paypal.com/donate/?hosted_button_id=FV6C563QKSYGS
Content
0:00 Intro
5:18 Identifying Missing Data
15:45 Dealing with Missing Data (.drop .dropna)
28:20 Dealing with Missing Data (.fillna)
42:27 Extracting Data
Disclaimer: This video was sponsored by Brilliant
zhlédnutí: 580

Video

This is the best web scraping method
zhlédnutí 2,5KPřed 28 dny
To try everything Brilliant has to offer-free-for a full 30 days, visit brilliant.org/ThePyCoach . You’ll also get 20% off an annual premium subscription. In this video, we'll see step by step how to find the hidden API and use it to easily extract data from sites with Python. 🔥 My FREE ChatGPT Cheat Sheet: frankandrade.ck.page/08c94cf1c1 My Courses 🔥 Join My Automation Course in Python: www.ud...
ChatGPT for Data Analysis - Full Course
zhlédnutí 2,2KPřed 2 měsíci
To try everything Brilliant has to offer-free-for a full 30 days, visit brilliant.org/ThePyCoach . You’ll also get 20% off an annual premium subscription. 🔥 My FREE ChatGPT Cheat Sheet: artificialcorner.com/p/redeem-my-udemy-courses-for-free 🧑🏻‍💻 Resources for the course: github.com/thepycoach/chatgpt/tree/main My Courses 🔥 Join My Automation Course in Python: www.udemy.com/course/automate-your...
Web Scraping with GPT-4o and Python is easy!
zhlédnutí 5KPřed 2 měsíci
To try everything Brilliant has to offer-free-for a full 30 days, visit brilliant.org/ThePyCoach . You’ll also get 20% off an annual premium subscription. In this video, we'll see how to do web scraping with GPT-4o and Python OpenAI Playground: platform.openai.com/playground/chat?models=gpt-4o Scripts: github.com/thepycoach/chatgpt/tree/main/GPT-4o Site: www.adamchoi.co.uk/bttsresult/detailed M...
GPT-4o for data analysis is amazing! (3 New Features)
zhlédnutí 2,2KPřed 2 měsíci
Free dataset used in the video: brdta.com/thepycoach_ds In this video, we'll explore the new data analysis features in ChatGPT's GPT-4o. My Courses 🔥 Join My Automation Course in Python: www.udemy.com/course/automate-your-life-with-python/?referralCode=7FA8B361D7A92B03A8C3 🔥 Join My Python for Data Science Bootcamp: www.udemy.com/course/python-for-data-science-bootcamp-2022-from-zero-to-hero/?r...
3 Python automation projects you can finish in a weekend
zhlédnutí 3,9KPřed 3 měsíci
To try everything Brilliant has to offer-free-for a full 30 days, visit brilliant.org/ThePyCoach . You’ll also get 20% off an annual premium subscription. In this video, we'll solve 3 Python automation projects. 👨🏻‍💻Code/Datasets used in this video: Project 2: github.com/thepycoach/automation/tree/main/Word Project 3: github.com/thepycoach/automation/tree/main/Google Form My Courses 🔥 Join My A...
If you're web scraping, don't make these mistakes
zhlédnutí 1,2KPřed 3 měsíci
Get $10 credit to try Bright Data: brdta.com/thepycoach_sb In this video, we'll see some common mistakes to avoid and tips to follow when web scraping. - Best web scraping libraries 2024: czcams.com/video/CwUADWr5nAI/video.html - Command: exe_path remote-debugging-port=9222 user-data-dir="new_profile_path" 🔥 Best Selling Web Scraping Course in Python: www.udemy.com/course/web-scraping-course-in...
You're using ChatGPT wrong (as a data analyst)
zhlédnutí 2,1KPřed 3 měsíci
To try everything Brilliant has to offer-free-for a full 30 days, visit brilliant.org/ThePyCoach . You’ll also get 20% off an annual premium subscription. 🔥 My FREE ChatGPT Cheat Sheet: artificialcorner.substack.com/p/redeem-my-udemy-courses-for-free In this video, we'll see how to use ChatGPT more effectively for data analysis and programming tasks. My Courses 🔥 Join My Automation Course in Py...
Automate Boring Excel Tasks with These New GPTs
zhlédnutí 940Před 4 měsíci
To try everything Brilliant has to offer-free-for a full 30 days, visit brilliant.org/ThePyCoach . You’ll also get 20% off an annual premium subscription. 🔥 My FREE ChatGPT Cheat Sheet: artificialcorner.substack.com/p/redeem-my-udemy-courses-for-free In this video, we'll see how to automate boring excel tasks with ChatGPT GPTs. Store Sales Dataset: www.kaggle.com/datasets/rohitsahoo/sales-forec...
10 Python Mistakes You Shouldn’t Make as a Data Analyst
zhlédnutí 932Před 4 měsíci
To try everything Brilliant has to offer-free-for a full 30 days, visit brilliant.org/ThePyCoach . You’ll also get 20% off an annual premium subscription. In this video, we’re going to see some common Python beginner mistakes that you should avoid when working with data. 🔥 My FREE Cheat Sheets: frankandrade.ck.page/08c94cf1c1 My Courses 🔥 Join My Automation Course in Python: www.udemy.com/cours...
What's the best Python Web Scraping library in 2024?
zhlédnutí 2,2KPřed 4 měsíci
Get $10 credit to try Bright Data’s Scraping Browser : brdta.com/thepycoach In this video, we'll review different Python web scraping libraries. 🔥 Best Selling Web Scraping Course in Python: www.udemy.com/course/web-scraping-course-in-python-bs4-selenium-and-scrapy/?referralCode=291C4D7FF6F683531933 🔥 Join My Automation Course in Python: www.udemy.com/course/automate-your-life-with-python/?refe...
Can ChatGPT replace data analysts?
zhlédnutí 2KPřed 5 měsíci
To try everything Brilliant has to offer-free-for a full 30 days, visit brilliant.org/ThePyCoach . You’ll also get 20% off an annual premium subscription. In this video, we'll see whether ChatGPT is useful for solving a real-world data analysis project. 🔥 My FREE ChatGPT Cheat Sheet: frankandrade.ck.page/08c94cf1c1 My Courses 🔥 Join My Automation Course in Python: www.udemy.com/course/automate-...
Web Scraping with ChatGPT Mentions is Mind Blowing!
zhlédnutí 29KPřed 5 měsíci
To try everything Brilliant has to offer-free-for a full 30 days, visit brilliant.org/ThePyCoach . You’ll also get 20% off an annual premium subscription. In this video, I'll show you how to do web scraping with GPT mentions (Scraper Data Analyst) - Link 1: www.audible.com/adblbestsellers?page=1 - Link 2: www.soccerphile.com/world-cup-2014-schedule-results My Data Analysis Course 🔥 SQL Python C...
Web Scraping for Beginners with Python and Selenium 4
zhlédnutí 9KPřed 6 měsíci
To try everything Brilliant has to offer-free-for a full 30 days, visit brilliant.org/ThePyCoach . The first 200 of you will get 20% off Brilliant’s annual premium subscription. In this video, we'll learn the first stage of a data analysis project-web scraping. We'll learn web scraping in Python using Selenium 4. Also, we'll learn the contains function which comes in handy when scraping HTML el...
The Best GPTs for Programmers
zhlédnutí 3,2KPřed 7 měsíci
To try everything Brilliant has to offer-free-for a full 30 days, visit brilliant.org/ThePyCoach . The first 200 of you will get 20% off Brilliant’s annual premium subscription. Here are the links to the best GPTs for programmers DesignerGPT: chat.openai.com/g/g-2Eo3NxuS7-designergpt Screenshot to CodeGPT: chat.openai.com/g/g-hz8Pw1quF-screenshot-to-code-gpt Code Tutor: chat.openai.com/g/g-HxPr...
How to Create Advanced Automation in Your GPTs - GPT Actions
zhlédnutí 7KPřed 8 měsíci
How to Create Advanced Automation in Your GPTs - GPT Actions
I've Created a Custom GPT That Extracts Data from Websites
zhlédnutí 64KPřed 9 měsíci
I've Created a Custom GPT That Extracts Data from Websites
Learning Polars for Data Analysis? Start Here!
zhlédnutí 2,7KPřed 10 měsíci
Learning Polars for Data Analysis? Start Here!
How I Use ChatGPT Vision As a Data Analyst
zhlédnutí 3,5KPřed 10 měsíci
How I Use ChatGPT Vision As a Data Analyst
How I'm Using ChatGPT to Learn Languages Fast
zhlédnutí 1,6KPřed 11 měsíci
How I'm Using ChatGPT to Learn Languages Fast
ChatGPT Code Interpreter Automates Excel Reporting (with Python)
zhlédnutí 5KPřed rokem
ChatGPT Code Interpreter Automates Excel Reporting (with Python)
How I Use ChatGPT as a Data Analyst: Plugins, Code Interpreter, GPT-4
zhlédnutí 26KPřed rokem
How I Use ChatGPT as a Data Analyst: Plugins, Code Interpreter, GPT-4
ChatGPT Code Interpreter: Connect to CSV File & Send Emails with Attachment
zhlédnutí 4KPřed rokem
ChatGPT Code Interpreter: Connect to CSV File & Send Emails with Attachment
Web Scraping with ChatGPT Code Interpreter is Mind-Blowing!
zhlédnutí 236KPřed rokem
Web Scraping with ChatGPT Code Interpreter is Mind-Blowing!
ChatGPT Code Interpreter - This Will Change Data Science Forever
zhlédnutí 14KPřed rokem
ChatGPT Code Interpreter - This Will Change Data Science Forever
Scrape Websites with 1 Prompt using This ChatGPT Plugin
zhlédnutí 14KPřed rokem
Scrape Websites with 1 Prompt using This ChatGPT Plugin
GPT-Engineer: Generate a Full Codebase with 1 Prompt
zhlédnutí 8KPřed rokem
GPT-Engineer: Generate a Full Codebase with 1 Prompt
This JupyterLab Extension Adds ChatGPT to Your Notebooks
zhlédnutí 10KPřed rokem
This JupyterLab Extension Adds ChatGPT to Your Notebooks
Automate Data Analysis with This ChatGPT Plugin
zhlédnutí 19KPřed rokem
Automate Data Analysis with This ChatGPT Plugin
Upload CSV File to ChatGPT and Do Data Analysis without Code Interpreter Plugin
zhlédnutí 66KPřed rokem
Upload CSV File to ChatGPT and Do Data Analysis without Code Interpreter Plugin

Komentáře

  • @paulchan6818
    @paulchan6818 Před 2 dny

    Can we mix loc() and iloc()? For example, the column is the name and row is the position.

  • @marronnier17
    @marronnier17 Před 4 dny

    Thank you so much. You made a complicated ( for me) topic very straight forward. It worked first time. Of course Google has changed some of it's gmail setting screens and menu but otherwise perfect. Thanks again.

  • @h.t.8812
    @h.t.8812 Před 6 dny

    thank you so much, I was thinking the group ID was the name of the group... unfortunately it seems pywhatkit doesn't type characters from outside the English language, not sure how I'll continue, maybe I'll transform the message into an image

  • @sagkiller
    @sagkiller Před 6 dny

    bro thanks it worked for me i was literally struggling to scrap data at my new job it helped me

  • @blackice214
    @blackice214 Před 7 dny

    This wont work on a lot of sites..you need pandas and make the script pretend you are a browser. Or you will get the error 403 forbidden

  • @abdulmuizzikumapayi2811

    can i use this @ in my api call of openai to interact with the gpt like scraper and data analysis

  • @varapradha-m6r
    @varapradha-m6r Před 8 dny

    Python is such a powerful language for automating tasks like sending emails. SmythOS can enhance that by orchestrating multiple AI agents to handle complex email workflows seamlessly

  • @atultanna
    @atultanna Před 9 dny

    Eager to see long form content using chatgpt 4o API

  • @atultanna
    @atultanna Před 9 dny

    Is it possible to extract images for affiliate market and satisfy their TOC

  • @txreal2
    @txreal2 Před 10 dny

    Your video goes directly into the useful data cleaning functions, no boring intro & stuff. Thanks 🙏

  • @kerry123kerry5
    @kerry123kerry5 Před 11 dny

    Is gpt 4o you use in the video free?

  • @Its_me_bishal20
    @Its_me_bishal20 Před 12 dny

    Scrape skool group members name and linkedin

  • @user-yq5uu4zq9o
    @user-yq5uu4zq9o Před 13 dny

    🎉🎉❤❤

  • @Libanes13sbo
    @Libanes13sbo Před 15 dny

    Exceptional tutorial! congratulations!

  • @Monsterdeh
    @Monsterdeh Před 15 dny

    Well, 21 data are not enough!

  • @ThePyCoach
    @ThePyCoach Před 15 dny

    To try everything Brilliant has to offer-free-for a full 30 days, visit brilliant.org/ThePyCoach . You’ll also get 20% off an annual premium subscription.

  • @LeoDabague
    @LeoDabague Před 16 dny

    I'm trying other websites and keep getting: 401 :( 2024-08-13 18:19:35 [scrapy.core.engine] DEBUG: Crawled (401)

  • @free_audiobooks
    @free_audiobooks Před 19 dny

    Let's appreciate his efforts , he trying to help community

  • @nijamyoi1206
    @nijamyoi1206 Před 19 dny

    U know how to bypass virtual queue from cloudflare?

  • @sakethkumarpeddi2089
    @sakethkumarpeddi2089 Před 26 dny

    Man. You are just awesome. I've spent almost half of my day on how to send emails with free SMTP services. Thank you, Thank you so much. 😊

  • @muhammaddawoud1838
    @muhammaddawoud1838 Před 29 dny

    This is one of the best python lessons.

  • @floyd1411
    @floyd1411 Před měsícem

    Could i scrape content (esp. Video links) from Patreon?

    • @ThePyCoach
      @ThePyCoach Před 29 dny

      If you mean getting the links, sure you can, but I'm not quite sure about extracting the video files because I never tried.

  • @mehdismaeili3743
    @mehdismaeili3743 Před měsícem

    Excellent .

  • @user-xf8sw2jy6w
    @user-xf8sw2jy6w Před měsícem

    It is very helpfull video, But i got this error "ImportError: cannot import name 'PandasAI' from 'pandasai' " i cant handle this could you give us some updates please :)

    • @genderplugin
      @genderplugin Před 23 dny

      Did you install it in your environment? That typically shows up when the package hasn't been installed.

  • @issamelimrany
    @issamelimrany Před měsícem

    Thank you ! still working as of now.

  • @Justwil07
    @Justwil07 Před měsícem

    Quite complex but very interesting and very useful

  • @pratibhalohiya9874
    @pratibhalohiya9874 Před měsícem

    Awesome 👍 thanks for sharing very useful content 🎉

  • @another-niko-pfp-holder
    @another-niko-pfp-holder Před měsícem

    What if I want to write the script for myself and never share it, should I also save the password as an env variable? (also thanks for the tutorial, exim don't want to work so this is very useful for me)

  • @allensabu6433
    @allensabu6433 Před měsícem

    1:27:29

  • @ThePyCoach
    @ThePyCoach Před měsícem

    To try everything Brilliant has to offer-free-for a full 30 days, visit brilliant.org/ThePyCoach . You’ll also get 20% off an annual premium subscription.

  • @tecnofest7683
    @tecnofest7683 Před měsícem

    Good Job! Thanks 🚀

  • @PeterLawrence193
    @PeterLawrence193 Před měsícem

    Great video

  • @emmanuelsackey286
    @emmanuelsackey286 Před měsícem

    Wow! Great video 👍 I have been looking for something like this. Cheers

  • @kaicex
    @kaicex Před měsícem

    Do you have any solution for cloaflare bypass that works?

  • @emiliomonsalve468
    @emiliomonsalve468 Před měsícem

    Thank you, these companies are charging hundreds of dollars to email people and were here doing it for free because of your tutorial. Thank you!

  • @user-gt4uu1io3h
    @user-gt4uu1io3h Před měsícem

    Thanks, this helped me a lot.

  • @eerd2449
    @eerd2449 Před měsícem

    which tool you using to creat the pyton script?

  • @bmc_
    @bmc_ Před 2 měsíci

    What if we want to only send the message if they respond? How can we implement that?

  • @gunngunn6763
    @gunngunn6763 Před 2 měsíci

    Thank you 🙏🙏🙏

  • @ThePyCoach
    @ThePyCoach Před 2 měsíci

    To try everything Brilliant has to offer-free-for a full 30 days, visit brilliant.org/ThePyCoach . You’ll also get 20% off an annual premium subscription.

  • @andyyy9521
    @andyyy9521 Před 2 měsíci

    I have an issue where my chrome driver not automatically go to the web url. How can I make that so when I run my python code , chrome automatically go to url?

    • @japhethmutuku8508
      @japhethmutuku8508 Před měsícem

      do you still have this issue?

    • @andyyy9521
      @andyyy9521 Před měsícem

      @@japhethmutuku8508 yes

    • @andyyy9521
      @andyyy9521 Před 25 dny

      @@japhethmutuku8508 No. Instead download the chromedriver, I downloaded the Chrome. So it just me that downloaded the wrong file.

  • @averied909
    @averied909 Před 2 měsíci

    why are you parsing the website with xml?

  • @kwakugyabaah6335
    @kwakugyabaah6335 Před 2 měsíci

    Can it accept a list of contacts as an argument?

  • @rahulrajeev9763
    @rahulrajeev9763 Před 2 měsíci

    Can we do this without having the paid version of gpt?

  • @francoisdekoker239
    @francoisdekoker239 Před 2 měsíci

    i get a traceback time out error

  • @marcosparra3981
    @marcosparra3981 Před 2 měsíci

    hi, in 1:04:05, a.e.t. stands for 'at extra time'

  • @osman_gedik
    @osman_gedik Před 2 měsíci

    Ich I want to send 10 emails at the same time, how do I do the loop here?

  • @aidanthompson5053
    @aidanthompson5053 Před 2 měsíci

    6:55

  • @disrael2101
    @disrael2101 Před 2 měsíci

    also what the differnce between the chatgpt version and the playground

  • @disrael2101
    @disrael2101 Před 2 měsíci

    i only have gpt 3.5 in the playground why