Convert json into matrix table? Javascript / HTML

Question

suppose I have a JSON object, in the example users can give a rating to themselves

[
    {
        "to": "jeff",
        "rating": 50,
        "from": "jeff"
    },
    {
        "to": "bob",
        "rating": 50,
        "from": "jeff"
    },
    {
        "to": "jeff",
        "rating": 75,
        "from": "bob"
    },
    {
        "to": "bob",
        "rating": 75,
        "from": "bob"
    }
]

I know how to display this in a simple grid panel like below

But this is a bit confusing, is there an easy way to convert this into a matrix table grid similar to the format below?

Just looking for a pure JS / jquery way of doing it, many thanks for any input!

It's a matrix table I think I need, just unsure how to parse the json into one — Coder
– Coder, Commented Mar 5, 2017 at 19:44

Nina Scholz · Accepted Answer · 2017-03-05 19:44:38Z

2

You could use some hashes for the right row/col reference

var data = [{ "to": "jeff", "rating": 50, "from": "jeff" }, { "to": "bob", "rating": 50, "from": "jeff" }, { "to": "jeff", "rating": 75, "from": "bob" }, { "to": "bob", "rating": 75, "from": "bob" }],
    result = [['to/from']];

data.forEach(function (row, col) {
    return function (a) {
        if (!(a.to in row)) {
            row[a.to] = result.push([a.to]) - 1;
        }
        if (!(a.from in col)) {
            col[a.from] = result[0].push(a.from) - 1;
        }
        result[row[a.to]][col[a.from]] = a.rating;
    };
}(Object.create(null), (Object.create(null))));

console.log(result);

.as-console-wrapper { max-height: 100% !important; top: 0; }

answered Mar 5, 2017 at 19:44

Nina Scholz

388k26 gold badges367 silver badges417 bronze badges

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

Collectives™ on Stack Overflow

Convert json into matrix table? Javascript / HTML

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related