Hi Sam,
If I have the structure of your data right, this might help:
scdf<-read.csv(text="DD Pack0.00
FTA English News0.00
FTA Complimentary0.00
WB1.18
WION1.18
Al Jazeera0.00
Animal Planet2.36
Asianet Movies17.70
Calcutta News0.00
Comedy Central5.90",
header=FALSE,
stringsAsFactors=FALSE)
digitindex<-as.numeric(regexpr("[[:digit:]]",scdf[,1]))
lengths<-sapply(scdf[,1],nchar)
scdf<-data.frame(channel=substr(scdf[,1],1,digitindex-1),
price=substr(scdf[,1],digitindex,lengths))
Jim
On Mon, Jun 17, 2019 at 1:47 AM Sam Charya via R-help
<r-help@r-project.org> wrote:
>
> Dear All,
>
> I need help with splitting a string. My data frame is in the following format:
> V11 DD Pack0.002 FTA English News0.003
> FTA Complimentary0.004 WB1.185 WION1.186
> Al Jazeera0.007 Animal Planet2.368 Asianet Movies17.709
> Calcutta News0.0010 Comedy Central5.90
> I read the file from a csv and set header = False, hence the name: V1.
> The data consists of names of TV Channels and their prices. For example: Row
> 1: Name of the Channel is 'DD Pack' and the Price is 0.00.similarly for Row
> 5, the name of the Channel is 'WION' and the price is 1.18.
> similarly for Row 8: The name of the Channel is 'Asianet Movies' and the
> price is 17.70.
>
> My question is: How would I separate the data into 2 columns: One for the
> Channel name and one for the Price.
> For example. The Heading should be for Col1: 'Channel Name' and for Col2:
> 'Price'The data under 'Channel Name' should be 'DD Pack' and for 'Price'
> should be 0.00 and so on and so forth.
> The letters and the numeric appears together and I am not being able to use a
> separator and I am not being able to figure this out. Kindly please help me
> with this.
> Many Thanks in advance for your help. This is my first question ever to the
> community so apologies if I have made a mistake in sending it to the wrong
> groups - kindly direct if that is the case.
> sam.
> ********************************************************
>
>
>
>
> [[alternative HTML version deleted]]
>
> ______________________________________________
> R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
______________________________________________
R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
