Daniel, I made the null in the data set unquoted and now it throws the following error:
Failed to find row with id " 'Global'". On Monday, April 10, 2017 at 4:44:16 PM UTC-6, Kory Clark wrote: > > Hi, > > Can someone point me to an example where a csv file is used instead of > hard coding the data for generating a treemap, I am referring to the > program in > https://developers.google.com/chart/interactive/docs/gallery/treemap . > > I am pasting below the program with changes which I have tried to generate > the treemap using CSV. Unfortunately, although I am able to load the csv > file, the treemap is not getting generated. Instead I get an error - Failed > to find row with id "null". > > I feel that there is something wrong in the way I am storing the CSV file > to arrayData. I am investigating further, but, in case, anyone could help > me, it would really be appreciated. > > My data file I call "data.csv" is below: > > > 'Location', 'Parent', 'Market trade volume (size)', 'Market > increase/decrease (color)' > 'Global', 'null', 0, 0 > 'America', 'Global', 0, 0 > 'Europe', 'Global', 0, 0 > 'Asia', 'Global', 0, 0 > 'Australia', 'Global', 0, 0 > 'Africa', 'Global', 0, 0 > 'Brazil', 'America', 11,10 > 'USA', 'America', 52,31 > 'Mexico', 'America', 24,12 > 'Canada', 'America', 16,-23 > 'France', 'Europe', 42,-11 > 'Germany', 'Europe', 31,-2 > 'Sweden', 'Europe', 22,-13 > 'Italy', 'Europe', 17,4 > 'UK', 'Europe', 21,-5 > 'China', 'Asia', 36,4 > 'Japan', 'Asia', 20,-12 > 'India', 'Asia', 40,63 > 'Laos', 'Asia', 4, 34 > 'Mongolia', 'Asia', 1, -5 > 'Israel', 'Asia', 12,24 > 'Iran', 'Asia', 18,13 > 'Pakistan', 'Asia', 11,-52 > 'Egypt', 'Africa', 21,0 > 'S. Africa', 'Africa', 30,43 > 'Sudan', 'Africa', 12,2 > 'Congo', 'Africa', 10,12 > 'Zaire', 'Africa', 8, 10] > > <html> > <head> > <script type="text/javascript" src=" > https://www.gstatic.com/charts/loader.js";></script> > <script src="papaparse.js"></script> > <script src=" > http://ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js > "></script> > <script type="text/javascript"> > google.charts.load('current', {'packages':['treemap']}); > google.charts.setOnLoadCallback(drawChart); > function drawChart() { > var csvfile = "data.csv"; > $.get(csvfile, function (data) { > var csvdata = Papa.parse(data); > var alpha = > google.visualization.arrayToDataTable(csvdata.data,false); > console.log(alpha); > tree = new > google.visualization.TreeMap(document.getElementById('chart_div')); > > tree.draw(alpha, { > minColor: '#f00', > midColor: '#ddd', > maxColor: '#0d0', > headerHeight: 15, > fontColor: 'black', > showScale: true > }); > }); > > } > </script> > </head> > <body> > <div id="chart_div" style="width: 900px; height: 500px;"></div> > </body> > </html> > > > > A subset of the data file is given below > > ['Location', 'Parent', 'Market trade volume (size)', 'Market > increase/decrease (color)'] > ['Global', null, 0, 0] > ['America', 'Global', 0, 0] > ['Europe', 'Global', 0, 0] > > > Thanks > > Kory > -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/google-visualization-api. To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/a36edd21-a6e2-4d1c-a309-fed3b4e65943%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
