Please enable JavaScript.
Coggle requires JavaScript to display documents.
Week 7: Data Transformation - Coggle Diagram
Week 7: Data Transformation
Why?
Data may be in
different files
or
database
JOIN
Both Files
have a
common variable field
Outcome: increase in the
number
of
variables(columns)
Append
monthly data into a
single data set
Note
that this is
possible
if
both data files
have
same number of variables(columns)
Outcome:
Increase
in
number
of
observations
Data may be in a
format not directly usable
The
column
and
row
need to be
switched
This is
known
as
Transpose
When
additional variable
is
needed
for
better analysis
Additional variable
can be
derived
from the given
raw data
Example: to find the
volume
Vol= Length X Breath X Height
Data need to be
reshaped
or
regroup
to
provide better insights
Data
Discretization
If, Else statement
If (variable) > or < than (specified value) then "High" Else "low"
Numerical --> Categorical
Data
re-coding
renaming
the
values
in the
cell
New
Column,
Consistent
Format
Group
&
Aggregate
Data
Normalisation
z-score
Both
variable into
common
base