How to format my data to output in this format (mongodb /python)

Question

Right now i use this command :

restos.aggregate([{$unwind:"$categories"},
{$group:{_id:'$categories.title', count:{$sum:1}}}, 
{$project:{ type:"$_id", count: 1,_id:0}}])

which outputs me data like this :

{ "count" : 3, "type" : "Sandwiches" }

What i'd like is to have this instead:

{ "Sandwiches" : 3 }

How can i achieve this ? I am using python with pymongo, will i need to format it manually ?

Thanks

J.F. · Accepted Answer · 2021-10-27 23:05:27Z

2

You can add an stage into aggregation with $replaceRoot and $arrayToObject like this:

{
  "$replaceRoot": {
    "newRoot": {
      "$arrayToObject": [
        [
          {
            "k": "$type",
            "v": "$count"
          }
        ]
      ]
    }
  }
}

Example here

answered Oct 27, 2021 at 23:05

J.F.

15.3k10 gold badges41 silver badges74 bronze badges

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

Collectives™ on Stack Overflow

How to format my data to output in this format (mongodb /python)

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