
ThatsWhatSheSaydã«ããã·ã£ãŒããã¯
åå€§ãªæ¢åµã«ãªãããã«ãã·ã£ãŒããã¯ã»ããŒã ãºã¯ãä»ã®äººãç®ã«èŠããªããã®ã§èŠãªãã£ãããšã«æ°ä»ãã®ã«ååã§ããã ãã¹ãŠã®æ©æ¢°åŠç¿ã®å°éå®¶ã«ããã®å質ãå¿
èŠã ãšæããŸãã ããããFeature Engineeringã®ããŒãã¯ãå€ãã®å Žåãæ©æ¢°åŠç¿ãšããŒã¿åæã³ãŒã¹ã§ã²ãšç®ã§ããããŸãã ãã®èšäºã§ã¯ã屿§ãåŠçããçµéšãåå¿è
ã®ããŒã¿ã»ã³ãã£ã¹ããšå
±æããããšæããŸãã ãããã圌ããæåã®èª²é¡ã解決ããäžã§ãããè¿
éã«æåãåããããšã«åœ¹ç«ã€ããšãé¡ã£ãŠããŸãã ãã®éšåã®ãã¬ãŒã ã¯ãŒã¯å
ã§ãæŠå¿µçãªåŠçæ¹æ³ãèæ
®ãããããšãããã«äºçŽããŸãã ãã®è³æã®å®çšçãªéšåã¯ãç§ã®ååã®Osina_Anyaã«ãã£ãŠãŸããªãå
¬éãããŸãã
æ©æ¢°åŠç¿ã®äžè¬çãªããŒã¿ãœãŒã¹ã®1ã€ã¯ãã°ã§ãã ãã°ã®ã»ãšãã©ãã¹ãŠã®è¡ã«æéããããŸããWebãµãŒãã¹ã®å Žåã¯ãIPãšUserAgentããããŸãã ãã®ããŒã¿ããã©ã®ãããªå
åãæœåºã§ããããæ€èšããŠãã ããã
æé
UnixTimestamp
UnixTimestampã¯ã1970-01-01 00ïŒ00ïŒ00.000ããçµéããç§æ°ã§ãäžè¬çãªæéã®è¡šçŸã§ãããèªç¶æ°ã§ãã ãã®åœ¢åŒã§ã¢ãã«ã«æéã远å ã§ããŸããããã®ã¢ãããŒãã¯ååž°åé¡ã§ããæ©èœããŸãã ã€ãã³ãã®ã·ãŒã±ã³ã¹ã«é¢ããæ
å ±ã®ã¿ãUnixTimestamp圢åŒã§ä¿åãããã¢ãã«ã¯ææ¥ãæãæéãªã©ã«ã€ããŠäœãç¥ããªããããåé¡ã¿ã¹ã¯ã§ã¯ãã£ãã«æ©èœããŸããã
幎ãæãæ¥ãæéãåãç§ãææ¥
å€ãã®å Žåãæéã¯èªç¶æ°ã®ã»ããã®åœ¢åŒã§ã¢ãã«ã«è¿œå ãããŸãã幎ãæãªã©ãå¿
èŠãªè©³çްã«å¥ã
ã«è¿œå ãããŸãã ããšãã°ã2017-09-08 12ïŒ07ïŒ12.997ã¯ã2017ã09ã08ã12ã07ã®5ã€ã®ãµã€ã³ã«å€æã§ããŸãããŸãããã€ããªãµã€ã³ã远å ããããšãã§ããŸãïŒäŒæ¥ãã©ãããæé垯ãå€åæéãã©ãããªã©ããªã©ããã®ãããªæ©èœã®ã»ãããæåãããšãã»ãšãã©ã®å Žåãé«å質ã§åé¡ã解決ã§ããŸãã æã
ãOneHotEncoding Creationã¡ãœããã¯æ°ãæ/æ°å¹Žéæ©èœããŸãããããã¯ç·Žç¿ããããšããŸããã¯ã§ãã
ãµãŒã¯ã«è¡šç€º
å€ãã®å Žåãåã
ã®ã³ã³ããŒãã³ãã®ã»ãããšããŠæéã衚ãã ãã§ååã§ããã1ã€ã®åŒ±ç¹ããããè¿œå æ©èœã®è¿œå ãå¿
èŠã«ãªãå ŽåããããŸãã
çŸåšã®æéã«åŸã£ãŠãäººãæºåž¯é»è©±ãåãäžããçç±ã倿ãã-é³ãæ¶ãããã¢ã©ãŒã ãèšå®ãããšããã¿ã¹ã¯ããããšããŸãã ããã«ãå±¥æŽããŒã¿ããã人ã23.00ãã01.00ã«ã¢ã©ãŒã ãèšå®ãã07.00ãã21.00ã«ã¢ã©ãŒã ããªãã«ããããšãããããŸãã ããžã¹ãã£ãã¯ååž°ã«ãã£ãŠåé¡ã®è§£æ±ºãéå§ããå Žåãæ¬¡ã®å³ã®åå²é¢ãæ§ç¯ããå¿
èŠããããŸãã

