[R] Help with a third ggplot error
r@oknz @end|ng |rom gm@||@com
Wed Jun 19 00:06:19 CEST 2019
Nobody else has asked the obvious question: why are the data squashed
like that in the first place? why not modify the process that generates the
data so that it does not do that? Jamming things together like that is not
common practice with CSV files, so what does the CSV file look like and why
does it look like that?
On Wed, 19 Jun 2019 at 03:55, Sam Charya via R-help <r-help using r-project.org>
> Thanks a lot Boris, I tried out your worked out solution and it works
> just perfectly fine. No doubt I need a lot of practice with regexr and the
> pattern stated by you - I will do that now. Thanks a lot for pointing me in
> the right direction. Appreciate it a lot.
> On Monday, 17 June 2019, 2:39:14 pm GMT+5:30, Boris Steipe <
> boris.steipe using utoronto.ca> wrote:
> (Technically you are now thread-hijacking. But here goes:)
> mydf <- data.frame(V11 = c("DD Pack0.002",
> "FTA English News0.003",
> "FTA Complimentary0.004"),
> stringsAsFactors = FALSE)
> # regex matching start-of-string(letters or blanks)(numbers, a decimal
> # point, more numbers)end-of-string: "^([a-zA-Z ]+)([0-9]+\\.[0-9]+)$"
> # first check that all elements are matched by the regex. If not, an
> # of how the strings are patterned is not true ...
> all(grepl("^([a-zA-Z ]+)([0-9]+\\.[0-9]+)$", V11)) # must be true!
> mydf$`Channel name` <- gsub("^([a-zA-Z ]+)([0-9]+\\.[0-9]+)$", "\\1",
> mydf$Price <- gsub("^([a-zA-Z ]+)([0-9]+\\.[0-9]+)$", "\\2",
> # V11 Channel name Price
> # 1 DD Pack0.002 DD Pack 0.002
> # 2 FTA English News0.003 FTA English News 0.003
> # 3 FTA Complimentary0.004 FTA Complimentary 0.004
> Note this _will_ give wrong results if channel names like "ABC4" exist.
> > On 2019-06-15, at 15:40, Sam Charya via R-help <r-help using r-project.org>
> > Hello All,
> > I need help with splitting a string. My data frame is in the following
> > 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 it is named V1.
> > The data consists of names of 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 so there is no separator
> and I am not being able to figure this out. Kindly please help resolve
> > 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 group - kindly direct if that is the case.
> > sam.
> > ********************************************************
> > [[alternative HTML version deleted]]
> > ______________________________________________
> > R-help using r-project.org mailing list -- To UNSUBSCRIBE and more, see
> > https://stat.ethz.ch/mailman/listinfo/r-help
> > PLEASE do read the posting guide
> > and provide commented, minimal, self-contained, reproducible code.
> [[alternative HTML version deleted]]
> R-help using r-project.org mailing list -- To UNSUBSCRIBE and more, see
> PLEASE do read the posting guide
> and provide commented, minimal, self-contained, reproducible code.
[[alternative HTML version deleted]]
More information about the R-help