Exploratory セミナー #54 - コロナデータの可視化シリーズ Part 1

Slide 1

Slide 1 text

EXPLORATORY ΦϯϥΠϯɾηϛφʔ #54 ίϩφσʔλͷՄࢹԽγϦʔζ Part 1

Slide 2

Slide 2 text

2 εϐʔΧʔ നށ ܟొ Customer Succes EXPLORATORY ུྺ େֶࡏֶதʹϑʔυϩεΛݮΒͨ͢ΊʹɺֶੜஂମΛ্ཱͪ͛୅දΛ ຿ΊΔɻͦͷޙɺϏδωεΛ஌ΔͨΊʹԽֶϝʔΧʔͷσϡϙϯͱ ϑʔυςοΫܥελʔτΞοϓͰӦۀͱϚʔέςΟϯάΛܦݧɻ ΞϓϦͷ੒௕ͷͨΊʹ͸σʔλαΠΤϯε͕ඞཁͩͱײ͡ɺΞϓϦʹ ಛԽͨ͠Ϣʔβʔͷߦಈ෼ੳπʔϧΛ։ൃ͢ΔاۀʹͯɺΞϓϦۀք ͷKPI෼ੳͳͲΛ୲౰͢Δɻ ݱࡏ͸Exploratory, Inc. ͰΧελϚʔαΫηεΛ୲౰͢Δ๣Βɺσʔ λͷՄࢹԽͱ୳ࡧతσʔλ෼ੳΛઐ໳ͱͯ͠σʔλαΠΤϯεͷීٴ ʹऔΓ૊Ήɻ @ShirotoTakato

Slide 3

Slide 3 text

Vision ͩΕ΋͕σʔλΛ΋ͱʹ ΑΓΑ͍ҙࢥܾఆ͕Ͱ͖Δ

Slide 4

Slide 4 text

Mission σʔλαΠΤϯεͷຽओԽ

Slide 5

Slide 5 text

఻͑Δ σʔλΞΫηε σʔλ ϥϯάϦϯά ՄࢹԽ ΞφϦςΟΫε ౷ܭ/ػցֶश σʔλαΠΤϯεɾϫʔΫϑϩʔ ࣭໰

Slide 6

Slide 6 text

ExploratoryɹϞμϯˍγϯϓϧ UI ఻͑Δ σʔλΞΫηε σʔλ ϥϯάϦϯά ՄࢹԽ ΞφϦςΟΫε ౷ܭ/ػցֶश ࣭໰

Slide 7

Slide 7 text

EXPLORATORY ΦϯϥΠϯɾηϛφʔ #54 ίϩφσʔλͷՄࢹԽγϦʔζ Part 1

Slide 8

Slide 8 text

ΞδΣϯμ • ԣ௕ͷσʔλ(ϫΠυܕ)Λॎ௕ͷσʔλ(ϩϯάܕ)ʹม׵͢Δ • σʔλλΠϓͷม׵ • දࣔ͢Δ஋ͷ੍ݶ • ूܭ • ϑΟϧλʢूܭؔ਺ʣ • ྻΛ݁߹͢Δ • ܭࢉΛ࡞੒ 8

Slide 9

Slide 9 text

9 ੈքͷίϩφ΢Πϧεͷࢮ๢ऀ਺ͷσʔλ

Slide 10

Slide 10 text

10 σʔλ͸Githubʹެ։͞Ε͍ͯͯɺσʔλΛϦϞʔτCSVͱͯ͠औಘ͢ΔͨΊ ʹ͸ɺRawΛΫϦοΫͯ͠։͘ɻ

Slide 11

Slide 11 text

11 ͜ͷURLΛ࢖ͬͯσʔλΛΠϯϙʔτ͢Δ͜ͱ͕Ͱ͖Δɻ

Slide 12

Slide 12 text

12 σʔλϑϨʔϜͷϓϥεϘλϯ͔ΒϑΝΠϧσʔλΛબ୒͢Δɻ

Slide 13

Slide 13 text

13 ϑΝΠϧɾσʔλιʔεͷμΠΞϩά͕։͘ͷͰɺϦϞʔτΛબ୒͢Δɻ

Slide 14

Slide 14 text

14 ςΩετϑΝΠϧ(CSV౳ͷ۠੾ΓϑΝΠϧ)Λબ୒͢Δɻ

Slide 15

Slide 15 text

15 ϦϞʔτɾϑΝΠϧͷURLʹԼهͷϦϯΫΛίϐʔˍϖʔετ͢Δɻ https://raw.githubusercontent.com/CSSEGISandData/COVID-19/ master/csse_covid_19_data/csse_covid_19_time_series/ time_series_covid19_deaths_global.csv

Slide 16

Slide 16 text

16 ϦϞʔτɾϑΝΠϧͷURLʹೖྗͰ͖ͨΒOKϘλϯΛΫϦοΫ͢Δɻ

Slide 17

Slide 17 text

17 ΠϯϙʔτͷμΠΞϩά͕දࣔ͞ΕΔͷͰɺอଘϘλϯΛΫϦοΫ͢Δɻ

Slide 18

Slide 18 text

