Export Count Table
Exports the count table from a saved transformation for use with new data
Category: Learning with Counts
Applies to: Machine Learning Studio (classic)
This content pertains only to Studio (classic). Similar drag and drop modules have been added to Azure Machine Learning designer (preview). Learn more in this article comparing the two versions.
This article describes how to use the Export Count Table module in Azure Machine Learning Studio (classic). The Export Count Table module is provided for backward compatibility with experiments that use the Build Count Table (deprecated) and Count Featurizer (deprecated) modules.
When you use the new Build Counting Transform module to create count-based features, the module outputs both a featurized dataset and a transform that creates features from counts. By using the Export Count Table module, you can separate the count-based features output by this newer module into count metadata and a count table. These output formats were used by earlier, now deprecated modules:
For general information about count tables and how they are used to create features, see Learning with Counts.
For all new experiments, we recommend that you use the following modules:
How to configure Export Count Table
In Azure Machine Learning Studio (classic), open the experiment where you want to use the imported count table.
Locate the saved count transformation, and add it to the experiment.
Connect the output of the saved count transformation (labeled transformation) to Export Count Table.
Add the Count Featurizer (deprecated) module to the experiment, and connect it to the two outputs of Export Count Table.
The Count Featurizer (deprecated) module requires an additional input, for the dataset you want to featurize. Connect the dataset to apply the saved transformation to outputs.
Set any necessary parameters for Count Featurizer (deprecated), including the label column, the count columns, the columns to featurize, and the features to output.
You must select a subset of the columns that were originally selected for the counting transformation. However, the Export Count Table module does not provide the list of these columns, so you should review the original experiment and make a note of which columns were used. If you select a column that was not used when creating the transformation, an error is raised.
Explore examples of count-based featurization using these sample experiments in the Azure AI Gallery:
Flight delay prediction: Shows how count-based featurization can be useful in a very large dataset.
Learning with Counts: Multiclass classification with NYC taxi data: Demonstrates the use of count-based features in a multiclass prediction task.
Learning with Counts: Binary classification with NYC taxi data: Uses count-based features in a binary classification task.
If you open a Gallery experiment created using the deprecated versions of the Learning with Counts modules, the experiment is automatically upgraded to use the newer modules.
|Counting transform||ITransform interface||The counting transform.|
|Dracula count metadata||Data Table||The metadata of the counts.|
|Dracula count table||Data Table||The count table.|
|Error 0003||Exception occurs if one or more of inputs are null or empty.|
|Error 0086||Exception occurs when a counting transform is invalid.|
For a list of errors specific to Studio (classic) modules, see Machine Learning Error codes.
For a list of API exceptions, see Machine Learning REST API Error Codes.