Execute the following in the browser adress bar:
https://console.cloud.google.com/bigquery?p={project-id}&page=project
e.g. https://console.cloud.google.com/bigquery?p=bigquery-public-data&page=project
| library(reactable) | |
| library(dplyr) | |
| red_pal <- function(x) rgb(colorRamp(c("#FFCDD2FF", "#C62828FF"))(x), maxColorValue = 255) | |
| blue_pal <- function(x) rgb(colorRamp(c("#BBDEFBFF", "#1565C0FF"))(x), maxColorValue = 255) | |
| mtcars %>% | |
| select(cyl, mpg) %>% | |
| reactable( | |
| pagination = FALSE, |
| Country,ISOA3,Continent,1880,1881,1882,1883,1884,1885,1886,1887,1888,1889,1890,1891,1892,1893,1894,1895,1896,1897,1898,1899,1900,1901,1902,1903,1904,1905,1906,1907,1908,1909,1910,1911,1912,1913,1914,1915,1916,1917,1918,1919,1920,1921,1922,1923,1924,1925,1926,1927,1928,1929,1930,1931,1932,1933,1934,1935,1936,1937,1938,1939,1940,1941,1942,1943,1944,1945,1946,1947,1948,1949,1950,1951,1952,1953,1954,1955,1956,1957,1958,1959,1960,1961,1962,1963,1964,1965,1966,1967,1968,1969,1970,1971,1972,1973,1974,1975,1976,1977,1978,1979,1980,1981,1982,1983,1984,1985,1986,1987,1988,1989,1990,1991,1992,1993,1994,1995,1996,1997,1998,1999,2000,2001,2002,2003,2004,2005,2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019 | |
| "Afghanistan","AFG","Asia",-0.325,-0.160,-0.814,-0.773,-0.971,-1.133,-1.123,-0.478,0.088,-0.679,-0.617,-1.107,-0.323,-0.914,-1.006,-0.286,-0.299,-0.759,-0.959,0.192,-0.560,-0.291,0.206,-1.049,-0.403,-0.859,-0.386,-0.973,-0.615,-0.069,-0.620,-0.842,-0.251,-0.432,0.256,0.886,-0.614,-0.067,-0.513,-0.38 |
| library(data.table) | |
| library(dplyr) | |
| library(R.utils) | |
| # JUST MASS | |
| mass <- gunzip("arcos-ma-statewide-itemized.tsv.gz") | |
| mass_opioids <- fread(file = 'arcos-ma-statewide-itemized.tsv') | |
| glimpse(mass_opioids) # 2,574,240 observations | |
| summary(mass_opioids) |
Execute the following in the browser adress bar:
https://console.cloud.google.com/bigquery?p={project-id}&page=project
e.g. https://console.cloud.google.com/bigquery?p=bigquery-public-data&page=project
| library(dplyr) | |
| library(ggplot2) | |
| library(plotly) | |
| library(viridis) | |
| data("starwars") | |
| p <- ggplot(starwars) + | |
| geom_point( | |
| aes( # all 4 aes() arguments will print in the plotly tooltip | |
| x = height, # arg 1 |
| # File # 1 | |
| # https://drive.google.com/open?id=1Lhz23JP4gRW4p_01D7OzaL60CT1wfem- | |
| # File # 2 | |
| # https://drive.google.com/open?id=1XOWD8COTdDx30HNLZgrp57WzWUGOtaKA | |
| # NOTE: To load data, you must download both the extract's data and the DDI | |
| # and also set the working directory to the folder with these files (or change the path below). | |
| #install.packages("tidyverse") |
| library(httr) | |
| library(jsonlite) | |
| # https://dataseolabs.com | |
| # Doc : https://www.similarweb.com/corp/developer/ | |
| # Create your key here : https://pro.similarweb.com/#/account/api-management | |
| # You can have freely 3 Months of Web Traffic Data | |
| # conf | |
| myList <- c("cuisineaz.com","marmiton.org","odelices.com","allrecipes.fr") |
| library(chunked) | |
| library(tidyverse) | |
| # I want to look at the daily page views of Wikipedia articles | |
| # before 2015... I can get zipped log files | |
| # from here: https://dumps.wikimedia.org/other/pagecounts-ez/merged/2012/2012-12/ | |
| # I get bz file, unzip to get this: | |
| my_file <- 'pagecounts-2012-12-14/pagecounts-2012-12-14' |
| library(tidycensus) | |
| library(leaflet) | |
| library(sf) | |
| library(viridis) | |
| options(tigris_use_cache = TRUE) | |
| il1 <- get_acs(geography = "county", | |
| variables = c(hhincome = "B19013_001"), | |
| state = "IL", | |
| geometry = TRUE) %>% |
| library(googleAuthR) | |
| ## set scopes for calendar | |
| options(googleAuthR.scopes.selected = "https://www.googleapis.com/auth/calendar.readonly", | |
| googleAuthR.client_id = "XXXX", ## add your Google project client Id | |
| googleAuthR.client_secret = "XXXX") ## add your Google project client secret | |
| ## make sure calendar API is activated for your Google Project at below URL: | |
| # https://console.cloud.google.com/apis/api/calendar-json.googleapis.com/overview |