[R] different between read.table and read.delim

David Winsemius dwinsemius at comcast.net
Fri Dec 23 08:07:28 CET 2016


In the future you can examine the consequence kid various choices for parameters with something along the lines of 

table( count.fields( file= .. ,  ... <parameters>))

Sent from my iPhone

> On Dec 22, 2016, at 9:13 PM, Jinsong Zhao <jszhao at yeah.net> wrote:
> 
>> On 2016/12/23 11:31, Sarah Goslee wrote:
>> Look at the default arguments to each, especially the quote argument.
>> 
>> Sarah
>> 
> 
> Thank you very much!
> 
> The quote and fill argument are not same for the two function. only change quote or fill can not make read.table() work.
> 
> Best,
> Jinsong
> 
>>> On Thu, Dec 22, 2016 at 10:24 PM, Jinsong Zhao <jszhao at yeah.net> wrote:
>>> Hi there,
>>> 
>>> I have a data set file, called "ecotox.rep", which is a delimited file
>>> separated with "|".
>>> 
>>> When I tried to read the file with the following command,
>>> 
>>>> df <- read.table("ecotox.rep", sep = "|", header = TRUE,
>>>> stringsAsFactors=FALSE)
>>> 
>>> I got the error messages:
>>> 
>>> Error in scan(file = file, what = what, sep = sep, quote = quote, dec = dec,
>>> :
>>>  line 113 did not have 87 elements
>>> 
>>> However, when I read the file with the following command,
>>> 
>>>> df <- read.delim("ecotox.rep", sep = "|", header = TRUE,
>>>> stringsAsFactors=FALSE)
>>> 
>>> I got a correct output.
>>> 
>>> If I understand correctly, read.delim() is just wrapped from read.table(),
>>> why read.delim() works, but read.table() doesn't.
>>> 
>>> Thanks in advance.
>>> 
>>> Best,
>>> Jinsong
> 
> ______________________________________________
> 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.



More information about the R-help mailing list