Web Scrape in Google Sheets: IMPORTXML Function (Part 2)
Web Scrape in Google Sheets: IMPORTXML Function (Part 2)
Part 1: https://youtu.be/Q5yVoTqD06M
In this video, we scrape Yelp, Craigslist, and TechCrunch using the importxml function in Google Sheets.
W3 Schools Tutorial: https://www.w3schools.com/xml/xpath_intro.asp
----------------
Datase
----------------
Craigslist: https://philadelphia.craigslist.org/d/cars-trucks/search/cta
TechCrunch: https://techcrunch.com/
Yelp: https://www.yelp.com/search?find_desc=burgers&find_loc=New+York%2C+NY&ns=1
----------------
Timeline
----------------
0:00 Intro
0:40 Scraping Craigslist
4:42 Scraping TechCr…
Watch on YouTube ↗
(saves to browser)
Chapters (4)
Intro
0:40
Scraping Craigslist
4:42
Scraping TechCrunch
5:28
Scraping Yelp
Playlist
Uploads from Dataslice · Dataslice · 12 of 22
1
2
3
4
5
6
7
8
9
10
11
▶
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