Search⌘ K

Web Scraping Exercise: DataFrames to CSV

Explore how to transform web-scraped HTML tables into pandas DataFrames and export these as CSV files. This lesson helps you practice data extraction techniques needed for ETL processes, enabling efficient preparation of data for analysis and further processing.

We've already read and parsed a Wikipedia web page containing tables ranking the world’s largest banks by total assets and by country. We'll leverage this parsed data to create pandas DataFrames and export them as CSV files for further analysis.

Let’s convert the parsed HTML tables into pandas DataFrames and export them as CSV files.

Create DataFrames using pandas

...