ranking m - 経済統計練習帳

var artist=new Array();
 
function myFunction() {
 
 id="1FAcgMg-pgpXMZ2fDAMBVIoHyoqxY79M1xBgcqTqExvs";
 
ex = SpreadsheetApp.openById(id);
 
sh = ex.getSheetByName("data");
 
 
  number=sh.getLastRow();
 
Logger.log(number);
var v=sh.getRange(1,1,number,4).getValues();
 
  t1="";
  sx=0;
   for(s=1;s<number+1;s++){
  t=v[s-1][0]
  z=0;
  if(t1==t)z=100;
  if(z<60)  sx=sx+1;
  if(z<60) artist[sx]=v[s-1][2];
     t1=t;
   }
  number=sx;
 
 
 var dic=new Array();
  var point=new Array();
 
 
  dic[0]="";
 
  n=0;
   for(s=1;s<number+1;s++){
  sx=dic.indexOf(artist[s]);
  if(sx<1) n=n+1;  
  if(sx<1) dic[n]=artist[s];  
   }
 
   for(s=1;s<n+1;s++){
   point[s]=0;
   }
 
   for(s=1;s<number+1;s++){
  sx=dic.indexOf(artist[s]);
  point[sx]=point[sx]+1; 
   }
 
 
 
   for(s=1;s<n+1;s++){
  if(point[s]>1)Logger.log(dic[s]+","+point[s]);
}
 
 
}