load table

// Carregando um CSV

//mais em https://p5js.org/reference/#/p5.TableRow/getString

​

let table;

​

function preload() {

  //my table is comma separated value "csv"

  //and has a header specifying the columns labels

  table = loadTable('https://deckard.openprocessing.org/user3417/visual1603117/h10f780e448780b603afd4b5119bd76b5/investimentoop2.csv',

                    'csv', 'header');

  table2 = loadTable('https://deckard.openprocessing.org/user3417/visual1603117/h10f780e448780b603afd4b5119bd76b5/investimentoop.csv',

                    'csv', 'header');

  //the file can be remote

  //table = loadTable("http://p5js.org/reference/assets/mammals.csv",

  //                  "csv", "header");

}

​

function setup() {

  //count the columns

  createCanvas(800,800);

  background(0);

  print(table.getRowCount() + ' total rows in table');

  print(table.getColumnCount() + ' total columns in table');

​

  print(table.getColumn('2022'));

  //retorna uma lista com o nome da Coluna

​

  //cycle through the table

  for (let r = 0; r < table.getRowCount(); r++)

    for (let c = 0; c < table.getColumnCount(); c++) {

      if(r==0) print(table.getString(r, c));//print somente ministerio da economia

    }

  print(table.getString(0, 0));//retorna o valor que está na coluna 0,0 no caso uma String Ministério da Economia

  print(table.getNum(0, 5));

  print(table.getString(1, 0));

  print(table.getNum(1, 5));

  //area da elipse PI*(r*r); ou area=PI*(pow(raio,2));

  let dataAreaMax = PI*(pow(width/2,2));

  print(dataAreaMax);

  let areaME2018 = map(table.getNum(0, 5),0,1400000000,0,dataAreaMax)/10000;

  let areaMT2018 = map(table.getNum(1, 5),0,1400000000,0,dataAreaMax)/10000;

  print(areaME2018);

  print(areaMT2018);

  let raio=sqrt(areaME2018/PI);//formula para calcular o raio a partir da area

  let raio2=sqrt(areaMT2018/PI);

  ellipse(width/4,height/2,raio*2,raio*2);

  ellipse(width-width/4,height/2,raio2*2,raio2*2);

  print(raio);

  print(raio2);

  fill(255);

  text(table.getString(0,0),width/4,height*0.7);

  text(table2.getString(0,5),width/4,height*0.8);

  text(table.getString(1,0),width-width/4,height*0.7);

  text(table2.getString(1,5),width-width/4,height*0.8);

  text(2018,width/2,height*0.3);

}

​