Hi R users, I have a string for example 'X35.84375_.100.71875', and I have another dataframe df that I want to export with the transformed string name '35.84375_-100.71875' with no extension. How to do this in R? Thanks for your help. a = 'X35.84375_.100.71875' write.table(df, file='', row.names=F, col.names=F)
about file name
5 messages · lily li, jim holtman, Rui Barradas
just strip off the first character:
a
[1] "X35.84375_.100.71875"
a.new <- sub("^.", '', a)
a.new
[1] "35.84375_.100.71875"
Jim Holtman Data Munger Guru What is the problem that you are trying to solve? Tell me what you want to do, not how you want to do it.
On Thu, Jul 28, 2016 at 3:51 PM, lily li <chocold12 at gmail.com> wrote:
Hi R users,
I have a string for example 'X35.84375_.100.71875', and I have another
dataframe df that I want to export with the transformed string name
'35.84375_-100.71875' with no extension. How to do this in R? Thanks for
your help.
a = 'X35.84375_.100.71875'
write.table(df, file='', row.names=F, col.names=F)
[[alternative HTML version deleted]]
______________________________________________ R-help at 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.
Thanks, but how to get the string like this: "35.84375_-100.71875" use the minus sign instead of dot.
On Thu, Jul 28, 2016 at 2:38 PM, jim holtman <jholtman at gmail.com> wrote:
just strip off the first character:
a
[1] "X35.84375_.100.71875"
a.new <- sub("^.", '', a)
a.new
[1] "35.84375_.100.71875"
Jim Holtman Data Munger Guru What is the problem that you are trying to solve? Tell me what you want to do, not how you want to do it. On Thu, Jul 28, 2016 at 3:51 PM, lily li <chocold12 at gmail.com> wrote:
Hi R users,
I have a string for example 'X35.84375_.100.71875', and I have another
dataframe df that I want to export with the transformed string name
'35.84375_-100.71875' with no extension. How to do this in R? Thanks for
your help.
a = 'X35.84375_.100.71875'
write.table(df, file='', row.names=F, col.names=F)
[[alternative HTML version deleted]]
______________________________________________ R-help at 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.
add another step: (need to learn about regular expressions)
a
[1] "X35.84375_.100.71875"
a.new <- sub("^.", '', a)
a.new
[1] "35.84375_.100.71875"
sub("_.", "_-", a.new)
[1] "35.84375_-100.71875"
Jim Holtman Data Munger Guru What is the problem that you are trying to solve? Tell me what you want to do, not how you want to do it.
On Thu, Jul 28, 2016 at 4:39 PM, lily li <chocold12 at gmail.com> wrote:
Thanks, but how to get the string like this: "35.84375_-100.71875" use the minus sign instead of dot. On Thu, Jul 28, 2016 at 2:38 PM, jim holtman <jholtman at gmail.com> wrote:
just strip off the first character:
a
[1] "X35.84375_.100.71875"
a.new <- sub("^.", '', a)
a.new
[1] "35.84375_.100.71875"
Jim Holtman Data Munger Guru What is the problem that you are trying to solve? Tell me what you want to do, not how you want to do it. On Thu, Jul 28, 2016 at 3:51 PM, lily li <chocold12 at gmail.com> wrote:
Hi R users,
I have a string for example 'X35.84375_.100.71875', and I have another
dataframe df that I want to export with the transformed string name
'35.84375_-100.71875' with no extension. How to do this in R? Thanks for
your help.
a = 'X35.84375_.100.71875'
write.table(df, file='', row.names=F, col.names=F)
[[alternative HTML version deleted]]
______________________________________________ R-help at 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.
Hello,
Just use ?sub.
x <- "35.84375_.100.71875"
y <- sub("_\\.", "_-", x)
Hope this helps,
Rui Barradas
?
Citando lily li <chocold12 at gmail.com>:
Thanks, but how to get the string like this: "35.84375_-100.71875" use the minus sign instead of dot. On Thu, Jul 28, 2016 at 2:38 PM, jim holtman <jholtman at gmail.com> wrote:
just strip off the first character:
a
[1] "X35.84375_.100.71875"
a.new <- sub("^.", '', a)
a.new
[1] "35.84375_.100.71875"
Jim Holtman
Data Munger Guru
What is the problem that you are trying to solve?
Tell me what you want to do, not how you want to do it.
On Thu, Jul 28, 2016 at 3:51 PM, lily li <chocold12 at gmail.com> wrote:
Hi R users, I have a string for example 'X35.84375_.100.71875', and I have another dataframe df that I want to export with the transformed string name '35.84375_-100.71875' with no extension. How to do this in R? Thanks for your help. a = 'X35.84375_.100.71875' write.table(df, file='', row.names=F, col.names=F) ? ? ? ? [[alternative HTML version deleted]]
______________________________________________ R-help at 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.
[[alternative HTML version deleted]]
______________________________________________ R-help at 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.htmland provide commented, minimal, self-contained, reproducible code.
?