Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
About Missing Values
Search
Sponsored
·
Your Podcast. Everywhere. Effortlessly.
Share. Educate. Inspire. Entertain. You do you. We'll handle the rest.
→
bk
August 09, 2019
Science
410
1
Share
Embed
Copy iframe code
Copy JS code
Copy link
Start on current slide
About Missing Values
bk
August 09, 2019
More Decks by bk
See All by bk
Befriending Kurtosis with R
bk_18
1
1k
tidy_rpart
bk_18
1
1.7k
dotdotdot_in_predict_function
bk_18
1
1.1k
Introduction_of_GoogleAnalytics_with_R
bk_18
2
1k
web scraping with polite package
bk_18
2
830
start-salesforce-with-r
bk_18
0
910
Missspell Detection
bk_18
1
170
Other Decks in Science
See All in Science
Tensor Factorization Meets Deformed Information Geometry: Convex Relaxation under Deformed Algebra
gkazunii
0
110
データベース01: データベースを使わない世界
trycycle
PRO
1
1.3k
プロジェクト「Azayaka」のSARの数式とジオメトリ
syuchimu
0
370
水耕栽培:古代の知恵から宇宙農業まで
grow_design_lab
0
150
Wet Active Matter
rajeshrinet
0
120
AI bij literatuuronderzoek in de wetenschap
voginip
0
210
Bリーグのショットデータを活用した得点期待値モデルの構築 / Construction of expected points model using shot data of B.LEAGUE
konakalab
0
150
水耕栽培を始める前に知っておきたい植物の科学
grow_design_lab
0
260
データベース11: 正規化(1/2) - 望ましくない関係スキーマ
trycycle
PRO
0
1.2k
知能とはなにか -ヒトとAIのあいだ-
tagtag
PRO
1
110
「遂行理論の未来」(松島斉教授最終講義記念セッションの発表資料)
shunyanoda
0
930
生成AI・プレプリント時代における 研究成果公開の再設計 ― トップカンファレンス文化はどこへ向かうのか / Redesigning the Dissemination of Research Outputs in the Age of Generative AI and Preprints — Where Is the Top-Conference Culture Heading?
ykiyota
0
29k
Featured
See All Featured
GraphQLとの向き合い方2022年版
quramy
50
15k
Typedesign – Prime Four
hannesfritz
42
3.1k
Paper Plane (Part 1)
katiecoart
PRO
0
9.5k
First, design no harm
axbom
PRO
2
1.2k
エンジニアに許された特別な時間の終わり
watany
107
250k
Git: the NoSQL Database
bkeepers
PRO
432
67k
How to build a perfect <img>
jonoalderson
1
5.8k
Building a A Zero-Code AI SEO Workflow
portentint
PRO
0
630
How to Get Subject Matter Experts Bought In and Actively Contributing to SEO & PR Initiatives.
livdayseo
0
150
DBのスキルで生き残る技術 - AI時代におけるテーブル設計の勘所
soudai
PRO
67
56k
Between Models and Reality
mayunak
4
360
Kristin Tynski - Automating Marketing Tasks With AI
techseoconnect
PRO
0
280
Transcript
ܽଛॲཧʹ͍ͭͯ dࣦΘΕͨΛٻΊͯd
࣍ 1. ܽଛͱ 2. ܽଛআڈ 3. ܽଛλΠϓ 4. ୯Ұೖ๏ 5.
ଟॏೖ๏ 6. ࠓճհ͠ͳ͔ͬͨͷ 7. ࢀߟจݙ
ܽଛͱ Missing Valueʢܽଛɺܽଌʣ In statistics, missing data, or missing values,
occur when no data value is stored for the variable in an observation. Missing data are a common occurrence and can have a significant effect on the conclusions that can be drawn from the data. ʢhttps://en.wikipedia.org/wiki/Missing_dataʣ
ܽଛ͕͋Δͱ Կ͕ࠔΔͷ͔ʁ ܽଛͱ
ܭࢉग़དྷͳ͍ Q,10, 20, ܽଛͷฏۉʁ ܽଛͱ > mean(c(10, 20, NA)) [1]
NA
Ͳ͏͢Δͷ͔ʁ ܽଛͱ
1. ফ͢ 2. ຒΊΔ ܽଛͱ
1. ফ͢ 2. ຒΊΔ 1. ফ͢ ܽଛͱ
ܽଛͷ͋ΔϨίʔυΛফ͢ ମॏ ੑผ 50 ঁ 70 உ 55 NA NA
உ ܽଛআڈ
ମॏ ੑผ 50 ঁ 70 உ 55 NA NA உ
ମॏ ੑผ 50 ঁ 70 உ ܽଛͷ͋ΔϨίʔυΛফ͢ ܽଛআڈ
ମॏ ੑผ 50 ঁ 70 உ 55 NA NA உ
ମॏ ੑผ 50 ঁ 70 உ ϦετϫΠζ๏ ܽଛͷ͋ΔϨίʔυΛফ͢ ܽଛআڈ
ফ͍͍ͯ͠ͷʁ 1. ফͯ͠ྑ͍߹ 2. ফͯ͠ବͳ߹ ܽଛআڈ
શʹϥϯμϜʹܽଛ ܽଛύλʔϯੑผ ମॏͱແؔ ܽଛআڈ
શʹϥϯμϜʹܽଛ ܽଛύλʔϯੑผ ମॏͱແؔ ফͯ͠ͳ͍ ͨͩ͠ɺޮԼ͕Δ ܽଛআڈ
؍ଌมʹґଘͯܽ͠ଛ ঁੑͷํ͕ଟܽ͘ଛ ܽଛআڈ
؍ଌมʹґଘͯܽ͠ଛ ফ͢ͱঁੑͷσʔλͷΈݮগ ภΔ ঁੑͷํ͕ଟܽ͘ଛ ܽଛআڈ
ܽଛมࣗମʹґଘͯܽ͠ଛ ମॏͷॏ͍ํ͕ଟ͘ ܽଛ ܽଛআڈ
ܽଛมࣗମʹґଘͯܽ͠ଛ ফ͢ͱମॏͷߴ͍σʔλ͕ݮগ ภΔ ମॏͷॏ͍ํ͕ଟ͘ ܽଛ ܽଛআڈ
‣ શʹϥϯμϜʹܽଛˠMCAR ʢMissing Completely At Randomʣ ‣ ؍ଌมʹґଘͯܽ͠ଛˠMAR ʢMissing At
Randomʣ ‣ ܽଛมࣗମʹґଘͯܽ͠ଛˠNMAR ʢNot Missing At Randomʣ ܽଛλΠϓ
‣ શʹϥϯμϜʹܽଛˠMCAR ʢMissing Completely At Randomʣ ‣ ؍ଌมʹґଘͯܽ͠ଛˠMAR ʢMissing At
Randomʣ ‣ ܽଛมࣗମʹґଘͯܽ͠ଛˠNMAR ʢNot Missing At Randomʣ ܽଛλΠϓ
‣ શʹϥϯμϜʹܽଛˠMCAR ʢMissing Completely At Randomʣ ‣ ؍ଌมʹґଘͯܽ͠ଛˠMAR ʢMissing At
Randomʣ ‣ ܽଛมࣗମʹґଘͯܽ͠ଛˠNMAR ʢNot Missing At Randomʣ ফͯ͠ྑ͍ ܽଛλΠϓ
‣ શʹϥϯμϜʹܽଛˠMCAR ʢMissing Completely At Randomʣ ‣ ؍ଌมʹґଘͯܽ͠ଛˠMAR ʢMissing At
Randomʣ ‣ ܽଛมࣗମʹґଘͯܽ͠ଛˠNMAR ʢNot Missing At Randomʣ ܽଛλΠϓ
‣ શʹϥϯμϜʹܽଛˠMCAR ʢMissing Completely At Randomʣ ‣ ؍ଌมʹґଘͯܽ͠ଛˠMAR ʢMissing At
Randomʣ ‣ ܽଛมࣗମʹґଘͯܽ͠ଛˠNMAR ʢNot Missing At Randomʣ ରॲࠔ ܽଛλΠϓ
‣ શʹϥϯμϜʹܽଛˠMCAR ʢMissing Completely At Randomʣ ‣ ؍ଌมʹґଘͯܽ͠ଛˠMAR ʢMissing At
Randomʣ ‣ ܽଛมࣗମʹґଘͯܽ͠ଛˠNMAR ʢNot Missing At Randomʣ ܽଛλΠϓ
‣ શʹϥϯμϜʹܽଛˠMCAR ʢMissing Completely At Randomʣ ‣ ؍ଌมʹґଘͯܽ͠ଛˠMAR ʢMissing At
Randomʣ ‣ ܽଛมࣗମʹґଘͯܽ͠ଛˠNMAR ʢNot Missing At Randomʣ ܽଛλΠϓ
1. ফ͢ 2. ຒΊΔ 1. ফ͢ 2. ຒΊΔ ୯Ұೖ๏
ͲΜͳͰຒΊΔͷ͔ʁ ୯Ұೖ๏
1. ฏۉʢฏۉೖ๏ʣ 2. ༧ଌʢ֬ఆతճؼೖ๏ʣ 3. ༧ଌ + ࠩʢ֬తճؼೖ๏ʣ + ୯Ұೖ๏
1. ฏۉʢฏۉೖ๏ʣ 2. ༧ଌʢ֬ఆతճؼೖ๏ʣ 3. ༧ଌ + ࠩʢ֬తճؼೖ๏ʣ + ୯Ұೖ๏
ฏۉΛܭࢉ͠ೖ ୯Ұೖ๏
ฏۉΛܭࢉ͠ೖ ฏۉೖ๏ ฏۉ ≒ உੑͷମॏͷฏۉ ୯Ұೖ๏
1. ฏۉʢฏۉೖ๏ʣ 2. ༧ଌʢ֬ఆతճؼೖ๏ʣ 3. ༧ଌ + ࠩʢ֬తճؼೖ๏ʣ + ୯Ұೖ๏
ܽଌΛ༧ଌ͢ΔϞσϧΛ࡞Δ *ิॿม ܽ ଛ ͷ ͋ Δ ม *ิॿม:ܽଛͷ༧ଌʹΘΕΔมɻඞͣ͠తมͷ༧ଌʹΘΕΔΘ͚Ͱͳ͍ɻ
୯Ұೖ๏
ܽଌΛ༧ଌ͢ΔϞσϧΛ࡞Δ ิॿม ܽ ଛ ͷ ͋ Δ ม ୯Ұೖ๏
ܽଌΛ༧ଌ͢ΔϞσϧΛ࡞Δ ܽ ଛ ͷ ͋ Δ ม ʢ֬ఆతʣ ճؼೖ๏
ิॿม ୯Ұೖ๏
ܽ ଛ ͷ ͋ Δ ม ิॿม ೖ͕શͯઢ্ʹ ୯Ұೖ๏
ܽ ଛ ͷ ͋ Δ ม ༧ଌͷޡࠩΛաখධՁ ิॿม ೖ͕શͯઢ্ʹ
୯Ұೖ๏
1. ฏۉʢฏۉೖ๏ʣ 2. ༧ଌʢ֬ఆతճؼೖ๏ʣ 3. ༧ଌ + ࠩʢ֬తճؼೖ๏ʣ 1. ฏۉʢฏۉೖ๏ʣ
2. ༧ଌʢ֬ఆతճؼೖ๏ʣ 3. ༧ଌ + ࠩʢ֬తճؼೖ๏ʣ + ୯Ұೖ๏
ೖϞσϧʹޡ߲ࠩΛՃ ܽ ଛ ͷ ͋ Δ ม ิॿม ޡ߲ࠩ
୯Ұೖ๏
ܽ ଛ ͷ ͋ Δ ม ิॿม ೖϞσϧʹޡ߲ࠩΛՃ Β͖ͭΛө
୯Ұೖ๏
ܽ ଛ ͷ ͋ Δ ม ิॿม ೖϞσϧʹޡ߲ࠩΛՃ ֬తճؼೖ๏
୯Ұೖ๏
ೖϞσϧͷޡ߲ࠩөग़དྷͨ ܽ ଛ ͷ ͋ Δ ม ิॿม ୯Ұೖ๏
ೖϞσϧͦͷͷͷෆ࣮֬ੑʁ ܽ ଛ ͷ ͋ Δ ม ิॿม ʁ
ʁ ʁ ୯Ұೖ๏
1ͭͷΛೖʢ୯Ұೖ๏ʣ ෳͷΛೖ ʢଟॏೖ๏ʣ ଟॏೖ๏
ೖ ੳ ౷߹ ෳͷೖΛਪఆ͠ෳͷೖࡁΈσʔλΛੜ ೖࡁΈσʔλΛ༻ͯ͠ਪఆ ਪఆΛ౷߹͠ɺ࠷ऴ݁Ռͱ͢Δ ଟॏೖ๏
ܽଛσʔλ ೖࡁΈσʔλ1 ೖࡁΈσʔλ2 ೖࡁΈσʔλ3 ੳ݁Ռ1 ੳ݁Ռ2 ੳ݁Ռ3 ࠷ऴ݁Ռ ೖ ੳ
౷߹ ଟॏೖ๏
ܽଛσʔλ ೖࡁΈσʔλ1 ೖࡁΈσʔλ2 ೖࡁΈσʔλ3 ੳ݁Ռ1 ੳ݁Ռ2 ੳ݁Ռ3 ࠷ऴ݁Ռ ೖ ੳ
౷߹ ଟॏೖ๏
‣ DA๏ : Data Augmentationʢσʔλ֦େ๏ʣ ‣ FCS๏ : Fully Conditional
Specificationʢ શ͖݅ࢦఆʣ ‣ EMB๏ : Expectation-Maximization with Bootstrapping ଟॏೖ๏
‣ ܽଛআڈɿϖΞϫΠζ๏ɺมআڈ ‣ ୯Ұೖ๏ɿൺೖ๏ɺϗοτσοΫ๏ɺίʔ ϧυσοΫ๏ɺLOCFɺNOCB ‣ ଟॏೖ๏ɿೖஅɺײੳ ‣ શใ࠷๏ ‣
LightGBMͳͲͷܽଛࣗಈॲཧ ࠓճհ͠ͳ͔ͬͨͷ
‣ ߴڮকٓ,ลඒஐࢠ, ܽଌσʔλॲཧ: RʹΑΔ୯Ұೖ๏ͱ ଟॏೖ๏ (౷ܭֶOne Point), ڞཱग़൛, 2017/12/9, 192ϖʔ
δ ‣ ܽଛ͕͋Δσʔλͷੳ, Sunny side up!, http:// norimune.net/1811 ‣ RͰ࣮ફʂܽଛσʔλੳೖʲ1ʳ, NHN TECHORUS Tech Blog, https://techblog.nhn-techorus.com/archives/6573 ‣ R ܽଛͷରԠʢmissing value treatmentʣ, ౷ܭֶͱӸֶͱ ࣌ʑɺॿڭੜ׆, http://jojoshin.hatenablog.com/entry/ 2017/02/03/220118 ࢀߟจݙ
ENJOY! A