
ãããã«ã¡ã¯ã深氎è±äžéã§ãã
ãä»åã®ãèè
èæžçŽ¹ä»ãã¯ãITã¹ãã©ããžã¹ãã§æè²ç³»YouTuberãšããŠã掻èºããäŒæ²¢åãããæžãããè¶
éPythonä»äºè¡å€§å
šãã«ã€ããŠã話ããããŸãã
ãèè
ãäŒæ²¢åããããã£ãŒã«ã
ITã¹ãã©ããžã¹ãã»æ
å ±åŠçå®å
šç¢ºä¿æ¯æŽå£«ïŒç»é²çªå· 第022079å·ïŒã»æè²ç³»YouTuber
穎å¹ããžãã¹å°éåŠæ ¡ïŒåºå³¶ççŠå±±åžïŒæåéšå€åãæ
å ±ç³»åŠç§ã§ããã°ã©ãã³ã°ã人工ç¥èœé¢é£ã®ç§ç®ãæ
åœãèæžïŒãããã©ããªäœæ¥ãç§éã§çµããïŒExcel x Pythonèªååã®è¶
åºæ¬ãïŒå®å³¶ç€ŸïŒ2020幎
https://twitter.com/zxb04116
âŒæ¬æ¥ç޹ä»ããŠããã ãèæžâŒ
ãExcelãããŒã¿æŽçïŒåæãç»ååŠçã®èªååã¯ã¶ãå®å
šç¶²çŸ
! è¶
éPythonä»äºè¡å€§å
šãïŒäŒæ²¢åèãå®å³¶ç€ŸïŒ2022幎ã
ââäŒæ²¢ããããä¹
ãã¶ãã§ããååã®èæžã¯PythonïŒãã€ãœã³ïŒã䜿ã£ãŠExcelã®äœæ¥å¹çUPãããããã®æ¬ã§ããããä»åã®èäœã¯ã©ã®ãããªå
容ãªã®ã§ããããïŒ
ãäŒæ²¢ããã
ãä»åãExcelã®èªååã ãã§ã¯ãªãããŸããŸãªä»äºã§äœ¿ããPythonã®æã«è§ŠããŠããŸããããã°ã©ãã³ã°èšèªPythonã¯ãä»ããžãã¹ããŒãœã³ã®éã§äººæ°ãé«ãŸã£ãŠããŠãããã§ãããã€ãŠããã³ããã°ã©ããŒã§ããããžãã¹ããŒãœã³ã®éã§ã¯æ¥åãå¹çåã»èªååããããã«Excel VBA/ãã¯ãã䜿ãããŠããŸãããPythonã¯ãã®ä»£ãããšãªãã€ã€ãããã§ãã
ããã®æ¬ã§ã¯ãããã£ãæ¹ãã¡åãã«ãPythonã䜿ã£ãä»äºè¡ãç¶²çŸ
ããŸãããExcelãã¡ãŒã«ãWEBã¯ãã¡ãããPCå
ã®ãã¡ã€ã«æŽçãé»åæºå°ãç»ååŠçãç»åããã®æåæœåºãåç»ç·šéãªã©ã®ææ°ãã¯ããã¯ã玹ä»ããŠããŸãã
ââããªãå
·äœçãªãããžãã¹ã§äœ¿ããPythonã®å°æãæ²èŒãããŠãããã§ããã
ãäŒæ²¢ããã
ãã¯ããPythonã®äŸ¿å©ã¯ã¶ãããããæ²èŒããŸãããåé¡éããã©ãã«ã·ã¥ãŒãã£ã³ã°ã«ã€ããŠã®ããŒãžããããŸãã
ââäŒæ²¢ããã¯ãæè²ç³»YouTuberãšããŠã掻èºãããããã°ã©ãã³ã°ã«é¢ããæ
å ±çºä¿¡ããããŠãŸããããYouTubeãã£ã³ãã«ã§ãæ¬æžãšé£æºããã³ã³ãã³ãã¯ããã®ã§ããããïŒ
ãäŒæ²¢ããã
ãYouTubeãã£ã³ãã«ã§ãæ¬æžã®å
容ã«è§Šããåç»ãé£ç¶ã§å
¬éããŠããŸãã
ããã®æ¬ãçºå£²ãããŠä»¥éãç§ã®YouTubeãã£ã³ãã«ã®è§£èª¬åç»ã§äººæ°ããããã®ãã¹ã5ãããã¯ã¢ãããããšããããªæãã«ãªããŸãã
第1äœãChapter2 Section 8 PDFå
ã®è¡šãExcelã«èªã¿èŸŒã
第2äœãChapter6 Section 1 ä»äºã«åãããŠããã°ã©ã ãã«ã¹ã¿ãã€ãºããã³ã
第3äœãChapter2 Section 5 ãã©ã«ãå
ã®ãšã¯ã»ã«ãã¡ã€ã«ã1ã€ãã€èªã¿èŸŒã
第4äœãChapter2 Section 10 幎床ãªã©ãè€æ°ã®ãã¡ã€ã«ã®çœ®æãäžåºŠã«è¡ã
第5äœãChapter5 Section 1 ååç»åãAIã«åŠç¿ããã
ââçµæ§ãªã¢ã«ã«ãä»äºã«çŸå Žã§äœ¿ããããã®ãäžäœã«ãªã£ãŠãŸããã
ãäŒæ²¢ããã
ãããã§ããããã¯ããåãåã£ãPDFãã衚ãåãåºããŠExcelã§ç·šéããããšããèŠæããä»äºãå¹ççã«ããããã®æ¹æ³ãèªåçã«è€æ°ã®ãšã¯ã»ã«ãã¡ã€ã«ãèªã¿èŸŒããšããå
容ã®åç»ããšãŠãããèŠèŽãããŠããŸãããŸããAIã®æŽ»çšã«ã€ããŠãé¢å¿ãé«ãããã§ãã
ââæ¬æžã§Pythonã«èå³ãæã£ãèªè
ãããã«äžæ©é²ãããã®æ
å ±æºãã³ãã¥ããã£ã¯ããã§ããããã
ãäŒæ²¢ããã
ãPythonã§æ±ãããšãã§ããã©ã€ãã©ãªïŒããããããšãç°¡åã«ã§ããããã°ã©ã ã®éšåéïŒã¯é²åã®ã¹ããŒããæ©ããæ°ãããã®ãã©ãã©ãåºãŠããŸããYouTubeã§PythonãRPAãšããããŒã¯ãŒãã§åç»ãæ€çŽ¢ãããšææ°ã®æ
å ±ããããããã解説åç»ã«åºäŒãããããšæããŸãã
ãä»ã¯ããããã®YouTuberãããã°ã©ãã³ã°ã®è§£èª¬åç»ãå
¬éããŠããã®ã§ãèªåã«ãã£ããã£ã³ãã«ãæ¢ããŠã¿ãã®ãè¯ãã§ãããããã¡ããç§ã®YouTubeãã£ã³ãã«ã§å
¬éããŠããPythonå
¥éãããããã§ãã
ââæ¬¡ã®æ¬ã®äºå®ã¯æ¢ã«ãããŸããïŒ
ãäŒæ²¢ããã
ããã¯ããITã®åã§äžå°äŒæ¥ã®DXæšé²ã«ã€ããŠã®ãã¯ããã¯ããå¹ççãªæ¹æ³ã«ã€ããŠã®æ¬ãæžããŠã¿ããã§ããããŒã³ãŒããããŒã³ãŒãæè¡ã®æŽ»çšãšãã£ãããŒããé¢çœããªãšæã£ãŠããŸãã
ââäŒæ²¢ããã®ä»åŸã®æŽ»åäºå®ã¯ïŒ
ãäŒæ²¢ããã
ãä»åŸããYouTubeãäžå¿ã«æ
å ±çºä¿¡ãããŠãããŸãããŸãããªã³ã©ã€ã³ã§ã®è¬æŒäŒã®ã話ãããã ãããã«ãªããŸããã幎å
ã«ã¯RPAã«ã€ããŠã®è¬æŒäŒã§ç»å£ãäºå®ããŠããŸããConnpassçµç±ã§åå ã§ããã€ãã³ãã§ãã
ââæ¥œãã¿ã«ããŠããŸããæ¬æ¥ã¯ããããšãããããŸããã
ïŒã€ã³ã¿ãã¥ãŒäºïŒ
ãã€ã³ã¿ãã¥ãŒãããŠã»æ·±æ°Žè±äžé ãããã£ãŒã« https://nitsuite.jp/fukamieã
ã¡ã«ãã¬ãã©ãããã©ãŒã ããŸããŸãããå人ã§çºæ¡ãéçºéå¶ããã¡ã«ãã¬ã®ç¶ããšåŒã°ãããWeb of the Yearã§æ¥æ¬äžãšãªã3幎é£ç¶å
¥è³ãæ°ããããŒã±ãã£ã³ã°æ¹åŒã確ç«ãããšããŠWebã¯ãªãšãŒã·ã§ã³ã»ã¢ãŠã©ãŒãåè³ãæªæ¥æ€çŽ¢ãã©ãžã«ç€Ÿå
代衚ãåããã¥ãŒã¹ãµã€ããã¬ãžã§ããéä¿¡ããåµåãããããæµè¡èªå€§è³ããMCNãã¬ãžã§ã¯ãªãç«ã¡äžããã·ã¥ãŒã¯ãªãŒã ã倧奜ãã