Exploratory Hour #105 - 元のデータ順をもとに、カテゴリー列の値の順序を指定したい

by Takato Shiroto

Slide 1

Slide 1 text

EXPLORATORY 1

Slide 2

Slide 2 text

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

Slide 3

Slide 3 text

3 • ࣭͝໰͸zoomͷνϟοτʹ͝౤ߘ͍ͩ͘͞ɻ • ηϛφʔͷײ૝΍໾ʹཱͭ৘ใΛTwitterͰϋογϡλάΛ ͚ͭͯπΠʔτΛ͓ئ͍͠·͢ɻ #Exploratoryηϛφʔ Exploratory Hour Exploratory Hour

Slide 4

Slide 4 text

Exploratory Hour

Slide 5

Slide 5 text

ʲࠓिͷ࣭໰ʳ • ผͷྻͷ஋Λ΋ͱʹɺΧςΰϦʔྻͷ஋ͷॱংΛࢦఆ͍ͨ͠ • ݩͷσʔλॱΛ΋ͱʹɺΧςΰϦʔྻͷ஋ͷॱংΛࢦఆ͍ͨ͠ 5

Slide 6

Slide 6 text

Very Bad Bad Neutral Good Very Good 1 2 3 4 5 6 ΧςΰϦʔܕͱಉ͡Α͏͕ͩɺ ಺ࡏతʹॱংؔ܎Λ͍࣋ͬͯΔσʔλ ॱং෇͖ΧςΰϦʔ (factor)

Slide 7

Slide 7 text

7 ΧςΰϦʔ (character)ͷ৔߹ɺΞϧϑΝϕοτॱͰදࣔ͞ΕΔɻ

Slide 8

Slide 8 text

8 ॱং෇͖ΧςΰϦʔ (factor)ͷ৔߹͸ɺࢦఆͨ͠ॱংΛ΋ͱʹදࣔͰ͖Δɻ

Slide 9

Slide 9 text

ճ౴ Bad Good Neutral Very Bad Very Good CharacterʢΧςΰϦʔʣ 9 ճ౴ Ϩϕϧ Very Bad 1 Bad 2 Neutral 3 Good 4 Very Good 5 ྻʹϨϕϧͷ৘ใΛ࣋ͨͤΔ͜ͱ͕Ͱ͖Δɻ Factorʢॱং෇͖ΧςΰϦʔʣ

Slide 10

Slide 10 text

ʲࠓिͷ࣭໰ʳ • ผͷྻͷ஋Λ΋ͱʹɺΧςΰϦʔྻͷ஋ͷॱংΛࢦఆ͍ͨ͠ • ݩͷσʔλॱΛ΋ͱʹɺΧςΰϦʔྻͷ஋ͷॱংΛࢦఆ͍ͨ͠ 10

Slide 11

Slide 11 text

11 ྺ୅ͷ૯ཧେਉͷσʔλ

Slide 12

Slide 12 text

12 • λΠϓʹόʔΛબ୒͢Δɻ • X࣠ʹࢯ໊Λબ୒͢Δɻ • Y࣠ʹࡏ৬೔਺Λબ୒͢Δɻ

Slide 13

Slide 13 text

13 ब೚ॱʹ૯ཧେਉͷࡏ৬೔਺ΛՄࢹԽ͍ͨ͠ͷ͕ͩɺࢯ໊ॱʹฒΜͰ͍Δɻ

Slide 14

Slide 14 text

14 ݩͷσʔλ͸ब೚ॱʹฒΜͰ͍ΔͷͰɺ͜ͷॱ൪ΛϨϕϧͱͯ͠ར༻͍ͨ͠ɻ

Slide 15

Slide 15 text

15 ࢯ໊ͷྻϔομϝχϡʔ͔Β஋ͷॱংΛηοτͷݩͷσʔλॱΛબ୒͢Δɻ

Slide 16

Slide 16 text

