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

Transcript

1. 42-ϢʔβʔͷͨΊͷ
   QBOEBTೖ໳ ୈ෦
   ελΠϧɾՄࢹԽ %BUF
   
   &WFOU
   1Z-BEJFT
   5PLZP
   .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 4UZMJOH
   c
   QBOEBT
   6TFS
   (VJEF
   

   IUUQTQBOEBTQZEBUBPSHQBOEBTEPDTTUBCMFVTFS@HVJEFTUZMFIUNM

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

   7JTVBMJ[BUJPO
   c
   QBOEBT
   6TFS
   (VJEF
   IUUQTQBOEBTQZEBUBPSHQBOEBTEPDTTUBCMFVTFS@HVJEFWJTVBMJ[BUJPOIUNM

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

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

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

   
   ʜ  *OEFYJOH
   BOE
   4FMFDUJOH
   %BUB  .VMUJ*OEFY
   
   "EWBODFE
   *OEFYJOH  .FSHF
   KPJO
   BOE
   DPODBUFOBUF  3FTIBQJOH
   BOE
   1JWPU
   5BCMFT  8PSLJOH
   XJUI
   5FYU
   %BUB  8PSLJOH
   XJUI
   NJTTJOH
   EBUB  $BUFHPSJDBM
   %BUB  /VMMBCMF
   *OUFHFS
   %BUB
   5ZQF  7JTVBMJ[BUJPO ˔ /P ߲໨ ࠓճ  $PNQVUBUJPOBM
   UPPMT  (SPVQ
   #Z
   TQMJUBQQMZDPNCJOF  5JNF
   4FSJFT
   
   %BUF
   GVODUJPOBMJUZ  5JNF
   %FMUBT  4UZMJOH ˔  0QUJPOT
   BOE
   4FUUJOHT  &OIBODJOH
   1FSGPSNBODF  4QBSTF
   EBUB
   TUSVDUVSFT  'SFRVFOUMZ
   "TLFE
   2VFTUJPOT
   '"2  $PPLCPPL ˔
   ୈ෦ͰϝΠϯͰѻͬͨষɹ˓
   ୈ෦Ͱิॿతʹ৮Εͨষ

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

8. w QBOEBTͷެࣜυΩϡϝϯτ
   w 6TFS
   (VJEF
   IUUQTQBOEBTQZEBUBPSHQBOEBTEPDT 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. (PPE
    ZPVS
    QBOEBT
    MJGF