æããã«ã圌女ã¯ãããè¡ãããšãã§ããŸããããã®ãããªæéã®èŠæ¹ã¯ã23.00ãš01.00ãéåžžã«è¿ãã€ãã³ãã§ãããšããæ
å ±ã倱ããŸãã ãã®å Žåã2次èšå·ã远å ã§ããŸãããããè¯ãæ¹æ³ããããŸãïŒ ãã®ãããªåé¡ã解決ããã«ã¯ã次ã®ãã¯ããã¯ã圹ç«ã¡ãŸãããµã€ã¯ã«ã§å€åããããšãããã£ãŠãããµã€ã³ãåããŸãã ããšãã°ããæéã-0ãã23ã«å€ãããŸãããããŠãcosïŒãæéã 2 pi / 24ïŒãsinïŒãæéã 2 pi / 24ïŒã®2ã€ã®èšå·ã«å€æããŸããäžå¿ã0ã§çŽåŸã1ã®åäœåã®ãµã€ã¯ã«èŠçŽ ã

éåžžã«å€ãã®ãã€ã³ãã«ã€ããŠãããžã¹ãã£ãã¯ååž°ã¯ç°¡åã«åå²é¢ãèŠã€ãã人ãã¢ã©ãŒã ãèšå®ããã®ã«åœ¹ç«ã¡ãŸãã ææ¥ãæããã¹ãã³ãµã€ã¯ã«ãªã©ã§ãåãããšãã§ããŸããçè«çã«ã¯ããã®æ¹æ³ã¯ããŒãªãšçŽæ°å±éã䜿çšããŠããè€éãªåšæé¢æ°ã«è£éã§ããŸããããã®ãããªå Žåã¯çºçããŸããã
IPã¢ãã¬ã¹
IPã«ã€ããŠäžèš
äžèŠãIPã¢ãã¬ã¹ã¯éèŠãªå
åã§ããããããã©ããããã¯å®å
šã«çè§£ã§ããŸããã çŸåšæãäžè¬çãªããªã¢ã³ãã¯IPV4ã§ããããã¯ãäŒçµ±çã«ã255.0.0.1ããšèšè¿°ãããŠãã4ãã€ãã®ã·ãŒã±ã³ã¹ã§ãã ãããã®çªå·ãŸãã¯ãã¹ãŠã®IPãæ°åèšå·ã®ããã«äœ¿çšããããšã¯çµ¶å¯Ÿã«æ£ãããããŸããã 2ã€ã®IPã¢ãã¬ã¹ïŒ123.123.123.123ãš124.123.123.123ïŒãããå Žåããããã®çªå·ã®è¿æ¥ã¯ãŸã£ããæå³ããããŸããïŒæåã¯China Unicom Beijingçãããã¯ãŒã¯ã2çªç®ã¯Beam Telecom Pvt Ltdã§ãïŒã IPããµããããåã䜿çšããã«ããŽãªãŒãšèŠãªãã®ã¯æ£ããã§ãããããå€§èŠæš¡ãªãµãŒãã¹ã«ã¯ãã®ãããªã«ããŽãªãŒã倿°ãããŸãã ããšãã°ã第3ã¬ãã«ã®ãµããããäžã®ã«ããŽãªãèæ
®ãããšã2 ^ 24-ã10 ^ 16ã«ãªããŸãã 1600äžãè¶
ãã屿§ãæã€ã¢ãã«ããã¬ãŒãã³ã°ããã«ã¯ã倧éã®ããŒã¿ãæ¬åœã«å¿
èŠã§ãããã»ãšãã©ã®å ŽåãäžèŠãªãã€ãºãçºçããŸãã

