ifelseの使い方

Exploratoryでのifelse関数の使い方を紹介しています。

Transcript

1. EXPLORATORY 1
3. 3 εϐʔΧʔ ଜཬҮ࠸ EXPLORATORY ུྺ HP(Hewlett Packard)Ͱ100ਓΛ௒͑ΔӦۀνʔϜΛ཰͍ɺ eCommerceɺςϨηʔϧεɺϑΟʔϧυηʔϧεͳͲଟذʹΘͨΔϏ δωεͷϚωδϝϯτɺϓϥϯχϯάΛܦݧɻࣾ಺֎Ͱ஝ੵ͞Εͨ๲ େͳσʔλΛ׆༻ͯ͠ϏδωεΛ੒௕ͤ͞ΔͨΊʹ͸σʔλαΠΤϯ εʹཪଧͪ͞Εͨҙࢥܾఆ͕ॏཁͩͱ਎Λ࣋ͬͯ஌Δɻݱࡏ͸ Exploratory, incͰϏδωε։ൃʹ౒ΊΔ͔ͨΘΒσʔλαΠΤϯεษ ڧձͳͲͷ৔Λ௨ͯ͠ɺص্ͷۭ࿦Ͱ͸ऴΘΒͳ͍ຊ౰ͷҙຯͰ׆༻ Ͱ͖ΔσʔλαΠΤϯεͷීٴʹऔΓ૊Ή
4. ࠓिͷؾʹͳΔ࣭໰ 1. ͋Δ৚݅ʹϚον͍ͯ͠Δ͔Ͳ͏͔Ͱάϧʔϓ෼͚͍ͨ͠ʢifelseʣ 2. ෳ਺ͷ৚݅ʹϚον͍ͯ͠Δ͔Ͳ͏͔Ͱάϧʔϓ෼͚͍ͨ͠ʢifelseʣ
5. ͋Δ৚݅ʹϚον͍ͯ͠Δ͔Ͳ͏ ͔Ͱάϧʔϓ෼͚͍ͨ͠ʢifelseʣ
6. ച্͕1,000υϧҎ্͔Ͳ͏͔
10. ࿦ཧԋࢉࢠ ԋࢉࢠ ҙຯ ྫ == ʹ౳͍͠ customer == “A” != ʹ౳͘͠ͳ͍ customer != “A” > ΑΓେ͖͍ sales > 35 >= Ҏ্ sales >= 35 < ΑΓখ͍͞ sales < 35 <= ҎԼ sales <= 35 %in% ؚΉʢͲΕ͔ʹ౳͍͠ʣ country %in% c(“China”, “Japan”) %nin% ؚ·ͳ͍ʢͲΕʹ΋౳͘͠ͳ͍ʣ country %nin% c(“China”, “Japan”) 10
11. ෳ਺ͷ৚݅ʹϚον͍ͯ͠Δ͔Ͳ͏ ͔Ͱάϧʔϓ෼͚͍ͨ͠ʢifelseʣ
12. ̍ͭͷ৚݅ʹϚον
13. sales ≧ 1,000 ̍ͭͷ৚݅ʹϚον
14. sales ≧ 1,000 & profit ≧ 100 ෳ਺ͷ৚݅ʹϚονʢandʣ
15. 15 customer ID sales profit sales͕1000Ҏ্ profit͕10Ҏ্ sales͕1000Ҏ্͔ͭ profit͕10Ҏ্ AA-10315102 544.7 17 FALSE TRUE FALSE AA-10315120 2713.4 1 TRUE FALSE FALSE AA-10315139 2955.8 32 TRUE TRUE TRUE AA-103151402 4780.6 41 TRUE TRUE TRUE AA-103151404 753.5 2 FALSE FALSE FALSE AA-1031545 368.3 5 FALSE FALSE FALSE AA-1031548 68.1 1 FALSE FALSE FALSE AA-1031558 545.4 24 FALSE TRUE FALSE ෳ਺ͷ৚݅ʹϚονʢandʣ
16. sales ≧ 1,000 | profit ≧ 100 ෳ਺ͷ৚݅ʹϚονʢorʣ
17. 17 customer ID sales profit sales͕1000Ҏ্ profit͕10Ҏ্ sales͕1000Ҏ্΋͘͠͸ profit͕10Ҏ্ AA-10315102 544.7 17 FALSE TRUE TRUE AA-10315120 2713.4 1 TRUE FALSE TRUE AA-10315139 2955.8 32 TRUE TRUE TRUE AA-103151402 4780.6 41 TRUE TRUE TRUE AA-103151404 753.5 2 FALSE FALSE FALSE AA-1031545 368.3 5 FALSE FALSE FALSE AA-1031548 68.1 1 FALSE FALSE FALSE AA-1031558 545.4 24 FALSE TRUE TRUE ෳ਺ͷ৚݅ʹϚονʢorʣ
18. A and B sales > 1000 & profit >10 A or B sales > 1000 | profit >10 ·ͱΊ
19. Q&A
20. Contact Email takato@exploratory.io Twitter Hashtag #ExploratoryHour ͰπΠʔτʂ Twitter @ExploratoryJp Exploratory Hour https://bit.ly/30odd9q