Skip to content

Instantly share code, notes, and snippets.

View lix90's full-sized avatar
🎯
Focusing

Li Xiang lix90

🎯
Focusing
View GitHub Profile
@paslandau
paslandau / bigquery-extract-url-parameters-array.sql
Last active May 16, 2023 06:09
Extract query parameters from a URL as ARRAY in BigQuery
#standardSQL
# Extract query parameters from a URL as ARRAY in BigQuery; standard-sql; 2018-04-08
# @see http://www.pascallandau.com/bigquery-snippets/extract-url-parameters-array/
WITH examples AS (
SELECT 1 AS id,
'?foo=bar' AS query,
'simple' AS description
UNION ALL SELECT 2, '?foo=bar&bar=baz', 'multiple params'
UNION ALL SELECT 3, '?foo[]=bar&foo[]=baz', 'arrays'
UNION ALL SELECT 4, '', 'no query'
@arcaravaggi
arcaravaggi / update_migrate.R
Last active November 4, 2025 09:39
Update R and migrate R packages to new installation from within the console
#From https://stackoverflow.com/questions/1401904/painless-way-to-install-a-new-version-of-r
# Run in the old version of R (or via RStudio)
setwd("C:/Temp/")
packages <- installed.packages()[,"Package"]
save(packages, file="Rpackages")
# INSTALL NEW R VERSION
if(!require(installr)) { install.packages("installr"); require(installr)} #load / install+load installr
# See here for more on installr: https://www.r-statistics.com/2013/03/updating-r-from-r-on-windows-using-the-installr-package/
@javierluraschi
javierluraschi / importing-modern-data-into-r
Last active August 16, 2017 05:19
Importing Modern Data - useR 2016
---
title: "Importing Modern Data into R"
author: Javier Luraschi
date: June 29, 2016
output: revealjs::revealjs_presentation
---
## Overview
* Importing Data
@duffn
duffn / creating_a_date_dimension_table_in_postgresql.sql
Last active October 22, 2025 07:38
Creating a date dimension table in PostgreSQL
DROP TABLE if exists d_date;
CREATE TABLE d_date
(
date_dim_id INT NOT NULL,
date_actual DATE NOT NULL,
epoch BIGINT NOT NULL,
day_suffix VARCHAR(4) NOT NULL,
day_name VARCHAR(9) NOT NULL,
day_of_week INT NOT NULL,
@kdzwinel
kdzwinel / optimizely.js
Created June 17, 2015 21:31
Calculating A/B Test Sample Size
"use strict";
//based on https://www.optimizely.com/resources/sample-size-calculator/
function getSampleSize() {
let effect = 0.05; // Minimum Detectable Effect
let significance = 0.95; // Statistical Significance
let conversion = 0.05; // Baseline Conversion Rate
let c = conversion - (conversion * effect);
let p = Math.abs(conversion * effect);
@ShingoFukuyama
ShingoFukuyama / Font-Awesome-for-Emacs.el
Last active May 3, 2020 11:46
Show Font Awesome icons on Emacs
;; Assume you have already installed Font Awesome on the system
;; http://fortawesome.github.io/Font-Awesome/
(require 'ov)
;; Overlay Library
;; https://github.com/ShingoFukuyama/ov.el
;; Example 1: Insert all fonts at the cursor position
(defun font-awesome-insert-all ()
@octocat
octocat / .gitignore
Created February 27, 2014 19:38
Some common .gitignore configurations
# Compiled source #
###################
*.com
*.class
*.dll
*.exe
*.o
*.so
# Packages #
@genedna
genedna / gentoo-install-manual.md
Last active September 18, 2025 10:01
Gentoo 安装手册

Gentoo 安装手册

第一步:下载安装介质

GentooMinimal Install CD 每周都会自动构建一个版本,服务器一般使用最新的 x86_64 版本。 国内的镜像下载地址是:

第二步:启动机器,设置网络环境和开启 SSH 服务