case_when

Transcript

1. • ෳ਺ͷ৚݅Λ΋ͱʹɺෳ਺ͷάϧʔϓΛ࡞੒͢Δ • ෳ਺ͷ৚݅Λ΋ͱʹɺҟͳΔܭࢉॲཧΛ͍ͨ͠ Exploratory Hour
2. EXPLORATORY 2
4. ෳ਺ͷ৚݅Λ΋ͱʹɺෳ਺ͷάϧʔϓΛ࡞੒͢Δ
5. FIFAͷαοΧʔબखͷσʔλʹ೥ྸͷྻ͕ ͋Δ͕ɺ೥ྸΛ΋ͱʹɺ৽ਓɺதݎɺϕς ϥϯͱάϧʔϓ෼͚͍ͨ͠ɻ Question 1
6. Age (೥ྸ) ྻͷϔομϝχϡʔΑΓɺ • σʔλΛஔ׵ / ม׵ / ຒΊΔ • ৚݅ʹΑͬͯطଘͷ஋Λஔ͖׵͑Δ
7. case_whenͱ͍͏ؔ਺Λ࢖͏ɻॻ͖ํͱͯ͠͸ɺʮ৚݅ʯͱʮ৚݅ ͕ຬͨ͞Εͨࡍͷ஋ʯͷϖΞΛ”~”Ͱͭͳ͙ɻ ͜ͷྫͰ͸ɺ1ͭ໨ͷ৚݅”೥ྸ͕30ࡀΑΓେ͖͍”ͳΒ”ϕςϥϯ”Λ ฦ͠ɺ2ͭ໨ͷ৚݅”೥ྸ͕20ࡀະຬ”ͳΒ”৽ਓ”Λฦ͢ɻ3ͭ໨ͷ৚݅ TRUE্͕ه2ͭͷ৚݅ʹ߹Θͳ͍΋ͷͳͷͰɺϕςϥϯͰ΋৽ਓͰ ΋ͳ͍άϧʔϓͱ͍͏͜ͱͰ”தݎ”Λฦ͢͜ͱʹ͢Δɻ
8. FIFAͷαοΧʔબखͷσʔλʹϙδγϣϯ ͷྻ͕͋Δ͕ɺ͜ΕΛ΋ͱʹɺGK, DEF, MID, FWDͱάϧʔϓ෼͚͍ͨ͠ɻ Question 2
9. ϙδγϣϯʹΑͬͯɺGK, DEF, MID, FWDͱ͍͏̐ͭͷάϧʔϓʹΘ͚͍ͨɻ GKͷΑ͏ʹ͔̍ͭ֘͠౰͢Δϙδγϣϯ͕ͳ͍৔߹͸ɺ== Ͱద߹ͤ͞Δɻෳ ਺͏ͪͷͲΕ͔ʹద߹͢Δͱ͍͏৚݅ͷ৔߹͸%in%ͱ͍͏ԋࢉࢠΛ࢖͍ɺc() ͷதʹద߹͍ͤͨ͞ީิΛೖΕ͓ͯ͘ɻ֘౰͠ͳ͍΋ͷ͸”Others”ͱ͢Δɻ
10. ෳ਺ͷ৚݅Λ΋ͱʹɺҟͳΔܭࢉॲཧΛ͍ͨ͠
11. બखͷධՁֹ୯ҐͷྻʹM΍Kͱ͍͏ه߸͕ ͋Δ͕ɺM(Million)ͩͬͨΒධՁֹ(€)ͷྻ ͷ஋ʹ1,000,000Λֻ͚ͨ਺஋ʹɺK(Kilo) ͩͬͨΒ1,000Λֻ͚ͨ਺஋ʹ͍ͨ͠ɻͦΕ Ҏ֎͸ͦͷ··ͷ਺஋ʹ͍ͨ͠ɻ Question 3
12. Value͕ϢʔϩݐͯͷධՁֹɺUnit͕୯Ґ(K, M౳)
13. Unitͷྻ͕ධՁֹͷ୯ҐɻMͩͬͨΒMillion ͭ·Γ 1,000,000Λֻ͚ͨ஋Λܭࢉ͠ɺKͩͬͨΒKiloͭ·Γ 1,000Λֻ͚ͨ஋Λܭࢉ͠ɺͦΕҎ֎͸ͦͷ··ͷ஋Λฦ͢ Α͏ʹ͢Δɻ
14. ͱ͜Ζ͕ɺ͜ͷ··࣮ߦ͢ΔͱΤϥʔʹͳΔɻ
15. ཧ༝͸σʔλܕͷෆҰக ͲͪΒ΋Numericͱ͍͏σʔλܕͷҰछͰ͋Δ͕ɺྻͷதʹࠞࡏͰ͖ͳ͍ɻ ઌఔͷcase_whenͷ݁Ռ͸ɺInteger (੔਺) ͱDouble (࣮਺)͕ࠞͬͯ͡͠·͏ɻ Numeric Integer Double ྫ: 1, 2, 3 ྫ: 1.01, 2.53, 3.14
16. Double Double Integer ݩͷσʔλܕ͕IntegerͰ΋ɺܭࢉ͢ΔͱDoubleʹͳΔ
17. ղܾࡦ - Doubleʹม׵͢Δ 3൪໨ͷ஋ͷͱ͜ΖͰas.double()ͱ͍͏ؔ਺Ͱ σʔλܕΛDoubleʹ͢Δͱσʔλܕ͕શͯdouble ʹͳΔͷͰΤϥʔ͕ͳ͘ͳΔɻ
18. ղܾࡦ̎ - Integerʹม׵͢Δ 1൪໨ͱ̎൪Ίͷܭࢉ݁ՌΛas.integer͢Ε͹ integerʹͰ͖Δɻ
19. Q&A
20. Contact Email takato@exploratory.io Twitter Hashtag #ExploratoryHour ͰπΠʔτʂ Twitter @ExploratoryJp Exploratory Hour https://bit.ly/30odd9q