gghatano’s gists

gghatano / customer_master.csv

Created June 19, 2021 07:32

python100knock_chapter_1

We can't make this file beautiful and searchable because it's too large.

	customer_id,customer_name,registration_date,customer_name_kana,email,gender,age,birth,pref
	IK152942,平田裕次郎,2019-01-01 00:25:33,ひらたゆうじろう,[email protected],M,29,1990/6/10,石川県
	TS808488,田村詩織,2019-01-01 01:13:45,たむらしおり,[email protected],F,33,1986/5/20,東京都
	AS834628,久野由樹,2019-01-01 02:00:14,ひさのゆき,[email protected],F,63,1956/1/2,茨城県
	AS345469,鶴岡薫,2019-01-01 04:48:22,つるおかかおる,[email protected],M,74,1945/3/25,東京都
	GD892565,大内高史,2019-01-01 04:54:51,おおうちたかし,[email protected],M,54,1965/8/5,千葉県
	AS265381,笠井洋介,2019-01-01 05:51:07,かさいようすけ,[email protected],M,69,1949/8/9,岡山県
	HD739338,橋口将也,2019-01-01 05:51:08,はしぐちまさや,[email protected],M,45,1974/6/4,神奈川県
	HI791416,細井麻由子,2019-01-01 07:03:53,ほそいまゆこ,[email protected],F,30,1989/7/25,三重県
	HD819739,塩見はるか,2019-01-01 08:17:23,しおみはるか,[email protected],F,49,1969/10/8,神奈川県

gghatano / apple_location.csv

Created April 7, 2021 10:04

Appleの移動傾向データ

We can't make this file beautiful and searchable because it's too large.

geo_type,region,transportation_type,alternative_name,sub-region,country,2020-01-13,2020-01-14,2020-01-15,2020-01-16,2020-01-17,2020-01-18,2020-01-19,2020-01-20,2020-01-21,2020-01-22,2020-01-23,2020-01-24,2020-01-25,2020-01-26,2020-01-27,2020-01-28,2020-01-29,2020-01-30,2020-01-31,2020-02-01,2020-02-02,2020-02-03,2020-02-04,2020-02-05,2020-02-06,2020-02-07,2020-02-08,2020-02-09,2020-02-10,2020-02-11,2020-02-12,2020-02-13,2020-02-14,2020-02-15,2020-02-16,2020-02-17,2020-02-18,2020-02-19,2020-02-20,2020-02-21,2020-02-22,2020-02-23,2020-02-24,2020-02-25,2020-02-26,2020-02-27,2020-02-28,2020-02-29,2020-03-01,2020-03-02,2020-03-03,2020-03-04,2020-03-05,2020-03-06,2020-03-07,2020-03-08,2020-03-09,2020-03-10,2020-03-11,2020-03-12,2020-03-13,2020-03-14,2020-03-15,2020-03-16,2020-03-17,2020-03-18,2020-03-19,2020-03-20,2020-03-21,2020-03-22,2020-03-23,2020-03-24,2020-03-25,2020-03-26,2020-03-27,2020-03-28,2020-03-29,2020-03-30,2020-03-31,2020-04-01,2020-04-02,2020-04-03,2020-04-04,2020-04-05,2020-04-06,2020-04-07,2020-0

gghatano / nba_2018.csv

Last active January 22, 2021 06:38

https://jp.global.nba.com/standings/

Atlantic Division	w	l	pct	gb	w_home	l_home	w_road	l_load
y___Toronto Raptors	58	24	0.707	0	32	9	26	15
x___Philadelphia 76ers	51	31	0.622	7	31	10	20	21
x___Boston Celtics	49	33	0.598	9	28	13	21	20
x___Brooklyn Nets	42	40	0.512	16	23	18	19	22
New York Knicks	17	65	0.207	41	9	32	8	33
z___Milwaukee Bucks	60	22	0.732	0	33	8	27	14
x___Indiana Pacers	48	34	0.585	12	29	12	19	22
x___Detroit Pistons	41	41	0.5	19	26	15	15	26
Chicago Bulls	22	60	0.268	38	9	32	13	28

gghatano / 20210108_RWDseminar.txt

Created January 9, 2021 05:30

	匿名加工と分析への影響分析

	○212 たなべさん第一三共

	胆石症患者への投薬結果データの分析

	[用語　]
	Research Question
	PECOS...後で調べる
	Patient, Exposure, Comparison, Outcome

gghatano / gist:96a3b4b2c79112ce2470d97953cf09a6

Created January 5, 2021 08:36

test

This file has been truncated, but you can view the full file.

	101213
	2630802623863106 -57183793823298912
	-7911000 172531577672394160
	-15822000 345063155344788320
	-741144217727319183 -16308535575048082
	-361145589699841029 -7946841595084166
	-392290850140882080 -18047767188325790
	-156323935071980865 -3439835858357710
	2234136999221062 -101530742043862053
	-7911000 172531577672394160

gghatano / tmp.csv

Created September 11, 2020 06:34

ts	type1	type2	col1	col2
2020-01-01 09:00:00	aaa	aaa1	1111	2222
2020-01-01 09:00:01	aaa	aaa1	1112	2232
2020-01-01 09:00:02	aaa	aaa1	1112	2232
2020-01-01 09:00:00	aaa	aaa2	1111	2222
2020-01-01 09:00:01	aaa	aaa2	1112	2232
2020-01-01 09:00:02	aaa	aaa2	1112	2232
2020-01-01 09:00:00	bbb	bbb1	1111	2222
2020-01-01 09:00:01	bbb	bbb1	1112	2232

gghatano / Dockerfile

Created August 28, 2020 03:48

PWSCUP2020 サンプルコードが動く環境を作る

	FROM python:3.8

	RUN apt-get update \
	&& apt-get install -y --no-install-recommends apt-utils dialog 2>&1 \
	&& apt-get install -y git iproute2 procps lsb-release gdb vim less\
	&& apt-get install -y sudo \
	&& apt-get install -y make

	RUN pip3.8 install pandas category_encoders

gghatano / dummy_master.csv

Created June 17, 2020 04:32

NAME	ID	DATE1	DATE2	DATE3	DATE4	VAL
HOGE1	X1	2020/12/20	2020/10/15	2020/05/12	2020/09/03	X
HOGE2	X2	2020/12/20	2020/10/12	2020/05/01	2020/09/03	X
HOGE3	X3	2020/12/20	2020/10/15	2020/05/12	2020/09/30	X
HOGE4	X4	2020/12/20	2020/10/15			X
HOGE4	X5					X

gghatano / dummy.csv

Last active June 17, 2020 01:49

ID	DATE	VAL
1	2020/02/10	X
1	2020/03/05	X
1	2020/05/20	X
2	2020/02/02	X
2	2020/01/10	X
2	2020/02/20	X
3	2020/03/09	X
3	2020/12/30	X
4		X

gghatano / algorithm.cpp

Last active July 21, 2020 09:57

	#include <bits/stdc++.h>
	// #include <boost/multiprecision/cpp_int.hpp>
	using namespace std;
	// using namespace boost::multiprecision;

	# define REP(i,n) for (int i=0;i<(n);++i)
	# define rep(i,a,b) for(int i=a;i<(b);++i)
	# define all(v) v.begin(),v.end()
	# define showVector(v) REP(i,v.size()){cout << (v[i]) << " ";} cout << endl;
	template<class T> inline bool chmin(T &a, T b){ if(a > b) { a = b; return true;} return false;}

gghatano gghatano