Say I have a data frame that looks like this:
Factor Value
====== =====
1A.In 1.0
1A.Out 2.6
1B.In 0.5
1B.Out 3.4
2A.In 5.5
etc.
My goal is to add columns to the data frame that extract information from the single Factor column, as such:
Factor Value Fact1 Fact2 Fact3
====== ===== ===== ===== =====
1A.In 1.0 1 A In
1A.Out 2.6 1 A Out
1B.In 0.5 1 B In
1B.Out 3.4 1 B Out
2A.In 5.5 2 A In
I just cannot figure out how to do this without using subset ad nauseum. I'm relatively new to R, and don't have a background in programming, so any advice would be much appreciated.
See ?substr
.
within(df, {
Fact1 <- substr(Factor, 1, 1)
Fact2 <- substr(Factor, 2, 2)
Fact3 <- substr(Factor, 4, 999)
})
I'm making assumptions here about how many characters to use for each new variable. For more generality, you should have some kind of regular structure in Factor
, eg dots as separators for all your variables.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With