Python SQL AI æ©æ¢°åŠç¿ãã£ãŒãã©ãŒãã³ã° ChatGPT
ãAIãã©ã³ðãæªçµéšããChatGPTÃPythonã§çæAIã¢ããªéçº&ããŒã¿åæð¥





ã§ããããš
AIãã©ã³ã§ã¯ãã«ãªãã¥ã©ã ã«æ²¿ã£ãŠæ©æ¢°åŠç¿ãããŒã¿åæããã£ãŒãã©ãŒãã³ã°çã®ææ³ãåŠã³ãAIã¢ããªãéçºããŠãå®å掻çšã転è·ãæ¡ä»¶ç²åŸãªã©ã®ãã£ãªã¢ã¢ãããç®æããŸãã*
ããã°ã©ãã³ã°ã»AIåå¿è æè¿ïŒäœäŸ¡æ Œã§AIã¢ããªéçºãããã«ãªãããã®ã¹ãã«ç¿åŸã培åºãã©ããŒããŸã
é«é¡ãªAIã»ããŒã¿ãµã€ãšã³ã¹ã¹ã¯ãŒã«ã®ãµãŒãã¹ããªãã¬ã€ã¹ð¥
å§åçãªã³ã¹ãïŒäœæéæå°
AIã»ããŒã¿ãµã€ãšã³ã¹ã¹ã¯ãŒã«ã§ã¯ã50ã80äžå以äžããããŸãã
æ¬ãã©ã³ã§ã¯ãæ2äžåå°ããããã°ã©ãã³ã°ãããŒã¿åæãAIã¢ããªå®è£
ãŸã§äžæ°é貫ãããµãŒãã¹ãæäŸããŸãã
æ«æé²æ¢ïŒå®æã¡ã³ã¿ãªã³ã°ã§é²æç®¡ç+åãããªãç¹ã培åºè§£èª¬
宿çã«ãããªé話ã¡ã³ã¿ãªã³ã°ã宿œããŸãã
åŠç¿ããŒã¹ãç®æšã«åãããŠæ¬¡åã¡ã³ã¿ãªã³ã°ãŸã§ã®å®¿é¡ãèšå®ããããã¹ãããšãæç¢ºã«ããŸãããŸããåãããªãç¹ãäžå®ãªç¹ãã䌺ãããã¢ããã€ã¹ã宿œããŸãã
æ«æãããåŠç¿ãç¶ç¶ã§ããããã«èª¿æŽããããŸãã
質åãæŸé¡ïŒæ©ãã§é²ãŸãªãæéã培åºçã«åæž
Slackã«ãŠã«ãªãã¥ã©ã ã®è³ªåãçžè«å¯Ÿå¿ãããŸãã
å¹³æ¥ã»åæ¥ç¥é¢ä¿ãªã24æé以å
ã«å¯Ÿå¿å¯èœã§ããã©ã®ç掻ãªãºã ã§æŽ»åããŠããæ¹ã§ã倧äžå€«ã§ãã
質åããããšã§è¿·ãæéãæžããå¹çè¯ãåŠç¿å¯èœã§ãã
ãããªæ¹ã«ãªã¹ã¹ã¡ïŒ
ðããŒã¿ãµã€ãšã³ãã£ã¹ããããŒã¿ã¢ããªã¹ããAIãšã³ãžãã¢ãããã³ãããšã³ãžãã¢ãªã©ãç®æããŠããŠå°±è·ããã
ðã¹ã¯ãŒã«ã«éã£ãŠããããæãããã«æé·ã§ããªãã£ã
ðãã£ãªã¢ã®ã€ã¡ãŒãžãå
·äœçã«ã§ããªã
ðæè¿è©±é¡ã®ChatGPTãåŠãã§å®åã«æŽ»ãããã
ðPythonã䜿ã£ãŠAIãããŒã¿åæã®ææ³ãåŠã³ãã
ðGASãSQLã䜿ã£ãŠäœæ¥ãå¹çåããã
ðAIãããŒã¿åæãå®åã«æŽ»ãããã
ð坿¥ãããªãŒã©ã³ã¹ã§åããã
ç¿åŸã§ããã¹ãã«
- ChatGPTãªã©LLMïŒå€§èŠæš¡èšèªã¢ãã«ïŒ
- ããã³ãããšã³ãžãã¢ãªã³ã°
- Pythonããã°ã©ãã³ã°
- PythonããŒã¿åæç³»ã©ã€ãã©ãª(numpy,pandas,matplotlibãªã©)
- Pythonæ©æ¢°åŠç¿ç³»ã©ã€ãã©ãª(scikit-learnãªã©)
- ãã£ãŒãã©ãŒãã³ã°ïŒPytorchãKeras/TensorFlowãªã©ïŒ
- SQLãDBãããŒã¿ãŠã§ã¢ããŠã¹(BigQuery)
- çµ±èšãæ©æ¢°åŠç¿åºç€ç¥è
- ã¹ã¯ã¬ã€ãã³ã°
- BIããŒã«
- ã¹ãã¬ããã·ãŒã/GAS
宿çãªã¡ã³ã¿ãªã³ã°ã«ãŠãããªãã®ç®æšèšå®ã«åãããŠåŠç¿ããã¹ãã«ãéžå®ããŠãããŸãã
ã«ãªãã¥ã©ã äŸ
ãŽãŒã«ïŒLLMãªã©çæAIãæŽ»çšããŠã¢ããªã±ãŒã·ã§ã³ãäœã
- ããã³ããã£ã³ã°
- Pythonåºç€
- OpenAI API
- ç»åçæAPI
- ãªãªãžãã«ãã£ãããããéçº
- LangChainã§äžŠåã«æç« ãç»åçæ
- LangChainã§çŽåã«ç»åçæããã³ããçæâç»åçæ
- LangChainã§Embeddingâæ€çŽ¢âæç« çæ
- GPT3ã¢ãã«ã®FineTuning
- ãªãªãžãã«AIéçº
- ãªãªãžãã«AIãWebã¢ããªã«çµã¿èŸŒã¿
ã¹ã¯ãŒã«ãšã®éã3éž
æªçµéšããç®æšéæãŸã§ãµããŒã
æ¬ãã©ã³ã§ã¯å°±è·ãæ¡ä»¶ç²åŸãã¢ããªãªãªãŒã¹ãªã©ãç®æšéæãã§ãããããµããŒããããŠããã ããŸãã
äžè¬çãªããã°ã©ãã³ã°ã¹ã¯ãŒã«ã®ãŽãŒã«ã¯ãããã°ã©ãã³ã°ãæããŠã«ãªãã¥ã©ã ãçµããŠåæ¥ãããããšã§ããããã®å
ã®ç®æšéæãŸã§ã¯ãµããŒãããŠãããŸããã
æçç®æšéæã®ããã®ãªãŒããŒã¡ã€ãã«ãªãã¥ã©ã
è¯è³ªãªææã¯Webäžã«ãããããããŸããããã©ããã©ã®é çªã§ã©ãåŠç¿ããããã倧åã§ããè±å¯ãªãªãªãžãã«ææãWebäžã®åç»ææããã³ãºãªã³ææãªã©ãå©çšããããããçµã¿åãããŠäžäººã²ãšãã«åãããã«ãªãã¥ã©ã ãäœã£ãŠããŸãã
æ¡ä»¶ç²åŸãå°±è·ã«å¿ é ïŒãªãªãžãã«ããŒããã©ãªãªå¶äœ
äžè¬çãªã¹ã¯ãŒã«ã§ã¯ããªãªãžãã«ããŒããã©ãªãªå¶äœãŸã§è¡ããªãããã忥åŸã«ããŒããã©ãªãªãäœãããšã«ãªãã®ã§ããããµããŒããåããããæ«æããŠããŸãæ¹ãå€ãã§ãã
æ¬ãã©ã³ã§ã¯ãããªãã®äœãããAIã¢ããªã®å®çŸã«åããŠãäŒç»ãèšèšãã³ãŒãã£ã³ã°ãå
¬éãŸã§äžæ°é貫ãµããŒãããŸãããäœããæãä»ããŠãããããããªãããšããåå¿è
ã®æ¹ã§ããå®å¿ããŠè¿·ããªãå®è£
ã§ããããã¢ããã€ã¹ããããŸãã
ç¬åŠãšã®éã3éž
1ïžâ£3åæ©ãç®æšéæã§ãã
ç¬åŠã ãšç®æšéæãŸã§ã®æéãé·ããªããŸãã
ç¬åŠã§ã¯1ã2幎ãããã¹ãã«ç¿åŸã6ã¶æçšåºŠã§ç¿åŸããŠãããŸãã
- ç¡é§ãåãèœãšããæçç®æšéæã«ãªãã¥ã©ã
- åŠç¿ã®ææç©ã§å®çžŸãç©ã¿äžããäžç³äºé³¥ã®åŠç¿èª²é¡
- æªçµéšè ã®9å²ãå®è·µããŠããªããçéã§é²ããå¹ççãªå匷æ³
- ãã©ã³å¥çŽåŸã«ã¢ããUPïŒåŠç¿æéçŽ1.5ã2å
- ã«ãªãã¥ã©ã æã+24æé質åãæŸé¡ã®ãããã¹ã©ã¹ã©åŠç¿ãé²ããŠæéãã¹ããªã
çµæã«ã€ãªããåŠç¿ç°å¢ãæäŸããŠããŸãã
æçã§ã®ç®æšéæãç®æããŠãããŸãããã
2ïžâ£æ«æç1岿ªæº
ããã°ã©ãã³ã°åŠç¿ã¯æ«æçãéåžžã«é«ãã§ãã
çŽ9å²åŒ±ãæ«æãæããŠãããšããããŠããŸãã
ããããæ«æèŠå
- ç°å¢æ§ç¯ããšã©ãŒã§ã€ãŸã¥ããâãæ¬¡ã«é²ããªãã®ã§ããã
- 次äœãããã°ãããããããªããªããâãæ¬¡ããããšã決ããã®ã倧å€ã§ããã
- ä»ãã£ãŠããåŠç¿ãæ£ãããããããªããâãç®æšã«åãã£ãŠããæããªãã¢ããäœäž
âæ¬ãã©ã³ã§ã¯äžèšã®æ«æèŠå ã培åºçã«æé€ããŸã
- Slack質åãæŸé¡ã§ã€ãŸãã鲿¢ïŒã¹ã©ã¹ã©åŠç¿ãé²ãããã
- 宿ã¡ã³ã¿ãªã³ã°ã§ããã¡ã³ã¿ãŒãä»ããã¹ãåŠç¿èšç»ã»æ£ããå匷æ³ãæå
- ç®æšéæã§ããåçŸæ§ã®é«ãã«ãªãã¥ã©ã ãæäŸ
3ïžâ£ç¬åŠã§ã¯ã§ããªãäœéšãã§ãã
1人ã§ã¯ã§ããªãäœéšããã£ã³ã¹ããããŸãã
- 400äººä»¥äžæå±ããåŠç¿ã³ãã¥ããã£ã§ã€ãã³ãåå
- åãã¬ãã«ã®ãšã³ãžãã¢ãšããŒã éçºäœéš
- æš¡æ¬é¢æ¥ããã£ãªã¢çžè«ãªã©è»¢è·ãæ¡ä»¶ç²åŸçžè«
- å°±è·äŒæ¥ç޹ä»ãããªãŒã©ã³ã¹æ¡ä»¶ç޹ä»ïŒéå»100å以äžã«ã玹ä»ïŒ
ãµããŒãå 容
1ïžâ£ãã€ãŸã§ã«äœãã©ã®é çªã§åŠç¿ãããæç¢ºå
ãâ
ç®æšããéç®ããæ¯æã®åŠç¿ç®æšã®æäŸ
ãâ
ãäœãã©ã®é çªã§ãåŠç¿ããã¹ããåãããªãŒããŒã¡ã€ãã«ãªãã¥ã©ã ã®æäŸ
2ïžâ£ã€ãŸãããŠããæéãçãã§ãã
ãâ
ãã£ãã質ååçïŒç¡å¶éïŒ
ãâ
ç°å¢æ§ç¯ãµããŒã
ãâ
åŠç¿æ¹æ³ã¢ããã€ã¹
ãâ
ãªãªãžãã«ããŒããã©ãªãªæ·»å
3ïžâ£åŠç¿è
å士ã§åç£ç¢ç£šã§ãã
ãâ
ããããäŒ
ãâ
ã¡ã³ãã£ãŒäž»å¬ã®å匷äŒ
ãâ
亀æµã»èŠªçŠäŒ
4ïžâ£ããŒã¿ãµã€ãšã³ãã£ã¹ãã®ãã£ãªã¢æŠç¥ãæãã
ãâ
宿1察1ãããªé話ã¡ã³ã¿ãªã³ã°
ãâ
坿¥ã»ããªãŒã©ã³ã¹ã»è»¢è·ã«é¢ããçžè«
ãâ
è»¢è·æ»ç¥è¬åº§
ãããªæ¹ãæ¬ãã©ã³ã®å¯Ÿè±¡ã§ãïŒ
ããã°ã©ãã³ã°åŠç¿æ¹éã§ãæ©ã¿ã®æ¹
â
ç¬åŠã§éçºãå§ãããã©ãProgateãUdemyããããã€ã³ã¹ããŒã«ä»¥éã§äœãããããããããããªã
â
ããŒããã©ãªãªãšãªããµã€ãã»ãã¶ã€ã³ãäœãããããäœãã©ãå匷ããã°ããã®ãããããªã
ãð ããªãã«åã£ãæçåŠç¿ã«ãŒããæç€ºãããŠããã ããŸãïŒ
1ã€ã®ãšã©ãŒã§äœæéãç¡é§ã«ããããšãããæ¹
â
ç°å¢æ§ç¯ãåèŠæ®ºãéããŠèŸã...
â
ããã®ãšã©ãŒããã£ãŠå
ã«é²ããªã
ãð Slackãã¡ã³ã¿ãªã³ã°ã§ã§ããéã察å¿ãããŠããã ããŸãïŒ
ããã°ã©ãã³ã°åŠç¿ã«ãŠãæ«æã»ããæ°åªå€±çµéšã®ããæ¹
â
å®éã«ãªãªãžãã«ã§ã³ãŒããæžãããšãããšæãæ¢ãŸã...
â
æžç±ãUdemyãªã©ã§ã€ãŸã¥ããŠããŸã£ãããŸããæ¬¡ã«äœãããã°ãããåãããªã...
ãð ãªãªãžãã«ææãè¯è³ªãªãã³ãºãªã³ææã䜿ããç®æšãåŠç¿ãªãºã ã«åãããŠæ«æããåŠç¿ã§ãããªãŒããŒã¡ã€ãã«ãªãã¥ã©ã ãæäŸããŸãïŒ
ã¹ã¯ãŒã«ã忥ããããã©ããŒããã©ãªãªã1人ã§äœããªãæ¹
â
ã«ãªãã¥ã©ã ããªããããã©ãèªåäžäººã§è©äŸ¡ãããããŒããã©ãªãªãäœæã§ããªã
â
ã©ããªé åºã§ãµã€ãå¶äœã»ãã¶ã€ã³ãããŠãããããããªã...
ãð çŽåŸãããããŒããã©ãªãªã宿ã§ãããŸã§ã䞊走ããŠãµããŒãããŸãïŒ
æªçµéšããAIãšã³ãžãã¢ã«è»¢è·ããèãã®æ¹
â
ã³ããçŠã§ããèªåã®åžæããã¢ãã³ãªWebç³»éçºäŒæ¥ã«å
¥ããã
â
ãããããšã³ããªãŒããŠãããæžé¡éžèããªããªãéããªã..
ãð æªçµéšãããšã³ãžãã¢ã100å以äžèŒ©åºããçµéšãããéžèã«éããããããŒããã©ãªãªãã¢ããŒã«ãã€ã³ããªã©ã®ã¢ããã€ã¹ãè¡ããŸãïŒ
åå¿è ããããªãŒã©ã³ã¹ãšããŠçšŒãããæ¹ãæªçµéšãã転è·ãããæ¹ãŸã§å¯Ÿå¿å¯èœã§ãã
åãã©ã³ã®ãµããªãŒç޹ä»
Zoomçžè«ãã©ã³
è²æã®ããããæ©ã¿ã®çžè«ã«ä¹ãããã®åŸã®ã¢ã¯ã·ã§ã³ãã©ã³ãŸã§ãææ¡ããŸãã
ðAIã»ããã°ã©ãã³ã°ã®å¹ççãªå匷æ³ã§çéã§æé·ã§ããŸãïŒ
ðãã€ãŸã§ã«ããªãã®ç®æšãéæã§ããã®ããæææãšããŒãããããæç€ºããŸãïŒ
ðçŸåšã®ãã¬ã³ãã«åã£ãAIéçºææ³ãåŠã¹ãŸãïŒ
ðæªçµéšã§ã®æ¡ä»¶ç²åŸã»å°±è·æ¹æ³ãç¥ããããã«ã§ãåãåºããŸãïŒ
ðã©ã®ãã©ã³ã«ããããæ±ºããããŠãã or åè¬ããããã©ããè¿·ã£ãŠããå Žåãæèãå
·äœçã«ãªã£ãŠå³è¡åã§ããŸãïŒ
ãæå®ã§åŠç¿ã¹ã¿ãŒãïŒãæ1ã¡ã³ã¿ãªã³ã°ãã©ã³
æªçµéšã®æ¹ã§ãå®å¿ããŠAIéçºæ¡ä»¶ãåæ³š or å°±è·ã§ãããããæå®äŸ¡æ Œã§ãªã¹ã¯ãæããªããæè¡æå°ãAIã¢ããªéçºãå
å®ã»æ¡ä»¶ç²åŸãŸã§äžæ°é貫ãµããŒãããŸãã
ðã¡ã³ã¿ãªã³ã°ã®é »åºŠä»¥å€ã®ãµãŒãã¹ã¯å
šãŠåãïŒæå®äŸ¡æ Œã§åŠç¿ãå§ãããæ¹ã«ããããã§ããéäžã§ãã©ã³å€æŽãOKãªã®ã§ãã詊ãã§åè¬ãããæ¹ãã
ð瀟äŒäººãªã©ã§ãå¿ããæ¹ã«äººæ°ã®ãã©ã³ã§ãã
ãã³ã¹ãæåŒ·ïŒãéé±ã¡ã³ã¿ãªã³ã°ãã©ã³
é±ã«15ã30æéçšåºŠã®åŠç¿å¯èœãªæ¹åãã®ãã©ã³ã¹ãã©ã³ã§ãã2é±éã«1åã®ã¡ã³ã¿ãªã³ã°ãéããŠãå¹çè¯ãåŠç¿ãé²ããããšãã§ããŸãã
ðæ1åã®ã¡ã³ã¿ãªã³ã°ã ãšã¢ãããŒã·ã§ã³ãç¶ãã®ãäžå®......ãã ãã©é±1åã®é »åºŠã ãšé²æãããŸããªãå¯èœæ§ããã......ããšãã£ãæ¹ã«ããããã®ãã©ã³ã¹ãåãããã©ã³ã§ãã
ðããçšåºŠæéãåãã瀟äŒäººã»åŠçã®æ¹ã«äººæ°ã®ãã©ã³ã§ãã
ãäžçªäººæ°ïŒãé±1ã¡ã³ã¿ãªã³ã°ãã©ã³
æ¬æ°ã§æé·ãããæ¹åãïŒçæéã§AIéçºãããæ¹ã«ãŽã£ããã®ãã©ã³ã§ãã
ðæªçµéšããçéã§AIã¢ããªãªãªãŒã¹ãæ¡ä»¶ç²åŸã»å
å®ãŸã§äžæ°é貫ãµããŒãããŸãïŒ
ðå®å
šæªçµéšã®ç¶æ
ãã3ã¶æã§ãªãªãžãã«ããŒããã©ãªãªãäœæïŒ
ðæ©ãçµæãåºããŠãæ©ã忥ã§ããã°äžçªã³ã¹ããè¯ãã§ãã
â»é±20ã40æé以äžããã°ã©ãã³ã°åŠç¿ã§ããæ¹ã«ããããã§ãïŒ
ãèå³ããæ¹ã¯ãŸãã¯ãZoomçžè«ãã©ã³ãããå©çšãã ããïŒ
ãã©ã³ã«ã€ããŠã®ãçžè«ã¯ãã¡ãã»ãŒãžã§ããåãããããŸãããæ°è»œã«ãé£çµ¡ãã ãã
ã¡ã³ã¿ãŒãããã£ãŒã«
äŒè€ ããã€@塟è¬åž«âãã«ã¹ã¿ãã¯ãšã³ãžãã¢
ã³ãŒã¹ã¡ãã¥ãŒ
ã¡ã³ã¿ãªã³ã°å®çžŸ
ãã£ãšã¿ãæçš¿
ã¬ãã¥ãŒ

ãã©ã³å€æŽã®ãããã¡ãã®ãã©ã³ãäžæŠè§£çŽãããŠããã ããŸãã
ãã£ãããšçžè«ã«ã®ã£ãŠããã ããŠããŸãã
åºç€ãæ¬ ããŠããããšããã£ãããšææããã ããåå°ãã埩ç¿ãããŠããç¶æ
ã§ãã
åŒãç¶ããããããé¡ãããããŸãã

倧å€ç³ãèš³ãããŸãããã10æã«ãŸãå®ãããé¡ãããŸãã

ææçŸ©ãªæéãããããšãããããŸããã
8æããããããããé¡ãèŽããŸãã
çžè«ã§ããŸã
äŒè€ ããã€@塟è¬åž«âãã«ã¹ã¿ãã¯ãšã³ãžãã¢
7æéå
è¿ä¿¡ã¹ããŒã
24æé以å
â»ãããŸã§ãç®å®ãšãªããŸã