PyLadies Tokyo Meetup #41 | SQLユーザのためのpandas入門 第2部

98df8bb11748bb59fef1aa1e474e8e02?s=47 komo_fr
May 26, 2019
Education
1
240

PyLadies Tokyo Meetup #41 | SQLユーザのためのpandas入門 第2部

repository: https://github.com/komo-fr/pyladiestokyo_41_pandas
event page: https://pyladies-tokyo.connpass.com/event/129156/
Twitter: https://twitter.com/komo_fr

98df8bb11748bb59fef1aa1e474e8e02?s=128

komo_fr

May 26, 2019
Tweet

More Decks by komo_fr

See All by komo_fr
98df8bb11748bb59fef1aa1e474e8e02?s=48 komofr
14
6.3k
98df8bb11748bb59fef1aa1e474e8e02?s=48 komofr
0
920
98df8bb11748bb59fef1aa1e474e8e02?s=48 komofr
1
150
98df8bb11748bb59fef1aa1e474e8e02?s=48 komofr
15
5.8k
98df8bb11748bb59fef1aa1e474e8e02?s=48 komofr
2
370
98df8bb11748bb59fef1aa1e474e8e02?s=48 komofr
4
1.3k
98df8bb11748bb59fef1aa1e474e8e02?s=48 komofr
3
1.6k
98df8bb11748bb59fef1aa1e474e8e02?s=48 komofr
1
300
98df8bb11748bb59fef1aa1e474e8e02?s=48 komofr
1
330

Other Decks in Education

See All in Education
49152f9ea4577167477f76489a4bbbf3?s=48 asial_edu
0
110
1135dc242dcff3b90ae46fc586ff4da8?s=48 signer
0
370
Cf47cf3c3e0f037f899088df041e2cca?s=48 dpc
0
180
B9ade6772136154da028ffd0a006eb8f?s=48 antoinephi
0
130
1e708b2afb8622d5c5f070a94a3425a9?s=48 tibbelit
0
180
944a10f2c7ba844b2bfc7b7f624b204c?s=48 lwug
0
110
4615930de72ec08f99d3227761ace0d8?s=48 yenlung
0
190
C0f0968555a1e046963baa6b5e74e3c9?s=48 salvemaria
0
100
18cdb6f294c8cb10a46167e462c2a51f?s=48 matleenalaakso
1
350
703f52adaba29aff9877b03b98d431a6?s=48 koeri
0
960
000b0a3c74c92548328535cc67a57bfb?s=48 expertlanguage
0
130
981993425604cfde7590e4fdb3ce80e9?s=48 manoj036
0
1.2k

Featured

See All Featured
5b6a2bd86ef643786a381a212e0ef2f1?s=48 geoffreycrofte
11
280
6bb82b13cda86d3b821fa44100335ddf?s=48 thoeni
3
340
Dad095ea7038f89f760419ce475d5d14?s=48 michaelherold
224
8.3k
24fc194843a71f10949be18d5a692682?s=48 gr2m
82
11k
D47656e20ff5e42f125fc5ea0fd636c6?s=48 tmm1
61
7.4k
9128d500301ae51524e887bb680f471d?s=48 caitiem20
304
16k
433acaea1012b25d97ae66da9b998dad?s=48 malarkey
190
8.2k
016edace78ffe826f2348d1e0c504afd?s=48 maggiecrowley
5
260
C35e01544a0dd94a2cf1619ee8a42ebb?s=48 clairelew
10
1.2k
Ae14cc4491ac334f9cd23f9f93b4305e?s=48 orderedlist
PRO
326
35k
C0390e8b11079f8761c0cd3274ed61cb?s=48 productmarketing
5
510
39488f9d172ab92fd352f2cd7b73258d?s=48 mza
80
3.9k

