Passing json array of array in django to javascript google charts

Question

I have an actuals array of array coming from django queryset as a json. I am having trouble feeding it to the google charts.js Below is the code. views.py

def historicals(request):
    actuals= serializers.serialize("json",Del.objects.all()[1:10])
    json_object = json.loads(actuals)
    actuals=[]
    i=1
    for element in json_object:
       dt=element['fields']['Date']
       dt=datetime.datetime.strptime(dt,'%Y-%m-%dT%H:%M:%S%z')
       dt=dt.date()
       dt=datetime.datetime.strftime(dt,'%Y-%m-%d')
       Vol=str(element['fields']['Volume'])
       print (dt)
       cn=str(element['fields']['Customer'])
       cn = str(cn)     
       actuals.append([pxn,Vol,dt])
        
    print (actuals)
    context['actuals']=actuals
  
    return render(request,'customer.html',context)

var actuals = "{{ actuals | safe }}";

will shows the following in page source.

[['001', '5155', '2020-01-14'], ['001', '57.0', '2020-02-13'], ['001', '510', '2020-02-25'], ['001', '5760', '2020-03-23'], ['001', '46.625', '2020-03-30'], ['001', '910', '2020-04-01'], ['001', '435300.0', '2020-03-20']]

console.log(actuals); //Would show the above array of arrays
for (i = 0; i < actuals.length; i++) {
  for (j = 0; j < actuals[i].length; j++) {
    var dt = i;
    actual = actuals[i][j]; //tried parseFloat too didnt work 
    //data.addRow([i,actual[i][1]);
    console.log(actuals[i][j]); //--> this shows individual characters in the array [ , 0 0 0 0 1
  }
}

I am trying to iteratively add a row using the data.addRow line. My problem is actuals[i][j] is showing an individual character (this shows individual characters in the array [ , 0 0 0 0 1....) in console.log instead of whole string or numbers or dates.

I was expecting the console.log(actuals[i][j]) to show ['001', '5155', '2020-01-14'] in the browser console. Can you help?

please show the expected result for the set of data you show [['001', '5155', '2020-01-14'], ['001', '57.0', '2020-02-13'], ['001', '510', '2020-02-25'], ['001', '5760', '2020-03-23'], ['001', '46.625', '2020-03-30'], ['001', '910', '2020-04-01'], ['001', '435300.0', '2020-03-20']] — Mario
– Mario, Commented Jun 26, 2020 at 20:43
in this line actual = actuals([i][j]); you get TypeError: actuals is not a function try instead actual = actuals[i][j]; without parentheses — Mario
– Mario, Commented Jun 26, 2020 at 20:47
It's probably easier/safer to use json_script to pass context variables to your JS — Iain Shelvington
– Iain Shelvington, Commented Jun 26, 2020 at 20:49

Mario · Accepted Answer · 2020-06-26 21:08:09Z

1

actuals[i][j] should show only one value.

If what you need is to pass each instance of the array as an argument to data.addRow you can use forEach, for example

actuals.forEach((entry, index) => data.addRow(index, entry));

If you need to transform the array data before using it in data.addRow() you can do the following

actuals.forEach((entry, index) => {
  const item = [+entry[0], +entry[1], new Date(entry[2])];

  data.addRow(index, item);
});

The unary + operator will convert the string to number

answered Jun 26, 2020 at 21:08

Mario

5,0044 gold badges42 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

user2162611 · Accepted Answer · 2020-06-26 21:48:24Z

0

In the context variable, I removed the quotes and the loop and charts worked very easily after that.

var actuals = {{ actuals | safe }};

answered Jun 26, 2020 at 21:48

user2162611

1753 silver badges13 bronze badges

Collectives™ on Stack Overflow

Passing json array of array in django to javascript google charts

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related