RolandColored

#!/bin/bash
for filename in *.tsv; do
    echo $filename
    tail -n +23 $filename | head -n 1 | sed -e 's/.*(\(.*\)).*/\1/' | sed -e 's/, /\t/g' > fixed/$filename
    tail -n +24 $filename | head -n -7 >> fixed/$filename
done

edonosotti

# ========================================================
# Create Google Cloud Projects from scratch with Terraform
# ========================================================
#
# This script is a workaround to fix an issue with the
# Google Cloud Platform API that prevents to fully
# automate the deployment of a project _from scratch_
# with Terraform, as described here:
# https://stackoverflow.com/questions/68308103/gcp-project-creation-via-api-doesnt-enable-service-usage-api
# It uses the `gcloud` CLI:

whi-tw

#!/usr/bin/env bash
if [ "${1}" == "-q" ] && [[ ${2} == --qf* ]]; then
    arch="$(uname -m)"
    ver="$(pacman -Q ${@: -1} | awk '{print $2}')"
    if [ ! -z "${ver}" ]; then
        echo "{\"name\":\"${@: -1}\",\"version\":\"${ver}\",\"arch\":\"${arch}\"}"
    else
        echo "package ${@: -1} is not installed"
    fi
elif [ "${1}" == "-ql" ]; then

jobdiogenes

edavidaja

library(purrr)

xls_to_xlsx  <- function(file) {
  if (fs::path_ext(file) != "xls") {
    stop("file must have extension xls")    
  }
  
  sheets <- readxl::excel_sheets(file)
  
  insheets <- map(sheets, ~readxl::read_excel(file, .x, col_names = FALSE))

dbtek

# venv_wrapper, manage all virtual environments under ~/.venv/
# Include following in .bashrc / .bash_profile / .zshrc
# See https://gist.github.com/dbtek/fb2ddccb18f0cf63a654ea2cc94c8f19
# Usage
# $ mkvenv myvirtualenv # creates venv under ~/.venv/
# $ venv myvirtualenv   # activates venv
# $ deactivate          # deactivates venv
# $ rmvenv myvirtualenv # removes venv

export VENV_HOME="$HOME/.venv"

bpmore

1. Copy/Paste the information below to the clipboard
2. Open the spreadsheet whose sheets need to be alphabetised
3. Choose Tools > Script editor > Blank (this opens a new tab in the browser)
4. Press Control+A followed by Control+V copy and paste the script in
5. Press Control+S to save the script
6. Choose Run > sortSheets
7. Go back to the spreadsheet tab to view the new sorted tab order

--Copy everything below this line--
function sortSheets () {

liukun

local char_to_hex = function(c)
  return string.format("%%%02X", string.byte(c))
end

local function urlencode(url)
  if url == nil then
    return
  end
  url = url:gsub("\n", "\r\n")
  url = url:gsub("([^%w ])", char_to_hex)

andrewxhill

CREATE TYPE minimum_spanning_tree_internal AS (
  d NUMERIC[],
  a INT[],
  b INT[],
  geoms GEOMETRY[],
  ids TEXT[]
);

CREATE TYPE minimum_spanning_tree_unit AS (
  d NUMERIC,

Bill

# This docker-compose.yml will run the Hypothes.is annotation server.
# (adapted from instructions here https://h.readthedocs.org/en/latest/INSTALL.html)
#
# Place this file in the working directory (clone of https://github.com/hypothesis/h)
# run with docker-compose up -d
#
# Now browse to Hypothes.is at http://192.168.59.103:8000/ and create an account
# You'll see the invitation email in Mailcatcher at http://192.168.59.103:1080/
# Click that invitation link and log in on your local Hypothes.is
# And you are ready to annotate!