A short introduction to loading and transforming data in KNIME without writing code, following an Extract → Load → Transform approach on already downloaded data. The CSV Reader node loads the data (similar reader nodes exist for Excel, JSON and tables), and columns can be chosen in its Transformation tab or with the Column Filter node; the Column Rename node gives the inputs consistent names.
Data from two CSV readers is then concatenated into one table, rows where the step count is 0 are removed with a row filter, and two visualization nodes explore the result: Linear Correlation, which produces a correlation matrix between the columns, and Scatter Plot, which plots one column against another. The author presents KNIME as a powerful visual programming tool with a huge repository of nodes.
The Arabic article is a translation of an English article. Read the original: An introduction to data cleaning and manipulation with Knime (Towards Data Science).