18 ೚ҙͷ໊લΛࢦఆͯ͠ɺ࡞੒ϘλϯΛΫϦοΫ͢Δɻ

Slide 19

Slide 19 text

19 σʔλΛΠϯϙʔτ͢Δ͜ͱ͕Ͱ͖ͨɻ

Slide 20

Slide 20 text

20 σʔλͷྻ਺ΛݟΔͱ467ྻͱ͔ͳΓଟ͍͜ͱ͕Θ͔Δɻ

Slide 21

Slide 21 text

21 ࢮ๢ऀ਺ͷσʔλ͕೔͝ͱʹྻͱͯ͋͠ΔͨΊɺྻ਺͕ଟ͘ͳ͍ͬͯΔɻ

Slide 22

Slide 22 text

ࢮ๢ऀ਺ͷਪҠΛՄࢹԽ͍ͨ͠ 22

Slide 23

Slide 23 text

23 ϥΠϯνϟʔτΛ࢖ͬͯɺࢮ๢ऀ਺ͷਪҠΛՄࢹԽ͍ͨ͠ɻ

Slide 24

Slide 24 text

24 νϟʔτͷλΠϓʹϥΠϯΛબͼɺX࣠ʹ೔෇ΛׂΓ౰͍ͯͨɻ͔͠͠ɺ͜ͷ σʔλ͸೔͝ͱʹྻ͕͋ΔͨΊʹ࣌ܥྻͷਪҠΛՄࢹԽͰ͖ͳ͍ɻ

Slide 25

Slide 25 text

25 ஋ͷྻ͕ԣ௕ʹͳ͍ͬͯΔσʔλͷ͜ͱΛϫΠυܕͱ͍͏ɻ

Slide 26

Slide 26 text

26 ஋ͷྻ͕Ұྻʹ·ͱ·͍ͬͯΔॎ௕ͷσʔλͷ͜ͱΛϩϯάܕͱ͍͏ɻ

Slide 27

Slide 27 text

27 ϩϯάܕͷσʔλʹ͢Δ͜ͱͰɺνϟʔτͷ࣠ʹྻͱͯ͠બ୒Ͱ͖ΔΑ͏ʹͳ ΔͨΊՄࢹԽ͠΍͘͢ͳΔɻ

Slide 28

Slide 28 text

28 ϫΠυܕ͔Βϩϯάܕ΁ม׵͍ͨ͠ɻ

Slide 29

Slide 29 text

29 ೔͝ͱʹ஋͕͋ΔྻΛෳ਺બͼɺϫΠυ͔Βϩϯάܕ΁ͷબ୒͞ΕͨൣғΛબ ୒͢Δɻ

Slide 30

Slide 30 text

30 ϫΠυܕ͔Βϩϯάܕ΁ͷμΠΞϩά͕දࣔ͞ΕΔɻ

Slide 31

Slide 31 text

31 ։࢝ͷྻʹ࠷ॳͷ೔ɺ຤ඌͷྻʹ࠷ޙͷ೔ͷྻΛબ୒͢Δɻ

Slide 32

Slide 32 text

32 Ωʔྻʹ͸Dateɺ஋ͷྻʹ͸DeathsΛೖྗ࣮ͯ͠ߦ͢Δɻ

Slide 33

Slide 33 text

33 ϫΠυܕ͔Βϩϯάܕ΁ม׵͢Δ͜ͱ͕Ͱ͖ͨɻ

Slide 34

Slide 34 text

34 ͜ͷσʔλ͸ຖ೔ߋ৽͞ΕΔͨΊɺ࠶ΠϯϙʔτϘλϯΛԡ͢ͱ࠷৽ͷ೔ͷྻ ͕௥Ճ͞ΕΔɻ

Slide 35

Slide 35 text

35 ͜ͷઃఆͰ͸ɺσʔλͷߋ৽ʹ߹Θͤͯ຤ඌΛ࠷৽ͷ೔ʹม͑Δඞཁ͕͋Δɻ

Slide 36

Slide 36 text

36 ࢮ๢ऀ਺ͷྻҎ֎Λআ͘ͱɺσʔλ͕ߋ৽͞Εͯ΋ରԠͰ͖ΔͷͰ͸ͳ͍͔ʁ ϫΠυܕ͔Βϩϯάܕ΁ͷର৅ྻ औΓআ͖͍ͨྻ

Slide 37

Slide 37 text

37 εςοϓ2ͷτʔΫϯΛΫϦοΫ͢Δɻ

Slide 38

Slide 38 text

38 ϫΠυܕ͔Βϩϯάܕ΁ͷμΠΞϩάΛ։͘͜ͱ͕Ͱ͖Δɻ

Slide 39

Slide 39 text

39 ؚΉͰ͸ͳ͘ɺআ͘ʹνΣοΫΛ͢Δɻ

Slide 40

Slide 40 text

40 ೔͝ͱʹ͋Δࢮ๢ऀ਺ͷྻ͚ͩͰϫΠυܕ͔Βϩϯάܕʹ͍ͨͨ͠Ίɺ Province/State͔ΒLong·ͰͷྻΛআ͖͍ͨɻ

Slide 41

