Re: [Rd] read.table() with quoted integers

2014-04-26 Thread ashmoran
Milan Bouchet-Valat wrote It seems that read.table() in R 3.0.1 (Linux 64-bit) does not consider quoted integers as an acceptable value for columns for which colClasses=integer. But when colClasses is omitted, these columns are read as integer anyway. For example, let's consider a file

[Rd] read.table() with quoted integers

2013-10-04 Thread Jens Oehlschlägel
I agree that quoted integer columns are not the most efficient way of delivering csv-files. However, the sad reality is that one receives such formats and still needs to read the data. Therefore it is not helpful to state that one should 'consider character to be the correct colClass in case

Re: [Rd] read.table() with quoted integers

2013-10-04 Thread Joshua Ulrich
On Tue, Oct 1, 2013 at 11:29 AM, David Winsemius dwinsem...@comcast.net wrote: On Sep 30, 2013, at 6:38 AM, Joshua Ulrich wrote: On Mon, Sep 30, 2013 at 7:33 AM, Milan Bouchet-Valat nalimi...@club.fr wrote: Hi! It seems that read.table() in R 3.0.1 (Linux 64-bit) does not consider

Re: [Rd] read.table() with quoted integers

2013-10-04 Thread Duncan Murdoch
On 13-10-04 7:31 AM, Joshua Ulrich wrote: On Tue, Oct 1, 2013 at 11:29 AM, David Winsemius dwinsem...@comcast.net wrote: On Sep 30, 2013, at 6:38 AM, Joshua Ulrich wrote: On Mon, Sep 30, 2013 at 7:33 AM, Milan Bouchet-Valat nalimi...@club.fr wrote: Hi! It seems that read.table() in R

Re: [Rd] read.table() with quoted integers

2013-10-04 Thread Joshua Ulrich
On Thu, Oct 3, 2013 at 9:44 AM, Jens Oehlschlägel jens.oehlschlae...@truecluster.com wrote: I agree that quoted integer columns are not the most efficient way of delivering csv-files. However, the sad reality is that one receives such formats and still needs to read the data. Therefore it is

Re: [Rd] read.table() with quoted integers

2013-10-04 Thread Milan Bouchet-Valat
Le vendredi 04 octobre 2013 à 07:34 -0500, Joshua Ulrich a écrit : On Thu, Oct 3, 2013 at 9:44 AM, Jens Oehlschlägel jens.oehlschlae...@truecluster.com wrote: I agree that quoted integer columns are not the most efficient way of delivering csv-files. However, the sad reality is that one

Re: [Rd] read.table() with quoted integers

2013-10-04 Thread Milan Bouchet-Valat
Le vendredi 04 octobre 2013 à 07:55 -0400, Duncan Murdoch a écrit : On 13-10-04 7:31 AM, Joshua Ulrich wrote: On Tue, Oct 1, 2013 at 11:29 AM, David Winsemius dwinsem...@comcast.net wrote: On Sep 30, 2013, at 6:38 AM, Joshua Ulrich wrote: On Mon, Sep 30, 2013 at 7:33 AM, Milan

Re: [Rd] read.table() with quoted integers

2013-10-04 Thread Henrik Bengtsson
On Fri, Oct 4, 2013 at 4:55 AM, Duncan Murdoch murdoch.dun...@gmail.com wrote: On 13-10-04 7:31 AM, Joshua Ulrich wrote: On Tue, Oct 1, 2013 at 11:29 AM, David Winsemius dwinsem...@comcast.net wrote: On Sep 30, 2013, at 6:38 AM, Joshua Ulrich wrote: On Mon, Sep 30, 2013 at 7:33 AM, Milan

Re: [Rd] read.table() with quoted integers

2013-10-04 Thread peter dalgaard
On Oct 4, 2013, at 17:10 , Henrik Bengtsson wrote: On Fri, Oct 4, 2013 at 4:55 AM, Duncan Murdoch murdoch.dun...@gmail.com wrote: On 13-10-04 7:31 AM, Joshua Ulrich wrote: On Tue, Oct 1, 2013 at 11:29 AM, David Winsemius dwinsem...@comcast.net wrote: On Sep 30, 2013, at 6:38 AM,

Re: [Rd] read.table() with quoted integers

