Skip to content

Instantly share code, notes, and snippets.

View gghatano's full-sized avatar

gghatano gghatano

25 followers · 38 following
View GitHub Profile
@gghatano
gghatano / m1_score.detail.csv
Last active December 24, 2023 21:22
No Year Order Name Judge Score
1 2001 1 中川家 きよし 91
1 2001 1 中川家 青島 90
1 2001 1 中川家 小朝 90
1 2001 1 中川家 石井 90
1 2001 1 中川家 鴻上 85
1 2001 1 中川家 松本 70
1 2001 1 中川家 紳助 80
1 2001 1 中川家 札幌 65
1 2001 1 中川家 大阪 89
@gghatano
gghatano / NBA_LEAGUE_AVERAGE_PER_100_POSESSIONS.csv
Last active October 10, 2022 13:13
We can make this file beautiful and searchable if this error is corrected: It looks like row 8 should actually have 31 columns, instead of 8. in line 7.
Rk,X_Season,X_Lg,X_Age,X_Ht,X_Wt,X_G,X_FG,X_FGA,X_3P,X_3PA,X_FT,X_FTA,X_ORB,X_DRB,X_TRB,X_AST,X_STL,X_BLK,X_TOV,X_PF,X_PTS,X_FG%,X_3P%,X_FT%,X_Pace,X_eFG%,X_TOV%,X_ORB%,X_FT/FGA,X_ORtg
1,2022-23,NBA,,,,0,,,,,,,,,,,,,,,,,,,,,,,,
2,2021-22,NBA,26.1,6-6,215,1230,41.1,89.2,12.6,35.6,17.1,22.1,10.5,34.5,45.0,24.9,7.7,4.8,13.9,19.9,112.0,.461,.354,.775,98.2,.532,12.3,23.2,.192,112.0
3,2020-21,NBA,26.1,6-6,217,1080,41.3,88.6,12.7,34.7,17.0,21.9,9.9,34.5,44.4,24.9,7.6,4.9,13.9,19.3,112.3,.466,.367,.778,99.2,.538,12.4,22.2,.192,112.3
4,2019-20,NBA,26.1,6-6,218,1059,40.4,87.9,12.1,33.8,17.7,22.9,10.0,34.4,44.4,24.1,7.6,4.8,14.4,20.6,110.6,.460,.358,.773,100.3,.529,12.8,22.5,.201,110.6
5,2018-19,NBA,26.3,6-6,219,1230,40.8,88.6,11.3,31.8,17.6,22.9,10.3,34.6,44.8,24.4,7.6,4.9,14.0,20.8,110.4,.461,.355,.766,100.0,.524,12.4,22.9,.198,110.4
6,2017-18,NBA,26.4,6-7,220,1230,40.5,87.9,10.7,29.6,17.0,22.1,9.9,34.5,44.4,23.7,7.9,4.9,14.6,20.3,108.6,.460,.362,.767,97.3,.521,13.0,22.3,.193,108.6
7,2016-17,NBA,26.6,6-7,221,1230,40.2
@gghatano
gghatano / 20220916_NDBユーザ会_1.md
Last active September 16, 2022 02:15

1. 厚労省_坂本享史さま　NDBの最近の事情

NDB 概要

  • 高確法、健康保険法、社会福祉法等の改正により、NDBの利用・提供・活用の根拠法を定義している
    • 収集、第三者提供、介護DB等との連結
    • 社会福祉法の改正により、精緻な名寄せが可能になった（ID5?）
  • 規模 　- レセプト229億、特定検診3億、特定保健指導1000万
  • リードタイム
  • レセプトは3か月、検診は1年
@gghatano
gghatano / exec.bash
Last active August 30, 2022 08:11
PWSCUP2022用のスクリプト群
#!/usr/bin/env bash
#
# exec.bash
# ============
#
# 概要
#　　　PWSCUP2022 メモファイルから匿名化を実行するスクリプト
#
# 前提
# 0. XXをチームID、YYをデータIDとする
@gghatano
gghatano / 20220304_PWSイベント.md
Created March 4, 2022 02:40