Slide 41 text

41 ։࢝ʹProvince/StateΛબͼɺ຤ඌʹLongΛબ୒͢Δɻ

Slide 42

Slide 42 text

42 ։࢝ͱ຤ඌͷઃఆ͕Ͱ͖ͨΒ࣮ߦϘλϯΛΫϦοΫ͢Δɻ

Slide 43

Slide 43 text

43 ೔͝ͱʹ͋Δࢮ๢ऀ਺ͷྻΛϫΠυܕ͔Βϩϯάܕʹม׵Ͱ͖ͨɻ

Slide 44

Slide 44 text

44 ͜ͷํ๏Ͱ͸ɺ࠷৽ͷ೔ͷྻ͕௥Ճ͞Εͯ΋ઃఆΛม͑Δඞཁ͸ͳ͍ɻ

Slide 45

Slide 45 text

45 νϟʔτɾϏϡʔΛબ୒͠ɺνϟʔτϐϯΛεςοϓ2ʹඥ͚ͮΔɻ

Slide 46

Slide 46 text

46 • νϟʔτλΠϓʹϥΠϯΛબ୒͢Δɻ • X࣠ʹDateΛબ୒͢Δɻ • Y࣠ʹDeathsΛબͼɺूܭؔ਺ʹ߹ܭ஋(sum)Λબ୒͢Δɻ

Slide 47

Slide 47 text

47 ೔෇ͷॱং͕͓͔͍͠Α͏ͩɻ1݄1೔ͷޙʹ1݄11೔͕དྷ͍ͯΔʁʁ

Slide 48

Slide 48 text

48 X࣠ͷDateͷྻͷσʔλλΠϓ͕Characterܕʹͳ͍ͬͯΔ͔ΒͰ͋Δɻ

Slide 49

Slide 49 text

49 DateͷྻΛCharacterܕ͔ΒDateܕʹม׵͢Δɻ

Slide 50

Slide 50 text

50 ྻϔομϝχϡʔ͔ΒσʔλλΠϓΛม׵ΛબͼɺDate(೔෇)/POSIXct(೔෇ ࣌ؒܕ)λΠϓΛબ୒͢Δɻ͔͠͠ɺ͔͠͠ͲΕΛબ΂͹͍͍ͷͩΖ͏͔ʁ

Slide 51

Slide 51 text

2017-01-01 year month day 51 ZNE ΋ͱͷσʔλ͕೥(year)ɺ݄(month)ɺ೔(day)ͷॱ൪Ͱ͋Ε͹ymdؔ਺Λ ࢖ͬͯσʔλλΠϓΛcharacterܕ͔ΒDateܕ΁ม׵Ͱ͖Δɻ

Slide 52

Slide 52 text

ymd("2015-10-01") ymd("2015/10/01") ymd("Created on 2015 October 1st") 52 ymd ΋ͱͷจࣈྻͷฒͼॱͷΈ͕ॏཁɻͦΕͧΕͷؒʹ͋Δจࣈྻ͸ؔ܎ͳ͍ɻ

Slide 53

Slide 53 text

53 ࠓճͷσʔλͷ৔߹͸ɺ݄ɾ೔ɾ೥ͷॱͳͷͰmdyʹͳΔɻ 1/22/20 mdy

Slide 54

Slide 54 text

54 ࠓճͷσʔλͷ৔߹͸ɺ݄ɾ೔ɾ೥ͷॱͳͷͰmdyʹͳΔɻ 1/22/2020 mdy ೥ͷ20͕ແͯ͘΋ ͍͍ͷ͔ʁ

Slide 55

Slide 55 text

55 σʔλλΠϓͷม׵͔ΒDate(೔෇)/POSIXct(೔෇࣌ؒ)λΠϓʹม׵Λબͼɺ Month, Day, YearΛબ୒͢Δɻ

Slide 56

Slide 56 text

56 ܭࢉΛ࡞੒ͷμΠΞϩά͕։͘ͷͰɺͦͷ··࣮ߦ͢Δɻ

Slide 57

Slide 57 text

57 DateͷྻΛDateܕ(೔෇)ʹม׵͢Δ͜ͱ͕Ͱ͖ͨɻ

Slide 58

Slide 58 text

58 Dateܕʹ͢Δ͜ͱͰ೔෇ͷظؒΛ֬ೝ͢Δ͜ͱ͕Ͱ͖Δɻ

Slide 59

Slide 59 text

59 ϥΠϯνϟʔτʹ໭ΓɺνϟʔτϐϯΛεςοϓ3ʹඥ͚ͮΔɻ

Slide 60

Slide 60 text

60 ೔෇ͷूܭ୯ҐΛؙΊॲཧͷ೔ʹมߋ͢Δɻ

Slide 61

Slide 61 text

61 ࢮ๢ऀ਺ͷਪҠΛՄࢹԽ͢Δ͜ͱ͕Ͱ͖ͨɻ

Slide 62

Slide 62 text

62 ࢮ๢ऀ਺͕ੵΈ্͕͍ͬͯΔΑ͏ʹݟ͑Δ͕ɺ͜ͷσʔλͷҰߦ͸೔ຖͷࢮ๢ ऀ਺Ͱ͸ແ͍ͷ͔ʁ

