load table3

// Carregando um CSV

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

​

let table;

let anima = 3 ;

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');

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

                    'csv');

  //the file can be remote

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

  //                  "csv", "header");

}

​

function setup() {

  //count the columns

  createCanvas(windowWidth,windowHeight);

  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 quando adiciona o header

​

  //cycle through the table

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

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

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

    }

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

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

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

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

}

function draw(){

  background(0);

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

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

  print(dataAreaMax);

  let ajusteTela = width*20;

  let areaME2018 = map(table.getNum(1, anima),0,1400000000,0,dataAreaMax)/ajusteTela;

  let areaMT2018 = map(table.getNum(2, anima),0,1400000000,0,dataAreaMax)/ajusteTela;

  print(areaME2018);

  print(areaMT2018);

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

  let raio2=sqrt(areaMT2018/PI);

  print(raio);

  print(raio2);

  //desenha

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

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

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

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

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

  text(table2.getString(2,anima),width-width/4,height*0.8);

  fill(255);

  text(table.getString(0,anima),width/2,height*0.3);

  //animando o texto com a função sin

  anima= floor(3+sin(millis()*0.00018)*2.5);

  anima=constrain(anima,1,5);

  text(anima,100,100);

}

​