Hub
Pricing About
ComponentComponent

discover multple categorical columns

ashokharnal profile image
Draft Latest edits on 
Dec 31, 2019 9:39 AM
Drag & drop
Like
Use or download
This node helps discover multiple categorical columns in the dataset in one go among numeric columns. Many a time data is annonymized with a large number of numerical columns, some of which are, in fact, nominal. In this component, you specify the maximum number of distinct values for a numeric column. If distinct values are equal to or less than that specified, the column would be transformed to string column else not. The outputs of component are possible categorical columns and the rest of dataframe The component uses 'Python Script' node to perform this function. It needs 'pandas' library.

Component details

Input ports
  1. Type: Table
    Port 1
    KNIME dataset, as for example from a csv reader.
Output ports
  1. Type: Table
    Possible Categorical columns
    These are your numeric columns but possibly categorical
  2. Type: Table
    Rest of dataset
    This is the rest of dataset

Used extensions & nodes

Created with KNIME Analytics Platform version 4.1.0
  • Go to item
    KNIME CoreTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.1.0

    knime
  • Go to item
    KNIME Python Integration

    KNIME AG, Zurich, Switzerland

    Version 4.1.0

    knime
  • Go to item
    KNIME Quick FormsTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.1.0

    knime

This component does not have nodes, extensions, nested components and related workflows

Legal

By using or downloading the component, you agree to our terms and conditions.

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • Courses + Certification
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more about KNIME Business Hub
© 2025 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Data Processing Agreement
  • Credits