Slide 63

Slide 63 text

63 ςʔϒϧɾϏϡʔ͔ΒϑΟϧλΛΫϦοΫ͢Δɻ

Slide 64

Slide 64 text

64 • ྻʹCountry/RegionΛબ୒͢Δɻ • ԋࢉࢠʹ౳͍͠Λબ୒͢Δɻ • ஋ʹUSΛબ୒͢Δɻ

Slide 65

Slide 65 text

65 ςʔϒϧɾϏϡʔͷϑΟϧλΛ࢖ͬͯUSͷσʔλͷΈ͕දࣔ͞Εͨɻ

Slide 66

Slide 66 text

66 USͷσʔλ͸463ߦ͋ΔΑ͏ͩɻ

Slide 67

Slide 67 text

67 ߦͷදࣔൣғΛ500ʹઃఆ͢Δɻ

Slide 68

Slide 68 text

68 ࢮ๢ऀ਺ͷ஋͸͜Ε·Ͱͷ஋Λ଍্͍͛ͯ͘͠ɺྦྷੵ߹ܭ஋ͱͳ͍ͬͯΔɻ

Slide 69

Slide 69 text

69 ࠷ޙͷ೔(࠷ޙͷߦ)ΛݟΔ͜ͱͰɺݱࡏͷࢮ๢ऀ਺͕Θ͔Δɻ

Slide 70

Slide 70 text

70 ςʔϒϧɾϏϡʔɾϑΟϧλΛ࡟আ͢Δɻ

Slide 71

Slide 71 text

ࠃ͝ͱʹࢮ๢ऀ਺ͷਪҠΛՄࢹԽ͍ͨ͠ 71

Slide 72

Slide 72 text

72 ৭(άϧʔϓԽ)ʹCountry/RegionΛબ୒͢Δɻ

Slide 73

Slide 73 text

73 Ұҙͳ஋ͷνΣοΫʹʮදࣔ͢Δ஋ͷ਺Λ੍ݶ͢ΔʯΛબͿɻ

Slide 74

Slide 74 text

74 ࠃ͝ͱʹࢮ๢ऀ਺ͷਪҠΛՄࢹԽ͢Δ͜ͱ͕Ͱ͖͕ͨɺࢮ๢ऀ਺ͷ߹ܭ஋ͷ্ Ґ50ͷࠃ͕ՄࢹԽ͞Ε͍ͯΔɻ

Slide 75

Slide 75 text

75 ࢮ๢ऀ਺ͷ࠷େ஋ͷ্Ґ20ΧࠃͷΈΛ࢒͍ͨ͠ɻ

Slide 76

Slide 76 text

76 • λΠϓʹ্ҐΛબ୒͢Δɻ • ݁Ռͷ਺ʹ20Λೖྗ͢Δɻ • جʹͳΔྻʹDeathsΛબͼɺूܭؔ਺ʹ࠷େ஋ ʢMAXʣΛબ୒͢Δɻ

Slide 77

Slide 77 text

77 ࢮ๢ऀ਺ͷଟ্͍Ґ20ΧࠃͰਪҠΛՄࢹԽ͢Δ͜ͱ͕Ͱ͖ͨɻ

Slide 78

Slide 78 text

78 ΞϝϦΧ͸ࢮ๢ऀ਺͕໿57ສਓ΋͍ΔΑ͏ͩɻ

Slide 79

Slide 79 text

79 Πϯυ͸4݄ʹೖ͔ͬͯΒࢮ๢ऀ਺͕ٸܹʹ૿͍͑ͯΔΑ͏ͩɻ

Slide 80

Slide 80 text

ਓޱൺͰݟΔͱͲͷࠃ͕ࢮ๢͢Δׂ߹͕ଟ ͍ͷ͔ʁ 80

Slide 81

Slide 81 text

81 ͜ͷσʔλʹ͸ਓޱͷσʔλ͸ͳ͍ɻ

Slide 82

Slide 82 text

82 ͜͏͍͏࣌͸ɺྻ݁߹Λ࢖ͬͯਓޱͷσʔλΛ௥Ճ͢Δɻ

Slide 83

Slide 83 text

83 ίϩφ΢Πϧεͷσʔλ ਓޱͷσʔλ ࠃͰάϧʔϓԽ ࠃ͝ͱʹࢮ๢ऀ਺Λूܭ ࢮ๢ऀ਺ͷਓޱൺΛܭࢉ ݁߹(Join) ࠃ͝ͱʹࢮ๢ऀͷਓޱൺΛٻΊΔͨΊͷखॱ ࠷৽ͷ೥ʹϑΟϧλ ਓޱͷσʔλͱ݁߹

Slide 84

Slide 84 text

84 ίϩφ΢Πϧεͷσʔλ ਓޱͷσʔλ ࠃͰάϧʔϓԽ ࠃ͝ͱʹࢮ๢ऀ਺Λूܭ ࢮ๢ऀ਺ͷਓޱൺΛܭࢉ ݁߹(Join) ࠃ͝ͱʹࢮ๢ऀͷਓޱൺΛٻΊΔͨΊͷखॱ ࠷৽ͷ೥ʹϑΟϧλ ਓޱͷσʔλͱ݁߹

