tag:support.nodebox.net,2012-11-01:/discussions/nodebox-2-3/6194-table-nodesNodeBox: Discussion 2020-04-14T20:10:34Ztag:support.nodebox.net,2012-11-01:Comment/481087112020-02-22T08:53:25Z2020-02-22T08:53:27ZTable Nodes<div><p>Wow, nodebox is very flexible. Have you created the manipulation nodes only by using nodebox standard nodes or have you used Python? I wonder if it is possible to use python packages like pandas or numpy inside nodebox. That would lift the processing of data to a novel level.</p></div>Alexander Gogltag:support.nodebox.net,2012-11-01:Comment/481087112020-02-22T11:34:42Z2020-02-22T11:37:44ZTable Nodes<div><p>Alexander,</p>
<p>All of these nodes are subnetworks, created using only NodeBox standard nodes - you can open them up and see for yourself. If you check out my node library you will see that a half dozen or so of those nodes were built using Python.</p>
<p>In theory you should be able to use packages like pandas or numpy from NodeBox as long as they are installed on the user's machine, but there are some wrinkles due to the older version of Jython NodeBox is built on. See this (old) note for more clues:</p>
<p><a href="http://support.nodebox.net/discussions/general-discussion/14716-pandas-and-nodebox">http://support.nodebox.net/discussions/general-discussion/14716-pan...</a></p>
<p>My preference is to do everything in pure NodeBox unless an external language is absolutely unavoidable. I do pretty much all my data analysis and visualization work using NodeBox and have built networks with thousands of nodes. NodeBox is definitely quirky - and is showing its age - but it is enormously flexible if you have the will to persevere.</p>
<p>The chart nodes I am building are already starting to be quite useful. I can turn out some decent visualizations in minutes by snapping a few nodes together. I remember that you were doing some nice radar charts a few years ago. Are you still using NodeBox? What have you done with it lately?</p>
<p>John</p></div>johntag:support.nodebox.net,2012-11-01:Comment/481087112020-03-07T21:59:00Z2020-03-07T21:59:00ZTable Nodes<div><p>UPDATE</p>
<p>I have made improvements to two of the table nodes described above, and added a new one.</p>
<p>CHANGE_COL</p>
<p>The original version of this node required you to provide a list of values to the new values port. Now, if you leave this port empty, the node will use the values contained under the key specified as the Current Key. This makes it easier to rename a column header: just choose Replace, then enter the current name and the new name; no need to do a lookup to supply the existing values. You could also leave the new data port empty and use the Add Before or Add After option to create a duplicate column (though I don't see much use for that).</p>
<p>SUMMARIZE</p>
<ol>
<li>I added a new method to use when summarizing. In addition to Sum, Average, and Count, you can now choose to Count Distinct. If you had a table of customers grouped by state and city, you could use Count Distinct to produce a summary table of how many different cities occurred in each state.<br></li>
<li>The value key is now optional when you use the Count method. If you just want a count of how many items fall under each category in your category key, you can simply leave the partition and value keys blank. This avoids having to use or create a second key just to get such a count. If you leave the value key blank and use any other method you will get nonsensical results (all 0s for Add and Average, all 1s for Count Distinct).</li>
</ol>
<p>SUM_COLS</p>
<p>Sum_cols is a variant of the Summary node. It has no option to create partitions from a partition key. Instead it allows you to enter a comma-separated list of existing keys for the Value Keys. It will then create a summary table with subtotals for each of those existing keys. This allows you to work directly on a table without having to use the Transpose node to create an interim table that the Summary node could use. By choosing different category and value keys you can make a wide variety of different summary tables from the same source table (see screenshot for one example).</p>
<p>Revised Table Nodes network attached. Comments welcome!</p>
<p>Enjoy!</p>
<p>John</p></div>johntag:support.nodebox.net,2012-11-01:Comment/481087112020-03-15T03:34:39Z2020-03-15T03:35:39ZTable Nodes<div><p>ANOTHER UPDATE</p>
<p>I made a minor improvement to the drop_calls node.</p>
<p>Now, instead of feeding a list of keys into the Column keys port, you can just type in a comma-separated list. This is more convenient when you only have a few columns to drop or keep (which seems to be most of the time),</p>
<p>Screenshot and updated version of the table node demo attached.</p>
<p>John</p></div>johntag:support.nodebox.net,2012-11-01:Comment/481087112020-03-30T19:42:48Z2020-04-14T20:10:34ZTable Nodes<div><p>Hi John,</p>
<p>Yes I still use nodebox for some projects. Last year I've create a card game to make the allocation of university courses to teachers at our department a lot more fun and interactive. Basically, Nodebox loads a data table and then spits out cards, that are styled based on curriculua (Bachelor's / Master's / PhD), summer / winter term, amount of credit points and teaching hours. If a class has more than one group of students, the card is multiplied.</p>
<p>It was a fun project to design and I am happy with the result of it. But we haven't had the chance to test it due to covid19...</p></div>Alexander Gogltag:support.nodebox.net,2012-11-01:Comment/481087112020-03-30T21:14:13Z2020-03-30T21:14:13ZTable Nodes<div><p>Ah and here is an image of the print sheet of the last version of the cards: I've improved the pattern quite a bit :)</p></div>Alexander Gogltag:support.nodebox.net,2012-11-01:Comment/481087112020-03-30T23:24:21Z2020-03-30T23:24:21ZTable Nodes<div><p>Alexander,</p>
<p>Interesting! Just curious: did you use any of my table nodes to help make your cards?</p>
<p>BTW, the table nodes (and many other new nodes) are included in the latest release of my Node Library:</p>
<p><a href="http://support.nodebox.net/discussions/show-your-work/372-cartan-node-library-20">http://support.nodebox.net/discussions/show-your-work/372-cartan-no...</a></p>
<p>John</p></div>johntag:support.nodebox.net,2012-11-01:Comment/481087112020-03-31T07:58:12Z2020-03-31T07:58:13ZTable Nodes<div><p>No, because I have started working on it before you've published your nodes, but I am going to try it at my next project :)</p>
<p>john <a href="mailto:tender2+d94e6053fa@tenderapp.com">tender2+d94e6053fa@tenderapp.com</a> --- 2020-03-31 Tue 01:24:</p></div>Alexander Gogl