Group by count

Hi NodeBox folks

I've trying to build a pie chart / wheel diagram from CSV import. I've got an input list of strings, and I'd like to size the arcs by the count of duplicate entries for each unique value in the list.

So if my input list is something like "Alice, Alice, Alice, Bob, Bob", I' like to produce the list of numbers "3, 2" so I can size my arcs accordingly. In SQL land this would be a GROUP BY clause with a COUNT(*) in the SELECT part.

Any ideas?

Pete

Hi,

There is no built-in node that does this. However, I've created a custom one for you ("group_count") that you can use.

I've added an example that counts all words from a speech by Obama and shows a frequency plot. Be sure to read the comments to understand the network.

Let me know if you have any further questions.

We're planning on adding better aggregation capabilities to NodeBox in the future.

Best,

F

Comment version still needs to be released?

Hi,

Sorry for the confusion. A version of NodeBox with support for comments is
not released yet. That said, the file will open fine, you just won't see
any comments.

We'll prepare a new release of NodeBox – with support for comments – this
week.

Best,

F

We just released a version supporting comments. Download it from the NodeBox site.

Just what I needed - thanks so much Frederik!

Pete