Solution to an exercise for data aggregation.
Calculate summary statistics for subgroups of data with the GroupBy and Pivoting nodes.
CHECK YOUR ANSWERS:
GroupBy:
a. The average age is 37 years for the women and 39 years for the men
b. Husband is the most common family relationship of the German people in the data
c. The number of rows in the data is 32549
Pivoting:
a. The most common combination of age bin and work class is <35 years and Private. 10936 people belong to this group.
b. The most widespread education level in the Private workclass is HS-grad
To use this workflow in KNIME, download it from the below URL and open it in KNIME:
Download WorkflowDeploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.
Try NodePit Runner!Do you have feedback, questions, comments about NodePit, want to support this platform, or want your own nodes or workflows listed here as well? Do you think, the search results could be improved or something is missing? Then please get in touch! Alternatively, you can send us an email to mail@nodepit.com, follow @NodePit on Twitter or botsin.space/@nodepit on Mastodon.
Please note that this is only about NodePit. We do not provide general support for KNIME — please use the KNIME forums instead.