げねきい - 経済統計練習帳

var vs=new Array();
var namex=new Array();
 var codex=new Array();
 
function plusplus() {
 
var id="1uI-AbGetnPJu57yRs6JqBiKXh27h61O-6THBgibJ0fw";
 
var ex1 = SpreadsheetApp.openById(id);
var sheet = ex1.getSheetByName("dic");
 
number=sheet.getLastRow()-1; 
 
  Logger.log(number);
 
 
var v=sheet.getRange(1,1,number+1,2).getValues();
 
for(s=1;s<number+1;s++){
namex[s]=""+v[s][0]; 
codex[s]=""+v[s][1];
}
 
 
for(tr=1;tr<number+1;tr++){
pc="";
if(codex[tr].length<1)pc=oricon(namex[tr]);
if(pc.length>0)sheet.getRange(tr+1,2).setValue(pc);
}
 
 }
 
function  movie(){
 
 
 var id="1uI-AbGetnPJu57yRs6JqBiKXh27h61O-6THBgibJ0fw";
 
var ex1 = SpreadsheetApp.openById(id);
var sheet = ex1.getSheetByName("dic");
 
number=sheet.getLastRow()-1; 
 
var namex=new Array();
 var codex=new Array();  
 
 
var v=sheet.getRange(1,1,number+1,2).getValues();
 
 sx=0;
 for(s=1;s<number+1;s++){
ss=""+v[s][1];
if(ss.length>0)sx=sx+1;
if(ss.length>0)namex[sx]=v[s][0]; 
if(ss.length>0)codex[sx]=""+v[s][1];
Logger.log(codex[s]);
}
 
number=sx;
 
Logger.log(number);
 
  var id2="10VFCUHIj7sysxoRfUmffSOPEvoqNdZBb_7_PutstdXg";
 
var ex2 = SpreadsheetApp.openById(id2);
var sh2 = ex2.getSheetByName("dic");
 
dicnumber=sh2.getLastRow()-1;
 
Logger.log(dicnumber);
 
var v2=sh2.getRange(1,1,dicnumber+1,2).getValues();
 
  var code=new Array();
  var dic_key=new Array();
   var dic=new Array();
 
 dic_key.push("noname");
 
  for(s=1;s<dicnumber+1;s++){
  dic_key.push(v2[s][0]);
  dic[s]=v2[s][0];
  code[s]=v2[s][1]; 
  }
 
  var delta=new Array();
 
  for(s=1;s<number+1;s++){ 
  sx=dic_key.indexOf(namex[s]);
  if(sx<0)dicnumber=dicnumber+1;
   if(sx<0)dic[dicnumber]=namex[s];
   if(sx<0)code[dicnumber]=codex[s];
    if(sx<0)dic_key.push(namex[s]);
  }
 
 
 
  for(s=0;s<dicnumber+1;s++){
  delta[s]=new Array();
  }
 
  delta[0][1]="code";
  for(s=1;s<dicnumber+1;s++){
 delta[s][0]=dic[s];
 delta[s][1]=code[s];
  }
 
 sh2.getRange(1,1,dicnumber+1,2).setValues(delta); 
 
 
 
 
 
 
}
 
 
 
function oricon(nn) {
 
  word=ecl.EscapeSJIS(nn)
 
 
   uu="http://www.oricon.co.jp/search/result.php?types=artist&search_string="+word;
 
 
       try {
 
 var response = UrlFetchApp.fetch(uu);
 str=response.getContentText("SJIS");
 
    } 
    catch (e) {Logger.log("Fail")}
 
 
 
 
  p1=str.indexOf("</strong>を含む芸能人名</span></h3>");
 
p2=str.indexOf("lock-search-box bottom mb0",p1);
 
  str=str.substring(p1,p2);
 
 
  var x=str.split("\n");
 
 
 
  var code="";
        for(s=1;s<x.length;s++){
        h=0;
       if(x[s].indexOf("/prof/")>-1)h=h+1;
        if(code.length<1)h=h+1;
        if(h==2)code=x[s];
 
        }
 
  p1=code.indexOf("prof");
  p2=code.indexOf("\" ",p1);
  if(p1>-1)code=code.substring(p1,p2);
 
 code=code.replace("prof/","");
 
  code=code.replace("/","");
 
      return code;
 
 
 
 
 
 
}
 
 
 
