ぷろぐらむ - 経済統計練習帳

var point = new Array();
 var x = new Array();
 var artist = new Array();
 var num = new Array();
 
function sample() {
 
        var query = "SELECT * FROM " +
            '1f1J0tujTJigAHNvNVNnUAURfC56CKviMqf-8j_3H';
        var encodedQuery = encodeURIComponent(query);
 
        var url = ['https://www.googleapis.com/fusiontables/v1/query'];
        url.push('?sql=' + encodedQuery);
        url.push('&key=AIzaSyAH0WCAXRIdHdbI-6bnMSN4kVDDZZmGyqY');
        url.push('&callback=?');
 
 
 
 
 
        $.ajax({
            url: url.join(''),
            dataType: 'jsonp',
            success: function (data) {
                var rows = data['rows'];
 
 
 
                sx = 0;
 
                for (var i in rows) {
                    sx = sx + 1;
                    point[sx]=rows[i][2];
                    artist[sx]=rows[i][0];
                    num[sx]=rows[i][1];
                }
 
 
      number = sx;
 
    var dic=new Array();
 
 
      dicnumber=0;
 
 for(s=1;s<number+1;s++){
 h=0;  
 for(sx=1;sx<dicnumber+1;sx++){
 if(artist[s]==dic[sx])h=100;  
 }  
if(h<50)dicnumber=dicnumber+1;
if(h<50)dic[dicnumber]=artist[s];
}
 
var p=new Array();
 
for(s=1;s<dicnumber+1;s++){
p[s]=new Array();  
} 
 
for(s=1;s<dicnumber+1;s++){
for(sx=1;sx<9;sx++){
p[s][sx]=0;
}
} 
 
 
 
for(s=1;s<number+1;s++){
n=num[s];
for(sx=1;sx<dicnumber+1;sx++){
if(artist[s]==dic[sx])p[sx][n]=point[s];  
}   
}
 
 
 alert(p[1][1]);
 
 
 
 
 
 
 
            }
        });
 
}