Skip to content

Instantly share code, notes, and snippets.

View kyoro1's full-sized avatar
🏠
Working from home

Kyoichi Iwasaki kyoro1

🏠
Working from home
View GitHub Profile
@kyoro1
kyoro1 / file0.py
Last active January 8, 2019 08:36
Microsoft Azureのcomputer visionでカンタンな分析をしてみよう ref: https://qiita.com/kyoro1/items/fcef81e84da99bc52de9
import requests
import matplotlib.pyplot as plt
import json
from PIL import Image
from io import BytesIO
@kyoro1
kyoro1 / file0.txt
Last active June 20, 2018 12:00
pandasでWindow関数的な集計 ref: https://qiita.com/kyoro1/items/ffe2a11986131857e6ef
import pandas as pd
import numpy as np
from numpy.random import *
from pandas import rolling_mean, rolling_apply
@kyoro1
kyoro1 / file0.txt
Last active June 9, 2018 06:39
画像回転スクリプト & 並列処理 ref: https://qiita.com/kyoro1/items/760b56508844a083901c
import cv2
from scipy import ndimage
import os
from joblib import Parallel, delayed
@kyoro1
kyoro1 / file0.txt
Last active May 31, 2018 11:05
pandasで、行 or 列内に欠損値がある時に、無視して加算・無視せず加算する方法 ref: https://qiita.com/kyoro1/items/ce89d6d444eec2b26512
import pandas as pd
import numpy as np
df = pd.DataFrame({'C1': [1, np.nan, np.nan],
'C2': [2, 1, 3],
'C3': [np.nan, np.nan, 1]})
import numpy.random import *
## 0~1までの乱数を設定
tmp = rand()
if tmp <= epsilon:
output = 1
else:
output = 0
print(output)
@kyoro1
kyoro1 / file0.sh
Last active December 14, 2017 09:20
AzureのSQL Serverにテーブルの内容を書き出す ref: https://qiita.com/kyoro1/items/eaa4c136df60373d3501
pip install sqlalchemy
@kyoro1
kyoro1 / file0.txt
Last active December 14, 2017 08:43
indexからcolumnへ、columnからindexへ ref: https://qiita.com/kyoro1/items/56c1606e0218fbfae32d
import pandas as pd
df = \
pd.DataFrame({ 'date' : ['2017-12-14','2017-12-15','2017-12-16'],
'symbol' : ["A","B","C"],
'number' : [1,2,3]})
from sklearn.datasets import load_iris
from pandas.tools.plotting import parallel_coordinates
import pandas as pd
import matplotlib.pyplot as plt
import matplotlib
matplotlib.style.use('ggplot')
@kyoro1
kyoro1 / file0.py
Last active March 31, 2017 15:52
Azure documentDBのdocumentをpydocumentdbで抽出してみる ref: http://qiita.com/kyoro1/items/51410dad7f41fa0e07b4
pip install pydocumentdb
@kyoro1
kyoro1 / file0.txt
Created March 14, 2017 02:14
Azure SQL ServerのデータテーブルをRODBCで抽出してみる ref: http://qiita.com/kyoro1/items/926cd575a4cf0ba6cbdf
## library
library(RODBC)
## initial setting
## 上述の通り、適宜設定値は変えて下さい
myServer <- "abc_server.database.windows.net"
myUser <- "abc_user"
myPassword <- "abc_password"
myDatabase <- "abc_database"
myDriver <- "SQL Server"