Share
Embed
Transcript
24 slides
-
#2ར༻·Ͱͷงғؾ #JH2VFSZ (PPHMF $MPVE 4UPSBHF 'JSFCBTF "OBMZUJDT -PDBM 4UPSBHF FH$47
'MVFOUE ɾ &NCVML 8FC$POTPMF (PPHMF 4QSFBETIFFU (PPHMF %BUBTUVEJP +VQZUFS /PUFCPPL ʜ ʜ -
#JH2VFSZ.- .-.BDIJOF-FBSOJOH wྑ͍ͱ͜Ζ w#2ͰػցֶशϞσϧΛ࡞ɾ࣮ߦͰ͖Δ w#2Λطʹ༻͍ͯ͠Δ߹ͦͷ··͑Δ w42-ͷࣝΛར༻Ͱ͖Δ wαϙʔτ͞Ε͍ͯΔϞσϧͱ༻్ྫ wઢܗճؼ wച্༧ଌ w߲ϩδεςΟοΫճؼϞσϧ
wϢʔβʔ͕Λങ͏͔ങΘͳ͍͔ wଞΫϥεྨϩδεςΟοΫճؼ wϢʔβʔͷᅂʢڵຯͷ͋Δ৯ͷδϟϯϧʣ -
Ϟσϧ࡞ CREATE MODEL `bqml_tutorial.sample_model` OPTIONS(model_type='logistic_reg') AS SELECT IF(totals.transactions IS NULL,
0, 1) AS label, IFNULL(device.operatingSystem, "") AS os, device.isMobile AS is_mobile, IFNULL(geoNetwork.country, "") AS country, IFNULL(totals.pageviews, 0) AS pageviews FROM `bigquery-public- data.google_analytics_sample.ga_sessions_*` WHERE _TABLE_SUFFIX BETWEEN '20160801' AND '20170630' -
Ϟσϧ࡞ CREATE MODEL `bqml_tutorial.sample_model` OPTIONS(model_type='logistic_reg') AS SELECT IF(totals.transactions IS NULL,
0, 1) AS label, IFNULL(device.operatingSystem, "") AS os, device.isMobile AS is_mobile, IFNULL(geoNetwork.country, "") AS country, IFNULL(totals.pageviews, 0) AS pageviews FROM `bigquery-public- data.google_analytics_sample.ga_sessions_*` WHERE _TABLE_SUFFIX BETWEEN '20160801' AND '20170630' ϩδεςΟοΫճؼͷϞσϧΛ࡞Δ ༧ଌͷϥϕϧʢܾࢉͨ͠PSͯ͠ͳ͍ʣ ༧ଌϥϕϧMBCFMΧϥϜͰ015*0/4Ͱ ࢦఆͰ͖Δ 4&-&$5ͨ͠σʔλͰֶश 4&-&$5͍ͯ͠Δ֤ΧϥϜΛύϥϝʔλͱͯ͠νϡʔχϯά͢Δ -
ϞσϧͷධՁ #standardSQL SELECT * FROM ML.EVALUATE(MODEL `bqml_tutorial.sample_model`, ( SELECT IF(totals.transactions
IS NULL, 0, 1) AS label, IFNULL(device.operatingSystem, "") AS os, device.isMobile AS is_mobile, IFNULL(geoNetwork.country, "") AS country, IFNULL(totals.pageviews, 0) AS pageviews FROM `bigquery-public- data.google_analytics_sample.ga_sessions_*` WHERE _TABLE_SUFFIX BETWEEN '20170701' AND '20170801')) .-&7"-6"5& ͰϞσϧΛධՁ͢Δ ධՁσʔλϞσϧ࡞࣌ʹͬͨͱҧ͏ͷΛར༻͍ͯ͠Δ ֤ࢦඪͷݟํνϡʔτϦΞϧͷεςοϓ -
ϞσϧΛͬͯ༧ଌ #standardSQL SELECT country, SUM(predicted_label) as total_predicted_purchases FROM ML.PREDICT(MODEL `bqml_tutorial.sample_model`,
( SELECT IFNULL(device.operatingSystem, "") AS os, device.isMobile AS is_mobile, IFNULL(totals.pageviews, 0) AS pageviews, IFNULL(geoNetwork.country, "") AS country FROM `bigquery-public-data.google_analytics_sample.ga_sessions_*` WHERE _TABLE_SUFFIX BETWEEN '20170701' AND '20170801')) GROUP BY country ORDER BY total_predicted_purchases DESC LIMIT 10 wࠃ͝ͱͷਫ਼ࢉྃΛ༧ଌ w.-13&%*$5ؔͷ4&-&$5Ͱೖྗ w݁ՌQSFEJDUFE@MBCFMʹPSͰೖΔ wQSFEJDUFE@MBCFM@DPMVNO@OBNFͱ͍͏໋໊نଇ -
w.-ෑډ͕͘ͳ͖͍ͬͯͯΔ w#JH2VFSZ.-ͰֶशͰ͖ΔϞσϧͷΑ͏ʹయܕతͳ ͷͳΒखܰʹ͑Δ w'JSFCBTF.-,JUͰ༻ࡁΈϞσϧΛ༻Ͱ͖ͨΓ wͳΜ͔͍͍ײ͡ʹϞσϧΛ࡞Δ͜ͱ͕Ͱ͖ͯϞσϧΛ ͏ଆͱͯ͠ҙࣝ͢Δ͜ͱ͋Δ wධՁ݁Ռͷݟํ wαʔϏεಛੑͱরΒ͠߹Θͤͯඞཁͳਫ਼ͷೝࣝ wΞϓϦέʔγϣϯͷϞσϧͷΈࠐΈ wϞσϧͷߋ৽Մೳੑ
wਫ਼ͷϞχλϦϯά wσʔλੜϞϊ wϞσϧ͕ݹ͘ͳͬͯਫ਼͕མ͖͍ͪͯͯͳ͍͔ wࠓޙ͜ͷลΓΛѻ͑ΔΑ͏ʹͳΔͱڧͦ͏ -
w ͷهࣄͳͷͰࠓҧ͏͔ w IUUQTDMPVEHPPHMFDPNCMPHQSPEVDUTHDQCJHRVFSZ VOEFSUIFIPPE w ྻࢦ%#ͱΫΤϦͷׂ౷࣏ w ԣʹ͢Ε͢Δ΄Ͳ͍ͷͰɺຊʹେྔͷϦιʔεΛ͑Δ (PPHMFͳΒͰͷαʔϏε
w %SVNFMΫΤϦ࣮ߦΤϯδϯ w ΫΤϦΛׂͯ͠ॲཧ͠ɺ࠷ऴతʹΈ্͛Δ·Ͱ w $PMPTTVTࢄετϨʔδ w ΧϥϜ୯ҐͰσʔλΛѹॖ w #PSHΫϥελϚωʔδϟ w ेສͷϚγϯͰಈ࡞͢ΔΫϥελ w Ϛγϯ͕མͪͯେৎ w +VQJUFSωοτϫʔΫ w 1FUBCJUTFDͷόϯυ෯Λ࣋ͭωοτϫʔΫ w ສͷϚγϯ͕(CTͰΓͱΓͰ͖Δ w %SFNFMͷ֤֊ؒ-FBG/PEFTͱ$PMPTTVTͰͷσʔλ ͷΓͱΓΛߴԽͰ͖Δ