在Bash中对JSON记录进行分组和排序

sudo apt-get install jq

[
  {
    "name": "Alice",
    "age": 25,
    "city": "New York"
  },
  {
    "name": "Bob",
    "age": 30,
    "city": "London"
  },
  {
    "name": "Charlie",
    "age": 35,
    "city": "Tokyo"
  },
  {
    "name": "Alice",
    "age": 28,
    "city": "Paris"
  },
  {
    "name": "Bob",
    "age": 32,
    "city": "Berlin"
  }
]

cat data.json | jq 'group_by(.name) | map({name: .[0].name, count: length})'

[
  {
    "name": "Alice",
    "count": 2
  },
  {
    "name": "Bob",
    "count": 2
  },
  {
    "name": "Charlie",
    "count": 1
  }
]

cat data.json | jq 'group_by(.age) | map({age: .[0].age, avg_age: (map(.age) | add) / length})'

[
  {
    "age": 25,
    "avg_age": 25
  },
  {
    "age": 30,
    "avg_age": 30
  },
  {
    "age": 35,
    "avg_age": 35
  },
  {
    "age": 28,
    "avg_age": 28
  },
  {
    "age": 32,
    "avg_age": 32
  }
]

cat data.json | jq 'group_by(.city) | map({city: .[0].city, names: map(.name) | sort})'

[
  {
    "city": "New York",
    "names": [
      "Alice"
    ]
  },
  {
    "city": "London",
    "names": [
      "Bob"
    ]
  },
  {
    "city": "Tokyo",
    "names": [
      "Charlie"
    ]
  },
  {
    "city": "Paris",
    "names": [
      "Alice"
    ]
  },
  {
    "city": "Berlin",
    "names": [
      "Bob"
    ]
  }
]