Skip to content

Instantly share code, notes, and snippets.

@ishideo
ishideo / max_value_importer.rb
Last active December 11, 2017 06:18
max_value_importer.rb
#!/usr/bin/env ruby
# -*- coding: utf-8 -*-
# ruby max_value_importer.rb --file "./xlsx/xxx.xlsx" --sheet "sheet1" --date_range "A2:A100" --value_range "B2:B100" --date_cell "E3" --value_cell "F2"
require 'csv'
require 'optparse'
require 'win32ole'
class WIN32OLE
def to_a
[].tap do |array|
#!/usr/bin/env python3
# -*- coding: utf-8 -*-
from datetime import datetime
import itertools
import pandas as pd
import pprint
import pytz
import unittest
(ns report.header
(:require [clojure.java.io :as io]
[clojure.string :as str]
;[clojure.data.csv :as csv]
[clojure.tools.cli :refer [parse-opts]])
(:gen-class))
(def cli-options
[["-f" "--file FILE" "Input file path"
:default "input.txt"]
;; -*- coding: utf-8; lexical-binding: t -*-
(defun copy-num (file words)
(with-temp-buffer
(insert-file-contents-literally file)
(goto-char (point-min))
(catch 'e
(mapcar #'(lambda (x)
(unless (search-forward x nil t)
(throw 'e "")))
#!/bin/sh
vim -X -u NONE -c ':1 | /abc' -c '/xyz' -c '/123' -c 'normal! $vT y' -c ':redir! >> input.txt | silent! echo @0 | redir END | :q!' output.txt
vim -X -u NONE -c ':redir! >> output.txt | silent! echon "\n" | redir END | :q!
#!/usr/bin/env python
# -*- coding: utf-8 -*-
import sys, requests, codecs
from bs4 import BeautifulSoup
def scraping(url):
response = requests.get(url)
html = response.text.encode(response.encoding)
soup = BeautifulSoup(html, 'lxml')
#!/usr/bin/env python2
# -*- coding: utf-8 -*-
from __future__ import unicode_literals
from __future__ import print_function
from bs4 import BeautifulSoup
import mechanize, re, time, json, codecs
class KnowledgeArticles:
def __init__(self):
#!/usr/bin/env python2
# -*- coding: utf-8 -*-
from __future__ import unicode_literals
from __future__ import print_function
from bs4 import BeautifulSoup
import mechanize, re, time, json, codecs
class LodgeArticles:
def __init__(self):
#!/usr/bin/env python3
# -*- coding: utf-8 -*-
from datetime import datetime
import itertools
import pandas as pd
import pprint
import pytz
import unittest
#!/usr/bin/env ruby
# -*- coding: utf-8 -*-
# ruby log_extractor.rb --in_csv "./abc.csv" --in_time_column "2" --in_value_column "3" --in_skip_lines "0" --out_time_column_format "%Y/%m/%d %H:00:00" --interval "5" --begin_date "20xx/xx/xx" --duration "month"
require 'csv'
require 'date'
require 'optparse'
require 'time'
class LogExtractor
def initialize