[R] read

Val v@|kremk @end|ng |rom gm@||@com
Fri Aug 9 02:40:08 CEST 2019


Thank you  all, I can read the text file but the problem was there is
a single quote embedded  in  the first row of second column. This
quote causes the problem

vld<-read.table(text="name prof
  A      '4.5
  B       "3.2
  C       5.5 ",header=TRUE)

On Thu, Aug 8, 2019 at 7:24 PM Anaanthan Pillai
<anaanthanpillai using gmail.com> wrote:
>
> data <- read.table(header=TRUE, text='
>  name prof
>   A  4.5
>   B  3.2
>   C  5.5
>  ')
> > On 9 Aug 2019, at 8:11 AM, Val <valkremk using gmail.com> wrote:
> >
> > Hi all,
> >
> > I am trying to red data where single and double quotes are embedded
> > in some of the fields and prevented to read the data.   As an example
> > please see below.
> >
> > vld<-read.table(text="name prof
> >  A      '4.5
> >  B       "3.2
> >  C       5.5 ",header=TRUE)
> >
> > Error in read.table(text = "name prof \n  A      '4.5    \n  B
> > 3.2     \n  C       5.5 ",  :
> >  incomplete final line found by readTableHeader on 'text'
> >
> > Is there a way how to  read this data and gt the following output
> >  name prof
> > 1    A  4.5
> > 2    B  3.2
> > 3    C  5.5
> >
> > Thank you inadvertence
> >
> > ______________________________________________
> > 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 http://www.R-project.org/posting-guide.html
> > and provide commented, minimal, self-contained, reproducible code.
>



More information about the R-help mailing list