Slide 85

Slide 85 text

85 Australia͕ෳ਺ߦ͋ΔΑ͏ͩɻ1ߦΛ1Χࠃʹͯ͠ɺࢮ๢ऀ਺ͷ߹ܭΛٻΊΔʹ ͸Ͳ͏ͨ͠Βྑ͍͔ʁ

Slide 86

Slide 86 text

ूܭΛ࢖͏ͱࠃ͝ͱʹࢮ๢ऀ਺Λ·ͱΊΔ ͜ͱ͕Ͱ͖Δɻ 86

Slide 87

Slide 87 text

87 ूܭΛ࢖͏ͱɺෳ਺ߦ͋ΔσʔλΛҰߦʹ·ͱΊͯܭࢉͨ݁͠ՌΛฦ͢͜ͱ͕ Ͱ͖Δɻ State Country Deaths New South Wales Australia 50 Victoria Australia 20 Western Australia Australia 10 Country Deaths_sum Australia 80

Slide 88

Slide 88 text

88 Country/Regionͷྻϔομϝχϡʔ͔ΒूܭΛબ୒͢Δɻ

Slide 89

Slide 89 text

89 ूܭͷμΠΞϩά͕දࣔ͞ΕΔɻ

Slide 90

Slide 90 text

90 άϧʔϓԽʹDateΛׂΓ౰ͯɺूܭ୯ҐʹؙΊॲཧͷ೔Λબ୒͢Δɻ

Slide 91

Slide 91 text

91 ஋ʹDeathsΛબͼɺूܭؔ਺ʹ߹ܭ஋(sum)Λબ୒͢Δɻ

Slide 92

Slide 92 text

92 ࠃ͝ͱʹࢮ๢ऀ਺ͷ߹ܭ஋Λूܭ͢Δ͜ͱ͕Ͱ͖ͨɻ

Slide 93

Slide 93 text

93 ίϩφ΢Πϧεͷσʔλ ਓޱͷσʔλ ࠃͰάϧʔϓԽ ࠃ͝ͱʹࢮ๢ऀ਺Λूܭ ࢮ๢ऀ਺ͷਓޱൺΛܭࢉ ݁߹(Join) ࠃ͝ͱʹࢮ๢ऀͷਓޱൺΛٻΊΔͨΊͷखॱ ࠷৽ͷ೥ʹϑΟϧλ ਓޱͷσʔλͱ݁߹

Slide 94

Slide 94 text

ਓޱͷσʔλͷΠϯϙʔτ 94

Slide 95

Slide 95 text

95 σʔλϑϨʔϜͷϓϥεϘλϯ͔ΒσʔλɾΧλϩάΛબ୒͢Δɻ

Slide 96

Slide 96 text

96 σʔλɾΧλϩάͷμΠΞϩά͕දࣔ͞ΕΔɻ

Slide 97

Slide 97 text

97 ݕࡧϘοΫεʹPopulation(ਓޱ)ͱೖྗͯ͠ݕࡧϘλϯΛΫϦοΫ͢Δɻ

Slide 98

Slide 98 text

98 ࠃผͷGDPͱਓޱσʔλ(1960೥~2019೥)ͷΠϯϙʔτΛΫϦοΫ͢Δɻ

Slide 99

Slide 99 text

99 σʔλɾΧλϩάͷΠϯϙʔτͷμΠΞϩά͕දࣔ͞ΕΔͷͰɺͦͷ··࣮ߦ ͢Δɻ

Slide 100

Slide 100 text

100 σʔλϑϨʔϜ໊ʹ೚ҙͷ໊લΛೖྗͯ͠ɺ࡞੒ϘλϯΛΫϦοΫ͢Δɻ

Slide 101

Slide 101 text

101 ਓޱͷσʔλΛΠϯϙʔτ͢Δ͜ͱ͕Ͱ͖ͨɻ

Slide 102

Slide 102 text

102 YearͷྻΛݟΔͱɺ1960೥͔Β2019೥·Ͱσʔλ͕͋ΔΑ͏ͩɻ

Slide 103

Slide 103 text

103 ࠃ͝ͱʹ࠷ޙͷਓޱͷ஋͚ͩΛ࢒͍ͨ͠ɻ ࠃ ೔෇ ਓޱ ೔ຊ ೔ຊ தࠃ தࠃ ΞϝϦΧ ΞϝϦΧ

Slide 104

Slide 104 text

104 ͔͠͠ɺࠃʹΑͬͯ͸2019೥ͷσʔλ͕ͳ͘ɺ2018೥·Ͱ͔͠σʔλ͕ͳ͍ ͜ͱ͕͋Δɻ ࠃ ೔෇ ਓޱ ೔ຊ ೔ຊ தࠃ தࠃ ΞϝϦΧ ΞϝϦΧ

Slide 105

Slide 105 text

