What you'll learn:
- JOIN Types
- Changing names of the column headers
- Merging columns to create a new column
- Pattern Matching Criteria
- Range Checking Criteria
- Finding Data Patterns
Data pre-processing and coding is a prerequisite to move ahead in Data Science. KNIME eliminates those hurdles for you.
This course is for anyone who is familiar with tools such as Excel or Power Query (ETL). This course will help you get a head start in Data Science without any coding.
We’ll learn some practical applications of data blending and manipulation and apply our knowledge in the real world and solve business queries immediately. Following are the topics that we'll cover in this course:
JOIN Types - Left Outer, Right Outer, Full Outer, Inner, Left Anti, and Right Anti
Splitting one column into two
Change the name of the column headers
Merge columns to create a new column
Find out list of Male/Female candidates (Pattern Matching Criteria)
Filter out people whose credit score exceed a certain limit (Range Checking Criteria)
Pivoting with multiple columns and complex aggregation methods
Finding data patterns
By the end of the course, we will feel comfortable working with the KNIME Analytics Platform.