Please enable JavaScript.
Coggle requires JavaScript to display documents.
Data Transformations: Chapter 10 (Transformations (10.2) (Addition (+),…
Data Transformations: Chapter 10
Focus on creating new columns based on data acquired
Text
categorical
numerical
If then staments and one-hot encoding (10.1.1)
examine value in column and make changes to this value in the dataset
In excel "If"
In SQL " Case"
One hot encoding
Changes from categorical columns to discreet binary columns
for certain machine learning tools (can only read binary)
Transformations (10.2)
Addition (+)
Subtraction (-)
Absolute (abs)
Division (/)
Multiplicaiton (*)
Less than (<)
Greater than (>)
Less than or equal to (<=)
Greater than or equal to (>=)
Not equal (!=)
Equal (==)
Exponentation (C
e**(r
t)
Natural logarithm (log())
Squareroot (sqrt())
Square (square())