In real-world machine learning scenarios, datasets are often not provided in a single, simple CSV file. Instead, they may be stored in a relational database, where information is distributed across multiple tables. For example, an e-commerce application might store customer addresses in one table and their purchase data in another, requiring practitioners to extract and merge these separate files before modeling.

Relational Database

In data science, missing values (often represented programmatically as `NaN`) occur when entries in a dataset are empty or undefined, resulting from missing data collection or parsing errors. These incomplete records are a persistent challenge in data preprocessing and must be deliberately handled before training a model, typically through either imputation (estimating replacement values) or deletion (discarding the incomplete rows or columns).

Missing Values

Comma-separated values (CSV) files are a ubiquitous format for storing tabular, spreadsheet-like data. In a CSV file, each line represents a distinct data record, and the individual fields within that record are separated by commas.

Claude

Data table

A dataset is collections of data, which can be in the form of a table, network, text, image, video, sound, ...

Dataset

Organized data presented in rows and columns. A table is useful for summarizing information and comparing different variables.

Table

Dive into Deep Learning

CSV File

- Number of data points (instances)
- Attributes (variables)
- Types of attributes (variables)
- Number of attributes (variables)
- Statistical measures

Characteristics of a dataset

Here are a list of free resources to find datasets. Most will be available in CSV format for easy integration into R or Python. 

Sample Datasets

It important to examine your dataset before starting to work with it for a machine learning task to:
- Understand how much missing data there is in the dataset.
- Get an idea of whether the features need further cleaning.
- Understand what techniques to use for analyzing the data.

The first step to analyze a dataset:

- 1) Equilibrium
- 2) Cyclic (periodic)
- 3) Random 
- 4) Complex

Wolfram's four classes of empirical data

Data can be distributed in several ways. Some of these include:
- Normal (Gaussian) distributions
- Uniform distributions
- Exponential distributions

Data Distributions

Supervised learning is a type of machine learning problem where the objective is to predict a designated unknown label based on known inputs. This approach requires a training dataset consisting of examples for which the ground truth labels are already known, allowing the model to learn the mapping from inputs to classifications.

Supervised Learning

A machine learning model is the computational machinery designed to ingest data of a specific type, apply mathematical transformations, and output predictions. In modern applications, the focus is on statistical models whose internal transformations can be estimated and refined using a dataset.

Machine Learning Model

Before data can be fed into any machine learning model, its overall quality must be evaluated and improved. Real-world datasets are often plagued by flaws such as extreme outliers, faulty sensor measurements, and human recording errors. Addressing these discrepancies is an essential part of the data preparation process to ensure the model learns from reliable information.

Data Quality

Beyond standard categorical and numeric variables, deep learning practitioners frequently work with myriad unstructured data formats. These complex data types include text strings for natural language processing, images and point clouds for computer vision, and audio data. Handling these diverse formats requires specialized approaches and advanced tools compared to traditional tabular data.

Deep Learning Data Types

A data processing bottleneck occurs when the time taken to load, transform, and prepare complex data—such as high-resolution images or large text corpora—exceeds the time required for actual model training. To prevent data preprocessing from severely slowing down the overall machine learning pipeline, practitioners must implement efficient algorithms and utilize advanced tools.

Data Processing Bottleneck

The success of a machine learning model heavily depends on having the right data, as encapsulated by the principle 'garbage in, garbage out.' If a dataset contains mistakes, features that do not predict the target, or reflects societal prejudices by under-representing certain groups, the learning process will fail or produce biased, harmful results.

Machine Learning Dataset Quality

A machine learning example, interchangeably referred to as a data point, sample, or instance, represents an individual record within a dataset. To be useful for learning algorithms, each example is characterized by a specific numerical representation, forming the basis for a model's predictions.

Machine Learning Example

A data batch, commonly referred to as a minibatch, is a discrete, smaller subset of a larger dataset that is processed simultaneously during a single iteration of machine learning model training or evaluation. Training typically requires multiple passes over a dataset, grabbing one minibatch at a time. Each minibatch consists of a tuple of features and corresponding labels. Processing data in minibatches rather than the entire dataset balances computational efficiency with hardware memory constraints.

Data Batch

When loading datasets for machine learning, the order in which data is read depends on the current mode. For training, data is typically read in a random order (shuffled) to properly update the model. For validation, data is read in a pre-defined, sequential order, which is important for debugging purposes and consistent evaluation.

Training vs. Validation Data Reading Order

Tables are highly effective tools for presenting substantial amounts of precise data concisely in an APA-style academic manuscript. Following general APA formatting principles, tables must introduce important new information rather than merely repeating data from the text, be designed as simply as possible, and be fully interpretable on their own without requiring the reader to reference the surrounding narrative.

APA Style Tables

A correlation matrix is a specific type of table utilized to present the correlation coefficients—typically Pearson’s $$r$$—among several different variables. To avoid redundant information and improve overall readability, only the lower half of the matrix is filled with values, as the upper half would display identical mirror correlations. Furthermore, because any variable's correlation with itself is always a perfect $$+1.00$$, these values along the diagonal are conventionally replaced with dashes.

Learn Before

Related

Learn After