りょうみｎ - 経済統計練習帳

var a=new Array();
var b=new Array();
var c=new Array();
var d=new Array();
 
var n=new Array();
var codex=new Array();
var namex=new Array();
var cr=new Array();
var ns=new Array();
 
var dic_name=new Array();
var dic_code=new Array();
var dic_key=new Array();
var number;
var dicnumber;
 
function sample(){
 
 
  dicx();
 
 sql("19hhrkxwiS5xaDrTdQGxm1dhohiDXxVQjES-rd4hA");
 
  Logger.log(number);
 
  sx=0;
  for(s=1;s<number+1;s++){
  sx=sx+1;
  namex[sx]=a[s];
  cr[sx]="主演男優";  
 ns[sx]=n[s];  
    sx=sx+1;
  namex[sx]=b[s];
  cr[sx]="主演女優";  
    ns[sx]=n[s];  
    sx=sx+1;
  namex[sx]=c[s];
  cr[sx]="助演男優";  
  ns[sx]=n[s];  
    sx=sx+1;
  namex[sx]=d[s];
  cr[sx]="助演女優";  
  ns[sx]=n[s];  
  }
 
 
  number=sx;
 
 for(s=1;s<number+1;s++){
 str=namex[s];
 str=str.replace("　","");
 str=str.replace(" ","");
 sx=dic_key.indexOf(str);
 codex[s]="";
 if(sx>0)codex[s]=dic_code[sx];
 }
 
 
 
 
id="1KUFXz6r7RmAB1dDlbovm31FGCs5y3xRjErtI-bLOXpg";
 
ex = SpreadsheetApp.openById(id);
 
sh = ex.getSheetByName("data");
 
 
 
  var v3=new Array();
  for(s=0;s<number+1;s++){
  v3[s]=new Array();
  }
 
  v3[0][3]="code";
  for(s=1;s<number+1;s++){
  v3[s][0]=ns[s];
  v3[s][1]=namex[s];
  v3[s][2]=cr[s];
  v3[s][3]=codex[s];
  }
 
  sh.getRange(1,1,number+1,4).setValues(v3);
 
 
 
 
 
}
 
 
function sql(idx) {
 
 
 
  var sql = 'SELECT * FROM ' +idx;
 
  var result = FusionTables.Query.sqlGet(sql, {hdrs: false});
 
 var r=result.rows;
 
 
  s=0;
    for(var i in r){   
  s=s+1;
   n[s]=r[i][0];
   a[s]=r[i][2];
   b[s]=r[i][3];
   c[s]=r[i][4];
   d[s]=r[i][5];
   }
 
 
 number=s;
 
 
}
 
 
function dicx() {
 
 
  id_or="16zlbESM_0PL9DVz7BpKayLwLdAMFTxHFQKoPxbfL";
 
  var sql = 'SELECT * FROM ' +id_or;
 
  var result = FusionTables.Query.sqlGet(sql, {hdrs: false});
 
 var r=result.rows;
 
 dic_key.push("noname");
 
  sxs=0;
    for(var i in r){   
  sx=dic_key.indexOf(r[i][0]);
  if(sx<1)dic_key.push(r[i][0]);
   if(sx<1)sxs=sxs+1;
  if(sx<1)dic_name[sxs]=r[i][0];
  if(sx<1)dic_code[sxs]=r[i][1];
   }
 
 
 
 
 
}