Please enable JavaScript.
Coggle requires JavaScript to display documents.
Chapter 10 (Splitting data (Sometimes code is checked and based on how…
Chapter 10
Splitting data
Sometimes code is checked and based on how binary your question is
RegEx
This language finds, replaces, or extracts text content
Think about the CTRL+F function -- but more advanced
EX: Email finder: " "
"
. "."___"
\w is their equivalent of % in SQL.
\d is for numerical values
\D is for alphabetical values
? is invisible. Means that bit after the field is not needed to match
Color vs Colour
Case sensitive
.
Replace
Match
Count matches
Repetitions
ASTERISK --> Pattern can match 0-infinite times, skipped if not found
PLUS --> Must happen at least once. No upper limit
{x} or {x, x+3} sets how many times the pattern can occur for it to count
Captures
Text to Column
Transforms
Column Manipulation
Addition
EX: Spouse count + Children = Family size
Subtraction
EX: Curent temp - Preferred indoor temp
Absolute --- Abs()
EX: Carnie weight guess. Actual amount off > Positive/Negative change
Multiplication
EX: Bad customer service reaction * Temperament
Exponentiation
Pert, used for compounding interest
Log, Sqrt, Sq
Pt. 10.1.1 and 10.2
