preceding X. and X

-----Original Message-----
From: r-help-bounces at r-project.org [mailto:r-help-bounces at r-
project.org] On Behalf Of Ben quant
Sent: Thursday, October 27, 2011 12:26 PM
To: r-help at r-project.org
Subject: Re: [R] preceding X. and X

Figured it out. Solution:
dat=read.csv(file_path, header=F)

dat

  V1         V2        V3       V4      V5         V6        V7
V8        V9        V10        V11        V12        V13       V14
V15         V16       V17       V18         V19        V20
1  0 -0.2404324 0.3554681 -0.21147 1.18128 -0.2279752 0.7483484 -
1.049239
0.5660589 -0.1840771 -0.6933892 -0.4749619 -0.5575557 0.3741988
0.5606208
-0.06091273 0.6453374 0.3537118 -0.09991461 -0.3207118
        V21       V22       V23       V24       V25       V26
V27        V28       V29        V30        V31       V32        V33
V34        V35       V36        V37        V38       V39
1 0.3321949 0.5137949 0.2281249 0.1412501 0.8793599 0.7216529 -1.147237
-0.0871542 0.3021812 0.05944923 -0.2407231 0.3589717 -0.4295433 -
0.07399785
-0.1088064 0.6161071 -0.2026699 -0.2004506 0.1542169
          V40      V41        V42        V43       V44        V45
V46        V47        V48         V49       V50      V51       V52
V53        V54       V55        V56        V57        V58
1 -0.06293466 1.160775 -0.1009804 -0.4574294 0.1289299 -0.1434428 -
1.090505
-0.2702305 -0.4381005 -0.06666691 0.1836706 0.728843 0.2219863 -
0.7939716
-0.2580837 0.4604682 -0.6085527 -0.1102456 -0.2470147
         V59        V60      V61        V62       V63        V64
V65      V66      V67        V68       V69       V70       V71
V72        V73       V74       V75        V76        V77
1 -0.1374674 0.05771337 0.615591 -0.2103958 0.3729799 -0.7636618
1.222489
1.175414 1.349652 -0.0653956 0.4461732 0.7385489 0.4267874 -0.4099944
-0.4456437 0.1310654 0.5912901 0.03645256 -0.1760742
        V78       V79       V80

Thanks,
Ben

On Thu, Oct 27, 2011 at 1:12 PM, Justin Haynes <jtor14 at gmail.com>
wrote:

Id look at the actual csv file.  I assume it has the X there also.
sounds like a good candidate for some data munging tools first before
you bring it into R.  also ?str of the data would be helpful. My

first

guess is those are all being read as column names.  Were they data in
the data.frame dat the should be quoted:

dat<-c('X0.0','X.0.24','X0.35','X.0.211')
dat

[1] "X0.0"    "X.0.24"  "X0.35"   "X.0.211"

versus:

names(dat)<-c('col_one','X.0.44',0.65,'last_col')
dat

 col_one    X.0.44      0.65  last_col
  "X0.0"  "X.0.24"   "X0.35" "X.0.211"



However, if you want to use R to clean it up, I'd use the stringr

package.

library(stringr)

dat<-str_replace(dat,'X.0.','-0.')
dat

[1] "X0.0"   "-0.24"  "X0.35"  "-0.211"

dat<-str_replace(dat,'X','')
dat

[1] "0.0"    "-0.24"  "0.35"   "-0.211"

dat<-as.numeric(dat)
dat

[1]  0.000 -0.240  0.350 -0.211

hope that helps,

Justin


On Thu, Oct 27, 2011 at 11:47 AM, Ben quant <ccquant at gmail.com>

wrote:

Hello,

Why do I get preceding "X." (that is a and X followed by a period)

for

negative numbers and an "X" for positive numbers when I read a csv

file?

Am

I stuck with this? If so, how do I convert it to normal numbers?

dat=read.csv(file_path)

dat

 [1] X0.0               X.0.240432350374   X0.355468069625
X.0.211469972378   X1.1812797415      X.0.227975150826

X0.74834842067