https://xkcd.com/742/
ãžãªãã±ãŒã·ã§ã³
å®éããããã¯ãŒã¯ãããããã¯ããã«å€ãã®æ
å ±ãIPããååŸãããŸãã ãã®ãããåœãå°åãå Žåã«ãã£ãŠã¯ãµãŒãã¹ã®ãŠãŒã¶ãŒãããéœåžãŸã§ããIPã¢ãã¬ã¹ããæ£ç¢ºã«æœåºãããŸãã ãããè¡ãã«ã¯ã次ã䜿çšã§ããŸãã
- çŸåšè±å¯ãªãªãŒãã³GeoIPããŒã¿ããŒã¹ã¯ããã®å€ããç¡æã®APIãæäŸããŠããŸãã äž»ãªããšã¯ãããããéè² è·ã«ããªãããšã§ãïŒ1åããã100-1000ãªã¯ãšã¹ã以äžïŒã 倧éã®ããŒã¿ãå¿
èŠãªå Žåã¯ãMindMaxãªã©ã®äŒæ¥ãã宿çã«æŽæ°ãããããŒã¿ããŒã¹ã賌å
¥ã§ããŸãã
- WhoIsãµãŒãã¹ãå€ãã®IPã¢ãã¬ã¹ã®ææè
ã«é¢ããå
¬éæ
å ±ïŒäžè¬ãŠãŒã¶ãŒã®å Žåããããã€ããŒã«é¢ããïŒãå
¬éããŸãã ãã®ããŒã¿ãååŸããã«ã¯ã httpsïŒ //www.nic.ru/whois/ãªã©ã®WhoIsãµãŒãã¹ã®1ã€ããŸãã¯Pythonããã±ãŒãžã䜿çšã§ããŸã ã ããšãã°ãæºåž¯é»è©±ã®IPã¢ãã¬ã¹ã¯176.59.41.95ã«ãªããŸããã WhoIsãµãŒãã¹ã¯ãIPãRussian Tele2ã«å±ããŠããããšã瀺ããŠããŸãã ã©ã®IPã§ãåãæäœãè¡ã£ãŠãã®åœã調ã¹ãããšãã§ããŸãããIPã¢ãã¬ã¹ã®ææè
ã«ã€ããŠæäŸãããæ
å ±ã®éã¯ã±ãŒã¹ããšã«ç°ãªããŸãã ããã«ãç¹å¥ãªIPã¢ãã¬ã¹ãããããšãå¿ããªãã§ãã ãã ã ããã§ãããã«ã€ããŠèªãããšãã§ããŸã ã
åæ§ã®ãµãŒãã¹ããIPã«ã€ããŠååŸããããŒã¿ãæ
éã«åŠçããŸãã ããŒã¿ã¯æã
å€ããªã£ãããæã«ã¯ãšã©ãŒãçºçãããããŸããåãIPãæã€1人ã®ãªãã¬ãŒã¿ãŒããã¢ã¹ã¯ã¯ãšãŠã©ãžãªã¹ãã¯ãåºãããšãå€ããããã¢ãã€ã«éä¿¡ãªãã¬ãŒã¿ãŒã®IPã¢ãã¬ã¹ã¯äžè¬ã«å€§ããªåé¡ã§ãã ãããã£ãŠããã°ã«èšèŒãããŠããã€ãã³ããçºçããæç¹ã§ããŒã¿ããŒã¹ã®ããŒãžã§ã³ããªããªã£ãŠããå¯èœæ§ãããããããµã€ã³ã®åéæã§ã¯ãªããåä¿¡æã«ãã°ã«ãããã®è¿œå ãã£ãŒã«ããäœæããããšããå§ãããŸãã ã¢ãããŒãã®ãã©ã¹ïŒãã·ã¢ã§åºäŒã£ãIPããšãŒãããã«ç§»åããããŸãã¯ãã®éã®äºå®ã远跡ã§ããŸãã ãã ãããããã®æ³šæäºé
ãããå Žåã§ãããã®é¢æ°ã¯ããŒã¿åæã«éåžžã«åœ¹ç«ã¡ãã¢ãã«ã®å質ã倧å¹
ã«åäžãããããšãã§ããŸãã
ãã®ã¢ã€ãã ã®è¿œèš
ãµãŒãã¹ãååã«å€§ããå Žåã¯ãGeoIPããŒã¿ããŒã¹ãèªåã§åéã§ããŸãã ãŠãŒã¶ãŒããµã€ã/ã¢ããªã±ãŒã·ã§ã³ã«ãžãªãã±ãŒã·ã§ã³ãžã®ã¢ã¯ã»ã¹ãæäŸãããšãç¹å®ã®IPã¢ãã¬ã¹ã®å Žæã«é¢ããæ
å ±ãèªåçã«åãåããŸãã å°ççäœçœ®ãåºããå°ççã«åºãIPã¢ãã¬ã¹ã䜿çšããå Žåã®å¯ŸåŠæ¹æ³ãçè§£ããå¿
èŠãããã®ã¯ããªãã ãã§ãã ããã«ããã®ææ³ã䜿çšãããšããŠãŒã¶ãŒãã©ãããæ¥ãã®ããæšæž¬ã§ããŸããèªå®
ãããè·å Žãããå€åºäžã§ãã
IPã¢ãã¬ã¹ã®æž
æµåºŠ
ããŒã¿åæã®ããã«ãããããæ€çŽ¢ãããããããã³åæ§ã®ãæªéãã®ã¢ã¯ã·ã§ã³ããå®éã®ãŠãŒã¶ãŒã®ã¢ã¯ã·ã§ã³ããã£ã«ã¿ãªã³ã°ãã䟡å€ãããå ŽåããããŸãã å
ã®å®åŒåã§ã¯ããã®ã¿ã¹ã¯ã¯éåžžã«è€éã§ãã¹ãã 察çãè©æ¬ºå¯Ÿçãªã©ã®å€ãã®åéã§äœ¿çšãããŠããŸãã ããããããŒã¿ããã£ã«ã¿ãªã³ã°ããã¿ã¹ã¯ã«ã€ããŠã¯ãIPã«ãããã£ã«ã¿ãªã³ã°ãšããããåçŽãªæ¹æ³ã§ååãªå ŽåããããŸãã ãã®ãããã€ã³ã¿ãŒãããäžã§ãè©æ¬ºãdDoSæ»æãé »ç¹ã«å®è¡ãããIPã¢ãã¬ã¹ãtor-exitnode IPã¢ãã¬ã¹ïŒãããã¯ãµãŒãã¹ãžã®é »ç¹ãªãªã¯ãšã¹ãã«å¯ŸããŠIPããããã³ã°ããã€ãã¹ããããã«äœ¿çšããããšãå€ãïŒããã³ãªãŒãã³ãããã·ã®IPã¢ãã¬ã¹ã®ãªãŒãã³ãªã¹ããèŠã€ããããšãã§ããŸã-serversïŒåãç®çã§äœ¿çšãããå ŽåããããŸãïŒã ãã®ãããããããã®ããŒã¿ããŒã¹ã®IPã¢ãã¬ã¹ããã©ã°ãç¹åŸŽãã¯ãã«ã«è¿œå ã§ããŸãã ããã«ãå±¥æŽããŒã¿ã«ãããšããã°ã®ãã®è¡ã®IPã¢ãã¬ã¹ãšåããããã€ããŒãæºããå¯èœæ§ãèæ
®ããããšãã§ããŸãã ãã®ç¢ºçã¯å
åã«ããªãåŸãŸãã圌ã ãããã€ããŒãã©ã¡ãŒã¿ãŒãæã£ãŠããŸãã確çãèšç®ããããã«ã¹ããŒãªãŒãã©ããŸã§èŠããã§ãã ããã¯éèŠã§ãããŠãŒã¶ãŒã®ååžãšããã®çµæãšããŠããµãŒãã¹äžã®ãŠãŒã¶ãŒãããã€ããŒã®ååžãå€åããŠããããã§ãã
ãæªæã®ããããŠãŒã¶ãŒã®ãã£ã«ã¿ãªã³ã°ã®åé¡ã«æ»ããšãç§ã¯æ³šæããŠãã ãããæšæºçãªæ¹æ³ã¯ãä¿¡é Œã§ãããã©ãã¯ãªã¹ãã«è¡šç€ºãããIPã¢ãã¬ã¹ãããã°ããã£ã«ã¿ãªã³ã°ããããšã§ãã åæã«ãããããéå§ãããŠãŒã¶ãŒã¯ãä¿¡é Œã§ããã¢ã¯ã·ã§ã³ãæè¿å®è¡ãããŠãŒã¶ãŒã®ãªã¹ãã«å±ããŠããŸããã è¯ããŠãŒã¶ãŒã§ããæã
Torããããã·ã«ç®ãåããã®ã§ããããã®æ¡ä»¶ã¯ã©ã¡ããåæ§ã«éèŠã§ãããè¯ããŠãŒã¶ãŒã¢ã«ãŠã³ãã¯ãããã³ã°ãããå¯èœæ§ããããŸãã ãããã£ãŠã圌ãå®åšã®äººç©ãšããŠç¹åŸŽä»ããè¡åã¯ãæè¿çºçããªããã°ãªããŸããã
ãŠãŒã¶ãŒãšãŒãžã§ã³ã
UserAgentã«ã€ããŠå°ã
HTTPãããã³ã«ã«ã€ããŠè©±ããŠããå Žåããªã¯ãšã¹ãããããŒã§ãµãŒããŒã«ãªã¯ãšã¹ããéä¿¡ãããœãããŠã§ã¢ã¯ããœãããŠã§ã¢ããŒãžã§ã³ãšãªãã¬ãŒãã£ã³ã°ã·ã¹ãã ã«é¢ããæ
å ±ãå«ãUser-Agentãã£ãŒã«ããæž¡ããŸãã ãã®ããããŒãã£ãŒã«ãã¯ãå€ãã®å Žåãã¢ãã€ã«ããŒãžã§ã³ã®ãµã€ããŸãã¯JSã䜿çšããªããµã€ãããŒãžã§ã³ã«ãªãã€ã¬ã¯ãããŸãã ãã©ãŠã¶ã®ããŒãžã§ã³ãšãªãã¬ãŒãã£ã³ã°ã·ã¹ãã ã«å ããŠãUserAgentã«ã¯ä»ã®æçšãªæ
å ±ãå«ãŸããŠããå ŽåããããŸãããååŸãé£ããå ŽåããããŸãã å®éãUser-Agentæååã«ã¯æ¿èªãããåäžã®åœ¢åŒã¯ãªãã誰ããå¿
èŠã«å¿ããŠæ
å ±ãæžã蟌ã¿ãŸãã UserAgentè¡ãããã©ãŠã¶ãšãªãã¬ãŒãã£ã³ã°ã·ã¹ãã ãæœåºã§ããããŸããŸãªã©ã€ãã©ãªãããã奜ã¿ã«å¿ããŠéžæã§ããŸãã å人çã«ã¯ã https://github.com/ua-parserã奜ãã§ãã
OSããœãããŠã§ã¢ãäœãé£ããã§ããïŒ
ãã©ãŠã¶ãšãªãã¬ãŒãã£ã³ã°ã·ã¹ãã ã¯ãããã€ã¹ã®çš®é¡ã«é¢ä¿ãªããOneHotEncodingã䜿çšããŠã«ããŽãªæ©èœãšããŠè¿œå ã§ããŸãã ãã®ããã ãã«ããã©ãŠã¶ãšãªãã¬ãŒãã£ã³ã°ã·ã¹ãã ãæ³šææ·±ãèŠãå¿
èŠããããŸãã ãã ããUserAgentã䜿çšãããšãWebKitã䜿çšããŠãæ€çŽ¢ããããPythonã¹ã¯ãªãããããã°ã©ã ãããã³ã«ã¹ã¿ã ãã©ãŠã¶ãŒãã«ããèå¥ã§ããŸãã ãã®å€æ°ã®å¯èœæ§ã«ãã£ãŠã®ã¿ã倿°ã®åé¡ãçºçããŸãã UserAgentæååã«ã¯äœã§ãæžã蟌ãããšãã§ãããã«ãŠã§ã¢éçºè
ã¯ããã䜿çšããŸãããµãŒããŒã§ã¯ããã¹ãŠãäžè¬ãŠãŒã¶ãŒãã³ã³ãã¥ãŒã¿ãŒã«Chromeãã©ãŠã¶ãŒãšWindows 10ãæã£ãŠããããã«èŠããŸãã ãããã£ãŠãUserAgentããã®ããŒã¿ã«éåžžã«æ³šæãããã©ãŠã¶ã®ããŒãžã§ã³çµ±èšã®ç°åžžã«æ³šæããå¿
èŠããããŸãã ãã®äžã§ãéåžžã«å€ãããŒãžã§ã³ã®ã¯ãã ãåŸè
ãããã¯ããã«äººæ°ãããããšã«æ°ä»ãããå€ãã¢ã³ããã€ãããã®ããã©ãã·ã¥ããèŠãããšãã§ããŸãã ããã«ãIPã®å Žåãšåæ§ã«ãåšæ³¢æ°åæã圹ç«ã¡ãŸãã ã»ãšãã©ã®å Žåãããããéçºè
ã¯ã察象ãŠãŒã¶ãŒããã®ãã©ãŠã¶ã®ååžãç¥ãããã€ã³ã¿ãŒããããŠãŒã¶ãŒéã®UserAgentã®ååžã§ããŒã¿ããŒã¹ããUserAgentãååŸããŸããããŒã¿ããŒã¹ã¯ãå°çããµãŒãã¹ã®å¯Ÿè±¡ãŠãŒã¶ãŒãªã©ãšäžèŽãããå€ããªãå¯èœæ§ããããŸãããã®ããŒã¿ã䜿çšããªãçç±ã ããã¯ããããããã詳ããèŠãŠãããã«æçšãªæ
å ±ãæœåºããæ©äŒã§ãã
ãããã«
ç¹æ§è©äŸ¡ã¯ãããŒã¿åæã®éèŠãªã¹ãããã§ãã å€ãã®å Žåãåå¿è
ã®ããŒã¿ã»ã³ãã£ã¹ãã¯ãè€éãªã¢ãã«ã®åé¡ãå€å±€ãã¥ãŒã©ã«ãããã¯ãŒã¯ã®æ§ç¯ãåé¡ã®è§£æ±ºãå¯èœãªå Žåã®ããŸããŸãªã¢ã«ãŽãªãºã ã®ã¢ã³ãµã³ãã«ã®äœæãéå§ããããžã¹ãã£ãã¯ååž°ã«é©åãªå
åãæ
éã«è¿œå ããŸãã ãã¬ãŒãã³ã°ã³ãŒã¹ã§ã¯ãã£ãã«èæ
®ãããªãããå®éã®äœæ¥ã§ããèŠãããããŒã¿ã«ã€ããŠè©±ããŸããã ãã®æ
å ±ãã圹ã«ç«ãŠã°å¹žãã§ãã
ãæž
èŽããããšãããããŸãã-ãããŠå¹žéãïŒ