I think it is what I want. The values look OK. I do get a warning. Here is
what you asked for:

> dat=read.csv(file_path, header=F)
Warning message:
In read.table(file = file, header = header, sep = sep, quote = quote,  :
  incomplete final line found by readTableHeader on 'y:\ALL
STRATEGIES\INVEST-TRADING\Zacks\RCsvData\VarPortRtns.csv'
> str(dat)
'data.frame':   1 obs. of  251 variables:
 $ V1  : num 0
 $ V2  : num -0.24
 $ V3  : num 0.355
 $ V4  : num -0.211
 $ V5  : num 1.18
 $ V6  : num -0.228
 $ V7  : num 0.748
 $ V8  : num -1.05
 $ V9  : num 0.566
 $ V10 : num -0.184
 $ V11 : num -0.693

...etc....

> 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
         V5

...etc...

Ben

On Thu, Oct 27, 2011 at 1:37 PM, Nordlund, Dan (DSHS/RDA) <
NordlDJ@dshs.wa.gov> wrote:

> > -----Original Message-----
> > From: r-help-bounces@r-project.org [mailto:r-help-bounces@r-
> > project.org] On Behalf Of Ben quant
> > Sent: Thursday, October 27, 2011 12:26 PM
> > To: r-help@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@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@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
>
> Ben,
>
> Are you sure that is what you want?  What is the result of running
>
> str(dat)
>
>
> Dan
>
> Daniel J. Nordlund
> Washington State Department of Social and Health Services
> Planning, Performance, and Accountability
> Research and Data Analysis Division
> Olympia, WA 98504-5204
> ______________________________________________
> R-help@r-project.org mailing list
> 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]]

