I Have data frame with 4 columns and I need to add space after each I so the values will split. Whole data frame has 8064 rows. Thank you.
CustomerI V1 V2 V3
1 1231231231 l22I34 l22 l22
2 1231231233 l7 l7I19 l7
3 1231231234 l31 l7 l31
4 1231231235 l31l7 l7 l31l7
5 1231231236 l16 l22 l16
6 1231231237 l31 l31 l31
Desired result
CustomerI V1 V2 V3
1 1231231231 l22 I34 l22 l22
2 1231231233 l7 l7 I19 l7
3 1231231234 l31 l7 l31
4 1231231235 l31 l7 l7 l31 l7
5 1231231236 l16 l22 l16
6 1231231237 l31 l31 l31
One idea would be to use
gsub
to capture the two groups and then insert a space between them