Web Scrape in Google Sheets: IMPORTHTML, IMPORTDATA, & IMPORTFEED Functions (Part 1)
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.thespruc…
Watch on YouTube ↗
(saves to browser)
Chapters (5)
Intro
0:36
ImportHTML
4:54
ImportDATA
5:46
ImportFEED
5:59
Summary
Playlist
Uploads from Dataslice · Dataslice · 11 of 22
1
2
3
4
5
6
7
8
9
10
▶
12
13
14
15
16
17
18
19
20
21
22
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
Web Scrape Multiple Pages with Loops - Web Scraping in R (Part 3)
Dataslice
Web Scrape Tables - Web Scraping in R (Part 4)
Dataslice
Create Animated Racing Bar Charts (Bar Chart Races)
Dataslice
Linear Regression Summary in R
Dataslice
Drag-and-drop ggplot2 graphs with the Esquisse library
Dataslice
Make Beautiful Graphs in R: 5 Quick Ways to Improve ggplot2 Graphs
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
DeepCamp AI