💥Check out [ Ссылка ] to sign up for BrightData and to automate your data collection.
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:
[ Ссылка ]
Download the sample file from here: [ Ссылка ]
⏱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.
LINK 👉 [ Ссылка ]
~
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:
What is Power Query and how to use it with 4 Practical Examples (250k views) - [ Ссылка ]
Automate Data Tasks with Power Query (10 examples) - [ Ссылка ]
⏳Short but powerful videos:
How to combine data from multiple sheets with PQ (250k views) - [ Ссылка ]
Combine data from multiple FILES with PQ (150k views) - [ Ссылка ]
Data cleaning with Excel (10 tips) - [ Ссылка ]
🎶Play Lists:
Power Query tips & tricks - [ Ссылка ]
Data cleanup & automation - [ Ссылка ]
~
#Excel #webscraping
~
A data analyst was deathly afraid of spiders. He could never web scrape.
![](https://s2.save4k.ru/pic/lFx0MkyBZsg/maxresdefault.jpg)