Icon

Data Wrangling _​ Most Frequent Wildcard Combinations

https://forum.knime.com/t/3-chars-sentences-analysis/72972

Data Wrangling _ Most Frequent Wildcard Combinationshttps://forum.knime.com/t/3-chars-sentences-analysis/72972 1) R script 2) 3-tuplecombinations 3) count triple wildcardmatch 4) 3 wildcardcombinations file1code wildcards file2text tablecodes idmax codes_idto R 'n'variableloop by rows 3-tuple combinations tablerow to columnregex codes to variableregex match 3 variablestype regex search codeextract_code (this node is optional in workflow)concatenate resultsgeneric column name in loopsum up matchesappend combination frequency to rowsort wildcard combination frequencydescendingFind all 3-tuple (generic)combinations withoutrepetition of code_idreplace generic mapped from codes_idshape to longshape to wide3-tuple combinations without repetition (clean table)resultstable Table Creator Table Creator Math Formula GroupBy Table Rowto Variable Group Loop Start Transpose Table Columnto Variable Rule Engine String Manipulation String Manipulation Loop End Column Rename(Regex) GroupBy Cross Joiner Sorter R Source (Table) Cell Replacer Unpivoting Pivoting RowID RowID Data Wrangling _ Most Frequent Wildcard Combinationshttps://forum.knime.com/t/3-chars-sentences-analysis/72972 1) R script 2) 3-tuplecombinations 3) count triple wildcardmatch 4) 3 wildcardcombinations file1code wildcards file2text tablecodes idmax codes_idto R 'n'variableloop by rows 3-tuple combinations tablerow to columnregex codes to variableregex match 3 variablestype regex search codeextract_code (this node is optional in workflow)concatenate resultsgeneric column name in loopsum up matchesappend combination frequency to rowsort wildcard combination frequencydescendingFind all 3-tuple (generic)combinations withoutrepetition of code_idreplace generic mapped from codes_idshape to longshape to wide3-tuple combinations without repetition (clean table)resultstable Table Creator Table Creator Math Formula GroupBy Table Rowto Variable Group Loop Start Transpose Table Columnto Variable Rule Engine String Manipulation String Manipulation Loop End Column Rename(Regex) GroupBy Cross Joiner Sorter R Source (Table) Cell Replacer Unpivoting Pivoting RowID RowID

Nodes

Extensions

Links