Скачать или смотреть Web Scraping Wikipedia with Pandas | How to scrape Wikipedia with ONE line of Python!

Wikipedia - Scrape any Table on the page using Pandas and one line of code - 100 characters long!
Using the following you can quickly get the data from any table on the page:

With the aid of ";" semi-colon you can combine the pandas import, and your commands onto one line, hit enter, and check your folder for a CSV!
Nice.

1:42 import pandas as pd
5:43 just table [5]
8:55 save to CSV

Credit: Lynn Leifker for the original idea. https://bit.ly/31ED54M

Play around with these commands and you'll quickly get the data you want #

🔴 import pandas as pd; print(pd.read_html('https://en.wikipedia.org/wiki/Interna...)

🔴 df= pd.read_html('https://en.wikipedia.org/wiki/Interna...)
🔴 print(f"This wikipedia page contains {len(df)} tables")
🔴 df = (df[5])
🔴 df = pd.DataFrame(df)
🔴 dft = df.T
🔴 print(dft)
🔴 df.to_csv("webscrapingf3000x.csv", sep=',', encoding='utf-8-sig')

I've scraped a list of F3000 champions into a CSV.
You may wish to do it with postcodes, football teams, countries, counties, states, whatever!

I'm not advising using pandas for web scraping in general, but thought this was a cool thing to show you - to have more than one way of solving a problem is what keeps things interesting?!

See you around yeah?
Dr Pi.

𝝅 Contact Dr Pi for business enquiries at : https://redandgreen.co.uk/contact/

P.s Mike Thackwell was one of the best drivers, he deserved to be on that list! 🏎