.. _auto_dataset_get_column_ratio:

*DATASET GET COLUMN RATIO*
==========================

Computes the element-wise ratio of a named column from two datasets (Dataset 1 / Dataset 2) and returns the result as a new dataset. Use this worker when you need to normalize, compare, or derive a per-row ratio between two parallel datasets sharing a common column.

When to use
-----------

Classification: **process**.

Tagged: ``column_ratio``, ``dataset``, ``element_wise``, ``ratio``, ``transform``.

Inputs
------

.. list-table::
   :header-rows: 1
   :widths: 20 20 20 20 20 20

   * - Label
     - ID
     - Type
     - Default
     - Required
     - Description
   * - Dataset
     - dataset1
     - dataset
     - —
     - 
     - Numerator dataset; must contain the column specified by `column_name`. Accepts any tabular dataset available in the workflow.
   * - Dataset
     - dataset2
     - dataset
     - —
     - 
     - Denominator dataset; must contain the same column specified by `column_name`. Ensure no zero values exist in the target column to avoid division-by-zero.
   * - Column Name
     - column_name
     - scalar
     - —
     - 
     - Name of the column (string, quoted) present in both datasets on which the element-wise ratio (dataset1 / dataset2) will be computed.

Outputs
-------

.. list-table::
   :header-rows: 1
   :widths: 20 20 20 20

   * - Label
     - ID
     - Type
     - Description
   * - dataset_get_column_ratio_output_1
     - dataset_get_column_ratio_output_1
     - dataset
     - Output dataset containing the element-wise ratio of the specified column (dataset1[column] / dataset2[column]); row count matches the input datasets.

Disciplines
-----------

- data.dataset.transform

Runnable example
----------------

A runnable example is registered for this worker. Open the example workflow on the d3VIEW canvas: `/api/workflow/example?id=dataset_get_column_ratio <https://www.d3view.com/api/workflow/example?id=dataset_get_column_ratio>`_

.. raw:: html

   <hr style="margin-top:2em">
   <p style="font-size:11px;color:#888">
   Auto-generated from <code>transformation</code> schema. Worker id: <code>dataset_get_column_ratio</code>. Schema hash: <code>b372f593884e</code>. Hand-curated docs in <code>workerexamples/</code> override this page when present.
   </p>