Icon

2. Loop on List of Columns

<p><strong>Loop on List of Columns - Column List Loop</strong></p><p>This workflow implements an example of a loop on a list of columns using the <em>Column List Loop Start</em> node.</p><p>First, we access the data created by the loop in the previous "Counting Loop" workflow. Then, we remove the duplicate "Cluster Membership" columns that each loop iteration created and keep only one to keep the dataset clean of duplicates. Next, we process the rest of the data. Here, we want to process the data of the different iterations (columns denoted by ("Iter #") differently, using different values for the "factor" variable. For that, we use a <em>Column List Loop Start</em> node to process one column in each iteration and define the logic inside the "Define factor" metanode.</p><p>Lastly, we plot the processed data in a scatter plot. Adjust the configuration of the <em>Scatter Plot</em> to visualize data of different groups and note the different data ranges for each group.</p>

Workflow: Loop on List of Columns - Column List Loop


This workflow implements an example of a loop on a list of columns using the Column List Loop Start node.

First, we access the data created by the loop in the previous "Counting Loop" workflow. Then, we remove the duplicate "Cluster Membership" columns that each loop iteration created and keep only one to keep the dataset clean of duplicates. Next, we process the rest of the data. Here, we want to process the data of the different iterations (columns denoted by ("Iter #") differently, using different values for the "factor" variable. For that, we use a Column List Loop Start node to process one column in each iteration and define the logic inside the "Define factor" metanode.

Lastly, we plot the processed data in a scatter plot. Adjust the configuration of the Scatter Plot to visualize data of different groups and note the different data ranges for each group.

Reading data

Access data generated by the counting loop in the "Counting Loop" workflow.

Visualizing data

Loop body

Visualizing data

Check data range for each group of data (Iter #)

Visualize original data
Scatter Plot
Visualize processed dataof group 3 (Iter #2)
Scatter Plot
Keep only one"Cluster Membership"column
Column Filter
Remove"Cluster Membership"
Column Filter
Calculate:current column * factor
Expression
"temp_column" backto original name
Column Renamer
Current columnto "temp_column"
Column Renamer
Loop End (Column Append)
Define factor
generatedData.csv
CSV Reader
Define list of columnsto be processed in the loop
Column List Loop Start
Color by cluster
Color Manager
Add back Cluster Membership
Joiner

Nodes

Extensions

Links