Back to Glossary Index

Dagster Data Engineering Glossary:


Data Discretization

Transform continuous data into discrete categories or bins to simplify analysis.

Data discretization definition:

Discretization is the process of converting continuous data into a set of discrete intervals or categories. This technique can be used for data reduction, simplification, or to make the data more suitable for analysis and it typically applied to very large datasets.

Data discretization examples using Python

Please note that you need to have the necessary Python libraries installed in your Python environment to run the code samples below.

using pandas cut()

One practical example of discretization in Python is using the pandas cut() function. The cut() function allows you to specify the number of bins you want to use and the range of the data, and it returns a new column with the values binned into those intervals. For example:

import pandas as pd

# create a sample dataset
data = pd.DataFrame({'values': [1, 2, 3, 4, 5, 6, 7, 8, 9, 10]})

# bin the values into three intervals
data['bins'] = pd.cut(data['values'], bins=3, labels=['Low', 'Medium', 'High'])

# view the binned data
print(data)

This will create a new column called 'bins' with the values binned into three intervals, 'Low', 'Medium', and 'High'. The output will be:

   values    bins
0       1     Low
1       2     Low
2       3  Medium
3       4  Medium
4       5  Medium
5       6    High
6       7    High
7       8    High
8       9    High
9      10    High

Another example of using using the pandas cut() function, if we have a DataFrame df containing a column ages , we can create bins and labels as follows:

import pandas as pd

# create a sample dataset
data = {'ages': [21, 32, 45, 18, 52, 28, 38, 50]}
df = pd.DataFrame(data)

bins = [0, 18, 35, 50, float('inf')]
labels = ['child', 'young adult', 'middle-aged', 'senior']

df['age_group'] = pd.cut(df['ages'], bins=bins, labels=labels)

print(df)

This will create a new column age_group in df containing the categorical labels based on the binning and print out the result:

   ages    age_group
0    21  young adult
1    32  young adult
2    45  middle-aged
3    18        child
4    52       senior
5    28  young adult
6    38  middle-aged
7    50  middle-aged

using scikit-learn

Another example of discretization in Python is using the KBinsDiscretizer class from the scikit-learn library. This class allows you to specify the number of bins, the strategy for dividing the data, and whether to encode the intervals as integers or one-hot vectors. For example:

from sklearn.preprocessing import KBinsDiscretizer

# create a sample dataset
data = [[1], [2], [3], [4], [5], [6], [7], [8], [9], [10]]

# bin the values into three intervals
discretizer = KBinsDiscretizer(n_bins=3, encode='ordinal', strategy='uniform')
data_bins = discretizer.fit_transform(data)

# view the binned data
print(data_bins)

This will create a new array with the values binned into three intervals, and will yield the following:

[[0.]
 [0.]
 [1.]
 [1.]
 [1.]
 [2.]
 [2.]
 [2.]
 [2.]
 [2.]]

In this case, the encode parameter is set to ordinal, which means that the intervals are represented as integers. If it were set to onehot, the intervals would be represented as one-hot vectors.


Other data engineering terms related to
Data Transformation:
Dagster Glossary code icon

Align

Aligning data can mean one of three things: aligning datasets, meeting business rules, or arranging data elements in memory.
An image representing the data engineering concept of 'Align'
Dagster Glossary code icon

Clean or Cleanse

Remove invalid or inconsistent data values, such as empty fields or outliers.
An image representing the data engineering concept of 'Clean or Cleanse'
Dagster Glossary code icon

Cluster

Group data points based on similarities or patterns to facilitate analysis and modeling.
An image representing the data engineering concept of 'Cluster'
Dagster Glossary code icon

Curate

Select, organize, and annotate data to make it more useful for analysis and modeling.
An image representing the data engineering concept of 'Curate'
Dagster Glossary code icon

Denoise

Remove noise or artifacts from data to improve its accuracy and quality.
An image representing the data engineering concept of 'Denoise'
Dagster Glossary code icon

Denormalize

Optimize data for faster read access by reducing the number of joins needed to retrieve related data.
An image representing the data engineering concept of 'Denormalize'
Dagster Glossary code icon

Derive

Extracting, transforming, and generating new data from existing datasets.
An image representing the data engineering concept of 'Derive'
Dagster Glossary code icon

ETL

Extract, transform, and load data between different systems.
An image representing the data engineering concept of 'ETL'
Dagster Glossary code icon

Encode

Convert categorical variables into numerical representations for ML algorithms.
An image representing the data engineering concept of 'Encode'
Dagster Glossary code icon

Filter

Extract a subset of data based on specific criteria or conditions.
An image representing the data engineering concept of 'Filter'
Dagster Glossary code icon

Fragment

Break data down into smaller chunks for storage and management purposes.
An image representing the data engineering concept of 'Fragment'
Dagster Glossary code icon

Homogenize

Make data uniform, consistent, and comparable.
An image representing the data engineering concept of 'Homogenize'
Dagster Glossary code icon

Impute

Fill in missing data values with estimated or imputed values to facilitate analysis.
An image representing the data engineering concept of 'Impute'
Dagster Glossary code icon

Linearize

Transforming the relationship between variables to make datasets approximately linear.
An image representing the data engineering concept of 'Linearize'

Munge

See 'wrangle'.
An image representing the data engineering concept of 'Munge'
Dagster Glossary code icon

Normalize

Standardize data values to facilitate comparison and analysis. Organize data into a consistent format.
Dagster Glossary code icon

Reduce

Convert a large set of data into a smaller, more manageable form without significant loss of information.
An image representing the data engineering concept of 'Reduce'
Dagster Glossary code icon

Reshape

Change the structure of data to better fit specific analysis or modeling requirements.
An image representing the data engineering concept of 'Reshape'
Dagster Glossary code icon

Serialize

Convert data into a linear format for efficient storage and processing.
An image representing the data engineering concept of 'Serialize'
Dagster Glossary code icon

Shred

Break down large datasets into smaller, more manageable pieces for easier processing and analysis.
Dagster Glossary code icon

Skew

An imbalance in the distribution or representation of data.
Dagster Glossary code icon

Split

Divide a dataset into training, validation, and testing sets for machine learning model training.
Dagster Glossary code icon

Standardize

Transform data to a common unit or format to facilitate comparison and analysis.
Dagster Glossary code icon

Tokenize

Convert data into tokens or smaller units to simplify analysis or processing.
An image representing the data engineering concept of 'Tokenize'

Transform

Convert data from one format or structure to another.
An image representing the data engineering concept of 'Transform'
Dagster Glossary code icon

Wrangle

Convert unstructured data into a structured format.
An image representing the data engineering concept of 'Wrangle'