Скачать с ютуб AWESOME Excel trick to scrape data from web automatically в хорошем качестве

AWESOME Excel trick to scrape data from web automatically

💥Check out https://brightdata.grsm.io/chandoo 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: https://en.wikipedia.org/wiki/List_of... Download the sample file from here: https://chandoo.org/wp/wp-content/upl... ⏱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 👉 https://brightdata.grsm.io/chandoo ~ 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) -    • Power Query Tutorial - What is it, ho...   Automate Data Tasks with Power Query (10 examples) -    • 10 Ways to save time & Automate tasks...   ⏳Short but powerful videos: How to combine data from multiple sheets with PQ (250k views) -    • AWESOME Excel trick to combine data f...   Combine data from multiple FILES with PQ (150k views) -    • Powerful trick to combine all Excel f...   Data cleaning with Excel (10 tips) -    • Data Cleaning in Excel - 10 Tricks (B...   🎶Play Lists: Power Query tips & tricks -    • Power Query Tutorial - What is it, ho...   Data cleanup & automation -    • Data Cleaning in Excel - 10 Tricks (B...   ~ #Excel #webscraping ~ A data analyst was deathly afraid of spiders. He could never web scrape.