function dix(){
 
var id="1uI-AbGetnPJu57yRs6JqBiKXh27h61O-6THBgibJ0fw";
 
var ex1 = SpreadsheetApp.openById(id);
var sheet = ex1.getSheetByName("data");
 
number=sheet.getLastRow()-1; 
 
  Logger.log(number);
 
 
  var v=sheet.getRange(1,1,number,4).getValues();  
 
  var don=new Array();
  var dic=new Array();
 
  sx=0;
  for(s=1;s<number;s++){
  h=0;  
  ppp=""+v[s][0];
  if(ppp=="出演者")h=h+1;
  z=""+v[s][3];
  if(z.length==0)h=h+1;
  if(h==2)sx=sx+1;
  if(h==2)don[sx]=v[s][2]; 
  }
  pp=sx;
 
  dot=0;
  for(s=1;s<pp+1;s++){
  h=0;
  for(sx=1;sx<dot+1;sx++){
  if(don[s]==dic[sx])h=100;
  }
  if(h<50)dot=dot+1;
  if(h<50)dic[dot]=don[s];
  }
 
 
 
  var point=new Array();
  for(s=0;s<dot+1;s++){
  point[s]=new Array();
  }
  point[0][0]="A";
 
  for(s=1;s<dot+1;s++){
  point[s][0]=dic[s];
  }
 
  dot=sx+1;
  var shx = ex1.getSheetByName("dic");
shx.getRange(1,1,dot,1).setValues(point); 
 
 
 
}
 
 
 
function plus(){
 
  var id="1uI-AbGetnPJu57yRs6JqBiKXh27h61O-6THBgibJ0fw";
 
var ex1 = SpreadsheetApp.openById(id);
var sheet = ex1.getSheetByName("dic");
 
number=sheet.getLastRow()-1; 
 
var codex=new Array();
 
var v=sheet.getRange(1,1,number+1,2).getValues();
 
for(s=1;s<number+1;s++){
namex[s]=v[s][0]; 
codex[s]=v[s][1];
}
 
 
  var id2="10VFCUHIj7sysxoRfUmffSOPEvoqNdZBb_7_PutstdXg";
 
var ex2 = SpreadsheetApp.openById(id2);
var sh2 = ex2.getSheetByName("dic");
 
dicnumber=sh2.getLastRow()-1;
 
var v2=sh2.getRange(1,1,dicnumber+1,2).getValues();
 
  var code=new Array();
  var dic_key=new Array();
 
 dic_key.push("noname");
 
  for(s=1;s<dicnumber+1;s++){
  dic_key.push(v2[s][0]);
  code[s]=v2[s][1]; 
  }
 
 
  var delta=new Array();
 
  for(s=1;s<number+1;s++){
  sx=dic_key.indexOf(namex[s]);
  if(sx>0)codex[s]=code[sx];
  }
 
  for(s=0;s<number+1;s++){
  delta[s]=new Array();
  }
 
  delta[0][0]="code";
  for(s=1;s<number+1;s++){
  delta[s][0]=codex[s];
  }
 
 sheet.getRange(1,2,number+1,1).setValues(delta); 
 
 
 
}
 
 
function dl() {
 
  for(s=0;s<1000;s++){
  vs[s]=new Array();
  }
 
  for(s=0;s<1000;s++){
  vs[s][0]=0;
  vs[s][1]="";
  vs[s][2]="";  
  }
 
 
 
  uu="https://artv.info/ar1701.html";
 
      str="";
      try {
 
 var res = UrlFetchApp.fetch(uu);
 
  str=res.getContentText("EUC-JP");
 
 
 
    } 
    catch (e) {}
 
  p1=str.indexOf("-月-</div>");
  p2=str.indexOf("<!-- 下部ここまで -->",p1);
 
  str=str.substring(p1,p2);
 
 
  var x=str.split("<a name=");
 
 for(s=1;s<x.length;s++){ 
   p1=x[s].indexOf("left pl5px");
    p2=x[s].indexOf("</td>",p1);
   x[s]=x[s].substring(p1,p2);
 }
 
  n=0;
 
  for(tr=1;tr<x.length;tr++){ 
  strx=x[tr];
 
 
  for(k=1;k<41;k++){
  strx=strx.replace("<br>","△");
  strx=strx.replace("、","△");
  strx=strx.replace("etc","");
  strx=strx.replace("\n","");
  }
 
 var y=strx.split("△");
 
var delta=new Array(); 
var pos=new Array(); 
 
                      sx=0;
 for(s=0;s<y.length;s++){  
 var sp=""+y[s];
  if(sp.length>1)sx=sx+1;
 if(sp.length>1)delta[sx]=y[s];
 
}
 
number_p=sx;
   kk="left pl5px\">";
 
  for(s=1;s<number_p+1;s++){ 
  delta[s]=delta[s].replace(kk,"");
 
}
 
 pos[0]="出演者"; 
    for(s=1;s<number_p+1;s++){ 
  p1=delta[s].indexOf("：");
  z=pos[s-1];
 if(p1>-1)z=delta[s].substring(0,p1);    
 pos[s]=z;
 delta[s]=delta[s].replace(pos[s],"");
 delta[s]=delta[s].replace("：","");     
    }
 
     for(s=1;s<number_p+1;s++){ 
     n=n+1;
     vs[n][0]=tr;
     vs[n][1]=pos[s];  
     vs[n][2]=delta[s];
     Logger.log(delta[s]);
     }
 
 
 
 
}
 
 
  var id="1VMPZ4KadgjpAAwBZN79jWWpiqHBmslLBi2gMpN2U0hc";
 
 var ex1 = SpreadsheetApp.openById(id);
  var sheet = ex1.getSheetByName("data");
  sheet.getRange(1,1,1000,3).setValues(vs);
 
 
 
}