ããŒã¿åæããã³ãã¹ã§ããã¹ããŒãã«ïŒ
éèããŒã¿ãèªåã®æã§çŽæ¥åæããŠã¿ãŠãã ããã
ExcelããŒã¿åæãäœããæ®å¿µ... ð¯
æ¥ã
ãéèŠã«ãªãããŒã¿åæèœåïŒ
ããã ãå€ãã®æ¹ãããŒã¿åæã«é¢å¿ãå¯ããŠããŸãã
ãšããã§ãExcel(Excel)ã§å€§éã®ããŒã¿ãå å·¥ãåæããŠã¿ãæ¹ãªããäžåºŠããæ©ãã§ã¿ãã¯ãã§ãã
å€ãã®ããŒã¿ãæ±ããšã·ãŒããé
ããªãå§ãã䜿ãåæã®æªã颿°ã®ããã«é ãçããªããŸãããã
ãšã¯ã»ã«ãèŠããä»ã
ãã³ãã¹ã«äŒããšãã
ãã³ãã¹ã¯ããã°ã©ãã³ã°èšèªPythonã䜿ã£ãŠããŸã
ããŒã¿æœåºãå å·¥ãåæãå¯èŠåã«äœ¿ããã
ããŒã¿åæã«ç¹åããã©ã€ãã©ãªã§ãã
ããŒã¿è§£æã«ããã°ã©ãã³ã°ã掻çšãããšããã°é£ããæããããããã«ãªããŸãã
ããããExcelã§ã¯ãªããã³ãã¹ã§ããŒã¿åæãéå§ãããšãã¯ããã«ç°¡åã§äŸ¿å©ã«ããŒã¿ãåæããŠåŠçã§ããŸãã
Excelã®ä»£ããã«ãã³ãã¹ãæžãã¹ã3ã€ã®çç±ïŒ
ãã³ãã¹ã§ç°¡å
éèããŒã¿åæãå§ããŸãããð¡
Pythonã®åºæ¬ææ³ã¯ããããŸããã
éèããŒã¿/æç³»åããŒã¿ãã©ã®ããã«æ±ãã¹ãã
ç¥ããªã人ã®ããã«äœãããŸããã
éèããŒã¿åæã®ããã®ãã³ãã¹ã©ã€ãã©ãªã®äœ¿ãæ¹å
¬éïŒ
ãã®ã¬ãã¹ã³ã§ã¯ãæç³»åããŒã¿ãæ±ãããã«ãã³ãã¹ãã©ã®ããã«äœ¿çšãããã詳ãã説æããŸãããã³ãã¹ã§ããŒã¿ãåŒã³åºããŠã©ã®ããã«åæãè¡ããã玹ä»ããç§ãæ
£ã芪ããã ãã³ãã¹ããã¥ã¢ã«ãäžç·ã«ãå±ãããŸãããŸããå®éã®éèããŒã¿åæã«ããã«è¿ã¥ãããã«ãããŸããŸãªããŒã¿ã§ããŸããŸãªäŸã玹ä»ããŸãã
ãŸããå®éã«ãã³ãã¹ã§éèããŒã¿ãæ±ããªããæããæ§ã
ãªçµéšãè¬çŸ©ã«ãŸãšããŸãããããŒã¿åæãéå§ãããšãå€ãã®æéããããŠæ©ãå¿
èŠãããéšåãé·ãæ©ãããšãªãæž¡ããããã«ãå®éã®ããŒã¿åæã«å¿
èŠãªããŸããŸãªäŸãå«ãŸããŠããŸãã
ä»åã®è¬çŸ©ãéããŠèªåã ãã®ãã³ãã¹ããã¥ã¢ã«ãäœæããéèããŒã¿åæã«ãããŠãšã¯ã»ã«ã§ã¯ãªãPythonã§çããã®æãåãããã«ããããšããã®è¬çŸ©ã®ç®æšã§ããæåã¯ãã³ãã¹ãèŠæ
£ããŠããŠé£ãããããããŸããããè¬çŸ©ããã¹ãŠèãããããã³ãã¹ãããŒã¿åæã®ããã«æ¬åœã«äŸ¿å©ãªããŒã«ã§ãããšããäºå®ãæããããšãã§ããã§ããããçããã®ææŠãå¿æŽããŸãïŒ
ãããªæ¹ã«ããããã§ãâ
- ãã³ãã¹ãåããŠãæ
£ããŠããªãæ¹
- Pythonã§éèããŒã¿ãåæããã人
- éèããŒã¿åæã®ããã®ç¬èªã®ãã³ãã¹ããã¥ã¢ã«ãäœæãããæ¹
誰ã§ãã§ããïŒ
4段éã§åŠã¶æ¬çªãã³ãã¹ã
å¿çšåãé€ãããŒã¿åæ
ãã®è¬çŸ©ã¯ãåã«ãã³ãã¹ãäœã§ãããã説æããã³ãŒãã®ç·Žç¿ã ããããè¬çŸ©ã§ã¯ãããŸããã
åè¬çãããŒã¿åæã«å¿
èŠãªæ¬çªãã³ãã¹ããã¥ã¢ã«ãäœæã§ããããã«è¬çŸ©ãæ§æããŸããã
çŸå®æ§100ïŒ
ïŒäŸäžå¿ã®è¬çŸ©
è¬çŸ©ã®æåããæåŸãŸã§ãå®éã®éèããŒã¿ã䜿ã£ãŠå®ç¿ããŸããå®éã®åæã§çºçããå¯èœæ§ã®ããããŸããŸãªäŸãæåããæåŸãŸã§çŽæ¥èª¬æããŸãã
äžåºŠèŠãŠçµããè¬çŸ©ã¯NoïŒ
Jupyter NoteBookã䜿ã£ãŠãã³ãã¹ããã¥ã¢ã«ãäœæããŸããä»åŸãããŒã¿åæãè¡ããã³ã«è¬çŸ©ã§äœã£ãããã¥ã¢ã«ãåèã«ã§ããããã«ãªããŸãã
ããããã®æ©ã¿ãŸã§èããŸã
ãããŸã§ãã³ãã¹ã䜿çšããªããåå¿è
ãæ··ä¹±ããããç¹ãè¬çŸ©ã§çŽæ¥ããããŸãããããããã³ãã¹ã䜿ãããšã«ãªãçããã®æ©ã¿ãšè©Šè¡é¯èª€ã軜æžããŸãã
é®®ãããªãããžã§ã¯ãã§ã¬ãã«ã¢ããïŒ
åŸåã§ã¯ããããŸã§ã«åŠãã å
å®¹ãæ¬çªãããžã§ã¯ãã§ã©ã®ããã«äœ¿çšãããã玹ä»ããŸããå®éã®éèããŒã¿åæã§ã©ã®ããã«æŽ»çšã§ããããã芧ãã ããã
詳现ãªã«ãªãã¥ã©ã ãäžããçŽæ¥ç¢ºèªã§ããŸãã
è¬çŸ©ãäœã£ã
ç¥èå
±æè
ã®äžèšð€
ããã«ã¡ã¯ïŒ QTã§ãã
ä»äºã§ããããã¯ãžã£ããã¯ã§ç§ã䜿ã£ãŠããç¥èãäŒããããšããæ°æã¡ã§è¬çŸ©ãæ§æããŸããããã¶ãããŒã¿åæãšããã®ãèŠç¥ãã¬ã»ã©é ãæãããããããããŸããããå®ã¯ããã§ã¯ãªãããšãç¥ãããŠäŒããããšæããŸãã
ããŒã¿åæã«ã¯æ£è§£ããªããåãçµæã§ãå人ããšã«äž»åŒµã§ããçµè«ã¯ç°ãªãå ŽåããããŸããç§ã®ç¥èãšçµéšãããªãã®æææ±ºå®ã«åœ¹ç«ã€ããšãã§ããããšæããŸãã
æ°ã«ãªãç¹
ä»ç¢ºèªããŠãã ããïŒ ð¬
Q. Pythonã®åºæ¬ææ³ãç¥ããã«è¬çŸ©ãåè¬ã§ããŸããïŒ
ãã®è¬çŸ©ã¯PythonãæŽ»çšããŠããŒã¿åæãåŠã¶ããã®Pandasè¬çŸ©ã§ãã Pythonã®åºç€ææ³ã¯å¿
ãçç¥ããŠèããªããã°ãªããŸããã listãdictãtupleãforæãªã©ã®åºæ¬çãªPythonææ³ãç¥ã£ãŠãã人ãªã誰ã§ãåè¬ã§ããŸãã
Q. ãã³ãã¹ã®ãã¹ãŠã®æ©èœãåŠç¿ããã®ã§ããïŒ
ãã³ãã¹ã©ã€ãã©ãªã¯ãæ©èœãéåžžã«èšå€§ã§ããããããã³ãã¹ã®ãã¹ãŠãåŠã¶ããšã¯ã§ããŸããããã ããä»åã®è¬çŸ©ã§ã¯éèããŒã¿åæã«çŠç¹ãåœãŠãéèããŒã¿åæã«å¿
èŠãªãã³ãã¹æ©èœãæ±ãããšã«ãªããŸãã
Q. å®éã®éèããŒã¿ã¯ã©ãã§åããããŸããïŒ
è¬çŸ©ã§äœ¿çšãããã³ãŒããšéèããŒã¿ã¯ãè¬çŸ©ã«ãã£ãŠçŽæ¥æäŸãããŸããè¬çŸ©ã®[ãã¬ãã¥ãŒ]ã§ã©ã®ããã«è¬çŸ©ãåè¬ã§ãããåèã«ããŠãã ããïŒ ïŒã»ã¯ã·ã§ã³0 [è¬çŸ©åè¬åã®æ³šæäºé
])
Q. ä»ã®ãã³ãã¹è¬çŸ©ãšã¯ã©ãéããŸããïŒ
éèããŒã¿ã®åæã«çŠç¹ãåœãŠãããšã¯ãä»ã®è¬çŸ©ãšã®å€§ããªå·®å¥ç¹ã§ããå®éã®éèããŒã¿ã䜿ã£ãŠææ¥ããéèããŒã¿ãåæããé çªã§ã«ãªãã¥ã©ã ãæ§æããŸããã
äžç·ã«èããšè¯ã
é¢é£è¬çŸ©ã³ã¬ã¯ã·ã§ã³ð