Web Scrape in Google Sheets: IMPORTHTML, IMPORTDATA, & IMPORTFEED Functions (Part 1)

dataslice · Beginner ·📰 AI News & Updates ·5y ago

Skills: Data Literacy80%

Key Takeaways

The video demonstrates web scraping in Google Sheets using IMPORTHTML, IMPORTDATA, and IMPORTFEED functions, providing examples and code snippets for scraping tables, lists, and RSS feeds.

Original Description

Web Scrape in Google Sheets: IMPORTHTML, IMPORTDATA, & IMPORTFEED Functions (Part 1) Part 2: https://youtu.be/4A12xqQPJXU ---------------- Code ---------------- Tables: var i = 1; [].forEach.call(document.querySelectorAll('table'), function(x) { console.log(i++, x); }); Lists: var i = 1; [].forEach.call(document.querySelectorAll('ul,ol'), function(x) { console.log(i++, x); }); ---------------- Datasets ---------------- Apple Species: https://en.wikipedia.org/wiki/List_of_apple_cultivars Earthquakes: https://en.wikipedia.org/wiki/Lists_of_earthquakes Zha Jiang Mian Recipe: https://www.thespruceeats.com/zhajiangmian-chinese-noodle-recipe-4006698 Github CSV: https://github.com/datasets/population/blob/master/data/population.csv NASA RSS Feed: https://www.nasa.gov/content/nasa-rss-feeds/ ---------------- Timeline ---------------- 0:00 Intro 0:36 ImportHTML 4:54 ImportDATA 5:46 ImportFEED 5:59 Summary

Watch on YouTube ↗ (saves to browser)

Sign in to unlock AI tutor explanation · ⚡30

Playlist

Uploads from Dataslice · Dataslice · 5 of 16

← Previous Next →

Web Scrape Text from ANY Website - Web Scraping in R (Part 1)

Web Scrape Text from ANY Website - Web Scraping in R (Part 1)

Web Scrape Nested Links/Multiple Pages - Web Scraping in R (Part 2)

Web Scrape Nested Links/Multiple Pages - Web Scraping in R (Part 2)

Animate Graphs in R: Make Gorgeous Animated Plots with gganimate

Animate Graphs in R: Make Gorgeous Animated Plots with gganimate

Word Clouds in R: Useful & Beautiful Word Clouds with wordcloud2

Word Clouds in R: Useful & Beautiful Word Clouds with wordcloud2

Web Scrape in Google Sheets: IMPORTHTML, IMPORTDATA, & IMPORTFEED Functions (Part 1)

Web Scrape in Google Sheets: IMPORTHTML, IMPORTDATA, & IMPORTFEED Functions (Part 1)

Web Scrape in Google Sheets: IMPORTXML Function (Part 2)

Web Scrape in Google Sheets: IMPORTXML Function (Part 2)

Make Interactive Graphs in R: Creating & Embedding Interactive Graphs with plotly

Make Interactive Graphs in R: Creating & Embedding Interactive Graphs with plotly

R Maps: Beautiful Interactive Choropleth & Scatter Maps with Plotly

R Maps: Beautiful Interactive Choropleth & Scatter Maps with Plotly

Build a Data Science Portfolio (Free & Easy) with Jekyll & GitHub Pages | Part 1: Site Configuration

Build a Data Science Portfolio (Free & Easy) with Jekyll & GitHub Pages | Part 1: Site Configuration

Build a Data Science Portfolio (Free & Easy) with Jekyll & GitHub Pages | Part 2: Adding Posts

Build a Data Science Portfolio (Free & Easy) with Jekyll & GitHub Pages | Part 2: Adding Posts

Build a Data Science Portfolio (Free & Easy) with Jekyll & GitHub Pages | Part 3: Customization

Build a Data Science Portfolio (Free & Easy) with Jekyll & GitHub Pages | Part 3: Customization

Regex Basics | Match, Extract, and Clean Text

Regex Basics | Match, Extract, and Clean Text

Scrape Websites with Regular Expressions

Scrape Websites with Regular Expressions

Dplyr Essentials (easy data manipulation in R): select, mutate, filter, group_by, summarise, & more

Dplyr Essentials (easy data manipulation in R): select, mutate, filter, group_by, summarise, & more

Dplyr Advanced Guide: data cleaning, reshaping, and merging with lubridate, stringr, tidyr, ggplot2

Dplyr Advanced Guide: data cleaning, reshaping, and merging with lubridate, stringr, tidyr, ggplot2

Linear Regression Plots in R

Linear Regression Plots in R

This video teaches you how to use Google Sheets functions to scrape data from websites, including tables, lists, and RSS feeds, and provides examples and code snippets to get you started.

Key Takeaways

Use IMPORTHTML to scrape tables from websites
Use IMPORTDATA to scrape lists from websites
Use IMPORTFEED to scrape RSS feeds from websites
Use Google Sheets functions to import and manipulate data
Practice web scraping with provided datasets and code snippets

💡 Google Sheets provides a range of functions for web scraping, including IMPORTHTML, IMPORTDATA, and IMPORTFEED, which can be used to import and manipulate data from websites.

🔒 Pro feature: Ask AI to explain this lesson →

More on: Data Literacy

View skill →

Analyzing Billing Data with BigQuery

PySpark in Action: Hands-On Data Processing

PySpark in Action: Hands-On Data Processing

Analyze and Visualize Data Using Splunk Statistics

Analyze and Visualize Data Using Splunk Statistics

Apply SCD2 to Build Dynamic Data Models

Automate Financial Insights with AI Tools & Dashboards

Automate Financial Insights with AI Tools & Dashboards

Automate Excel Data with Power Query and Lookups

Automate Excel Data with Power Query and Lookups

Related AI Lessons

[PoV] When Everyone Is Smart, No One Is

In a world where AI makes everyone smart, the value of intelligence decreases, and new challenges arise

Critical thinking in the AI Era

Develop critical thinking skills to navigate the AI era effectively and make informed decisions

Medium · Data Science

Anthropic Just Passed OpenAI Among Business Users. Here’s What That Means for Your Stack.

Anthropic surpasses OpenAI in business user adoption, impacting the AI stack for enterprises

Introducing beLithe: AI Courses Built for Real People, Not Engineers

Learn about beLithe, an AI course platform designed for non-technical individuals, and its mission to make AI accessible to everyone

Chapters (5)

Intro

0:36 ImportHTML

4:54 ImportDATA

5:46 ImportFEED

5:59 Summary

Channels Television