Icon

JKISeason2-15_​sryu

Challenge 15: Create a Dashboard to Update Actuarial Information
Level: Medium

Description: You are a freelance data scientist and are asked to help an actuarial agency. To compute premiums for life insurances, actuaries need to find the age-dependent information about customers from an Actuarial Life table containing the probability of dying within 1 year and life expectancy. Your task is to make this process faster: create a dashboard in which an actuary specifies the age of the customer and this action updates probabilities and life expectancy for both genders. Feel free to use either tables or graphical representations of data. Hint: To combine values of the first 3 rows to use as column headers, refer to this workflow from the Community Hub. Hint 2: The Integer Widget does not refresh the interactive view of the component. Consider adding the Refresh Button Widget.

DataExtract the firsttwo rows with the column headervaluesReplace missingvalues with the previousvalueCombine the two parts of the column headersApply the new column headersRename& String to numberExcel Reader Row Splitter Transpose Missing Value Column Combiner Insert ColumnHeader Table Manipulator Component DataExtract the firsttwo rows with the column headervaluesReplace missingvalues with the previousvalueCombine the two parts of the column headersApply the new column headersRename& String to numberExcel Reader Row Splitter Transpose Missing Value Column Combiner Insert ColumnHeader Table Manipulator Component

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: sryus
Created at: 2023-07-05
On NodePit since: 2023-07-06
Last update: 2024-04-28
Created with KNIME version: v4.7.4
Tags: JKISeason2-15

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!