PWS Cup2021 説明 菊池さん(明治大学)

  • 2021年は、医療データの活用を想定。分析精度に影響しないように、安全な加工を施す技術を競うコンテスト。
  • NHANES(糖尿病のデータセット)を利用
    • 属性値 + 糖尿病罹患フラグ　の表データ
  • 各チームが匿名加工し、有用性・安全性で評価した結果で競う
    • 有用性：指定したデータ分析の精度
    • 安全性：各チームからの攻撃結果
  • 14チームが参加。匿名化：セコム、攻撃：NTT、総合：大阪大学のチームが優勝
@gghatano
gghatano / test.csv
Last active February 24, 2022 01:42
kaggle_titanic
PassengerId Pclass Name Sex Age SibSp Parch Ticket Fare Cabin Embarked
892 3 Kelly, Mr. James male 34.5 0 0 330911 7.8292 Q
893 3 Wilkes, Mrs. James (Ellen Needs) female 47 1 0 363272 7 S
894 2 Myles, Mr. Thomas Francis male 62 0 0 240276 9.6875 Q
895 3 Wirz, Mr. Albert male 27 0 0 315154 8.6625 S
896 3 Hirvonen, Mrs. Alexander (Helga E Lindqvist) female 22 1 1 3101298 12.2875 S
897 3 Svensson, Mr. Johan Cervin male 14 0 0 7538 9.225 S
898 3 Connolly, Miss. Kate female 30 0 0 330972 7.6292 Q
899 2 Caldwell, Mr. Albert Francis male 26 1 1 248738 29 S
900 3 Abrahim, Mrs. Joseph (Sophie Halaut Easu) female 18 0 0 2657 7.2292 C
@gghatano
gghatano / gg_hatano-tweet.xml
Last active February 6, 2022 13:33
Twitterのデータ.xml
This file has been truncated, but you can view the full file.
<?xml version="1.0" encoding="UTF-8"?>
<tweets>
<tweet>
<id>1490282669225422850</id>
<time>220206 201411</time>
<text>#今日のヘルシオ 恵方巻き(遅刻) http://pic.twitter.com/OujNScl3vv</text>
</tweet>
<tweet>
<id>1490115806055006208</id>
<time>220206 091107</time>
@gghatano
gghatano / canpaign_raw.csv
Last active January 6, 2022 07:41
We can make this file beautiful and searchable if this error is corrected: It looks like row 9 should actually have 28 columns, instead of 18. in line 8.
ID,Year_Birth,Education,Marital_Status,Income,Kidhome,Teenhome,Recency,MntWines,MntFruits,MntMeatProducts,MntFishProducts,MntSweetProducts,MntGoldProds,NumDealsPurchases,NumWebPurchases,NumCatalogPurchases,NumStorePurchases,NumWebVisitsMonth,AcceptedCmp3,AcceptedCmp4,AcceptedCmp5,AcceptedCmp1,AcceptedCmp2,Complain,Z_CostContact,Z_Revenue,Response
5524,1957,Graduation,Single,58138,0,0,58,635,88,546,172,88,88,3,8,10,4,7,0,0,0,0,0,0,3,11,1
2174,1954,Graduation,Single,46344,1,1,38,11,1,6,2,1,6,2,1,1,2,5,0,0,0,0,0,0,3,11,0
4141,1965,Graduation,Together,71613,0,0,26,426,49,127,111,21,42,1,8,2,10,4,0,0,0,0,0,0,3,11,0
6182,1984,Graduation,Together,26646,1,0,26,11,4,20,10,3,5,2,2,0,4,6,0,0,0,0,0,0,3,11,0
5324,1981,PhD,Married,58293,1,0,94,173,43,118,46,27,15,5,5,3,6,5,0,0,0,0,0,0,3,11,0
7446,1967,Master,Together,62513,0,1,16,520,42,98,0,42,14,2,6,4,10,6,0,0,0,0,0,0,3,11,0
965,1971,Graduation,Divorced,55635,0,1,34,235,65,164,50,49,27,4,7,3,7,6,0,0,0,0,0,0,3,11,0
6177,1985,PhD,Married,33454,1,0,32,76,10,56,3,1,23,2,4,0,
@gghatano
gghatano / tmp_without_dt.csv
Created January 6, 2022 01:59
We can make this file beautiful and searchable if this error is corrected: It looks like row 9 should actually have 28 columns, instead of 18. in line 8.
ID,Year_Birth,Education,Marital_Status,Income,Kidhome,Teenhome,Recency,MntWines,MntFruits,MntMeatProducts,MntFishProducts,MntSweetProducts,MntGoldProds,NumDealsPurchases,NumWebPurchases,NumCatalogPurchases,NumStorePurchases,NumWebVisitsMonth,AcceptedCmp3,AcceptedCmp4,AcceptedCmp5,AcceptedCmp1,AcceptedCmp2,Complain,Z_CostContact,Z_Revenue,Response
5524,1957,Graduation,Single,58138,0,0,58,635,88,546,172,88,88,3,8,10,4,7,0,0,0,0,0,0,3,11,1
2174,1954,Graduation,Single,46344,1,1,38,11,1,6,2,1,6,2,1,1,2,5,0,0,0,0,0,0,3,11,0
4141,1965,Graduation,Together,71613,0,0,26,426,49,127,111,21,42,1,8,2,10,4,0,0,0,0,0,0,3,11,0
6182,1984,Graduation,Together,26646,1,0,26,11,4,20,10,3,5,2,2,0,4,6,0,0,0,0,0,0,3,11,0
5324,1981,PhD,Married,58293,1,0,94,173,43,118,46,27,15,5,5,3,6,5,0,0,0,0,0,0,3,11,0
7446,1967,Master,Together,62513,0,1,16,520,42,98,0,42,14,2,6,4,10,6,0,0,0,0,0,0,3,11,0
965,1971,Graduation,Divorced,55635,0,1,34,235,65,164,50,49,27,4,7,3,7,6,0,0,0,0,0,0,3,11,0
6177,1985,PhD,Married,33454,1,0,32,76,10,56,3,1,23,2,4,0,
@gghatano
gghatano / tmp.csv
Last active January 5, 2022 06:06
We can make this file beautiful and searchable if this error is corrected: It looks like row 8 should actually have 29 columns, instead of 15. in line 7.
ID,Year_Birth,Education,Marital_Status,Income,Kidhome,Teenhome,Dt_Customer,Recency,MntWines,MntFruits,MntMeatProducts,MntFishProducts,MntSweetProducts,MntGoldProds,NumDealsPurchases,NumWebPurchases,NumCatalogPurchases,NumStorePurchases,NumWebVisitsMonth,AcceptedCmp3,AcceptedCmp4,AcceptedCmp5,AcceptedCmp1,AcceptedCmp2,Complain,Z_CostContact,Z_Revenue,Response
5524,1957,Graduation,Single,58138,0,0,2012-09-04,58,635,88,546,172,88,88,3,8,10,4,7,0,0,0,0,0,0,3,11,1
2174,1954,Graduation,Single,46344,1,1,2014-03-08,38,11,1,6,2,1,6,2,1,1,2,5,0,0,0,0,0,0,3,11,0
4141,1965,Graduation,Together,71613,0,0,2013-08-21,26,426,49,127,111,21,42,1,8,2,10,4,0,0,0,0,0,0,3,11,0
6182,1984,Graduation,Together,26646,1,0,2014-02-10,26,11,4,20,10,3,5,2,2,0,4,6,0,0,0,0,0,0,3,11,0
5324,1981,PhD,Married,58293,1,0,2014-01-19,94,173,43,118,46,27,15,5,5,3,6,5,0,0,0,0,0,0,3,11,0
7446,1967,Master,Together,62513,0,1,2013-09-09,16,520,42,98,0,42,14,2,6,4,10,6,0,0,0,0,0,0,3,11,0
965,1971,Graduation,Divorced,55635,0,1,2012-11-13,34,235,65,164,50,49,