Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
urban data challenge with dash
Search
Hide Ogawa
February 15, 2019
0
810
urban data challenge with dash
はんなりPythonの会#14
Hide Ogawa
February 15, 2019
Tweet
Share
More Decks by Hide Ogawa
See All by Hide Ogawa
生成AIの振り返りと妄想
hideyuki_ogawa
0
81
Digital TransformationをPythonを使って進めよう!
hideyuki_ogawa
1
160
国勢調査で実践する初心者のためのPythonデータ分析ハンズオンセミナー資料
hideyuki_ogawa
0
74
pykansai
hideyuki_ogawa
0
43
Python Kansai HannariPython
hideyuki_ogawa
0
67
Python Kansai Kick off
hideyuki_ogawa
1
59
izumisano hackathon
hideyuki_ogawa
0
39
Blockchain Getting Started
hideyuki_ogawa
0
110
Python Kyoto Dash Returns
hideyuki_ogawa
0
74
Featured
See All Featured
Dealing with People You Can't Stand - Big Design 2015
cassininazir
355
22k
実際に使うSQLの書き方 徹底解説 / pgcon21j-tutorial
soudai
111
35k
Creatively Recalculating Your Daily Design Routine
revolveconf
209
11k
Happy Clients
brianwarren
91
6.3k
How to name files
jennybc
62
92k
The Success of Rails: Ensuring Growth for the Next 100 Years
eileencodes
28
5.9k
10 Git Anti Patterns You Should be Aware of
lemiorhan
644
57k
StorybookのUI Testing Handbookを読んだ
zakiyama
10
4.5k
Keith and Marios Guide to Fast Websites
keithpitt
407
22k
The MySQL Ecosystem @ GitHub 2015
samlambert
242
12k
Debugging Ruby Performance
tmm1
68
11k
Web development in the modern age
philhawksworth
201
10k
Transcript
ඈࣖ ඈࣖ Urban Data Challenge with Dash Chomoku Hideyuki Ogawa
(@ogawahideyuki)
ඈࣖ ඈࣖ ࣗݾհ খɹӳ !PHBXBIJEFZVLJ ߹ಉձࣾܦӦ ۚ༥ɺσʔλɺϒϩοΫνΣʔϯͷձࣾͰ͢ ΜͳΓ1ZUIPOɺ#MPDLDIBJO0TBLBΦʔΨφΠβʔ ࢲࣗʮԿࣄશྗͰʂʯΛϞοτʔʹ
ඈࣖ ඈࣖ %BTIͱʁ 1ZUIPOͷՄࢹԽϑϨʔϜϫʔΫ1MPUMZͱ 'MBTLɺ3FBDUΛͨ͠ͷɻΣϒΞϓϦέʔγϣϯʹͰ͖Δɻ IUUQTEBTIQMPUMZ 1MPUMZࣗମ͕͔ͳΓΠϯλϥΫςΟϒʹಈ͘ͷʹՃ͑ɺ ཁૉͷબͳͲ͕πʔϧίʔϧόοΫͱ͍͏ػೳΛͬͯ ඳ͚ΔͷͰσʔλΛ͍Ζ͍Ζͳ͔֯ΒݟΒΕΔʂ ͋ͱ͍Ζ͍Ζͳਓͱڞ༗ͯ͠
৭ʑҙݟΛͿ͚ͭ߹͏ͱ͔ੌ͘ྑ͍ͱࢥ͏ɻ ͪΐͬͱ͚ͩίʔυΛݟͯΈ·͠ΐ͏ɻ
ඈࣖ ඈࣖ ΞʔόϯσʔλνϟϨϯδͱʁ IUUQVSCBOEBUBDIBMMFOHFKQBCPVU Ҭ՝ͷղܾΛతͱ࣏ͨࣗ͠ମΛத৺ͱ͢Δ ެڞσʔλͷ׆༻ͨؒ͠ͷΠϕϯτ։࠵Λ͏ ҰൠࢀՃܕίϯςετ ·͊ૣ͍͕ɺσʔλΛѻ͏͖ۚͷ ίϯςετ͕͋Δͬͯ͜ͱͳ
ඈࣖ ඈࣖ σʔλݩʑ͖͠ɺۚग़ΔΈ͍ͨ͠ɺ %BTI͓͡͞Μͱͯ͠ͷҐΛ֫ಘ͢ΔͨΊʹग़Δ͔ʂ ୈҰಈػ ୈೋಈػ ۚ༥ͷੈքͰΦϧλφςΟϒσʔλͬͯΔ͠ ͓͍ͬͯͨΒ͍Ζ͍ΖʹཱͭͰʂ ్த͔Βͷಈػ ຊͷ౷ܭ͍͠ɺσʔλΛͬͯ
༧ࢉ͕ճ͞ΕΔΑ͏ʹ͠ͳ͍ͱɺϗϯϚຊͳΔͰʂʂ Ϟνϕʔγϣϯ
ඈࣖ ඈࣖ ·͊ͳΜ͔ͦΜͳงғؾ͋Γ·͚ͨ͠ͲͶ͐ʙ ͔Μ͍ͷෆنଇൃݴ݄ IUUQUBNFJLFOFUEJBSZKBOIUN ͜Ε͑ΔσʔλΛ୳ͯ͠׆༻Ͱ͖Δͱࣔ͞ͳ͍ͱ σʔλͳ͘ͳΔ͔͠ΕΜʂʂʂ
ඈࣖ ඈࣖ ͱ͍͏Θ͚Ͱɺ େࡕͷަ௨σʔλͷมԽΛͪΐΖͬͱݟΑ͏ͱ͍͚ͯͨ͠Ͳɺ ॴಘͱ͔৭ʑͳσʔλΛՄࢹԽͯ͠Έ·ͨ͠ɻ IUUQTPTBLBUBLPZBLJIFSPLVBQQDPN ༧֎ͩͬͨ͜ͱ େࡕࢢͷΦʔϓϯσʔλͷαΠτ͕࡞࡞தʹ ͑ͳ͔ͬͨɾɾɾ ͏Ұͭژͷ॓ധॴͷՄࢹԽ
͜Εલ͔Β࡞͍ͬͯͨͷʹͪΐͬͱσʔλΛͨ͠ɻ IUUQTNZEBTILZPUPIFSPLVBQQDPN
ඈࣖ ඈࣖ େมͩͬͨ͜ͱ ΤΫηϧσʔλͰҐͰ୲ऀ͕มΘΔͷ͔ ࡞Γ͕มΘΔͷͰɺϓϩάϥϜ࡞ָ͔ͬͯͤͯ͠͞Β͑ͣɺ ·ͨɺΤΫηϧΛݟͳ͕Βௐ͠ͳ͍ͱ͍͚ͳ͔ͬͨ͜ͱɻ ͜Ε·͡Ͱ͍ɻ ࣄྫ େࡕࢢɹࣗಈंอ༗ IUUQXXXDJUZPTBLBMHKQUPTIJLFJLBLVQBHFIUNM
ਖ਼͘Β͍ίϨͷॲཧʹඅͨ͠ɻ ࠷ॳ͜Μͳࣄ͕͋Δͷ͔ͱࢥͬͨɻ ಉ͡σʔλΛҧ͏ߦʹೖΕͯͨΓΞϗ͔ͱࢥͬͨɻ IUUQTHJUIVCDPNNB[BSJNPOPVSCBO@EBUB@DIBMMFOHF@PTBLBCMPCNBTUFS EBUBDBS@BMM@BMMDTW
ඈࣖ ඈࣖ ژͷཱྀؗσʔλͷ࡞Γํ ɾσʔλΤΫηϧɻॅॴͳͲ͕ࡌ͍ͬͯΔ ɾ͔ͬ͜Α͘ਤʹϓϩοτ͍ͨ͠ͳͱࢥͬͨɻ ɾਤʹϓϩοτ͢Δ߹ɺܦͱҢ͕ඞཁͰ͋Δ͜ͱ͕Θ͔ͬͨɻ ɾͳΜ͔άʔάϧ༗ྉͬͯใ͕͋ͬͨͷͰ ϠϑʔͷδΦίʔμʔ"1*Λͬͨ IUUQTEFWFMPQFSZBIPPDPKQXFCBQJNBQPQFOMPDBMQMBUGPSNW HFPDPEFSIUNM
ɾͲ͏શͳҐஔใಘΒΕͳ͍ ʢԿஸ୯Ґʣ͔͔͠͠ͿΓͳ͍Α͏ʹݟ͑Δɻ ɾͦͷͨΊॅॴΛΓͳ͕ΒҐஔσʔλΛಘΔΑ͏ʹͨ͠ɻ
ඈࣖ ඈࣖ ژͷཱྀؗσʔλͷ࡞Γํ ɾ࠷ॳจࣈΓͳ͕Β͕͑ݟ͔ͭΔ·Ͱ͍ͬͯ͏ ࡞ۀΛߦ͍ͨ͘ͳͬͨɻ͔֬࠶ؼؔͬͯͷͰग़དྷΔΜ͡Όͳ͔͚ͬͨͬʁʁ Ͳ͔͜ͰಡΜ͔ͩͳ͊ͱࢥ͕ͬͨɺ ͜ͷຊʹ͋ͬͯ࡞Δ͜ͱ͕Ͱ͖ྑ͔ͬͨɻ ৭ʑ࡞Γ࢝ΊΔͱΞϧΰϦζϜͬͯॏཁͩͳ ͬͯࢥ͑ͨɻ
ඈࣖ ඈࣖ ژͷཱྀؗσʔλͷ࡞Γํ ਤσʔλͷϓϩοτ ͻͱ·ͣNBQCPYͱ͍͏αʔϏεΛ͏Α͏ͳͷͰJE QBTTXPSEͱτʔΫϯΛ࡞Δɻ Ͳ͜ͰώϯτΛಘ͔ͨΕ͕ͨฏ໘ΑΓࣼΊ͔Βݟͨ΄͏͕̏%ͬΆ͘ ख͕͔͔͍ͬͯΔΑ͏ʹݟ͑ΔͷͰͦͷΞΠσΞΛ࠾༻ͨ͠ɻ ͬͨ͜ͱͻͱͭͣͭϒϩάΛ࡞͓ͬͯ͘ͱ
ݟฦͤɺͦͷ࣌ʹߟ͑ͨ͜ͱ͕Θ͔ͬͯྑ͍ɻ IUUQTXXXNB[BSJNPOPOFUFOUSZ PQFOEBUB@WJTVBMJ[BUJPO@XJUI@QMPUMZ
ඈࣖ ඈࣖ ژͷཱྀؗσʔλͷ࡞Γํ ̐ IFSPLVʹ͋͛Δ ࣮͕͜͜%BTIͰҰ൪ϏοΫϦͨ͠Ͱɺ ؆୯ʹΣϒͰશһʹڞ༗Ͱ͖Δͬͯͱ͜Ζ͕ ྑ͍ͱࢥͬͯ·͢ɻʢIFSPLV͕ੌ͍ʁͲͬͪʁͲͬͪੌ͍ʁʣ Γ͔ͨ IUUQTEBTIQMPUMZEFQMPZNFOU
ɾϩʔΧϧͰಈ͘ͷʹJNQPSUPTɺTFSWFSBQQTFSWFSͬͯจݴΛ͢ɻ ɾHJUJHOPSFϑΝΠϧΛ࡞Δɻ ɾ1SPDpMFΛͭ͘Δɻ ɾSFRVJSFNFOUTUYUΛͭ͘Δɻ ɾίϚϯυΛ̑ߦॻ͘ʂ ɾૣ͍ʂ؆୯ʂIFSPLVੌ͍ ɾະͩʹ714ͷ͋͛ํΛ͔͍ͬͯͳ͍
ඈࣖ ඈࣖ ژͷཱྀؗσʔλ׆༻ํ๏Ҋ ॓ധࢪઃͷ૿Ճͱژͷ॓ധऀͷؔ ૿͑࢝Ίͨ·Ͱ͔͠·ͩσʔλ͕ఏڙ͞Ε͓ͯΒͣɾɾ σʔλʹͳ͍ॴ͕ຊʹͳ͍ͷͰ͋Εɾɾ ަ௨खஈͷൃୡ͕ॏཁʹࢥ͏ɻ ೆͷํΛݟͯΈΔͱɺԼమԊઢ॓ധࢪઃ͕ ͋Δ͕ɺԼమ͕௨͍ͬͯͳ͍ೆ۠ͷ΄͏͕ͳ͍ɻ ͦ͏͍͏ҬͬͯΠϯόϯυͷޮՌΛड͚͍ͯͳ͍
ͱߟ͑ΒΕɺͦͷԸܙΛ༩͑ΔΑ͏ͳࡦ͕ඞཁɻ
ඈࣖ ඈࣖ େࡕσʔλ֓؍ ɾͳΜ͔౷ܭࣄ݅͋Γɺ౷ܭσʔλΛͱΓ͋͑ͣ ͨ͘͞Μ٧ΊࠐΉํʹͨ͠ɻ͔͠͠ɺΦʔϓϯσʔλαΠτ͕ ͑ͳ͍ͱ͍͏ΞΫγσϯτɻ ɾσʔλΛݟ͍ͯΔͱ༧ࢉ͕ݮগ͍ͯ͠ΔӨڹ͔ʢόΠΞε͔͔ͬͯΔʁʣ σʔλͷࡉ͔͕͞ͳ͘ͳ͍ͬͯΔͱ࣮ײͰ͖Δσʔλଟ͘ݟΒΕͨɻ ɾͰࢥ͍ͷ֎σʔλଟ͋͘Γɺ ͜ΕͬͯϏδωεΔ্Ͱνϣοτ׆༻͢Δ͚ͩͰ༏Ґʹ
ಇ͘ΜͰͳ͍͔ͱࢥͬͨɻ ɾ࡞ΓํͱΓ͋͑ͣΤΫηϧσʔλΛྑ͘ݟͯʢॏཁʣɺ QBOEBTͰ͜ͶΔʂDTWͩͱߦ͕ͣΕͯΔͱ͔ͳ͍ͷͰྑ͔ͬͨɻ
ඈࣖ ඈࣖ େࡕσʔλ͔Β֞ؒݟ͑ͨ͜ͱ ɾਓޱಈΛݟΔͱɺେࡕࢢશମͰ̎̌Ͱ̐ˋऑਓޱ͕૿͍͑ͯΔɻ ɾ͔͠͠ɺਓޱͷਪҠ۠͝ͱʹόϥόϥɻ ɾҰൠʹΨϥ͕ѱ͍Ҭ͕ݮগʹ͋Γͦ͏͕ͩɺ ࣄ݅ൃੜͷώετϦΧϧͱ͔ݟ͚ͭΒΕͳ͔ͬͨͷͰͳΜͱݴ͑ͳ͍ɻ ɾਓޱݮগҬͰੈଳΛݟΔͱݮ͍ͬͯΔͱ͜Ζগͳ͍ɻ ɾࣗಈंݮ͍ͬͯΔ͚Ͳɺී௨༻ं૿͍͑ͯΔɻ ༻ं͕ݮ͍ͬͯΔɻʢौ࣌ؒܶతʹݮগʣ
ɾόεར༻ͨͩͻͨ͢ΒݮগɻԼమճ෮ɻ ɾࢲమͷར༻ݮগɻ+3ڧ͍ɻ
ඈࣖ ඈࣖ େࡕσʔλͰྔ͕ଟ͘ͳΔͷͰλϒΛͬͯΈͨ ͬͯΈ͚ͨͲɺλϒ͏ͱը໘ͷԼ·ͰݟͨΒ ্͍͍ͪͪ·ͰΒͳ͍ͱ͍͚ͳ͍ͷͰɺ͜Ε͋·Γྑ͘ͳ͍ͷͰɾɾɾ IUUQTEBTIQMPUMZEBTIDPSFDPNQPOFOUTUBCT λϒίʔϧόοΫͰར༻͢Δํ๏ͱλϒͷதʹνϧυϨϯͱͯ͠ ར༻͢Δํ๏ͷ͕̎ͭ͋Δɻ λϒͷதίʔϧόοΫ͢ΔͷͰɺνϧυϨϯͰ࡞Γ·ͨ͠ɻ ίʔυΛॻ͍͍ͯΔײ͡Ͱϖʔδͷ͡Ίʹ
EDD5BC ͱ͚ͭΔ͚ͩͳͷͰɺ͋·Γ໘͞ͳ͍͚Ͳɻ
ඈࣖ ඈࣖ Ͳ͏ݟͤΔ͔ͷ ͱΓ͋͑ͣɺͯ͢ͷҬΛ͍ͬΜʹݟΒΕͨ΄͏͕ Θ͔Γ͍͢Ζͬͯ͜ͱͰશ෦͍ͬΜʹݟͤͨɻ ͔͠͠ɺຌྫ͕શ෦ग़͍ͯͳ͍ɻ ্ݶͱ͔͋Δͷ͔ͳ͊ɾɾɾ ผ݅ͰશࠃͷσʔλʹऔΓΜͰ͍ΔͷͰ͕͢ɺ ͦΕͰ͍͔ͭ͘ΛϐοΫΞοϓͯ͠ՃͰ͖ΔΑ͏ʹ͍ͯ͠Δɻ IUUQTTZPLFOLFJ[BJIFSPLVBQQDPN
ͻͱͭͣͭυϩοϓμϯϝχϡʔͰݟΒΕΔ Α͏ʹ͕ͨ͠ɺબࢶ͕ଟ͍ͱɺͦΕͦΕͰ໘͍͘͞ɻ ߲͕ଟ͍ͱνΣοΫϘοΫε͕ྑ͕͛ͩ͞ɺ ཁૉ͕̎ͭͱ͔ʹͳͬͯޓ͍ʹ߲͕େྔͱ͔ ͳͬͨ߹Ͳ͏͢Δ͔ͱ͔ɾɾɾ
ඈࣖ ඈࣖ εϥΠμʔಈ͔ͳ͍ ΜͳΓ1ZUIPOͷϋϯζΦϯͳΜ͔Ͱ ૽͍Ͱ͍͔ͨ͠Ε·ͤΜ͕ɺωοτʹ্͛ΔͱͳΜ͔ εϥΠμʔ͕ಈ͖·ͤΜʢϩʔΧϧͰಈ͘ʣɻ ͜Ε͋͛ͯͪΐͬͱ͔ͯ͠Βࢥ͍ग़ͨ͠ͷͰ ಈ͔ͳ͍··ͷ࡞ͱͳͬͨʢఏग़͕ΪϦΪϦͰͦͷΊͪΌ͔ͬͨ͠ɾɾɾʣ ίϛϡχςΟʔͰฉ͍ͯΈΔ͖Ͱ͠ΐ͏Ͷ ʢ࣍ճ·Ͱʹɾɾɾʣ
ඈࣖ ඈࣖ ·ͱΊ ɾ1%'දࣔ༻ͷΤΫηϧΛ͑ΔΑ͏ʹ͢Δͷ݁ߏ໘ ɾ͔͠͠ɺ͔ͬ͠Γ͍ͯ͠ΔެతͳػؔͰ͜ΕͩͬͨΒࢲاۀɾɾɾ ɾࠃͷσʔλ͔Γݟ͖͚ͯͨͲࢢொଜ୯ҐͰ৭ʑͳσʔλ͕͋Γͦ͏ ɾࠓճืू̍ϲ݄લͱ͔ʹؾ͍͚ͨͲɺ࣍ճΠϕϯτΛ։࠵ͯ͠ ༧ࢉ̍̌ສԁΒͬͯͳΜ͔େʹͬͯΈ͍ͨʂʂʂ ɾͦΕΛ࣮ͬͯࡍʹϏδωεΛͯ͠Ք͍Ͱ੫ۚऩΊͯ ͦΕͰ౷ܭσʔλΛ֦ॆͯ͠Β͏Έ͍ͨͳϧʔϓΛճͤΔͱ໘ന͍͔ͳͱࢥ͏
ɾσʔλ͕ੌ͑͘Δͬͯͱ͜ΖΛݟ͚ͤͭ·͠ΐ͏ʂ