Data Transformations: Chapter 10 (Transformations (10.2) (Less than or…
Data Transformations: Chapter 10
Focus on creating new columns based on data acquired
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)
Less than (<)
Greater than (>)
Less than or equal to (<=)
Greater than or equal to (>=)
Not equal (!=)
Natural logarithm (log())