Exploratory Hour 行を結合する&列の値を分割する

Transcript

1. w ҟͳΔσʔλϑϨʔϜʹ͋ΔߦΛ௥Ճ͢Δ
   w ྻͷ஋Λ෼ׂͯ͠ෳ਺ͷྻΛ࡞Γ͍ͨ Exploratory Hour
2. EXPLORATORY 2
3. 3 εϐʔΧʔ നށ ܟొ Customer Succes EXPLORATORY ུྺ େֶࡏֶதʹϑʔυϩεΛݮΒͨ͢ΊʹɺֶੜஂମΛ্ཱͪ͛୅දΛ ຿ΊΔɻͦͷޙɺϏδωεΛ஌ΔͨΊʹԽֶϝʔΧʔͷσϡϙϯͱ ϑʔυςοΫܥελʔτΞοϓͰӦۀͱϚʔέςΟϯάΛܦݧɻΞϓ Ϧͷ੒௕ͷͨΊʹ͸σʔλαΠΤϯε͕ඞཁͩͱײ͡ɺΞϓϦʹಛԽ ͨ͠Ϣʔβʔͷߦಈ෼ੳπʔϧΛ։ൃ͢ΔاۀʹͯɺΞϓϦۀքͷ KPI෼ੳͳͲΛ୲౰͢Δɻݱࡏ͸Exploratory, Inc. ͰΧελϚʔαΫη εΛ୲౰͢Δ๣ΒɺσʔλͷՄࢹԽͱ୳ࡧతσʔλ෼ੳΛઐ໳ͱͯ͠ σʔλαΠΤϯεͷීٴʹऔΓ૊Ήɻ @ShirotoTakato
5. w ݄ͷσʔλʹ݄ͷσʔλΛߦͱͯ͠௥Ճ͍ͨ͠
   w ྻͷ஋Λ෼ׂͯ͠ෳ਺ͷྻΛ࡞Γ͍ͨ ࠓिͷ࣭໰
6. 7݄ͷσʔλʹ8݄ͷσʔλΛߦͱͯ͠௥ Ճ͍ͨ͠ Question 1
7. Ϛʔδ (Merge)
8. 1. ߦΛ௥Ճ (bind_rows) 2. ࿨ू߹ (union) 3. ੵू߹ (intersect) 4. ࠩू߹ (setdiff) Ϛʔδ (Merge)
9. Name Sales Thomas 15 James 100 Mike 20 Name Sales Mike 20 Paul 95 Susan 30 σʔλϑϨʔϜ1 Ϛʔδ (Merge) σʔλϑϨʔϜ̎
10. σʔλϑϨʔϜ1 Ϛʔδ (Merge) σʔλϑϨʔϜ̎ Name Sales Thomas 15 James 100 Mike 20 Name Sales Mike 20 Paul 95 Susan 30 Mike͕ॏෳ͍ͯ͠Δ
11. 1. ߦΛ௥Ճ (bind_rows) 2. ࿨ू߹ (union) 3. ੵू߹ (intersect) 4. ࠩू߹ (setdiff) Ϛʔδ (Merge)
12. ҟͳΔσʔλϑϨʔϜʹ͋ΔσʔλΛ શͯͷߦ(ॏෳՄ)ͰϚʔδ͢Δɻ ߦΛ௥Ճ/bind_rows
13. ߦΛ௥Ճ/bind_rows(શͯͷߦΛ݁߹) Name Sales Thomas 15 James 100 Mike 20 Name Sales Mike 20 Paul 95 Susan 30 σʔλϑϨʔϜ1 σʔλϑϨʔϜ̎ Name Sales Thomas 15 James 100 Mike 20 Mike 20 Paul 95 Susan 30 Mike͸ॏෳ͍ͯ͠Δ͕ɺbind_rows Ͱ͸શͯͷߦ͕௥Ճ͞ΕΔ
14. 1. ߦΛ௥Ճ (bind_rows) 2. ࿨ू߹ (union) 3. ੵू߹ (intersect) 4. ࠩू߹ (setdiff) Ϛʔδ (Merge)
15. ࿨ू߹/Union ҟͳΔσʔλϑϨʔϜʹ͋ΔσʔλΛ ॏෳແ͠ͰϚʔδ͢Δɻ
16. Name Sales Thomas 15 James 100 Mike 20 ࿨ू߹/union(Ұҙͷߦ͚ͩΛ݁߹) Name Sales Thomas 15 James 100 Mike 20 Name Sales Mike 20 Paul 95 Susan 30 σʔλϑϨʔϜ1 σʔλϑϨʔϜ̎ Mike͕ॏෳ͍ͯ͠ΔͨΊɺunionͰ ͸Ϛʔδઌͷॏෳ෼Λআ֎͢Δɻ Paul 95 Susan 30
17. 1. ߦΛ௥Ճ (bind_rows) 2. ࿨ू߹ (union) 3. ੵू߹ (intersect) 4. ࠩू߹ (setdiff) Ϛʔδ (Merge)
18. ੵू߹/intersect ҟͳΔσʔλϑϨʔϜʹ͋ΔσʔλΛ ڞ௨͢Δ෦෼͚ͩϚʔδ͢Δɻ
19. ੵू߹/intersect(ڞ௨͢ΔߦͷΈநग़) Name Sales Thomas 15 James 100 Mike 20 Name Sales Mike 20 Paul 95 Susan 30 σʔλϑϨʔϜ1 σʔλϑϨʔϜ̎ Name Sales Mike 20 Mike 20 Mike͕ॏෳ͍ͯ͠ΔͨΊɺ intersectͰMikeͷΈ͕࢒Δɻ
20. 1. ߦΛ௥Ճ (bind_rows) 2. ࿨ू߹ (union) 3. ੵू߹ (intersect) 4. ࠩू߹ (setdiff) Ϛʔδ (Merge)
21. ࠩू߹/Setdiff ҟͳΔσʔλϑϨʔϜʹ͋ΔσʔλΛ ڞ௨͠ͳ͍෦෼͚ͩϚʔδ͢Δɻ
22. Name Sales Thomas 15 James 100 ࠩू߹/setfdiff(ڞ௨͠ͳ͍ߦͷΈநग़) Name Sales Thomas 15 James 100 Mike 20 Name Sales Mike 20 Paul 95 Susan 30 σʔλϑϨʔϜ1 σʔλϑϨʔϜ̎ Mike͕ॏෳ͍ͯ͠ΔͨΊɺsetdiff Ͱ͸Mike͸আ֎͞ΕΔɻ Paul 95 Susan 30
23. Ϛʔδ/ߦ݁߹ • σʔλϑϨʔϜ໊Λอ࣋͢Δ(શͯͷߦΛ݁߹ͷΈ) • σʔλɾλΠϓΛڧ੍తʹἧ͑Δ
24. ྻͷ஋Λ෼ׂͯ͠ෳ਺ͷྻΛ࡞Γ͍ͨ Question 2
25. ෼ׂ εϖʔε۠੾Γ
26. ෼ׂ ίϯϚ(,)۠੾Γ
27. Q&A
28. Contact Email takato@exploratory.io Twitter Hashtag #ExploratoryHour ͰπΠʔτʂ Twitter @ExploratoryJp Exploratory Hour https://bit.ly/30odd9q