Now that we have Income
in a column we can split it up into upper and lower
as they are two different values. We can use multiple ways to extract this
information, seperate
, extract
, or case_when
. I will be using extract
as this provides the best way to collect this information.