02 Data
02 Data
to Data Mining
Chapter 2. Getting to Know Your Data
Jiawei Han, Computer Science, Univ. Illinois at Urbana-
Champaign, 2017
1
Data Mining: Concepts and
May 16, 2026 Techniques 2
Chapter 2. Getting to Know Your Data
Data Visualization
Summary
3
Types of Data Sets: (1) Record Data
Relational records
Relational tables, highly structured
Data matrix, e.g., numerical matrix, crosstabs
Transaction data
timeout
season
coach
game
score
team
ball
lost
pla
wi
n
y
TID Items
1 Bread, Coke, Milk
2 Beer, Bread Document 1 3 0 5 0 2 6 0 2 0 2
3 Beer, Coke, Diaper, Milk
Document 2 0 7 0 2 1 0 0 3 0 0
4 Beer, Bread, Diaper, Milk
5 Coke, Diaper, Milk Document 3 0 1 0 0 1 2 2 0 3 0
Transportation network
Molecular Structures
Image data:
Video data:
7
Important Characteristics of Structured
Data
Dimensionality
Curse of dimensionality
Sparsity
Only presence counts
Resolution
Patterns depend on the scale
Distribution
Centrality and dispersion
8
Data Objects
Data sets are made up of data objects
A data object represents an entity
Examples:
sales database: customers, store items, sales
medical database: patients, treatments
university database: students, professors, courses
Also called samples , examples, instances, data points, objects, tuples
Data objects are described by attributes
Database rows → data objects; columns → attributes
9
Attributes
Attribute (or dimensions, features, variables)
A data field, representing a characteristic or feature of a data object.
E.g., customer _ID, name, address
Types:
Nominal (e.g., red, blue)
Binary (e.g., {true, false})
Ordinal (e.g., {freshman, sophomore, junior, senior})
Numeric: quantitative
Interval-scaled: 100○C is interval scales
Ratio-scaled: 100○K is ratio scaled since it is twice as high as 50 ○K
Q1: Is student ID a nominal, ordinal, or interval-scaled data?
Q2: What about eye color? Or color in the color spectrum of physics?
10
Attribute Types
Nominal: categories, states, or “names of things”
Hair_color = {auburn, black, blond, brown, grey, red, white}
marital status, occupation, ID numbers, zip codes
Binary
Nominal attribute with only 2 states (0 and 1)
Symmetric binary: both outcomes equally important
e.g., gender
Asymmetric binary: outcomes not equally important.
e.g., medical test (positive vs. negative)
Convention: assign 1 to most important outcome (e.g., HIV positive)
Ordinal
Values have a meaningful order (ranking) but magnitude between successive
values is not known
Size = {small, medium, large}, grades, army rankings
11
Numeric Attribute Types
Quantity (integer or real-valued)
Interval
Inherent zero-point
We can speak of values as being an order of magnitude larger than the unit
of measurement (10 K˚ is twice as high as 5 K˚).
e.g., temperature in Kelvin, length, counts, monetary quantities
12
Discrete vs. Continuous Attributes
Discrete Attribute
Has only a finite or countably infinite set of values
E.g., zip codes, profession, or the set of words in a collection of documents
Sometimes, represented as integer variables
Note: Binary attributes are a special case of discrete attributes
Continuous Attribute
Has real numbers as attribute values
E.g., temperature, height, or weight
Practically, real values can only be measured and represented using a finite number
of digits
Continuous attributes are typically represented as floating-point variables
13
Chapter 2. Getting to Know Your Data
Data Visualization
Summary
14
Basic Statistical Descriptions of
Data
Motivation
To better understand the data: central tendency, variation and spread
15
Measuring the Central Tendency: (1)
Mean
Mean (algebraic measure) (sample vs. population):
Note: n is sample size and N is population size.
1 n
x xi x
n i 1 N
n
Weighted arithmetic mean: w x i i
x i 1n
w
i 1
i
Trimmed mean:
Chopping extreme values (e.g., Olympics gymnastics score computation)
16
Measuring the Central Tendency: (2)
Median
Median:
Middle value if odd number of values, or average of the middle two values otherwise
Estimated by interpolation (for grouped data):
Unimodal
Empirical formula:
mean mode 3 (mean median)
Multi-modal
Bimodal
Trimodal
18
Symmetric vs. Skewed Data
symmetric
Median, mean and mode of symmetric,
positively and negatively skewed data
positively negatively
skewed skewed
19
Properties of Normal Distribution Curve
← — ————Represent data dispersion, spread — ————→
n n n
1 1 1
2 2 2 2
s ( xi x ) [ x i ( x i ]
)
n 1 i 1 n 1 i 1 n i 1
n n
1 1
( xi ) xi
2 2 2 2
N i 1 N i 1
Standard deviation s (or σ) is the square root of variance s2 (or σ2)
21
Graphic Displays of Basic Statistical
Descriptions
Boxplot: graphic display of five-number summary
Histogram: x-axis are values, y-axis repres. frequencies
Quantile plot: each value xi is paired with fi indicating that approximately 100 fi % of
data are xi
Quantile-quantile (q-q) plot: graphs the quantiles of one univariant distribution
against the corresponding quantiles of another
Scatter plot: each pair of values is a pair of coordinates and plotted as points in the
plane
22
Measuring the Dispersion of Data: Quartiles &
Boxplots
Quartiles: Q1 (25th percentile), Q3 (75th percentile)
Inter-quartile range: IQR = Q3 – Q1
Five number summary: min, Q1, median, Q3, max
Boxplot: Data is represented with a box
Q1, Q3, IQR: The ends of the box are at the first and
third quartiles, i.e., the height of the box is IQR
Median (Q2) is marked by a line within the box
Whiskers: two lines outside the box extended to
Minimum and Maximum
Outliers: points beyond a specified outlier threshold, plotted individually
Outlier: usually, a value higher/lower than 1.5 x IQR
23
Visualization of Data Dispersion: 3-D
Boxplots
24
Histogram Analysis
Histogram
Histogram: Graph display of tabulated 40
35
frequencies, shown as bars
30
Differences between histograms and bar charts 25
26
Quantile Plot
Displays all of the data (allowing the user to assess both the overall behavior and
unusual occurrences)
Plots quantile information
For a data xi data sorted in increasing order, fi indicates that approximately 100 fi
% of the data are below or equal to the value xi
28
Scatter plot
Provides a first look at bivariate data to see clusters of points, outliers, etc.
Each pair of values is treated as a pair of coordinates and plotted as points in the
plane
29
Positively and Negatively Correlated Data
31
Chapter 2. Getting to Know Your Data
Data Visualization
Summary
32
Data Visualization
Why data visualization?
Gain insight into an information space by mapping data onto graphical primitives
Provide qualitative overview of large data sets
Search for patterns, trends, structure, irregularities, relationships among data
Help find interesting regions and suitable parameters for further quantitative
analysis
Provide a visual proof of computer representations derived
Categorization of visualization methods:
Pixel-oriented visualization techniques
Geometric projection visualization techniques
Icon-based visualization techniques
Hierarchical visualization techniques
Visualizing complex data and relations
33
Pixel-Oriented Visualization Techniques
For a data set of m dimensions, create m windows on the screen, one for each
dimension
The m dimension values of a record are mapped to m pixels at the corresponding
positions in the windows
The colors of the pixels reflect the corresponding values
36
Direct Data Visualization
Matrix of scatterplots
(x-y-diagrams) of the k-
dim. data
A total of k(k-1)/2
distinct scatterplots
38
Landscapes
40
Parallel Coordinates of a Data
Set
41
Icon-Based Visualization Techniques
Visualization of the data values as features of icons
Typical visualization methods
Chernoff Faces
Stick Figures
General techniques
Shape coding: Use shape to represent certain information encoding
Color icons: Use color icons to encode more information
Tile bars: Use small icons to represent the relevant feature vectors in document
retrieval
42
Chernoff Faces
A way to display variables on a two-dimensional surface, e.g., let x be eyebrow slant,
y be eye size, z be nose length, etc.
The figure shows faces produced using 10 characteristics--head eccentricity, eye
size, eye spacing, eye eccentricity, pupil size, eyebrow slant, nose size, mouth shape,
mouth size, and mouth opening): Each assigned one of 10 possible values,
generated using Mathematica (S. Dickson)
REFERENCE: Gonick, L. and Smith, W.
The Cartoon Guide to Statistics. New York:
Harper Perennial, p. 212, 1993
Weisstein, Eric W. "Chernoff Face." From
MathWorld--A Wolfram Web Resource.
[Link]/[Link]
43
Stick Figure
etc.
44
Hierarchical Visualization Techniques
Visualization of the data using a hierarchical partitioning into subspaces
Methods
Dimensional Stacking
Worlds-within-Worlds
Tree-Map
Cone Trees
InfoCube
45
Dimensional Stacking
Visualization of oil mining data with longitude and latitude mapped to the
outer x-, y-axes and ore grade and depth mapped to the inner x-, y-axes
47
Worlds-within-Worlds
Assign the function and two most important parameters to innermost world
Fix all other parameters at constant values - draw other (1 or 2 or 3 dimensional
worlds choosing these as the axes)
Software that uses this paradigm
N–vision: Dynamic
interaction through data
glove and stereo displays,
including rotation, scaling
(inner) and translation
(inner/outer)
Auto Visual: Static
interaction by means of
queries
48
Tree-Map
Screen-filling method which uses a hierarchical partitioning of the screen into
regions depending on the attribute values
The x- and y-dimension of the screen are partitioned alternately according to the
attribute values (classes)
50
Three-D Cone Trees
3D cone tree visualization technique works well for
up to a thousand nodes or so
First build a 2D circle tree that arranges its nodes in
concentric circles centered on the root node
Cannot avoid overlaps when projected to 2D
G. Robertson, J. Mackinlay, S. Card. “Cone Trees:
Animated 3D Visualizations of Hierarchical
Information”, ACM SIGCHI'91
Graph from Nadeau Software Consulting website:
Visualize a social network data set that models the
way an infection spreads from one person to the
next
51
Visualizing Complex Data and Relations: Tag Cloud
Tag cloud: Visualizing user-generated
tags
The importance of tag is represented
by font size/color
Popularly used to visualize
word/phrase distributions
52
Visualizing Complex Data and Relations: Social Networks
Visualizing non-numerical data: social and information networks
organizing
information
networks
A social network
53
Chapter 2. Getting to Know Your Data
Data Visualization
Summary
54
Similarity, Dissimilarity, and Proximity
Similarity measure or similarity function
A real-valued function that quantifies the similarity between two objects
Measure how two data objects are alike: The higher value, the more alike
Often falls in the range [0,1]: 0: no similarity; 1: completely similar
Dissimilarity (or distance) measure
Numerical measure of how different two data objects are
In some sense, the inverse of similarity: The lower, the more alike
Minimum dissimilarity is often 0 (i.e., completely similar)
Range [0, 1] or [0, ∞) , depending on the definition
Proximity usually refers to either similarity or dissimilarity
55
Data Matrix and Dissimilarity Matrix
Data matrix x11 x12 ... x1l
A data matrix of n data points with l dimensions x21 x22 ... x2l
D
Dissimilarity (distance) matrix
n data points, but registers only the distance d(i, j) xn1 xn 2 ... xnl
(typically metric)
0
Usually symmetric, thus a triangular matrix
d (2,1) 0
Distance functions are usually different for real, boolean,
categorical, ordinal, ratio, and vector variables
d ( n ,1) d ( n , 2) ... 0
Weights can be associated with different variables based
on applications and data semantics
56
Standardizing Numeric Data
Z-score: x
z
X: raw score to be standardized, μ: mean of the population, σ: standard deviation
the distance between the raw score and the population mean in units of the
standard deviation
negative when the raw score is below the mean, “+” when above
An alternative way: Calculate the mean absolute deviation
s f 1n (| x1 f m f | | x2 f m f | ... | xnf m f |)
where
m f 1n (x1 f x2 f ... xnf )
.
xif m f
standardized measure (z-score): zif s
f
Using mean absolute deviation is more robust than using standard deviation
57
Example: Data Matrix and Dissimilarity Matrix
Data Matrix
x2 x4
point attribute1 attribute2
4 x1 1 2
x2 3 5
x3 2 0
x4 4 5
2 x1
Dissimilarity Matrix (by Euclidean
x1 Distance)
x2 x3 x4
x1 0
x3
x2 3.61 0
0 2 4 x3 2.24 5.1 0
x4 4.24 1 5.39 0
58
Distance on Numeric Data: Minkowski
Distance
Minkowski distance: A popular distance measure
d (i, j ) p | xi1 x j1 | p | xi 2 x j 2 | p | xil x jl | p
where i = (xi1, xi2, …, xil) and j = (xj1, xj2, …, xjl) are two l-dimensional data
objects, and p is the order (the distance so defined is also called L-p norm)
Properties
d(i, j) > 0 if i ≠ j, and d(i, i) = 0 (Positivity)
d(i, j) = d(j, i) (Symmetry)
d(i, j) d(i, k) + d(k, j) (Triangle Inequality)
A distance that satisfies these properties is a metric
Note: There are nonmetric dissimilarities, e.g., set differences
59
Special Cases of Minkowski Distance
p = 1: (L1 norm) Manhattan (or city block) distance
E.g., the Hamming distance: the number of bits that are different between
two binary vectors d (i, j ) | x x | | x x | | x x |
i1 j1 i2 j2 il jl
60
Example: Minkowski Distance at Special
Cases
point attribute 1 attribute 2 Manhattan (L1)
x1 1 2 L x1 x2 x3 x4
x2 3 5 x1 0
x3 2 0 x2 5 0
x4 4 5 x3 3 6 0
x4 6 1 7 0
x2 x4 Euclidean (L2)
L2 x1 x2 x3 x4
4 x1 0
x2 3.61 0
x3 2.24 5.1 0
x4 4.24 1 5.39 0
2 x1
Supremum (L)
L x1 x2 x3 x4
x1 0
x2 3 0
x3 x3 2 5 0
0 2 4 x4 3 1 5 0
61
Proximity Measure for Binary Attributes
A contingency table for binary data
Object j
Object i
62
Example: Dissimilarity between Asymmetric Binary
Variables
Mary
Name Gender Fever Cough Test-1 Test-2 Test-3 Test-4
1 0 ∑row
Jack M Y N P N N N
Mary F Y N P N P N 1 2 0 2
Jack
Jim M Y P N N N N 0 1 3 4
Gender is a symmetric attribute (not counted in) ∑col 3 3 6
Jim
The remaining attributes are asymmetric binary 1 0 ∑row
Let the values Y and P be 1, and the value N be 0 1 1 1 2
Jack 0 1 3 4
Distance:
∑col 2 4 6
0 1 Mary
d ( jack , mary ) 0.33
2 0 1 1 0 ∑row
11
d ( jack , jim ) 0.67 1 1 1 2
111
1 2 Jim 0 2 2 4
d ( jim , mary ) 0.75
11 2 ∑col 3 3 6
63
Proximity Measure for Categorical Attributes
p
d (i, j) p m
64
Ordinal Variables
An ordinal variable can be discrete or continuous
Order is important, e.g., rank (e.g., freshman, sophomore, junior, senior)
Can be treated like interval-scaled
Replace an ordinal variable value by its rank: rif {1,..., M f }
Map the range of each variable onto [0, 1] by replacing i-th object in the
f-th variable by rif 1
zif
Mf 1
Example: freshman: 0; sophomore: 1/3; junior: 2/3; senior 1
Then distance: d(freshman, senior) = 1, d(junior, senior) = 1/3
Compute the dissimilarity using methods for interval-scaled variables
65
Attributes of Mixed Type
A dataset may contain all attribute types
Nominal, symmetric binary, asymmetric binary, numeric, and ordinal
One may use a weighted formula to combine their effects:
p
ij dij
w (f) (f)
d (i, j ) f 1 p
ij
w (f)
f 1
66 Treat z as interval-scaled
Cosine Similarity of Two Vectors
A document can be represented by a bag of terms or a long vector, with each attribute
recording the frequency of a particular term (such as word, keyword, or phrase) in the
document
69
attend if you want to do the 4th credit project!!!
KL Divergence: Comparing Two Probability
Distributions
The Kullback-Leibler (KL) divergence:
Measure the difference between two
probability distributions over the same
variable x
From information theory, closely related
to relative entropy, information
divergence, and information for
discrimination
DKL(p(x) || q(x)): divergence of q(x) from
p(x), measuring the information lost when
q(x) is used to approximate p(x)
Ack.: Wikipedia entry: The Kullback-Leibler (KL) divergence
Discrete form
Continuous form
70
More on KL Divergence
The KL divergence measures the expected number of extra bits required to code
samples from p(x) (“true” distribution) when using a code based on q(x), which
represents a theory, model, description, or approximation of p(x)
The KL divergence is not a distance measure, not a metric: asymmetric, not satisfy
triangular inequality (DKL(P‖Q) does not equal DKL(Q‖P))
In applications, P typically represents the "true" distribution of data, observations, or
a precisely calculated theoretical distribution, while Q typically represents a theory,
model, description, or approximation of P.
The Kullback–Leibler divergence from Q to P, denoted DKL(P‖Q), is a measure of the
information gained when one revises one's beliefs from the prior probability
distribution Q to the posterior probability distribution P. In other words, it is the
amount of information lost when Q is used to approximate P.
The KL divergence is sometimes also called the information gain achieved if P is used
instead of Q. It is also called the relative entropy of P with respect to Q.
71
Subtlety at Computing the KL Divergence
Base on the formula, DKL(P,Q) ≥ 0 and DKL(P || Q) = 0 if and only if P = Q
How about when p = 0 or q = 0?
limp→0 p log p = 0
when p != 0 but q = 0, DKL(p || q) is defined as ∞, i.e., if one event e is possible (i.e.,
p(e) > 0), and the other predicts it is absolutely impossible (i.e., q(e) = 0), then the
two distributions are absolutely different
However, in practice, P and Q are derived from frequency distributions, not counting
the possibility of unseen events. Thus smoothing is needed
Example: P : (a : 3/5, b : 1/5, c : 1/5). Q : (a : 5/9, b : 3/9, d : 1/9)
need to introduce a small constant ϵ, e.g., ϵ = 10−3
The sample set observed in P, SP = {a, b, c}, SQ = {a, b, d}, SU = {a, b, c, d}
Smoothing, add missing symbols to each distribution, with probability ϵ
P′ : (a : 3/5 − ϵ/3, b : 1/5 − ϵ/3, c : 1/5 − ϵ/3, d : ϵ)
Q′ : (a : 5/9 − ϵ/3, b : 3/9 − ϵ/3, c : ϵ, d : 1/9 − ϵ/3)
72
Chapter 2. Getting to Know Your Data
Data Visualization
Summary
73
Summary
Data attribute types: nominal, binary, ordinal, interval-scaled, ratio-scaled
Many types of data sets, e.g., numerical, text, graph, Web, image.
Gain insight into the data by:
Basic statistical data description: central tendency, dispersion, graphical displays
Data visualization: map data onto graphical primitives
Measure data similarity
Above steps are the beginning of data preprocessing
Many methods have been developed but still an active area of research
74
References
W. Cleveland, Visualizing Data, Hobart Press, 1993
T. Dasu and T. Johnson. Exploratory Data Mining and Data Cleaning. John Wiley, 2003
U. Fayyad, G. Grinstein, and A. Wierse. Information Visualization in Data Mining and Knowledge
Discovery, Morgan Kaufmann, 2001
L. Kaufman and P. J. Rousseeuw. Finding Groups in Data: an Introduction to Cluster Analysis. John
Wiley & Sons, 1990.
H. V. Jagadish et al., Special Issue on Data Reduction Techniques. Bulletin of the Tech. Committee on
Data Eng., 20(4), Dec. 1997
D. A. Keim. Information visualization and visual data mining, IEEE trans. on Visualization and
Computer Graphics, 8(1), 2002
D. Pyle. Data Preparation for Data Mining. Morgan Kaufmann, 1999
S. Santini and R. Jain,” Similarity measures”, IEEE Trans. on Pattern Analysis and Machine
Intelligence, 21(9), 1999
E. R. Tufte. The Visual Display of Quantitative Information, 2nd ed., Graphics Press, 2001
C. Yu, et al., Visual data mining of multimedia data for social and behavioral studies, Information
Visualization, 8(1), 2009
75
Data Mining: Concepts and 76
76 May 16, 2026 Techniques