105 2019೥ͰϑΟϧλͯ͠͠·͏ͱɺதࠃͷਓޱͷσʔλ͕ͳ͘ͳͬͯ͠·͏ɻ ࠃ ೔෇ ਓޱ ೔ຊ ೔ຊ தࠃ தࠃ ΞϝϦΧ ΞϝϦΧ ࠃ ೔෇ ਓޱ ೔ຊ ΞϝϦΧ

Slide 106

Slide 106 text

ࠃ͝ͱʹ೥ͷ࠷େ஋ͰϑΟϧλ͢Δ͜ͱͰɺࠃ͝ ͱͷ࠷ޙͷਓޱ͚ͩΛ࢒͢͜ͱ͕Ͱ͖Δɻ 106

Slide 107

Slide 107 text

107 1. ࠃΛάϧʔϓԽ͢Δɻ ࠃ ೔෇ ਓޱ ೔ຊ ೔ຊ தࠃ தࠃ ΞϝϦΧ ΞϝϦΧ

Slide 108

Slide 108 text

108 2. ೥ͷ࠷େ஋ͰϑΟϧλ͢Δ͜ͱͰɺࠃ͝ͱʹ࠷ޙͷ೥ͷߦ͚ͩΛ࢒͢͜ͱ͕ Ͱ͖Δɻ ࠃ ೔෇ ਓޱ ೔ຊ ೔ຊ தࠃ தࠃ ΞϝϦΧ ΞϝϦΧ ࠃ ೔෇ ਓޱ ೔ຊ தࠃ ΞϝϦΧ

Slide 109

Slide 109 text

109 ίϩφ΢Πϧεͷσʔλ ਓޱͷσʔλ ࠃͰάϧʔϓԽ ࠃ͝ͱʹࢮ๢ऀ਺Λूܭ ࢮ๢ऀ਺ͷਓޱൺΛܭࢉ ݁߹(Join) ࠃ͝ͱʹࢮ๢ऀͷਓޱൺΛٻΊΔͨΊͷखॱ ࠷৽ͷ೥ʹϑΟϧλ ਓޱͷσʔλͱ݁߹

Slide 110

Slide 110 text

110 Countryͷྻϔομϝχϡʔ͔ΒάϧʔϓԽΛ࣮ߦ͢Δɻ

Slide 111

Slide 111 text

111 ࠃ͝ͱʹάϧʔϓԽ͞Εͨɻ

Slide 112

Slide 112 text

112 ίϩφ΢Πϧεͷσʔλ ਓޱͷσʔλ ࠃͰάϧʔϓԽ ࠃ͝ͱʹࢮ๢ऀ਺Λूܭ ࢮ๢ऀ਺ͷਓޱൺΛܭࢉ ݁߹(Join) ࠃ͝ͱʹࢮ๢ऀͷਓޱൺΛٻΊΔͨΊͷखॱ ࠷৽ͷ೥ʹϑΟϧλ ਓޱͷσʔλͱ݁߹

Slide 113

Slide 113 text

113 Yearͷྻϔομϝχϡʔ͔ΒϑΟϧλΛબͼɺ౳͍͠Λબ୒͢Δɻ

Slide 114

Slide 114 text

114 ूܭؔ਺ʹνΣοΫΛͯ͠ɺ࠷େ஋Λબ୒͢Δɻ

Slide 115

Slide 115 text

115 ࠃ͝ͱʹ࠷ޙͷ೥ͷΈʹϑΟϧλ͢Δ͜ͱ͕Ͱ͖ͨɻ

Slide 116

Slide 116 text

116 ࠃʹΑͬͯ͸ɺ2018೥΍2017೥ͷσʔλ͕࢒͍ͬͯΔ͜ͱ͕֬ೝͰ͖Δɻ

Slide 117

Slide 117 text

117 άϧʔϓԽΛղআ͢Δɻ

Slide 118

Slide 118 text

118 άϧʔϓԽͷޮՌ͕ղআ͞Εͨɻ

Slide 119

Slide 119 text

119 ߦ਺ͱCountryͷҰҙͷ਺͕Ұக͍ͯ͠ΔͨΊɺ1ߦ͕1Χࠃʹͳ͍ͬͯΔɻ

Slide 120

Slide 120 text

120 ίϩφ΢Πϧεͷσʔλ ਓޱͷσʔλ ࠃͰάϧʔϓԽ ࠃ͝ͱʹࢮ๢ऀ਺Λूܭ ࢮ๢ऀ਺ͷਓޱൺΛܭࢉ ݁߹(Join) ࠃ͝ͱʹࢮ๢ऀͷਓޱൺΛٻΊΔͨΊͷखॱ ࠷৽ͷ೥ʹϑΟϧλ ਓޱͷσʔλͱ݁߹

Slide 121

Slide 121 text

121 ࠃ͝ͱʹࢮ๢ऀ਺Λूܭ͍ͯ͠ΔϒϥϯνͷσʔλϑϨʔϜΛ։͘ɻ

Slide 122

Slide 122 text

122 ͜ͷσʔλʹਓޱͷσʔλΛྻ݁߹͍ͨ͠ɻ

Slide 123

Slide 123 text

