Web Scraping with Pandas | Scraping Tables in 2 minutes!

Using the read_html() method by Pandas we can get access to the tables in a website. Then you can choose which table you want and export it to a CSV file using to_csv() method.
---Support Pythonology---
www.buymeacoff...
-- Best Online Resource for Python --
Datacamp: The best online resource to learn Python, Web Scraping, Data analysis, and Data Science (Affiliate link)
datacamp.pxf.i...

[@irfanshaikh262]

By far the simplest tutorial for scraping a wiki table. Didn't knew actually that it could be done so easily through pandas alone. Thanks a tonn sir

[@Daniel-uu8nu]

TYSM!!! Easy and straightforward, subbed :)

[@rishibhatnagar4888]

A million thanks dude! You made it so easy. Can you make a follow up video on how to refresh the data in the tables at a predefined interval. Thanks in advance ☺️

[@emye35]

THANK YOU SO SO MUCH! Many blessings to you! 🙌🙌

[@coachvik]

Solid tutorial! Thank you. 💯

[@debasishrajbehera]

very helpful sir....thank you so much..🙏

[@ninaemeka]

Thank you so much.God bless you the best among all pattern simple and short.

[@mboe94]

I was so happy when I saw how easy this was, but have a problem with lxml not being installed in Jupyter. Any fix?

[@usmanhanif9436]

Hello Sir! I saw your videos of data scrapping using beautiful soup and write that scraped data in CSV file and found your teaching style interesting can you do me a favor can you make a video of scraping using beautiful Soup and panda to store it in CSV file as soon as possible it will be helpful

[@Pythonology]

hi Usman. Thanks for your comment. I have a whole playlist of WebScraping projects some of which are with Pandas. Here is an example: kzbin.info/www/bejne/pmPcf4Ccdryrhac

[@geekpedia3539]

Is there a way to export it to a SQL program

[@sohanahmed9956]

How can I remove the number column?

[@coachvik]

Try setting the index to False. Example: df.to_csv('FileName.csv',index=False)

[@rashmiburse3298]

thank you so much :)

[@anurajms]

thank you

[@dedisupardi2815]

Cool👍