2013-10-04 Thread Peter Meilstrup
I think this is not the right approach -- quoting is a transport-layer feature of the CSV format, not part of the application layer. Quotes should always be interpreted away from column data before any data is handed to the application layer. (CSV does not _have_ any application layer; type

Re: [Rd] read.table() with quoted integers

2013-10-04 Thread Henrik Bengtsson
On Fri, Oct 4, 2013 at 9:15 AM, peter dalgaard pda...@gmail.com wrote: On Oct 4, 2013, at 17:10 , Henrik Bengtsson wrote: On Fri, Oct 4, 2013 at 4:55 AM, Duncan Murdoch murdoch.dun...@gmail.com wrote: On 13-10-04 7:31 AM, Joshua Ulrich wrote: On Tue, Oct 1, 2013 at 11:29 AM, David

Re: [Rd] read.table() with quoted integers

2013-10-04 Thread Peter Meilstrup
On Fri, Oct 4, 2013 at 9:20 AM, Peter Meilstrup peter.meilst...@gmail.com wrote: I think this is not the right approach -- quoting is a transport-layer feature of the CSV format, not part of the application layer. Quotes should always be interpreted away from column data before any data is

Re: [Rd] read.table() with quoted integers

2013-10-01 Thread Peter Meilstrup
On Mon, Sep 30, 2013 at 8:10 AM, Joris Meys jorism...@gmail.com wrote: Regardless of whether stored as character is interpreted the R way or the ASCII way, the point Joshua makes is rather valid. Mainly because read.table has an argument quote with default value \'. This means that at least

Re: [Rd] read.table() with quoted integers

2013-10-01 Thread Peter Meilstrup
On Tue, Oct 1, 2013 at 5:50 AM, Peter Meilstrup peter.meilst...@gmail.com wrote: On Mon, Sep 30, 2013 at 8:10 AM, Joris Meys jorism...@gmail.com wrote: Regardless of whether stored as character is interpreted the R way or the ASCII way, the point Joshua makes is rather valid. Mainly because

Re: [Rd] read.table() with quoted integers

2013-10-01 Thread David Winsemius
On Sep 30, 2013, at 6:38 AM, Joshua Ulrich wrote: On Mon, Sep 30, 2013 at 7:33 AM, Milan Bouchet-Valat nalimi...@club.fr wrote: Hi! It seems that read.table() in R 3.0.1 (Linux 64-bit) does not consider quoted integers as an acceptable value for columns for which colClasses=integer.

[Rd] read.table() with quoted integers

2013-09-30 Thread Milan Bouchet-Valat
Hi! It seems that read.table() in R 3.0.1 (Linux 64-bit) does not consider quoted integers as an acceptable value for columns for which colClasses=integer. But when colClasses is omitted, these columns are read as integer anyway. For example, let's consider a file named file.dat, containing: 1

Re: [Rd] read.table() with quoted integers

2013-09-30 Thread Joshua Ulrich
On Mon, Sep 30, 2013 at 7:33 AM, Milan Bouchet-Valat nalimi...@club.fr wrote: Hi! It seems that read.table() in R 3.0.1 (Linux 64-bit) does not consider quoted integers as an acceptable value for columns for which colClasses=integer. But when colClasses is omitted, these columns are read as

Re: [Rd] read.table() with quoted integers

2013-09-30 Thread Milan Bouchet-Valat
Le lundi 30 septembre 2013 à 08:38 -0500, Joshua Ulrich a écrit : On Mon, Sep 30, 2013 at 7:33 AM, Milan Bouchet-Valat nalimi...@club.fr wrote: Hi! It seems that read.table() in R 3.0.1 (Linux 64-bit) does not consider quoted integers as an acceptable value for columns for which

Re: [Rd] read.table() with quoted integers

2013-09-30 Thread Joshua Ulrich
On Mon, Sep 30, 2013 at 9:45 AM, Milan Bouchet-Valat nalimi...@club.fr wrote: Le lundi 30 septembre 2013 à 08:38 -0500, Joshua Ulrich a écrit : On Mon, Sep 30, 2013 at 7:33 AM, Milan Bouchet-Valat nalimi...@club.fr wrote: Hi! It seems that read.table() in R 3.0.1 (Linux 64-bit) does

Re: [Rd] read.table() with quoted integers

2013-09-30 Thread Joris Meys
Regardless of whether stored as character is interpreted the R way or the ASCII way, the point Joshua makes is rather valid. Mainly because read.table has an argument quote with default value \'. This means that at least according to R, everything between either or ' should be seen as of type

Re: [Rd] read.table() with quoted integers

2013-09-30 Thread Milan Bouchet-Valat
Le lundi 30 septembre 2013 à 10:07 -0500, Joshua Ulrich a écrit : On Mon, Sep 30, 2013 at 9:45 AM, Milan Bouchet-Valat nalimi...@club.fr wrote: Le lundi 30 septembre 2013 à 08:38 -0500, Joshua Ulrich a écrit : On Mon, Sep 30, 2013 at 7:33 AM, Milan Bouchet-Valat nalimi...@club.fr wrote:

Re: [Rd] read.table() with quoted integers

2013-09-30 Thread Joris Meys
It is after all an R-related mailing list, and professor Ripley has set a certain standard ages ago ;) On Mon, Sep 30, 2013 at 5:19 PM, Milan Bouchet-Valat nalimi...@club.frwrote: Le lundi 30 septembre 2013 à 10:07 -0500, Joshua Ulrich a écrit : On Mon, Sep 30, 2013 at 9:45 AM, Milan

Re: [Rd] read.table() with quoted integers

2013-09-30 Thread Milan Bouchet-Valat
Le lundi 30 septembre 2013 à 17:10 +0200, Joris Meys a écrit : Regardless of whether stored as character is interpreted the R way or the ASCII way, the point Joshua makes is rather valid. Mainly because read.table has an argument quote with default value \'. This means that at least according

Re: [Rd] read.table() with quoted integers

2013-09-30 Thread Joris Meys
On Mon, Sep 30, 2013 at 5:27 PM, Milan Bouchet-Valat nalimi...@club.frwrote: Le lundi 30 septembre 2013 à 17:10 +0200, Joris Meys a écrit : Regardless of whether stored as character is interpreted the R way or the ASCII way, the point Joshua makes is rather valid. Mainly because read.table

Re: [Rd] read.table() with quoted integers

2013-09-30 Thread Henrik Bengtsson
On Mon, Sep 30, 2013 at 5:33 AM, Milan Bouchet-Valat nalimi...@club.fr wrote: Hi! It seems that read.table() in R 3.0.1 (Linux 64-bit) does not consider quoted integers as an acceptable value for columns for which colClasses=integer. But when colClasses is omitted, these columns are read as