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
atmaCup#8振り返り〜個人的なテーブルコンペの取組み方と解法〜
Search
tomo20180402
December 23, 2020
Science
650
0
Share
Embed
Copy iframe code
Copy JS code
Copy link
Start on current slide
atmaCup#8振り返り〜個人的なテーブルコンペの取組み方と解法〜
tomo20180402
December 23, 2020
Other Decks in Science
See All in Science
データベース08: 実体関連モデルとは?
trycycle
PRO
0
1.3k
Conversation is the New Dashboard: 属人性を排除する第4世代BIツールの勢力図
shomaekawa
1
610
KISHIMOTO Atsuo
genomethica
0
170
1. CPC理論の展開と集合的知能モデル(JSAI2026 KS-27 集合的予測符号化と新たな知性の時代)
hayashiyus884
1
290
20260220 OpenIDファウンデーション・ジャパン ご紹介 / 20260220 OpenID Foundation Japan Intro
oidfj
0
370
機械学習 - K近傍法 & 機械学習のお作法
trycycle
PRO
1
1.6k
機械学習 - 授業概要
trycycle
PRO
0
560
Non-Gaussian, nonlinear causal discovery with hidden variables and application
sshimizu2006
0
150
Build your own LLM, Live, with MicroGPT
ianozsvald
0
100
明治薬科大学講義_ビッグデータ解析を支えるデータベース技術とクラウドコンピューティング
ktatsuya
1
130
Bリーグのショットデータを活用した得点期待値モデルの構築 / Construction of expected points model using shot data of B.LEAGUE
konakalab
0
150
AkarengaLT vol.40
hashimoto_kei
0
110
Featured
See All Featured
Exploring the relationship between traditional SERPs and Gen AI search
raygrieselhuber
PRO
2
4.1k
Optimising Largest Contentful Paint
csswizardry
37
3.8k
Efficient Content Optimization with Google Search Console & Apps Script
katarinadahlin
PRO
1
670
VelocityConf: Rendering Performance Case Studies
addyosmani
333
25k
The Illustrated Guide to Node.js - THAT Conference 2024
reverentgeek
1
410
Winning Ecommerce Organic Search in an AI Era - #searchnstuff2025
aleyda
1
2.1k
Evolution of real-time – Irina Nazarova, EuRuKo, 2024
irinanazarova
9
1.4k
The Organizational Zoo: Understanding Human Behavior Agility Through Metaphoric Constructive Conversations (based on the works of Arthur Shelley, Ph.D)
kimpetersen
PRO
0
380
Leadership Guide Workshop - DevTernity 2021
reverentgeek
1
320
Code Review Best Practice
trishagee
74
20k
Visualizing Your Data: Incorporating Mongo into Loggly Infrastructure
mongodb
49
10k
[SF Ruby Conf 2025] Rails X
palkan
2
1.1k
Transcript
atmaCup#8 ݸਓతͳςʔϒϧίϯϖͷऔΈํͱղ๏ !UPNP GPSCFHJOOFST
࣍ 1. ίϯϖͷऔΈํͱղ๏ ɹ1-1. σʔλΛݟΔ ɹ1-2. ಛྔΛ࡞Δ 2. ॳ৺ऀͷํʹΦεεϝ͍ͨ͜͠ͱ
0. ࣗݾհ • @tomo20180402 • ~2020.8 : SEɺ2020.9~ : σʔλੳपΓͷΤϯδχΞ
• σʔλੳίϯϖ2019.5͝Ζ͔Β͍ͬͯΔ • kaggle competitions expert (soloɿ*2ɺ*2) • atmaCupͷ݁ߏͳϔϏʔϢʔβ • ΦϨϯδδϡʔε͋·Γҿ·ͳ͍ ˡࠓճ
1. ίϯϖͷऔΈํͱղ๏
ͷલʹ… • ίϯϖͰΔ͜ͱΛͬ͘͟Γ֬ೝ • ᶅΛୡ͢ΔͨΊɺᶃˠᶄˠᶅͱऔΓΜͰ͍͘ ᶅ999Λ༧ଌ͍ͨ͠ ᶄ༧ଌʹޮ͘ಛྔΛ࡞͍ͨ͠ ᶃσʔλΛཧղ͠ɺಛྔͷΞΠσΞΛग़͍ͨ͠ ˞ಛྔ࡞ʹߜͬͯهࡌ
ͷલʹ… • ίϯϖͰΔ͜ͱΛͬ͘͟Γ֬ೝ • ᶅΛୡ͢ΔͨΊɺᶃˠᶄˠᶅͱऔΓΜͰ͍͘ ᶅ999Λ༧ଌ͍ͨ͠ ᶄ༧ଌʹޮ͘ಛྔΛ࡞͍ͨ͠ ᶃσʔλΛཧղ͠ɺಛྔͷΞΠσΞΛग़͍ͨ͠ ಛྔΛ࡞Δ σʔλΛݟΔ
˞ಛྔ࡞ʹߜͬͯهࡌ
• σʔλΛݟΔɺͱ • ؍ɿ • ςʔϒϧؒͷؔ • ֤ΧϥϜͷҙຯɾ༰ • σʔλܕɿnum,
cat, boolean • ܽଛ • ΧʔσΟφϦςΟͷߴ͞ • ֤ΧϥϜͷ • ΧϥϜؒͷؔ • train/testͷͷҧ͍ɺͳͲ ݟ͍ͨ؍͕ͨ͘͞Μ͋ͬͯେมɻ ಛྔ࡞ʹܨ͕ΔΑ͏ใΛཧ͍ͨ͠ʜɻ 1-1. σʔλΛݟΔ ˞ςʔϒϧσʔλͷ߹
1-1. σʔλΛݟΔ • ಛྔ࡞ʹܨ͕ΔΑ͏ใΛཧ͢Δ • σʔλΛݟΔաఔͰɺࣗͳΓʹѻ͍͍͢ܗͰ·ͱΊΔ • ྫ͑… ᶃ ςʔϒϧͷؔΛ1ຕʹ·ͱΊΔ
ᶄ ֤ΧϥϜ͝ͱʹΞΠσΞΛ·ͱΊΔ
1-1. σʔλΛݟΔ ᶃ ςʔϒϧͷؔΛ1ຕʹ·ͱΊΔ • ςʔϒϧͷඥ͚ • ΧϥϜͷҙຯ • σʔλܕ
• ϢχʔΫ • ܽଛͷɺͳͲ ΧϥϜ ༰ EUZQF OVMM OVOJRVF DPM" DPM$ ɿ ΧϥϜ ༰ EUZQF OVMM OVOJRVF DPM" DPM# ɿ ΧϥϜ ༰ EUZQF OVMM OVOJRVF DPM$ DPM% ɿ σʔλߏΛཧɾཧղͰ͖Δɻ جຊతͳใࡌͤΔ͜ͱͰɺΞΠσΞग़͠Λิॿ͢Δɻ UBCMF@B UBCMF@C UBCMF@D
1-1. σʔλΛݟΔ ᶄ ֤ΧϥϜ͝ͱʹΞΠσΞΛ·ͱΊΔ • matrixΜͰߟ͑ͯΈΔ ΧϥϜ ϝϞ DPM" DPM#
DPM" DPM# ʜ DPM" DPM# ࣗ༝ͳσʔλ୳ࡧʹՃ͑ͯߦ͏͜ͱͰ࿙ΕΛ͙ʢ͍͗ͨʣɻ
1-1. σʔλΛݟΔ • ૣσʔλΛݟͳ͕Β·ͱΊͯΈΔ • ex) Name • Cat •
ΧʔσΟφϦςΟߴ͍͕ɺॏෳ͢Δσʔλ͕ଘࡏ͢Δ • ෳͷϋʔυͰൃച͍ͯ͠Δ༷ • ൃച͍ͯ͠Δϋʔυ͕ଟ͍΄Ͳച্େ͖͘ͳΔͷͰ • NameͷΧϯτΛಛྔͱ͢Δ˒ • train/testͰେ͖͘ဃ͍ͯ͠ΔͨΊͦͷ··ಛྔͱͯ͑͠ͳ͍ • sortͯ͠தΛ֬ೝ͢ΔͱɺγϦʔζͷ͕ଟ͘ଘࡏ͢ΔΑ͏ʹݟ͑Δ • γϦʔζΛಛఆ͢Δ͜ͱ͕Ͱ͖Εച্ͷΛ௫ΊΔͷͰ • ྫ͑”pokemon”ΛؚΉιϑτΛݟΔͱɺϝΠϯͷγϦʔζશମతʹ͔ͳΓചΕ͍ͯͦ͏ • ԿΒ͔ͷํ๏ͰNameΛάϧʔϐϯά͢Δ˒ • ୯ޠͷΧϯτϕʔεͰͰ͖Δ͔ʁ • Name͝ͱͷച্ͷฏۉΛ֬ೝ • Wii SportsΊͪΌͪ͘ΌചΕͯΔʁʢ͔֬ʹ͏ͪʹ͋Δʣ ˞ࠓճγϯϓϧͳσʔλͳͷͰᶄͷΈ࣮ࢪ
1-1. σʔλΛݟΔ • ૣσʔλΛݟͳ͕Β·ͱΊͯΈΔ • ex) Name • Cat •
ΧʔσΟφϦςΟߴ͍͕ɺॏෳ͢Δσʔλ͕ଘࡏ͢Δ • ෳͷϋʔυͰൃച͍ͯ͠Δ༷ • ൃച͍ͯ͠Δϋʔυ͕ଟ͍΄Ͳച্େ͖͘ͳΔͷͰ • NameͷΧϯτΛಛྔͱ͢Δ˒ • train/testͰେ͖͘ဃ͍ͯ͠ΔͨΊͦͷ··ಛྔͱͯ͑͠ͳ͍ • sortͯ͠தΛ֬ೝ͢ΔͱɺγϦʔζͷ͕ଟ͘ଘࡏ͢ΔΑ͏ʹݟ͑Δ • γϦʔζΛಛఆ͢Δ͜ͱ͕Ͱ͖Εച্ͷΛ௫ΊΔͷͰ • ྫ͑”pokemon”ΛؚΉιϑτΛݟΔͱɺϝΠϯͷγϦʔζશମతʹ͔ͳΓചΕ͍ͯͦ͏ • ԿΒ͔ͷํ๏ͰNameΛάϧʔϐϯά͢Δ˒ • ୯ޠͷΧϯτϕʔεͰͰ͖Δ͔ʁ • Name͝ͱͷച্ͷฏۉΛ֬ೝ • Wii SportsΊͪΌͪ͘ΌചΕͯΔʁʢ͔֬ʹ͏ͪʹ͋Δʣ ˞ࠓճγϯϓϧͳσʔλͳͷͰᶄͷΈ࣮ࢪ ଞͷΧϥϜʢ͓ΑͼΧϥϜͷ߹ͤʣʹ͍ͭͯ·ͱΊΔɻ ϝϞࡶͰྑ͍ͷͰɺͱʹ͔͘୳ࡧͷ͍Λอͭͷ͕େࣄɺͳؾ͕͢Δɻ
1-1. σʔλΛݟΔ • ૣσʔλΛݟͳ͕Β·ͱΊͯΈΔ • ex) Year_of_Release • Cat, NumͷͲͪΒͱͯ͠༻Ͱ͖ͦ͏ʢnunique=40ʣ
• train/testͷ΄΅ಉ͡ • testʹະͷʢ2020ʣؚ͕·ΕΔ͕ɺ݅1݅ͷΈ • ൃച͕෯͍ɺͭ·Γଓ͖͍ͯ͠ΔγϦʔζ΄Ͳਓؾ͕͋Γɺച্ଟ͍ͷͰ • ൃചͷظؒɺٴͼɺϢχʔΫΛಛྔͱ͢Δ˒ • ൃചͷִ͕͍ؒ΄Ͳਓؾ͕͋Γɺച্ଟ͍ͷͰ • աڈͷൃച͔Βͷܦաɺະདྷͷൃച·ͰͷΛಛྔͱ͢Δ˒ • ʢnullΛআ͍ͯʣtrain/testͱʹYear_of_ReleaseͷঢॱͰฒΜͰ͍Δ • σʔλͷฒͼʹԿ͔͠Βҙຯ͕͋Δ͔ʁɺྫ͑Ҏ্ͷࡉ͔͍࣌ܥॱྻʹฒΜͰ͍ΔɺͳͲ • Year_of_Release͝ͱͷച্Λ֬ೝʢରมࡁʣ • େ͖͘ݟΔͱݮগʹ͋Γͦ͏ ˞ࠓճγϯϓϧͳσʔλͳͷͰᶄͷΈ࣮ࢪ
1-1. σʔλΛݟΔ • ಛྔͷ؍Λଟ͍࣋ͬͯ͘Δ΄Ͳଟ͘ͷΞΠσΞΛग़ͤΔ • ྫ͑… • Catɿ৽ͨͳใΛநग़Ͱ͖Δ͔ɺcount / frequency
encoding͕ޮ͖ͦ͏͔ • NumɿυϝΠϯࣝʹج͍ͮͯbinningग़དྷͦ͏͔ • Cat * Numɿaggregation͕ޮ͖ͦ͏͔ • Cat * Catɿ༗ޮͳΧςΰϦΛ࡞ΕΔ͔ɺunique͕ޮ͖ͦ͏͔ • Num * Numɿratio, diff͕ޮ͖ͦ͏͔ • Otherɿshift, rolling͕ޮ͖ͦ͏͔ʢtime seriesʣɺtarget encoding͕ޮ͖ͦ͏͔ աڈίϯϖLBHHMFؔ࿈ͷॻ੶͔ΒֶͿͷ͕͓͢͢Ίɻ
• ·ͱΊͨΞΠσΞΛinputʹͯ͠ಛྔΛ࡞Γ͍ͨ • ͕ɺಛྔࢥ͍͍ͭͯɺ࣮͢Δͷ͕ਏ͍…ɻ 1-2. ಛྔΛ࡞Δ গͣͭ͠Ͱྑ͍ͷͰɺίϯϖ͕ऴΘͬͨΒྲྀ༻Ͱ ͖ΔܗͰίʔυΛετοΫ͍ͯ͘͠ͷ͕͓͢͢Ίɻ
• ༻ͨ͠ಛྔ • Catɿ • NameͷάϧʔϐϯάʢγϦʔζͷಛఆʣ • Χϯτ1, 2Ҏ্ͷ୯ޠͰNameΛʢग़ݱճ͕গͳ͍୯ޠΛ༏ઌͯ͠ʣ্ॻ͖ •
τʔΫϯʹԠͨ͡ॏΈ͚ʹΑΔάϧʔϐϯάʢhakubishin3͞ΜͷdiscussionΑΓʣ • count encodingʢ߹ؚͤΉʣ • Cat * Numɿ • NumʢCritic/User_Count/Score, Year_of_Releaseʣʹର͢Δaggregation • keyɿ߹ؚͤΉCat • “Platform_and_Publisher”, “Genre_and_Publisher", etc… • mean, min, max, median, std 1-2. ಛྔΛ࡞Δ
• ༻ͨ͠ಛྔ • Cat * Catɿ • NameܥͷCat͝ͱͷɺҎԼͷunique • Platform,
Genre, Year_of_Release, Publisher • Num * Numɿ • PublisherܥɺNameܥͷCat͝ͱͷҎԼͷಛྔ • աڈͷൃച͔Βͷܦաɺະདྷͷൃച·Ͱͷ • աڈͷൃച͔Βͷιϑτͷྦྷܭɺকདྷൃച͢Διϑτͷྦྷܭ • NumʢCritic/User_Count/Score, Year_of_Releaseʣͷmeanʹର͢Δratio, diff 1-2. ಛྔΛ࡞Δ
• ༻ͨ͠ಛྔ • Otherɿ • PublisherܥɺNameܥͷCat͝ͱͷҎԼͷಛྔ • ൃച͞Εͨιϑτͷshift • leak
• ʮName, Year_of_ReleaseʯʮGenre, Year_of_ReleaseʯͰsort͢Δͱച্ॱʹฒͿ 1-2. ಛྔΛ࡞Δ /BNF :FBS@PG@3FMFBTFͰTPSUʢ߱ॱʣ (FOSF :FBS@PG@3FMFBTFͰTPSUʢ߱ॱʣ
• ޮ͔ͳ͔ͬͨಛྔ • target encoding • ল • shiftͷ͞ •
Year_of_ReleaseͷΧςΰϦผͰͷlagͱleadͷDiff͕ޮ͍ͨʢAkira Shirahama͞ΜΑΓʣ • [ࢀߟ] ಛྔҎ֎ • validationɿgroupkfoldʢ5fold, key=“Name"ʣ • modelɿlgb+xgb+catΛridge regressionͰstacking 1-2. ಛྔΛ࡞Δ
2. ॳ৺ऀͷํʹΦεεϝ͍ͨ͜͠ͱ • ·ͣࣗͰαϒ·ͰͬͯΈΔ • σΟεΧογϣϯͱͯوॏ͕ͩɺઌೖ؍ΛͨͣʹσʔλΛݟΔͷେࣄͩͱײ͡Δ • 1dayίϯϖͰαϒͰ͖ΔΑ͏ʹ͢Δ • ظܾઓʹͳΔͨΊɺEDAfeature
engineeringͷ؍ɺ·ͨɺίʔυͷཧ͕ਐΉ • ෛ͚ͳ͕ΒֶͿ • ະདྷͷใΛར༻͢Δߟ͕͑ͳܸ͘ˏatmaCup#7 • ࠓճ׆͔͖͠Ε͍ͯͳ͍Ͱ͕͢…
͓ΘΓ