gagan-bansal / json-groupby Goto Github PK

View Code? Open in Web Editor NEW

19.0 19.0 11.0 55 KB

Group json data based on properties of json

License: MIT License

JavaScript 100.00%

group groupby json json-properties

json-groupby's People

Contributors

Stargazers

Watchers

Forkers

sshyran lightlogic5 xnok chingfeng vdedyukhin githubgagan right-way pss4190 woohyodong beachstrider prashantswami

json-groupby's Issues

doesn't work for date

if the propertyy in your json is of type date.

Output as an array?

Should the output of groups be an array?
Like explained here:
https://stackoverflow.com/q/23600897/713573
If yes, then there would be major version bump and need to maintain this version also.

Separate group as undefined for undefined key

If group by key is not present in the sample then create a separate group by name undefined.
Right now it throws error.

Is the use of debugger intentional?

Is the use of debugger intentional on line 14 or can that be omitted in the master branch?

properties can be a single string

Convention over configuration.

var group = groupBy(array, properties [, collect])

Right now properties is an array, I think can be a string in case of single property.

json groupBy transform a key into array

Hi,

Thanks for this package, I using it and liked.
I have a problem with a json here:

[
    {
        "id_programacao": 1,
        "evento": "TESTE PROGRAMACAO 1",
        "descricao_evento": "teste usando o NodeJS",
        "tipo_evento": "Palestra",
        "local": "PRODAM",
        "hora_inicio": "2016-10-10T22:26:15.000Z",
        "hora_fim": "2016-10-13T22:26:22.000Z",
        "id_palestrante": 2,
        "nome": "Bruno Mendes",
        "cargo": "Analista",
        "empresa": "PRODAM",
        "curriculum": "Tem muito que aprender ainda... ¬¬"
    },
    {
        "id_programacao": 1,
        "evento": "TESTE PROGRAMACAO 1",
        "descricao_evento": "teste usando o NodeJS",
        "tipo_evento": "Palestra",
        "local": "PRODAM",
        "hora_inicio": "2016-10-10T22:26:15.000Z",
        "hora_fim": "2016-10-13T22:26:22.000Z",
        "id_palestrante": 1,
        "nome": "Rodolfo Azevedo",
        "cargo": "Programador",
        "empresa": "PRODAM",
        "curriculum": "Esse bixo manja velho"
    },
    {
        "id_programacao": 2,
        "evento": "TESTE PROGRAMACAO 2",
        "descricao_evento": "teste usando o Java",
        "tipo_evento": "Palestra",
        "local": "PRODAM",
        "hora_inicio": "2016-10-14T22:26:15.000Z",
        "hora_fim": "2016-10-15T22:26:22.000Z",
        "id_palestrante": 3,
        "nome": "Bruno do Mobile",
        "cargo": "Programador",
        "empresa": "PRODAM",
        "curriculum": "Até nos feriados"
    }
]

I have id_programacao: 1, but I have two id_palestrantes in this programacao, I like to transform this json to this:

[
    {
        "id_programacao": 1,
        "evento": "TESTE PROGRAMACAO 1",
        "descricao_evento": "teste usando o NodeJS",
        "tipo_evento": "Palestra",
        "local": "PRODAM",
        "hora_inicio": "2016-10-10T22:26:15.000Z",
        "hora_fim": "2016-10-13T22:26:22.000Z",
        palestrantes: [
          {
             "id_palestrante": 2,
             "nome": "Bruno Mendes",
             "cargo": "Analista",
             "empresa": "PRODAM",
             "curriculum": "Tem muito que aprender ainda... ¬¬"
          },
          {
             "id_palestrante": 1,
             "nome": "Rodolfo Azevedo",
             "cargo": "Programador",
             "empresa": "PRODAM",
             "curriculum": "Esse bixo manja velho"
          }
       ]
    },
    {
        "id_programacao": 2,
        "evento": "TESTE PROGRAMACAO 2",
        "descricao_evento": "teste usando o Java",
        "tipo_evento": "Palestra",
        "local": "PRODAM",
        "hora_inicio": "2016-10-14T22:26:15.000Z",
        "hora_fim": "2016-10-15T22:26:22.000Z",
        "id_palestrante": 3,
        "nome": "Bruno do Mobile",
        "cargo": "Programador",
        "empresa": "PRODAM",
        "curriculum": "Até nos feriados"
    }
]

Can you help me ?

Thanks and Regards.

[feature request] nested array

This library is very useful and the syntax make it easy to understand (very close to pandas a Python data manipulation library). However I see a missing feature that concern recurring use case .

Given the example of a book store, I retrieve the list of books with their title and the list of their authors.

  {
    "title": "",
    "author": [
      {
        "given": "",
        "family": "",
        "affiliation": []
      },
      {
        "given": "",
        "family": "",
        "affiliation": []
      },
]

Then I want to group those books by authors. (This append a lot when you have entities with a relation where books asMany authors.

Your library could implement a SQL like syntax to specify on which property inside the array you want to group

groupBy(books, ['author.given'])

One solution to tackle this would be to add a temporary array tmp that contain the property given for each author then use the group by as for tags

  books.forEach(function(item) {
      item.tmp = item['authors'].map(function(x) {
         return x.['given'];
      })
  });

groupBy(books, ['tmp'])

I believe this feature will complete the coverage of this library in terms of grouping and manipulating JSON Objects

gagan-bansal / json-groupby Goto Github PK

json-groupby's People

Contributors

Stargazers

Watchers

Forkers

json-groupby's Issues

doesn't work for date

Output as an array?

Separate group as undefined for undefined key

Is the use of debugger intentional?

properties can be a single string

json groupBy transform a key into array

[feature request] nested array

Recommend Projects

React

Vue.js

Typescript

TensorFlow

Django

Laravel

D3

Recommend Topics

javascript

web

server

Machine learning

Visualization

Game

Recommend Org

Facebook

Microsoft

Google

Alibaba

D3

Tencent