Skip to content

Instantly share code, notes, and snippets.

View rkaneko's full-sized avatar
🎯
Focusing

Ryota Kaneko rkaneko

🎯
Focusing
View GitHub Profile
@rkaneko
rkaneko / README.md
Last active February 4, 2024 07:18
Docker compose file for terraform CLI.
@rkaneko
rkaneko / sample.py
Created February 17, 2020 13:42
Put parquet file on MinIO (S3 compatible storage) using pyarrow and s3fs.
from typing import Any, Dict, List
import s3fs
from pyarrow import Table, parquet as pq
from pandas import DataFrame, Series
def to_df(data: List[Dict[str, Any]]) -> DataFrame:
df = DataFrame()
for item in data:
indexes = []
values = []
@rkaneko
rkaneko / print_cpu_usage.py
Created February 18, 2020 04:29
Profile CPU usage in Python sing psutil.
import time
import multiprocessing as mp
import psutil
from typing import Any, Callable, List, Tuple
def monitor(target: Callable[..., Any], args: Tuple[Any, ...]) -> List[float]:
worker_process = mp.Process(target=target, args=args)
worker_process.start()
p = psutil.Process(worker_process.pid)
@rkaneko
rkaneko / README.md
Created January 31, 2023 09:24
remark-gfm issue for mdast-util-find-and-replace by CommonJS module which may not support all module.exports as named exports
$ npm list mdast-util-find-and-replace
my-app@0.1.0 /home/rkaneko/workspace/axelglobe/docs.axelglobe.com
└─┬ remark-gfm@3.0.1
  └─┬ mdast-util-gfm@2.0.1
    └─┬ mdast-util-gfm-autolink-literal@1.0.3
      └── mdast-util-find-and-replace@2.2.2
@rkaneko
rkaneko / convert_featurecollection_into_multipolygon.sql
Created January 12, 2023 02:10
PostGIS query to convert FeatureCollection GeoJSON into MultiPolygon GeoJSON
WITH original AS (
SELECT
ST_Collect(ST_ShiftLongitude(ST_GeomFromGeoJSON(feat->>'geometry'))) geom
FROM (SELECT json_array_elements('HERE_IS_FEATURE_COLLECTION_GEOJSON'::json->'features') AS feat) AS f
)
SELECT ST_AsGeoJSON(o.geom) FROM original o LIMIT 1;
@rkaneko
rkaneko / InstallingAgOnCentOS.md
Last active November 7, 2022 16:57
Installing ag: the silver searcher on CentOS.

Installing ag on CentOS

Prerequistes

  • libpcre
  • liblzma

Download, build and install

@rkaneko
rkaneko / findFilesRecursively.js
Created September 6, 2017 02:43
Node.js find files recursively
const assert = require("assert");
const fs = require("fs");
const path = require("path");
function findFilesRecursively(pathToDir) {
assert(typeof pathToDir === "string");
return fs.readdirSync(pathToDir).map(filename => {
const fullpath = path.join(pathToDir, filename);
if (isFile(fullpath)) {
@rkaneko
rkaneko / InstallZshOnCentOS.md
Last active January 11, 2022 16:24
Installing zsh on CentOS

Installing zsh on CentOS

$ sudo yum install ncurses-devel

$ cd /usr/local/src

$ sudo curl -L http://sourceforge.net/projects/zsh/files/zsh/5.0.7/zsh-5.0.7.tar.gz/download -o zsh-5.0.7.tar.gz
#!/bin/bash
PROGNAME=$(basename $0)
VERSION="1.0"
usage() {
echo "Usage: $PROGNAME [OPTIONS] FILE"
echo " This script is ~."
echo
echo "Options:"
@rkaneko
rkaneko / qgis.md
Last active February 29, 2020 13:57
Install qgis on Ubuntu 18.04

How to install QGIS on Ubuntu 18.04

$ sudo apt-get install python3-software-properties

$ sudo add-apt-repository ppa:ubuntugis/ubuntugis-unstable

$ sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys F42ED6FBAB17C654

$ sudo apt-get update