Upgrade to Pro — share decks privately, control downloads, hide ads and more …

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

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

komo_fr

May 26, 2019
Tweet

More Decks by komo_fr

Other Decks in Education

Transcript

  1. 42-ϢʔβʔͷͨΊͷ
    QBOEBTೖ໳
    ୈ෦ελΠϧɾՄࢹԽ
    %BUF
    &WFOU1Z-BEJFT5PLZP.FFUVQ

    IUUQTQZMBEJFTUPLZPDPOOQBTTDPNFWFOU

    4QFBLFS!LPNP@GS 5PNPLP'VSVLJ

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    7JTVBMJ[BUJPOcQBOEBT6TFS(VJEF
    IUUQTQBOEBTQZEBUBPSHQBOEBTEPDTTUBCMFVTFS@HVJEFWJTVBMJ[BUJPOIUNM

    View full-size slide

  5. w σʔλಡࠐ‎σʔλલॲཧ‎ՄࢹԽ·ͰͷྲྀΕΛ

    Ұ؏ͯͭ͠ͷύοέʔδͰ׬݁Ͱ͖ΔͷͰخ͍͠
    w ͱ͸͍͑ɺࡉ͔͍͜ͱ΍Ζ͏ͱ͢Δͱ݁ہଞͷύοέʔδʢNBUQMPUMJCͳͲʣʹ

    खΛ৳͹ͨ͠Γ͸͠·͢ʢݸਓతҙݟʣ
    !5
    QBOEBTͰՄࢹԽ͢ΔͱԿ͕خ͍͠ͷʁ
    ΍Γ͍ͨ͜ͱ 8IBU
    ʹ߹Θͤͯ
    ޲͍͍ͯΔಓ۩ )PX
    ΛબͿ΂͖͚ͩͲ
    ͪΐͬͱͨ͜͠ͱͳΒ
    ͭͷಓ۩Ͱ׬݁ͨ͠ํָ͕ΑͶ

    View full-size slide

  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
    ˔ୈ෦ͰϝΠϯͰѻͬͨষɹ˓ୈ෦Ͱิॿతʹ৮Εͨষ

    View full-size slide

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

    View full-size slide

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

    View full-size slide

  9. w ೖ໳ऀ޲͚
    w QBOEBT NBUQMPUMJCͷجຊత
    ͳ࢖͍ํΛ+VQZUFSΛಈ͔͠ͳ
    ͕Β஌Γ͍ͨਓ޲͚
    w CPLFI͸Ұ෦৘ใ͕ݹ͘ͳͬ
    ͍ͯΔ͕ɺ࢖͑Δ෦෼͸͋Δ
    w QBOEBTΛ࣮ࡍʹ࢖͏৔໘͸ɺ
    QBOEBTҎ֎ͷπʔϧͷ஌ࣝ΋
    ඞཁʹͳΔ͜ͱ͕͋ΔͷͰɺ
    पล஌ࣝΛ·Δͬͱ೺ѲͰ͖
    Δͷ͕ྑ͍
    !9
    ຊͰֶͼ͍ͨਓ޲͚

    IUUQTBN[OUP[F$+"O

    View full-size slide

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

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

    IUUQTBN[OUPXOO:2

    View full-size slide

  11. w QBOEBT͸ػೳ͕ଟ͍ɻ৭ʑͰ͖Δɻ
    w ͦͷͨΊɺʮશͯΛຬวͳͪ͘ΌΜͱ׬ᘳʹ஌Ζ͏ͱ͢Δʯͷ͸
    ೉͍͠
    w ޿͘ઙ͘ʮ͜͏͍͏͜ͱ͕Ͱ͖ΔͷͶʙʯͬͯ೺Ѳͨ͠ޙɺ͋ͱ
    ͸ඞཁʹԠͯ͡ௐ΂Δͷ͕͓͢͢Ί
    w ࢲ !LPNP@GS
    ͸ͬ͘͟Γ೺Ѳͨ͠ޙ͸ɺϦϑΝϨϯεΛͻ͖ͳ
    ͕Βటष͘खΛಈ͔͠ͳ͕Β֮͑·ͨ͠
    !11
    ݸਓతͳ͓͢͢Ί

    View full-size slide

  12. (PPEZPVSQBOEBTMJGF

    View full-size slide