Icon

Challenge 14 - Removing Noise from Data

Challenge 14 - Removing Noise from Data
Challenge 14: Removing Noise from Data Description: You are working with audio recognition data tables such that each table’s initial and final rows contain zeroes. These beginning and ending zeroes areirrelevant noise that must be removed. Here is an example of such a data table:0080710Your goal is to only remove these unnecessary starting and trailing zeroes. You must keep the zeroes in the middle of the data, which do not constitute noise. As well, theposition of the starting and trailing zeroes differs per data table, so a good solution probably requires flow variables for flexibility (although there may be other solutionswhich do not involve flow variables). READ DATA FINAL OUTCOME Filter Zeroes with Lag column and some rules Logic to check whether the last row is still Zero Read audio_table_instanceLag InstanceColumnDefine rulesto delete rowsFilterZeroesNode 5Node 6Node 7Node 8Node 10Node 11Node 12Node 13CSV Reader Lag Column Rule Engine Row Filter Column Filter Sorter Table Rowto Variable Rule EngineVariable Variable toTable Row RowID Joiner Row Filter Challenge 14: Removing Noise from Data Description: You are working with audio recognition data tables such that each table’s initial and final rows contain zeroes. These beginning and ending zeroes areirrelevant noise that must be removed. Here is an example of such a data table:0080710Your goal is to only remove these unnecessary starting and trailing zeroes. You must keep the zeroes in the middle of the data, which do not constitute noise. As well, theposition of the starting and trailing zeroes differs per data table, so a good solution probably requires flow variables for flexibility (although there may be other solutionswhich do not involve flow variables). READ DATA FINAL OUTCOME Filter Zeroes with Lag column and some rules Logic to check whether the last row is still Zero Read audio_table_instanceLag InstanceColumnDefine rulesto delete rowsFilterZeroesNode 5Node 6Node 7Node 8Node 10Node 11Node 12Node 13CSV Reader Lag Column Rule Engine Row Filter Column Filter Sorter Table Rowto Variable Rule EngineVariable Variable toTable Row RowID Joiner Row Filter

Nodes

Extensions

Links