Skip to content

Instantly share code, notes, and snippets.

View divyaspec's full-sized avatar
🎯
Focusing

Divya divyaspec

🎯
Focusing
8 followers · 15 following
View GitHub Profile
@johnburnmurdoch
johnburnmurdoch / google_covid_mobility_scraper.R
Created April 15, 2020 08:04
# Install and load required packages
install.packages("needs")
library(needs)
needs(tidyverse, magrittr, animation, pdftools, png, scales)
# Function that extracts data from Google Mobility PDFs
process_google_mobility <- function(country_code, start_date, end_date){
# Convert first page of PDF into high-res PNG
pdf_convert(paste0("https://www.gstatic.com/covid19/mobility/",end_date,"_",country_code,"_Mobility_Report_en.pdf"), format = "png", pages = 1, dpi = 300, filenames = "IMG1.png")
@anhthii
anhthii / sql.md
Last active March 15, 2023 14:12

Prepare for SQL interview questions

Tutorial

SQL tutorial: https://tutorial.techaltum.com/SQLServer.html

Sample questions and solutions