f[^͂ChatGPT̋@\iCode Interpreterjłł邩A݂yԊOҁzFAIEf[^TCGX
ChatGPT́uxf[^́v@\f[^TCGXςH@flłȒPɃf[^͂ł悤ɂȂ̂H@M҂ۂɒ킵ǍɊÂzƓ@͂܂BAڂ̗Ƃ͊WȂԊO҂łB
@wAIEf[^TCGXxƂO̖{Ał́AuƂł͂ȂA܂AIGWjAf[^TCGeBXgł͂ȂASfl̈ʓIȎЉlłAV̎ЉlNłwюn߂vƂǎ҃^[QbgݒŁAS4̋LWJAɊĂ܂B̒2ł́Ał{Iȃf[^̗͂茳ő̌܂B
@ǂꂩ̎Af[^͂ChatGPTɁg肢hΒNłłႤˁHI@u͂̊bmwсA̓XLgɕtvȂă_____cc
@ȂӂɎvĂlȂȂ̂ł͂Ȃł傤BChatGPTɁuCode InterpreterviŁÁ݂uxf[^́FAdvanced Data AnalysisvƉjƂ@\oꂵ2023N7Af[^TCGeBXgłuChatGPTIɍsf[^͂zȏ̎͂vƋÂ܂܍xȃf[^͂܂ł剻āuf[^TCGeBXg̎dD邩vƊ@_̒ɂ͂܂B
}1@ChatGPT́uxf[^́v@\̗LiLPlus[U[płj@ۂɂǂȂ̂H@ႦΑ2ƓƂAChatGPTȂ``bƑfSłłĂ܂̂H@M҂Ă݂̂ŁA̓eAM҂vzAӌĂƎv܂B͘AڂƂ͒ڊWȂyԊOҁzƂARIȓǂݕƂĎQlɂĂKłB
@_猾ƁAmɍxȃf[^͂Ŏ{ł܂BłAM҂̏ꍇAxǂɂԂ܂B邽߂ɂu͂f[^͂̊bmƎHXL߂vƌ_t܂Bł͂ǂ̂悤ȕǂɂԂ̂H@Ƃ̂A{e̖ʔ|CgƎv܂̂ŁAЍŌ܂œǂłƂꂵłB
@ȂAƂChatGPTŎ邩܂B̍ۂ̉Ƃ́AM҂̌eƈقȂꍇ邱ƂB
1. ChatGPTɁuf[^́vĂ炨
@܂https://chat.openai.com/JāAuChatGPT 4viGPT-4jI܂iOf̐}1jBꂾŁuxf[^́vIɎg悤ɂȂ܂B
`ƖڕWݒ
@̂ŁAf[^͂ChatGPTɂ肢Ă݂܂傤BM҂2̋LeQlɁAL̃vvgieLXgj͂܂B
vvg1
܂ÔŁA肠bɂĂBȂÁuxf[^́v@\gpďsĂقłB
uCႢƃACXN[]Ă܂ACƔꂪȂāArWlX̋@ĂvƂ̐Ɖ肵܂B̖邽߂ɁAL2̖ڕWݒ肵܂B
- ˋ̃ACXN[̔グf[^i100jgāACACXN[̔グɂǂ̂炢êׂ
- ̓̋CƗjAACXN[̔グi101ځj\BɂāAuACXN[ǂꂾpӂׂvOɔcł悤ɂ
@Ɛ}2̂悤ɏo͂܂B
f[^͂̎菇
@}2̉́A2́ũf[^̗͂vŎeƂقړłB
- Xebv1F uf[^̎WƏv́A2Lł́uf[^WvƁuf[^^ϊF {Iȃf[^vƂ2̎菇łB
- Xebv2F uTIf[^́iEDAFExplanatory Data AnalysisjvƂpɂẮA{Aڂł͐Ă܂łBEDAƂ́AȂ@BwKf̂ł͂ȂAOɃf[^̓eOtɂĉȂǂāA̓炩ߔcĂƂłB2Lł́uf[^: Ot쐬vƂ菇Ŏ{܂B
- Xebv3F u֕́v́AWZoȂǂăf[^͂l@邱ƂłB2Lł́uf[^̓cF vʂ̊mFvƂ菇łB
- Xebv4F uf̍\zƕ]v́AA͂Ȃǂ̋@BwKf쐬A̐\]邱ƂłB2Lł́uf[^琔liႦΔzj\F ÁvƂ菇ɊY܂B
- Xebv5F u\ƈӎvv́Aۂɋ@BwKfŗ\A炩̈ӎvɖ𗧂Ă邱ƂłB2Lł́AقǂƓuf[^琔l\vƁuꂽmrWlXɐF ӎvvƂ2̎菇ɂ܂ełB
@f[^͂̃vZX́ANlĂȂ܂ˁB̂܂ܐi߂ĖȂł傤B
@bIȔfɂ́A{AڂŊwbmLpłˁB
2. ςȂ玸s̘Auf[^Abv[hv
@قǂChatGPT̉i}2jł́AŌɁuˋ̃f[^܂傤HvƕĂ܂Bf[^͑2ŎĝƓɂ̂ŁAMҁi[U[jAbv[h邱Ƃɂ܂傤B
f[^̏if[^t@C̃Abv[hj
@f[^̃Abv[h͊ȒPłB2̋LTvt@Cianalytic_ai.xlsxt@Cj_E[hAhbOhbvChatGPTɃAbv[h邾BAbv[h̃vvĝ͎悤ɏ܂B
vvg2
ˋ̃f[^Zbg͂gĂB
܂̓f[^͗pɃf[^̐ϊsłB
̑OƂĈُl⌇lĂB
܂AJeS[l͉A͂Ȃǂ₷lf[^ɕϊĂB
e@̓f[^ăxXgȂ̂IɑIĂB
肠O܂łōƂ͎~߂ĂB
@łȂƐiޑz肾̂łAʂ͐}3̒ʂ̃G[I
@ȂpɂȂĂ܂AuAbv[hꂽt@Cւ̃ANZXvɉ炩̃G[悤łBIɂxAsāAłG[ɂȂĂ܂BŌɁAuO̕@KChvƂĂi߂鋖߂Ă܂B
sFAbv[hɔG[̌
@Ảeł́uȂG[ɂȂvƂS܂BM҂͂ŌT낤Ƃ܂BChatGPT́uxf[^́v@\́APythonR[hĎsdg݂łBeLXg̍Ōɂ[>_]iView analysisjƂNNbNƁAPythonR[h܂B}4́A2ڂ̎sG[PythonR[h̓ełB
}4@ChatGPT́uxf[^́v@\PythonR[h\PythonpandasCu[ŁAExcelt@Cianalytic_ai.xlsxjǂݍł܂BɁAɓǂݍǂʂȀꍇ͂̃f[^̐擪5s\As̏ꍇ̓G[\鏈ɂȂĂ܂B
@]kłAvO~Oó̕AˑRPythonR[hŏłl邩܂BChatGPT́uxf[^́v@\gȂɂ́APythonR[hǂ߂郌x̊bvO~OXL͕K{ɂȂ܂BłȂƁÂ悤ɃG[Ƃ₨Ȍʂo͂ꂽƂɁATꂸɎl܂ɂȂ邩łB
@ITDeep InsidertH[ł́uAIEf[^TCGX̊wтvƂLb`Rs[ŁAPythonf[^͂̊bmƎHXLXebvEoCEXebvŊbςݏグ邽߂̃RecpӒłBς݂wPythonxƁAAړWJwPythonf[^x̏œǂނƂ߂܂B
@2ڂ̎sG[ɂȂĂ̂ɁÃG[̓e͉Ɋ܂܂Ă܂Bł̓G[łȂłBƂƂŁAM҂̈ꓬn܂܂BƂAf[^͂n߂ÔԋJ܂B
sFɌs
@ŏɋCt̂AExcelt@Cɂ̓[NV[gÃ[NV[gvvgŎwĂ܂łBuꂪvƓtAēxvvg܂At@CANZX̃G[B
@łG[pꂾ̂ŁAŁuG[bZ[W{ł肢܂Bvƃvvg܂B
@ɁuG[eo͂ĂBȂ̂fł܂BvƃvvgƂAut@C̓ǂݍ݂ɊւăG[Ă܂BG[̋̓IȓéAIȗO (`AceInternalException`) ƂĕĂA͈ʓIɂ̓VXe̓IȖĂ܂BvƂ܂BŁuChatGPT AceInternalExceptionvƂL[[hGoogleƂAl̃G[̕AChatGPTL̖肾ƕ܂i2023N125_jB͏CƎv܂Â܂܂ł͎l܂łB
F̉
@ŁAExcelt@Ci̓Iɂanalytic_ai.xlsxt@Ćmf[^n[NV[gjAeLXgCSViJ}j`̃t@CiUTF-8GR[hj̃f[^ɕύXĂ݂܂BuVvȃt@C`Ȃǂݍ߂̂ł́HvƊ҂āBꂪāAɐ}5̂悤ɓǂݍ߂܂B
@͏ɐi߂ꂻłˁB
3. yXƐiuOvƁuf[^vƁu֕́v
O
@قǂChatGPT̉i}5jł́AŌɁul̏AُľoƏAJeS[l̐lϊs܂Bł́AOn߂܂傤HvƕĂ܂B̂܂ܐi߂Ă炤Ƃɂ܂傤BŃvvg3̂悤ɏ܂B
vvg3
͂AOsĂB܂łł܂̃XebvɂĕĂB
@̌ʁA}6̉o͂܂B
@͂܂BA2Lł́u250v́u25v̏ԈႢƐ肵āÂ悤ɐlC܂BChatGPTɂ肢Ă݂܂傤íFvvg4AF}7jB
vvg4
25025̉\̂ŁÂ悤ɏCĂBēxAOf[^ŁÃXebvɂĕĂB
@S肠܂ˁBȂ݂ɔÔߕM҂́Af[^eŜ2LƔr܂ASłBɂŕM҂́APythonR[hJāgȏhȂǂȂ`FbN܂A͂܂łB
@ꂽPythonR[hSɂ͐MpłȂ̂ŁA͂PythonR[h̖ڎ`FbN͕K{łˁBƂAŏPythonR[h\ĂꂽB
@PythonR[hꍇ́AuPythonR[hSĕ\ĂBvƂŌɕtƁA\悤ɂȂ܂B
@Ȃ݂ɕM҂́Ãf[^͂̌㔼ł́APythonR[h\悤Ƀvvgɏ悤ɂȂ܂B߂łB
f[^
@āAقǂChatGPT̉i}7jł́AŌɁũXebvƂāÃf[^ɑĒTIf[^́iEDAjsƂł܂BccijccEDAsAƂf\zɐi݂܂A܂͑ɂ]܂HvƕĂ܂BłEDÂ߂Ƀf[^Ă炤Ƃɂ܂傤íFvvg5AF}8jB
vvg5
܂EDAs߂Ƀf[^ĂB
@Uz}2LƔrƓłBłˁBǂǂi߂܂傤B
֕
@قǂChatGPT̉i}8jł́AŌɁũXebvƂāÃf[^gpė\f\z邱Ƃl܂B܂AȂ镪͂ʂ̃Av[`Ɋւ邲v]Am点BvƕĂ܂BUz}ŁuCiTemperaturejƔziSalesjɂ͐̑֊W肻vƕ̂ŁAWZoĐlłtĂ܂傤íFvvg6AF}9jB
vvg6
\f\z̑Oɑ֕͂ĐlIɕ͂ĂB
@uCƔz̑ցv0.972ƎZo܂B͑2LƓlłB}9Ől̉ɂ̓ełˁB
@Ȃ݂ɁAuCƔzvȊO̍ړm̑W߂ĂĂ܂BuCƗjv̑֊W͖ӖȂ̂Ŗ܂BujƔzv0.778̑܂̂ŁAA͂̃f[^ڂƂĎgłA͋LȂĂ܂̂Ő܂B
@܂łɎUz}┠Ђ}AWȂǁAvwɊÂf[^͂̎@oĂ܂BChatGPTŃf[^͂ɂĂA͂肱̒m⊈pXL߂ƂƂłBmsĂƁA}̌vZl̈ӖȂł傤B
@m[̏Ԃuf[^͂̊bIȒmƍlAHXLgɕtvƂ́A܂iWJ́jAځwЉl1NwԁA₳f[^́yExcel^GNZŊwׂz xǔj邱Ƃ߂܂B
@ɑ܂傤Bf[^甄z\@BwKfĂ炢܂B
4. @BwK̒mꂽuÁv
P1FƂw̓_
@قǂChatGPT̉i}9jł́AŌɁuɁÃf[^ɗ\f̍\zi߂܂AƂɉ͂s܂HvƕĂ܂BUz}ƑWŁuCƔzvɂ͋̑ւƕĂ̂ŁA܂pāmCnf[^mzn\uÁv̋@BwKf̍\zw邱Ƃɂ܂BƂ͂AƓKȎ@邩Ȃ̂ŁAł͂ƃvvg7̂悤ɎwĂ݂܂B
@
vvg7
͂A\f\zĂB
@ɂA}10̂悤ɏo͂܂BPythonR[h\ĂȂ̂ŁAĂ邩Â炢łˁBPythonR[hJƁAscikit-learnƂ@BwKCu[LinearRegressioni`AFA͂̈jNXgĉA͂{Ă܂B͕M҂̈Ӑ}ʂłB
@@BwKf̓e⌋ʒĺA2̋LƈقȂĂ܂B
@̓Iɂ́A2Lł́mCnƂ1̃f[^ڂmzn\@BwKf쐬܂APythonR[hJƁAmCnƁmjnƂ2̃f[^ڂmzn\@BwKfĂ܂BȂ݂1̃f[^ڂ琔l\A͂́uPÁvA2ȏ̃f[^ڂ琔l\A͂́udÁvƌĂ܂B
@ȂAʎ̂͐悤Ȃ̂ŁA͂ŊԈႢł͂܂BM҂̑zӐ}ƈقȂ邾łB
@Ƃw͂͂_łˁBႦvvg8̂悤ɖI̓IɎwׂłB
vvg8
mCnf[^mzn\Af\zĂB̍ۂPythonR[hSĕ\ĂB
P2F@BwK̒ms
@Ƀvvg8ŎsĂA@BwKf̓e⌋ʒĺA2̋LƓɂȂ܂łBłChatGPTsPythonR[h̓eāuǂ̂悤ɏĂ邩vmF܂i}11jB
@}11ŒڂĂقӏԘgň݂͂܂Bg[jOZbgiPpjƃeXgZbgieXgpjɃf[^2Ă܂ˁIII
@mɋ@BwKł́Af[^Pp^eXgp2AnCp[p[^[i\Ȑݒ荀ځj̒Kvȏꍇ͌Pp^ؗp^eXgp3܂B́̕A@BwKfPłȂAۂ̉^pɂm̃f[^ɑėǍDȐ\iuĉs͂t\vƂĂ܂jێ邩ǂmF邽߂ɍs܂iuz[hAEgvƌ܂jB
@2Lł́A\zfĉ^p邱ƂASf[^găf[^͂ӎv肷邱ƂɏduĂ߁Â悤ȃf[^͎{Ă܂łBChatGPTƑ2̋LŁÄႢoĂƂ킯łB
@@BwK̂ƂSmȂĺAz[hAEĝ߂̃f[^ĉ\Ȃǂ̐Ɍ˘f܂ˁB̂悤ɁAChatGPTgăf[^͂sۂɂA@BwK̍Œ̒m͋߂܂B
@ITDeep InsidertH[ł́A2024NwPythonŊwԁu@BwKvxƂAڂ{iIɓWJĂ܂̂ŁAЈꏏɊwł܂傤B
PA
@Iɂ͐}11̋@BwKfŖ肠܂A2̋LƔrł悤ɁAđ2̋LƓɂȂ悤Ɏw܂íFvvg9AF}12jB
vvg9
eXgZbgĂ܂AȂ悤ɂĂBSẴf[^ʼnAf쐬ĂB̏ꍇPythonR[hSĕ\ĂB
@ő2̋LƊSɓłB
W
@2LƓlɁAWR2iA[2j߂Ă܂傤íFvvg10AF}13jB
vvg10
̏ꍇ̌WR^2vZĂBPythonR[h\ĂB
@W2̋Lƈv܂B
*@vvg10ɂu^2v́A\L₷TeX^LaTeX̏ɊÂłB̏łoĂƁAGoogle Colaboratorym[gubNȂǂ̃eLXgɗႦ$R^2$̂悤Ȍ`Ő̂ŕ֗łB
Uz}ւ̉A̕`
@łɁAOf̐}8ŕ\ꂽUz}̏ɁAA̓f\łuAvĂ݂܂傤íFvvg11AF}14jB
vvg11
قǂ̎Uz}ɂ̉Af̒ĂB
@A̐}A2̋LƓl̓eɂȂ܂B
5. ͌ʂ瓾m܂Ƃ߂āuӎvv
@ƂƂŁAf[^͈͂ʂ芮łB
@ŌɁA܂ł̃f[^͂ǂ̂悤ȂƂ̂B炩̃rWlẌӎvɂȂ悤ɁAm܂Ƃ߂Ă炢܂傤íFvvg12AF}15jB
vvg12
܂ł̃f[^͂œꂽm͂ǂ̂悤Ȃ̂ł傤H
u̓ACXN[̍ɂ肸A͍ɂߏɂȂArWlX̋@̂ʼnPvƂۑ肪܂B̉ۑɑӎvɁAꂽm𗧂Ă邱Ƃ͉\ł傤H
@m̂܂Ƃ߂ǂłˁBe͎QlɂȂƎv܂B
@Ȃ݂ɕM҂́Ǎłɂ荂x̋@BwKf̍\z͍܂B̓Iɂ́AmCnƁmjnƂ2̃f[^ڂmzn\dA̓f쐬A3̎Uz}ɉAʂ`ƂƂChatGPTɎ{܂B͂܂łłȂ蒷LɂȂĂ܂̂ŁA̐͊Ă܂B
@{ɁAChatGPTŃf[^͂łĂ܂܂ˁBASʼnmȂĂɂłƂ킯ł͂ȂłB
@Python̒mAf[^͂̒mA@BwK̒mƂbIAIf[^TCGX̃eV[A̗͂łf[^͂łƂlAŎ{\̍Ƃ^邽߂ɃAVX^gAIƂĊpAƂ̂łKChatGPT̊p@ƕM҂͎v܂B
Copyright© Digital Advantage Corp. All Rights Reserved.
ڂ̃e[}
ITmedia̓ACeBfBAЂ̓o^WłB