123 ݁߹͢Δʹ͸ɺ͓ޓ͍ͷσʔλϑϨʔϜͰҰக͢ΔΩʔྻ͕ඞཁʹͳΔɻ Country Deaths United States 200 Japan 20 China 40 Country Population United States 3,200 Japan 1,200 China 13,000 Ωʔྻ

Slide 124

Slide 124 text

124 ࠓճͷ৔߹͸Country(ࠃ໊)͕ΩʔྻʹͳΔɻ Ωʔྻ

Slide 125

Slide 125 text

125 ݁߹ݩͷσʔλϑϨʔϜʹ݁߹ઌͷσʔλϑϨʔϜͷྻΛ௥ՃͰ͖Δɻ Country Deaths United States 200 Japan 20 China 40 Country Population United States 3,200 Japan 1,200 China 13,000 Country Deaths Population United States 200 3,200 Japan 20 1,200 China 40 13,000 ݁߹ݩ ݁߹ઌ

Slide 126

Slide 126 text

126 ࠓճͷ৔߹͸ɺ݁߹ઌͷྻʹ͋ΔPopulationҎ֎ͷGDPͳͲ΋௥Ճ͞ΕΔɻ ݁߹ݩͷྻ ݁߹ઌͷྻ

Slide 127

Slide 127 text

127 Country/Regionͷྻϔομϝχϡʔ͔Β݁߹Λબ୒͢Δɻ

Slide 128

Slide 128 text

128 ݁߹ͷμΠΞϩά͕දࣔ͞ΕΔɻ

Slide 129

Slide 129 text

129 ݁߹ઌσʔλϑϨʔϜʹਓޱͷσʔλΛબͼɺΩʔྻʹ͸CountryΛબ୒͢Δɻ

Slide 130

Slide 130 text

130 ਓޱͷσʔλΛྻ݁߹͢Δ͜ͱ͕Ͱ͖ͨɻ

Slide 131

Slide 131 text

ਓޱൺΛٻΊΔ 131

Slide 132

Slide 132 text

132 ίϩφ΢Πϧεͷσʔλ ਓޱͷσʔλ ࠃͰάϧʔϓԽ ࠃ͝ͱʹࢮ๢ऀ਺Λूܭ ࢮ๢ऀ਺ͷਓޱൺΛܭࢉ ݁߹(Join) ࠃ͝ͱʹࢮ๢ऀͷਓޱൺΛٻΊΔͨΊͷखॱ ࠷৽ͷ೥ʹϑΟϧλ ਓޱͷσʔλͱ݁߹

Slide 133

Slide 133 text

133 ࢮ๢ऀ਺ͷྻ͔ΒܭࢉΛ࡞੒(Mutate)Λબ୒͢Δɻ

Slide 134

Slide 134 text

134 ܭࢉΛ࡞੒ͷμΠΞϩά͕දࣔ͞ΕΔɻ

Slide 135

Slide 135 text

135 ܭࢉΤσΟλʹԼهͷܭࢉࣜΛೖྗ࣮ͯ͠ߦ͢Δɻ

Slide 136

Slide 136 text

136 ࠃ͝ͱʹࢮ๢ऀ਺ͷਓޱൺΛٻΊΔ͜ͱ͕Ͱ͖ͨɻ

Slide 137

Slide 137 text

137 ͔͠͠ɺখ਺఺ͷܻ਺͕͔ͳΓେ͖͘ɺ௚ײతʹཧղͮ͠Β͍ɻ

Slide 138

Slide 138 text

138 εςοϓ8ͷܭࢉΛ࡞੒ͷτʔΫϯΛΫϦοΫ͢Δɻ

Slide 139

Slide 139 text

139 100,000ਓ͋ͨΓͷࢮ๢ऀ਺ʹ͢ΔͨΊɺܭࢉࣜΛԼهͷΑ͏ʹ͢Δɻ

Slide 140

Slide 140 text

140 10ສਓ͋ͨΓͷࢮ๢ऀ਺ΛٻΊΔ͜ͱ͕Ͱ͖ͨɻ

Slide 141

Slide 141 text

141 νϟʔτϏϡʔʹҠΓɺࢮ๢ऀ਺ͷਪҠͷνϟʔτΛෳ੡͢Δɻ

Slide 142

Slide 142 text

142 ෳ੡ͨ͠νϟʔτͷνϟʔτϐϯΛεςοϓ6ʹඥ͚ͮΔɻ

Slide 143

Slide 143 text

143 Y࣠ʹ10ສਓ͋ͨΓͷࢮ๢ऀ਺ͷྻΛબ୒͢Δɻ

Slide 144

Slide 144 text

144 νΣί͕࠷΋10ສਓ͋ͨΓͷࢮ๢ऀ਺͕ଟ͘ɺ4݄28೔ͷ࣌఺Ͱ273ਓͱ͍͏ ͜ͱ͕Θ͔Δɻ

Slide 145

Slide 145 text

145 ΠϯυͰ͸ɺ10ສਓ͋ͨΓͷࢮ๢ऀ਺͕4݄28೔ͷ࣌఺Ͱ15ਓͱࢮ๢ऀ਺ͷ্ Ґ20Χࠃͷ͏ͪͰ͸࠷΋গͳ͍Α͏ͩɻ

Slide 146

