Thank you BrightData for sponsoring this video 😍
~
Ever wanted to gather some data from web and use it for analysis? You can use Excel's Power Query to setup and automate web scraping easily. In this tutorial, let's look at how we can combine US state population data with Chocolate Sales data in Excel.
📗 Sample File:
=============
Practice the steps by using the Wikipedia link:
⏱Video Topics:
=============
0:00 - Web Scraping data to Excel - The problem
1:04 - URL based data Extraction with Power Query
3:40 - Cleaning up the data (Transforming with PQ)
5:54 - Loading data to Excel
6:20 - The problems with Power Query method & solution
💡BRIGHTDATA:
=============
If you have a more complex data collection need, then I highly recommend using BrightData. Using their tools, you can automate data collection, clean-up and archival for all situations. If you use my link below, you get a FREE DEMO & $250 matching credit.
~
MORE Power Query 💻⚡:
======================
Power Query can greatly automate & simplify your data processes. If you are new to this revolutionary technology check out below videos.
🕑🕑🕑 1+hr deep videos:
⏳Short but powerful videos:
🎶Play Lists:
~
#Excel #webscraping
~
A data analyst was deathly afraid of spiders. He could never web scrape.