16 ܭࢉΛ࡞੒ͷμΠΞϩά͕දࣔ͞ΕɺܭࢉΤσΟλʹ͸fct_inorderͱ͍͏ؔ਺ ͕දࣔ͞ΕΔͷͰɺͦͷ··࣮ߦ͢Δɻ

Slide 17

Slide 17 text

17 fct_inorderؔ਺͸σʔλλΠϓΛFactorʹม͑ͯɺݩͷσʔλॱΛ΋ͱʹΧς ΰϦʔͷ஋ʹॱংΛ͚ͭΔ͜ͱ͕Ͱ͖Δɻ fct_inorder(ࢯ໊) ࢯ໊ Ϩϕϧ ҏ౻തจ 1 ࠇాਗ਼ོ 2 ࢁ០༗๎ 3 দํਖ਼ٛ 4 ࢯ໊ ҏ౻തจ ࠇాਗ਼ོ ࢁ០༗๎ দํਖ਼ٛ

Slide 18

Slide 18 text

αϚϦϏϡʔʹҠಈ͢ΔͱɺݩͷσʔλͷฒͼॱͰࢯ໊ͷϨϕϧ͕ઃఆ͞Εͯ Δ͜ͱ͕Θ͔Δɻ 18

Slide 19

Slide 19 text

19 όʔνϟʔτʹ໭ΓɺνϟʔτͷϐϯΛεςοϓ2ʹ͚ͭΔɻ

Slide 20

Slide 20 text

20 ब೚ॱʹ૯ཧେਉͷࡏ৬೔਺ͷ߹ܭ஋ΛՄࢹԽ͢Δ͜ͱ͕Ͱ͖ͨɻ

Slide 21

Slide 21 text

࣍ճηϛφʔ

Slide 22

Slide 22 text

EXPLORATORY ΦϯϥΠϯɾηϛφʔ #47 ϑΟϧλʔͷ঺հ

Slide 23

Slide 23 text

No content

Slide 24

Slide 24 text

Slide 25

Slide 25 text

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

Slide 26

Slide 26 text

4݄ΦϯϥΠϯ։࠵ʂ ೔ఔɿ4݄13೔(Ր), 14೔(ਫ), 15೔(໦)

Slide 27

Slide 27 text

No content

Slide 28

Slide 28 text

σʔλϥϯάϦϯάɾτϨʔχϯά 5݄։࠵ʂ EXPLORATORY

Slide 29

Slide 29 text

5݄ΦϯϥΠϯ։࠵ʂ ೔ఔ: 5݄13೔(໦),14೔(ۚ) ૣظׂҾɿ3݄31೔(ਫ) ·Ͱ

Slide 30

Slide 30 text

No content

Slide 31

Slide 31 text

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

Slide 1

Slide 1 text

Slide 2

Slide 2 text

Slide 3

Slide 3 text

Slide 4

Slide 4 text

Slide 5

Slide 5 text

Slide 6

Slide 6 text

Slide 7

Slide 7 text

Slide 8

Slide 8 text

Slide 9

Slide 9 text

Slide 10

Slide 10 text

Slide 11

Slide 11 text

Slide 12

Slide 12 text

Slide 13

Slide 13 text

Slide 14

Slide 14 text

Slide 15

Slide 15 text

Slide 16

Slide 16 text

Slide 17

Slide 17 text

Slide 18

Slide 18 text

Slide 19

Slide 19 text

Slide 20

Slide 20 text

Slide 21

Slide 21 text

Slide 22

Slide 22 text

Slide 23

Slide 23 text

Slide 24

Slide 24 text

Slide 25

Slide 25 text

Slide 26

Slide 26 text

Slide 27

Slide 27 text

Slide 28

Slide 28 text

Slide 29

Slide 29 text

Slide 30

Slide 30 text

Slide 31

Slide 31 text

Slide 32

Slide 32 text

Slide 33

Slide 33 text