format the json data with jquery in to a particular format

Question

I am trying to construct a pie chart with flot, and getting the json data from server as below

[
  {"transactions": 7, "products__name": "mark"}, 
  {"transactions": 12, "products__name": "vicky"}, 
  {"transactions": 30, "products__name": "daniel"},   
  {"transactions": 6, "products__name": "hurray "}]

So i need to format the above list of dictionaries in to below format so that i can use that to directly insert to flot pie chat placeholder

data = [
    { label: "mark",  data: 7, color: "#4572A7"},
    { label: "vicky",  data: 12, color: "#80699B"},
    { label: "daniel",  data: 30, color: "#3D96AE"},
    { label: "hurray",  data: 6, color: "#89A54E"},
];

Actually i just want to do this with jquery, by using foreach or something else..

Where did the color values come from? Are they randomly chosen? — Robᵩ
– Robᵩ, Commented Nov 14, 2013 at 19:01
I actually i want to add the color manually, so since i know there will be only 5 items in the list for sure, manually i want to assign color to each item in the list — Shiva Krishna Bavandla
– Shiva Krishna Bavandla, Commented Nov 14, 2013 at 19:06

Farhadix · Accepted Answer · 2013-11-15 14:06:02Z

3

lst = [
  {"transactions": 7, "products__name": "mark"}, 
  {"transactions": 12, "products__name": "vicky"}, 
  {"transactions": 30, "products__name": "daniel"},   
  {"transactions": 6, "products__name": "hurray "}]
colors = ["#4572A7", "#80699B", "#3D96AE", "#89A54E"]
data = []

for i, c in zip(lst, colors):
   data.append({'label': i['products__name'], 'data': i["transactions"], 'color': c,})

edited Nov 15, 2013 at 14:06

answered Nov 14, 2013 at 18:31

Farhadix

1,4572 gold badges13 silver badges26 bronze badges

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

7 Comments

Shiva Krishna Bavandla Over a year ago

sorry i want to do this with jquery, i will get only five items in the list, so i want to arrange the color fixed to the records

Farhadix Over a year ago

I added colour to them.

Shiva Krishna Bavandla Over a year ago

i just want to do this logic with jquery not python

Farhadix Over a year ago

Why you add python tag to your question?

Shiva Krishna Bavandla Over a year ago

I added python because, i am getting the data in python right

|

Collectives™ on Stack Overflow

format the json data with jquery in to a particular format

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related