Slide 146 text

146 Πϯυͷࢮ๢ऀ਺͚ͩͰݟ͍ͯΔͱٸܹʹ૿͍͑ͯΔΑ͏ʹݟ͑Δ͕ɺਓޱ͋ ͨΓͷࢮ๢ऀ਺ͰݟΔͱଞͷࠃʹൺ΂ͯগͳ͍ͱ͍͏݁Ռʹͳͬͨɻ ࢮ๢ऀ਺ 10ສਓ͋ͨΓͷࢮ๢ऀ਺

Slide 147

Slide 147 text

147 ΞϝϦΧͷ10ສਓ͋ͨΓͷࢮ๢ऀ਺͕දࣔ͞Ε͍ͯͳ͍͕ͳ͔ͥʁ

Slide 148

Slide 148 text

148 ςʔϒϧɾϏϡʔͰ֬ೝ͢Δͱɺྻ݁߹͕͏·͍͍ͬͯ͘ͳ͍Α͏ͩɻ

Slide 149

Slide 149 text

149 ݁߹ͷࡍʹ࢖༻ͨ͠Ωʔ͕Ұக͍ͯ͠ͳ͍ɻ ίϩφ΢Πϧεͷσʔλ ਓޱͷσʔλ

Slide 150

Slide 150 text

͜ͷ໰୊͸ࠃ໊/ίʔυͷม׵ͰղܾͰ͖Δʂ 150

Slide 151

Slide 151 text

151 ࠃ໊/ίʔυͷม׵Ͱ͸Լهͷ͜ͱ͕Ͱ͖Δɻ(Ұ෦ൈਮ) United States / US ࠃ໊/ίʔυ େ཮໊: Americas ࠃ໊: United States ISO2C: US ISO3C: USA

Slide 152

Slide 152 text

152 ݁߹લͷεςοϓ4ͷूܭͷεςοϓΛબ୒͢Δɻ

Slide 153

Slide 153 text

153 Country/Regionͷྻϔομϝχϡʔ͔ΒςΩετσʔλͷՃ޻(UI)ͷม׵͢ΔΛ બ୒͢Δɻ

Slide 154

Slide 154 text

154 ม׵ݩͱม׵ઌʹࠃ໊Λબ୒͢Δɻ

Slide 155

Slide 155 text

155 ࠃ໊ͷදه༳ΕΛ౷Ұ͢Δ͜ͱ͕Ͱ͖ͨɻ

Slide 156

Slide 156 text

156 ςʔϒϧϏϡʔͷϑΟϧλͰ֬ೝͯ͠ΈΔͱɺUS͔ΒUnited StatesʹมΘͬͯ ͍Δ͜ͱ͕Θ͔Δɻ

Slide 157

Slide 157 text

157 ྻ݁߹ͷॲཧΛͨ͠εςοϓ6Λબ୒͢Δͱɺ্ख݁͘߹Ͱ͖͍ͯΔΑ͏ͩɻ

Slide 158

Slide 158 text

158 ઌఔͷ10ສਓ͋ͨΓͷࢮ๢ऀ਺ΛՄࢹԽͨ͠νϟʔτΛ։͘ɻ

Slide 159

Slide 159 text

159 ΞϝϦΧͷ10ສਓ͋ͨΓͷࢮ๢ऀ਺͸175ਓͱ͍͏͜ͱ͕Θ͔ͬͨɻ

Slide 160

Slide 160 text

160 ͪͳΈʹɺදࣔ͢Δ஋ͷ੍ݶͷର৅Λ10ສਓ͋ͨΓͷࢮ๢ऀ਺ʹมߋͯ͠ɺࢮ ๢཰ͷߴ͍ࠃͲ͏͠Ͱൺ΂Δ͜ͱ΋Ͱ͖Δɻ

Slide 161

Slide 161 text

࣍ճηϛφʔ

Slide 162

Slide 162 text

EXPLORATORY ΦϯϥΠϯɾηϛφʔ #55 μογϡϘʔυͷϥΠϑαΠΫϧ

Slide 163

Slide 163 text

No content

Slide 164

Slide 164 text

164

Slide 165

Slide 165 text

σʔλαΠΤϯεɾϒʔτΩϟϯϓ #22 EXPLORATORY 2021೥6݄։࠵ σʔλαΠΤϯεͷख๏Λϓϩάϥϛϯάͳ͠ʹجૅ͔Βମܥతʹֶͼɺ ͞Βʹ࣮ࡍͷۀ຿Ͱ࢖͏ͨΊͷεΩϧΛ਎ʹ͚͍͖ͭͯͨͩ·͢ɻ

Slide 166

Slide 166 text

6݄ΦϯϥΠϯ։࠵ʂ ೔ఔɿ6݄8೔(Ր), 9೔(ਫ), 10೔(໦)

Slide 167

Slide 167 text

No content

Slide 168

Slide 168 text

࿈བྷઌ ϝʔϧ takato@exploratory.io ΢ΣϒαΠτ https://ja.exploratory.io ϒʔτΩϟϯϓɾτϨʔχϯά https://ja.exploratory.io/training-jp Twitter @ExploratoryJp