Web Scrape in Google Sheets: IMPORTHTML, IMPORTDATA, & IMPORTFEED Functions (Part 1)
Skills:
Data Literacy80%
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
1
2
3
4
▶
6
7
8
9
10
11
12
13
14
15
16
Web Scrape Text from ANY Website - Web Scraping in R (Part 1)
Dataslice
Web Scrape Nested Links/Multiple Pages - Web Scraping in R (Part 2)
Dataslice
Animate Graphs in R: Make Gorgeous Animated Plots with gganimate
dataslice
Word Clouds in R: Useful & Beautiful Word Clouds with wordcloud2
dataslice
Web Scrape in Google Sheets: IMPORTHTML, IMPORTDATA, & IMPORTFEED Functions (Part 1)
dataslice
Web Scrape in Google Sheets: IMPORTXML Function (Part 2)
Dataslice
Make Interactive Graphs in R: Creating & Embedding Interactive Graphs with plotly
dataslice
R Maps: Beautiful Interactive Choropleth & Scatter Maps with Plotly
Dataslice
Build a Data Science Portfolio (Free & Easy) with Jekyll & GitHub Pages | Part 1: Site Configuration
dataslice
Build a Data Science Portfolio (Free & Easy) with Jekyll & GitHub Pages | Part 2: Adding Posts
dataslice
Build a Data Science Portfolio (Free & Easy) with Jekyll & GitHub Pages | Part 3: Customization
dataslice
Regex Basics | Match, Extract, and Clean Text
Dataslice
Scrape Websites with Regular Expressions
Dataslice
Dplyr Essentials (easy data manipulation in R): select, mutate, filter, group_by, summarise, & more
Dataslice
Dplyr Advanced Guide: data cleaning, reshaping, and merging with lubridate, stringr, tidyr, ggplot2
dataslice
Linear Regression Plots in R
dataslice
More on: Data Literacy
View skill →Related AI Lessons
⚡
⚡
⚡
⚡
More banks join SoftBank’s $40 billion OpenAI loan as syndication enters soft-launch phase
The Next Web AI
Day 15: The Ripple Effect — Why You Should Start “Building in Public” Today
Medium · AI
When the Instrument Changes
Medium · AI
How Artificial Intelligence Is Quietly Reshaping the Way We Work — and What to Do About It
Medium · Machine Learning
Chapters (5)
Intro
0:36
ImportHTML
4:54
ImportDATA
5:46
ImportFEED
5:59
Summary
🎓
Tutor Explanation
DeepCamp AI