Pro Yearly is on sale from $80 to $50! »

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

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

98df8bb11748bb59fef1aa1e474e8e02?s=128

komo_fr

May 26, 2019
Tweet

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