ç§ã¯ãXNUMX 幎éãäœãæžããŠããŸããã§ããããçªç¶ããããŒã¿ ãµã€ãšã³ã¹ããŒãããåŠã¶ããšãããããµã€ã¯ã«ã®åºçç©ã®åãå¹ãé£ã°ãçç±ãã§ããŸããã ãœãŒã·ã£ã« ãããã¯ãŒã¯ã® XNUMX ã€ãšç§ã®ãæ°ã«å
¥ãã®ããã¬ã®ã³ã³ããã¹ãåºåã§ããã®ã³ãŒã¹ã«é¢ããæ
å ±ãèŠã€ããŸããã
ããã«èŠåããŠãããŸãããç§ã¯ã³ãŒã¹éçºè
ããã®ç«¶åä»ç€Ÿãšã¯äžåé¢ä¿ããããŸããã èšäºå
ã®ãã¹ãŠã®å
容ã¯ãå°ãç®èãå«ãã ç§ã®äž»èŠ³çãªäŸ¡å€å€æã§ãã
ã§ã¯ãèŠåŽããŠçšŒãã 990 ã«ãŒãã«ãã©ãã«æè³ããã°ããã®ããŸã ããããŸããã? ããã§ã¯ãç«ã®äžã«ããããã
å°ãå眮ããšããŠãåå¿è
ãçæéã§ã100äžã«ãŒãã«ä»¥äžã®çµŠäžãåŸãæåããããŒã¿ã¢ããªã¹ããã«å€ããããšãã§ããææãªã³ãŒã¹ã«ã€ããŠã¯ãç§ã¯ããæççã§ããããšãè¿°ã¹ãŠãããŸãïŒããããã¿ã€ãã«åçãããããæšæž¬ããŠããã§ããããïŒèšäºïŒã
æ°å¹ŽåãããŒã¿ ãµã€ãšã³ã¹ ãã¬ãŒãã³ã°ã®ç©æ¥µçãªå®£äŒããã£ããã«ãç§ã¯ããŒã¿ ãµã€ãšã³ã¹ã®åéã§å°ãªããšãäœããç¿åŸããããã«ããŸããŸãªæ¹æ³ãè©ŠããèŠåŽããç¹ã«ã€ããŠã®ã¡ã¢ã Habr èªè ãšå ±æããŸããã
ã·ãªãŒãºã®ä»ã®èšäº1. åºæ¬ãåŠã³ãŸã:
ã倧å°åããããŒã¿ããã£ããïŒã â (Cognitive Class ã®ããŒã¿ ãµã€ãšã³ã¹ ã³ãŒã¹ã®æŠèŠ) ãä»ã圌ã¯ããªããæ°ããŠããŸãããŸãã¯ãŒãããã®ããŒã¿ãµã€ãšã³ã¹ ããªã¹ã«ãŒã®ä»£ããã«ã¢ã€ã¹ããŒã°ïŒã ãŸãã¯ãkaggle ã§ããŒã¿ãµã€ãšã³ã¹ã®åºç€ãåŠãŒããšããæ¹æ³ ãã§ããå°ããªãšã³ãžã³ïŒã ãŸãã¯ãæ©æ¢°åŠç¿ãšããŒã¿åæã®ã¹ãã·ã£ã©ã€ãŒãŒã·ã§ã³ãïŒããŒã¿ ãµã€ãšã³ã¹ã®åå¿è ã®èŠç¹ããïŒ
2. æåã®ã¹ãã«ãç·Žç¿ãã
ãRise of MachinesLearningããŸãã¯ããŒã¿ ãµã€ãšã³ã¹ãšé»çã¹ãã¯ãã«åæã®è¶£å³ãçµã¿åããããã® "æèšä»æãã®ãããªïŒ" ãŸã㯠Accord.NET Framework ã䜿çšãã C# ã§ã®æ©æ¢°åŠç¿ (ããŒã¿ ãµã€ãšã³ã¹) ãæ©æ¢°åŠç¿ã®åã䜿ã£ãŠãã ãããã«ãŒã¯ïŒã ãŸã㯠KSS ã«åŸã£ãç §æåšå ·ã®èªååé¡ ã4 åã®çµå©åŒãš XNUMX åã®è¬åãããŸãã¯ã¢ã¹ã¯ã¯æ¿åºã®ãªãŒãã³ããŒã¿ãåæããããã®ç·åœ¢ååž° ããã«ã³ã®ã¹ã«ã¿ã³ãžã®æçŽããŸã㯠Accord.NET ã䜿çšãã C# ã®ç·åœ¢ååž°ã«ããã¢ã¹ã¯ã¯ã®ãªãŒãã³ ããŒã¿ã®åæ
ãããŠä¹ ãã¶ãã«å¥ã®ã³ãŒã¹ãè©ŠããŠã¿ãããšã«ããŸããã
ã³ãŒã¹ã®èª¬æïŒ
ãããŒã¿ãµã€ãšã³ã¹ã§å§ãããã³ãŒã¹ã®èª¬æã§ã¯ãããã990ã«ãŒãã«ãè²»ãããåŸã次ã®ããšãçŽæãããŠããŸãã ïŒå·çæïŒ åå¿è åãã®ãããªè¬çŸ©ãšå®è·µçãªã¿ã¹ã¯ã®åœ¢åŒã§XNUMXé±éã®ã³ãŒã¹ãåããŸãã ãŸããã³ãŒã¹è²»çšã®äžéšãçšé¡æ§é€ã®åœ¢ã§è£åãããããšãå¿ããªãã§ãã ããïŒãã¹ãŠã®æžé¡ãéµéããããšãçŽæããŠããŸãïŒã
ãã®ã³ãŒã¹ã«ã¯ XNUMX ã€ã®æ¡ä»¶ãããã¯ããããXNUMX ã€ã¯ãããŒã¿ ãµã€ãšã³ã¹ããšã¯äœãã人æ°ã®ããåéã¯äœããããŒã¿ ãµã€ãšã³ã¹ã®åéã§ãã£ãªã¢ãç¯ãæ¹æ³ã«ã€ããŠèª¬æããŸãã XNUMX çªç®ã®ãããã¯ã§ã¯ãExcelãSQLãPythonãPower BIãData Culture ãšããããŒã¿åæçšã® XNUMX ã€ã®ããŒã«ã«ã€ããŠèª¬æããŸãã
ããŠããçŸå³ãããã ãªããšæããã³ãŒã¹æéãæ¯æããéå§æ¥ãåŸ ã¡ãŸãã
æåŸ ããŠãã³ãŒã¹éå§ã®åæ¥ã«å人ã¢ã«ãŠã³ãã«ãã°ã€ã³ããéçºè ããã®å¥ãã®èšèãã¹ã¯ããŒã«ããŠãåŸ æã®ã³ãŒã¹éå§ã®éç¥ãåŸ ã¡ãŸãã
æã¯æµããD-Day ãå°æ¥ãããã¬ãŒãã³ã°ãéå§ã§ããããã«ãªããŸããã æåã®ã¬ãã¹ã³ãéå§ãããšããããªè¬çŸ©ãè¿œå ææããã¹ãã宿é¡ãªã©ããªã³ã©ã€ã³åŠç¿ã·ã¹ãã ã«ããããã¹ããŒã ã衚瀺ãããŸãã CourseraãEDXãStepik ã䜿çšããããšãããå Žåã¯ãåé¡ã¯ãªãã¯ãã§ãã
ã³ãŒã¹å :
é çªã«è¡ããŸãããã æåã®ã¬ãã¹ã³ã®ãããã¯ã¯ãDS ã®æŠèŠ: åºæ¬ãå©ç¹ãå¿çšãã§ãåŸç¶ã®ãã¹ãŠã®ã¬ãã¹ã³ãšåæ§ã«ãããªè¬çŸ©ããå§ãŸããŸãã
ãããŠãæåãããåå¿ãã¡ã¯ãã®ã¢ãããŒãã«å°ãããŠããããã«æããããŸãã ãããã§ããããªããŸããã ç§ã®å€§å¥œããªãœé£ã®æŒ«ç»ããã
æåã®ç¬éãããã³ãŒã¹ã®ææãç¹å¥ã«é²é³ããããã®ã§ã¯ãªããä»ã®å ¬éã¬ãã¹ã³ãå°éã³ãŒã¹ããåããããã®ã§ããããšãããããŸãã åç»ã«ã åå¹ãããŠã³ããŒããªãã·ã§ã³ããããŸãã ãªãã©ã€ã³ã§èŠèŽããå Žåã
è¬çŸ©åŸã«ã¯ãææ¥ã®ããã®è¿œå è³æïŒãããªè¬çŸ©ããã®ãã¬ãŒã³ããŒã·ã§ã³ãšæšå¥šæç®ïŒãæäŸãããŸãããããããåæããããšã¯ãããŸããã
ãã®åŸãè©Šç·Žãç§ãã¡ãåŸ ã£ãŠããŸãã ãã¹ãã®è€éãã®çšåºŠãã察象ãšãªãå 容ã«å¯Ÿãã質åã®é©åæ§ã¯ããŸããŸã§ãã
ããã§ããã¬ãŒãã³ã°ã®çµæã«å¯Ÿããç¡é¢å¿ãçŸããŠããŸãã ãã¹ãã«å€±æããããšã¯ãããŸãããäœã圱é¿ããŸããã®å Žåã§ããã¬ãã¹ã³ã«ã¯æ£åžžã«åæ ŒããŸãããè¿œå ã®ååè¬ã®ãªã¯ãšã¹ãã«ã¯å¿çãããªãå¯èœæ§ãé«ããªããŸãã
ç¶ããŠãææ¥èšç»ããããªâè¿œå ãã ãææâãã¹ãããã³ãŒã¹å šäœã®åºæ¬ãšãªããŸãã
å Žåã«ãã£ãŠã¯ãã¬ãã¹ã³ãã¢ã³ã±ãŒããç¬èªã®å®¿é¡ã§èããããããšããããŸãã
宿é¡ã¯XNUMXã€ã ãã§ãã ãããŠæ£çŽã«èšããšãç§ã¯XNUMXã€ããåæ ŒããŸããã§ããã
æåã®å®¿é¡ã¯ãäž»èŠãªã¹ãã«ãæŠèª¬ããå±¥æŽæžãæåºããããšã§ãã 100ïŒ ãšã¯èšããŸããããã»ãŒã©ããªå±¥æŽæžã§ãåçããã課é¡ãåçããããšæãããŸãã 課é¡ã®çµäºåŸãè¿œå ã®è³æãã€ãŸãæšå¥šäºé ãéä¿¡ãããŸãã Coursera ã§å®¿é¡ã«èŠåŽããããšãæãåºããŠããã®ç°¡åãã«å°ãåæºããããŸããã
å°å ¥éšãçµäºãããããåŸ ã¡ããã®ãããŒââã¿ãµã€ãšã³ã¹å ¥éããŒã«ãã®åŠç¿ãå§ãŸããŸãã XNUMX ã€ç®ã¯ããExcel ã§ã®äœæ¥: ã¹ãã«ããŒãããã¢ããªã¹ãã«ã¢ããã°ã¬ãŒãããããšãã掟æãªã¿ã€ãã«ã®ã¬ãã¹ã³ã§ãã
ããïŒ é åçã«èãããŸãããå®éã«ã¯ãæåŸ ãšçŸå®ã®éã®éãã¯ããã¡ãŒã¹ãããŒãã®åºåã«ãããã³ããŒã¬ãŒã®åçãšãã¬ãžã§æž¡ããããã³ããŒã¬ãŒã®åçãšã®éã®éããšåãã§ãã
å®éãExcel ã®ã»ã«ã®èªåå ¥åãããVLOOKUP()ãé¢æ°ã®ãããã«ãã説æã«ç§»è¡ããéã«ãæåž«ãããã¹ããåŠãããšãã質åã®ããŒãã«ã€ããŠãã ã¬ããã®ããã«èºèºããæ§åã芳å¯ããŸããåå¿è åãã«ãã¹ãŠã説æããããŸãã¯ãããåãã«èå³æ·±ãè³æãæäŸãããã ç§ã®äž»èŠ³çãªæèŠã§ã¯ãã©ã¡ããããŸããããŸããã§ããã
ãã®ã³ãŒã¹ã«ã¯ã©ã€ããŠã§ãããŒãå«ãŸããŠããªãã«ãããããããç¹ã«çŽ æŽãããã§ãã ã€ãŸãããããã¯æ¬ åžããææ¥ã®é²ç»ã§ã¯ãªããåã«ãã£ãšåã«è¡ãããææ¥ã®é²ç»ã§ãïŒäžã®åçãåç §ïŒãèè ã¯ããã§ãé°å²æ°ãä¿åããããšã«æ±ºããŸããã (ãããã¯åã«æ ãè ã ã£ãã®ãããããŸãã) О æåž«ãé³å£°ã®åé¡ã解ãéãXNUMXåéèŠèŽãããŸã.
ãããªã®åŸã«ãæšæºçãªã¹ããŒã ã«åŸã£ãŠãè¿œå ã®è³æãšãã¹ããç¶ããŸãã
次ã®ãããã¯ã¯ SQL èšèªã«ã€ããŠã§ãã ãã®ã¬ãã¹ã³ã§ã¯ãSQL ã¯ãšãªã®æäœã®åºæ¬ãšäŸãæäŸããŸããååãšããŠãåæ§ã®ãããã¯ã«é¢ãããããªãšèšäºãèŠã€ããããšãã§ããŸãã ã€ã³ã¿ãŒãããã§ç¡æã§ç°¡åã«èŠã€ãããã.
SQL ã®åŸã«ã¯ãPython ã©ã€ãã©ãªãPandasãã䜿çšã㊠Kagle ããã®ããŒã¿ã»ãããåŠçããã¬ãã¹ã³ããããŸãã ææ¥èšç»ã¯ãããªâè¿œå ãšå€æŽãããŸããã ææâãã¹ãã è¿œå ã®ã¿ã¹ã¯ã¯æäŸããããçµæãèªåçã«ãã§ãã¯ããã¿ã¹ã¯ãããæäŸãããŸããã ãããã£ãŠãAnaconda ãã€ã³ã¹ããŒã«ããŠã³ãŒããèšè¿°ããå¿ èŠã¯ãããŸããã ãŸã ãããªè¬çŸ©ã®ã³ãŒãã®çŽ°ããéšåã«æ³šç®ããŠãã ããããé»è©±ã§èŠãã®ã¯ç¡æå³ã§ãã¢ãã¿ãŒã§ã»ãŒçã£çœã«èŠãªããã°ãªããŸããã§ããã
ã¬ãã¹ã³ 10: ãXNUMX åã§ã® PBI ã§ã®ç©æµã¬ããŒãã®èŠèŠåã (вОЎеП кÑÑаÑО ЎлОÑÑÑ ÐŒÐžÐœÑÑ 50)
ã ãã®ãããªã§ã¯ãPower BI ãšããèå³æ·±ãããŒã«ã«ã€ããŠè©±ããŸãããæ£çŽã«èšããšãç§ã¯ãããŸã§èããããšããããŸããã§ããã
äºæãã¬ã³ãŒã¹ã®çµãã:
æåŸã® XNUMX çªç®ã®ã¬ãã¹ã³ã§ã¯ãé©åãªããŒã¿ ã¹ãã¬ãŒãžã®äžè¬ååã«ã€ããŠèª¬æããŸãããã®è¬çŸ©ããŸãå¥ã®ã³ãŒã¹ããåãå ¥ããããŠããŸãã ãã®ææ¥ã§ã¯å®æãã¹ãã«å ããŠãŸã宿é¡ãåºãŸãããç§ã¯ãããŸããã§ããã ãã®çç±ãç¥ãããã§ãã?
ãšããã®ã¯ãä»æ¥ãŸã ååããçµãã£ãŠããªãè¬åº§ã®ããŒãžãéãããããããªã®ããã£ãããã§ãã
ã€ãŸã å®éã«ã¯ã³ãŒã¹ãå®äºããŠããªãã«ãããããããã·ã¹ãã ã¯ç§ãã³ãŒã¹ãæ£åžžã«å®äºãããšã¿ãªããŸããã.
ããã«ãæ®ãã®ãã¹ãŠã®ãããªãèŠèŽããŠãã¹ããè¡ã£ãåŸãã«ãŠã³ã¿ãŒã¯å€åããã56% ã®ãŸãŸã§ããã ããã ãšæããŸã ãŸã£ããäœãèŠãããã¹ããåããã«ãåæ¥èšŒæžããååŸããããšãã§ããŸããã.
ç¹ã«é©ãã¹ãããšã¯ããã®ã³ãŒã¹ã¯æ£åŒã«22æ14æ¥ãã04.08.2019æXNUMXæ¥ãŸã§ç¶ããXNUMX幎XNUMXæXNUMXæ¥ã«ãã§ã«ãåæ¥èšŒæžããç§ã«çºè¡ããããšããããšã§ãã
ç ä¿®ã®ææ
ãã¬ãŒãã³ã°ãå®äºãããšãå瀟ã®ãŠã§ããµã€ãã«ã¯ãæå®ã®åœ¢åŒã®æžé¡ã«ãã£ãŠè³æ Œã確èªããŸãããšçŽæãããŠããŸãã ãããåé¡ã¯ããã®ã³ãŒã¹ã¯åãã¬ãŒãã³ã° ããã°ã©ã ã§ãé«åºŠãªãã¬ãŒãã³ã° ããã°ã©ã ã§ããªãããã§ããã€ãŸããåã«ååŸããã ãã§ãã ååãšããŠå ¬çå°äœãæããªãã蚌ææžã.
ãããããã990 ã«ãŒãã«ã«äœãæåŸ
ããŠããŸããã?ããšãã質åãåœç¶ã§ãããã æ£çŽã«èšããšãäœãæåŸ
ããŠããŸããã§ããã é«å質ã®ã³ãŒã¹ã¯ããªãé«äŸ¡ã§ããããšã¯æããã§ãã ããããåé¡ã¯ããããããå£ããªãã ãã§ãªããäœåãå°éçã«äœãããç¡æã®ã³ãŒã¹ãããããšã§ããããšãã°ã
å©ç¹ã® XNUMX ã€ã¯ããããã®ã¬ãã¥ãŒè³æã XNUMX ãæã«éããããŠãããããããŒã¿ ãµã€ãšã³ã¹ã«ãŸã£ããæ £ããŠããªã人ã§ããã®åéãããã²ãŒãããã®ãéåžžã«ç°¡åã«ãªãããšã§ãã
ã³ãŒã¹ã®æåŸã«ã¯ãããããã®ããŒã«ãåŠã³ãå±¥æŽæžã«æ¬¡ã®ãããªããšãæžããããã«ãªãããšãçŽæãããŠããŸãã
å®éã« ããã¯éåžžã«åŒ·ãèªåŒµã§ãã åºæ¬çã«ã¯å€ãã®æ¥œåšã«ã€ããŠèãã ãã§ããã以äžã®ããšã¯äœããããŸããã
ãµããªãŒ
ç§ã®æèŠã§ã¯ããã®ã³ãŒã¹ã«ã¯æäœéã®æçšãªå 容ãå«ãŸããŠããŸãããç¹ã«æ®å¿µãªã®ã¯ãäœæè ãæ æ°ãããŠåå¥ã®ãããªè¬çŸ©ãé²ç»ããããšãã§ããªãã£ãããšã§ãã è¯ãæå³ã§ããã®ãããªããšã«ãéãæ±ããã®ã¯æ¥ãããããããã㯠10 åã® XNUMX ãèŠæ±ããã¹ãã§ãã
ãã ããäžèšã¯ãã¹ãŠç§ã®äž»èŠ³çãªäŸ¡å€å€æã§ããããã®ã³ãŒã¹ãåè¬ãããã©ããã¯ããªã次第ã§ããããšãããäžåºŠç¹°ãè¿ããŸãã
PS ãããããæéã®çµéãšãšãã«ã³ãŒã¹ã®äœæè
ãã³ãŒã¹ãå®æãããèšäºå
šäœã®é¢é£æ§ã倱ãããã§ãããã
念ã®ããæžããŠãããŸãããæå¹æéã¯22æ14æ¥ããXNUMXæXNUMXæ¥ãŸã§ã®ãã®ã³ãŒã¹ã®ååèµ·åæã§ãã
PPS æçš¿ãéåžžã«å€±æããããšãå€æããå Žåã¯åé€ããŸãããæåã¯æ¹å€ãèªã¿ãããšæããŸããããããäœããç·šéããå¿
èŠããããããããŸããã ããã§ãªããã°ãä»ã®ãšãããããã¯äœå質ã®ã³ãŒã¹ã«å¯Ÿãããã€ãã¹ã®äžéœåãªæ¹å€ã®ããã«èŠããŸã
åºæïŒ habr.com