Transcript

  1. 42-ϢʔβʔͷͨΊͷ QBOEBTೖ໳ ୈ෦ελΠϧɾՄࢹԽ %BUF &WFOU1Z-BEJFT5PLZP.FFUVQ
  IUUQTQZMBEJFTUPLZPDPOOQBTTDPNFWFOU  4QFBLFS!LPNP@GS 5PNPLP'VSVLJ

  2. w ୈ෦Ͱ͸ɺσʔλՃ޻ʢ42-Ά͍ૢ࡞ʣΛத৺ʹ࿩͠·ͨ͠ w ୈ෦Ͱ͸ɺQBOEBTʹΑͬͯσʔλΛࢹ֮తʹදݱ͢Δํ๏ʹ ͍ͭͯ঺հ͠·͢ w 4UZMJOH w 7JTVBMJ[BUJPO !2

    ୈ෦ͷ಺༰

  3. w QBOEBTͷ4FSJFT%BUB'SBNFʹ৚݅෇͖ॻࣜΛద༻͢Δػೳ w FH ෛͷ஋͸੺ࣈʹ͢Δɺ֤ߦͷ࠷େ஋ͷഎܠ৭Λม͑Δ w ελΠϧઃఆʹ͸$44Λ࢖͏ !3 4UZMJOH 4UZMJOHcQBOEBT6TFS(VJEF

    IUUQTQBOEBTQZEBUBPSHQBOEBTEPDTTUBCMFVTFS@HVJEFTUZMFIUNM

  4. w ؆୯ͳάϥϑΛඳը͢Δػೳ w ಺෦తʹ͸NBUQMPUMJCΛ࢖͍ͬͯΔ w NBUQMPUMJCՄࢹԽͷ1ZUIPOύοέʔδɻఆ൪͕ͩهड़͕ͪΐͬ ͱ໘౗ͳͷͰɺϥούʔ͕৭ʑ͋Δɻ !4 7JTVBMJ[BUJPO QBOEBTQMPU

    7JTVBMJ[BUJPOcQBOEBT6TFS(VJEF IUUQTQBOEBTQZEBUBPSHQBOEBTEPDTTUBCMFVTFS@HVJEFWJTVBMJ[BUJPOIUNM

  5. w σʔλಡࠐ‎σʔλલॲཧ‎ՄࢹԽ·ͰͷྲྀΕΛ
 Ұ؏ͯͭ͠ͷύοέʔδͰ׬݁Ͱ͖ΔͷͰخ͍͠ w ͱ͸͍͑ɺࡉ͔͍͜ͱ΍Ζ͏ͱ͢Δͱ݁ہଞͷύοέʔδʢNBUQMPUMJCͳͲʣʹ
 खΛ৳͹ͨ͠Γ͸͠·͢ʢݸਓతҙݟʣ !5 QBOEBTͰՄࢹԽ͢ΔͱԿ͕خ͍͠ͷʁ ΍Γ͍ͨ͜ͱ 8IBU

    ʹ߹Θͤͯ ޲͍͍ͯΔಓ۩ )PX ΛબͿ΂͖͚ͩͲ ͪΐͬͱͨ͜͠ͱͳΒ ͭͷಓ۩Ͱ׬݁ͨ͠ํָ͕ΑͶ

  6. !6 QBOEBT6TFS(VJEFͱࠓճͷߨ࠲ͷରԠ /P ߲໨ ࠓճ  *05PPMT 5FYU $47 )%'

    ʜ  *OEFYJOHBOE4FMFDUJOH%BUB  .VMUJ*OEFY"EWBODFE*OEFYJOH  .FSHF KPJO BOEDPODBUFOBUF  3FTIBQJOHBOE1JWPU5BCMFT  8PSLJOHXJUI5FYU%BUB  8PSLJOHXJUINJTTJOHEBUB  $BUFHPSJDBM%BUB  /VMMBCMF*OUFHFS%BUB5ZQF  7JTVBMJ[BUJPO ˔ /P ߲໨ ࠓճ  $PNQVUBUJPOBMUPPMT  (SPVQ#ZTQMJUBQQMZDPNCJOF  5JNF4FSJFT%BUFGVODUJPOBMJUZ  5JNF%FMUBT  4UZMJOH ˔  0QUJPOTBOE4FUUJOHT  &OIBODJOH1FSGPSNBODF  4QBSTFEBUBTUSVDUVSFT  'SFRVFOUMZ"TLFE2VFTUJPOT '"2  $PPLCPPL ˔ୈ෦ͰϝΠϯͰѻͬͨষɹ˓ୈ෦Ͱิॿతʹ৮Εͨষ

  7. w IUUQTHJUIVCDPNLPNPGSQZMBEJFTUPLZP@@QBOEBT !7 /PUFCPPLͷ৔ॴ

  8. w QBOEBTͷެࣜυΩϡϝϯτ w 6TFS(VJEFIUUQTQBOEBTQZEBUBPSHQBOEBTEPDT TUBCMFVTFS@HVJEFJOEFYIUNM !8 ݸਓతͳ͓͢͢Ίࢿྉ

  9. w ೖ໳ऀ޲͚ w QBOEBT NBUQMPUMJCͷجຊత ͳ࢖͍ํΛ+VQZUFSΛಈ͔͠ͳ ͕Β஌Γ͍ͨਓ޲͚ w CPLFI͸Ұ෦৘ใ͕ݹ͘ͳͬ ͍ͯΔ͕ɺ࢖͑Δ෦෼͸͋Δ

    w QBOEBTΛ࣮ࡍʹ࢖͏৔໘͸ɺ QBOEBTҎ֎ͷπʔϧͷ஌ࣝ΋ ඞཁʹͳΔ͜ͱ͕͋ΔͷͰɺ पล஌ࣝΛ·Δͬͱ೺ѲͰ͖ Δͷ͕ྑ͍ !9 ຊͰֶͼ͍ͨਓ޲͚  IUUQTBN[OUP[F$+"O

  10. w QBOEBTͷ։ൃऀࣗ਎ʹΑΔຊ w ෼ް͍ w QBOEBTଞɺOVNQZ΍NBUQMPUMJC ͷجຊΛ͔ͬ͠Γֶͼ͍͕ͨӳޠ ͷެࣜυΩϡϝϯτಡΉͷ͸͖ͭ ͍ɺͱ͍͏ਓ޲͚ ݸਓతҙݟ

     w ୈ൛ͱୈ൛͕͋ΔͷͰ஫ҙ w ࢲ͸Α͘ϦϑΝϨϯε͕ΘΓʹख ݩʹஔ͍ͯ࢖͍ͬͯͨʢ౰࣌ୈ ൛ʣ !10 ຊͰֶͼ͍ͨਓ޲͚  IUUQTBN[OUPXOO:2

  11. w QBOEBT͸ػೳ͕ଟ͍ɻ৭ʑͰ͖Δɻ w ͦͷͨΊɺʮશͯΛຬวͳͪ͘ΌΜͱ׬ᘳʹ஌Ζ͏ͱ͢Δʯͷ͸ ೉͍͠ w ޿͘ઙ͘ʮ͜͏͍͏͜ͱ͕Ͱ͖ΔͷͶʙʯͬͯ೺Ѳͨ͠ޙɺ͋ͱ ͸ඞཁʹԠͯ͡ௐ΂Δͷ͕͓͢͢Ί w ࢲ

    !LPNP@GS ͸ͬ͘͟Γ೺Ѳͨ͠ޙ͸ɺϦϑΝϨϯεΛͻ͖ͳ ͕Βటष͘खΛಈ͔͠ͳ͕Β֮͑·ͨ͠ !11 ݸਓతͳ͓͢͢Ί

  12. (PPEZPVSQBOEBTMJGF