Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Sign up for free
Menu
Search
Features
All features
Private URLs
Password Protection
Custom URLS
Scheduled publishing
Remove Branding
Restrict embedding
Deck Collections
Notes
Features
All features
Private URLs
Password Protection
Custom URLS
Scheduled publishing
Remove Branding
Restrict embedding
Deck Collections
Notes
Explore
Featured decks
Featured speakers
Programming
Technology
Storyboards
Explore
Featured decks
Featured speakers
Programming
Technology
Storyboards
Pricing
Search
Sign in
Sign up for free
About Missing Values
Search
bk
August 09, 2019
Science
430
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.8k
dotdotdot_in_predict_function
bk_18
1
1.2k
Introduction_of_GoogleAnalytics_with_R
bk_18
2
1k
web scraping with polite package
bk_18
2
850
start-salesforce-with-r
bk_18
0
940
Missspell Detection
bk_18
1
180
Other Decks in Science
See All in Science
データベース04: SQL (1/3) 単純質問 & 集約演算
trycycle
PRO
0
1.8k
Leitner Inauguration Lecture Chalmers University of Technology
xleitix
0
410
バランスって大事だね
akasan
1
170
[Relay webinaire eBIS actu n°16] Amélioration de la survie des JB avec la génétique - Introduction
institutdelelevage
PRO
0
430
機械学習 - SVM
trycycle
PRO
2
1.3k
機械学習 - ニューラルネットワーク入門
trycycle
PRO
0
1.4k
JPA2026_NetworkSymposium_Overview
junkashihara
0
110
データベース15: ビッグデータ時代のデータベース
trycycle
PRO
1
610
データベース14: B+木 & ハッシュ索引
trycycle
PRO
0
990
Cognitive Debt - What AI will do to us
martinlippert
1
130
O(log n)-Approximation Algorithms for Bipartiteness Ratio
tasusu
0
290
Massey Ratings for Match Outcome Prediction in Table Tennis: Evidence of Greater Stability than the ITTF World Ranking
konakalab
0
180
Featured
See All Featured
<Decoding/> the Language of Devs - We Love SEO 2024
nikkihalliwell
1
370
sira's awesome portfolio website redesign presentation
elsirapls
0
480
Conquering PDFs: document understanding beyond plain text
inesmontani
PRO
4
3.2k
Redefining SEO in the New Era of Traffic Generation
szymonslowik
1
500
Building a Modern Day E-commerce SEO Strategy
aleyda
45
9.3k
More Than Pixels: Becoming A User Experience Designer
marktimemedia
3
600
Leo the Paperboy
mayatellez
10
2.4k
The #1 spot is gone: here's how to win anyway
tamaranovitovic
4
1.2k
The Impact of AI in SEO - AI Overviews June 2024 Edition
aleyda
6
1.3k
The innovator’s Mindset - Leading Through an Era of Exponential Change - McGill University 2025
jdejongh
PRO
1
380
Heart Work Chapter 1 - Part 1
lfama
PRO
10
37k
エンジニアに許された特別な時間の終わり
watany
109
250k
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