RE: [EpiData-list] How should EpiData Analysis read a CSV (CommaSeparated File)
Hello!
I totally agree with you Max on this question.
Cheers, Bellinda
-----Original Message----- From: epidata-list-bounces@lists.umanitoba.ca [mailto:epidata-list-bounces@lists.umanitoba.ca] On Behalf Of epidata-list@lists.umanitoba.ca Sent: Thursday, March 09, 2006 6:35 PM To: epidata-list@lists.umanitoba.ca Subject: Re: [EpiData-list] How should EpiData Analysis read a CSV (CommaSeparated File)
Hello Jens,
I would strongly argue that a missing is a missing and a 0 (zero) is a very distinct value - hence never turn missings into zero by default... or in short: Option 2 Bests Max
On 10 Mar 2006, at 10:21, epidata-list@lists.umanitoba.ca wrote:
A question has come up.
Please consider how you find reading of a CSV file in analysis appropriate:
In a csv file the following data is found: id, s, pos, sex, ill 1,.,.,f,0 2...... etc (rest of records)
The data in line can be interpreted in two ways: Option 1: ID= 1 s= 0.0 pos=0.0 SEX = "f" ill = 0
Option 2: ID= 1 s= . pos=. SEX = "f" ill = 0
In other words the question is how to read ",.," should it be: Option 1: as 0.0 (which is current behaviour) or Option 2: .
Any comments on desired behaviour appreciated.
regards
Jens Lauritsen EpiData Association _______________________________________________ EpiData-list mailing list EpiData-list@lists.umanitoba.ca http://lists.umanitoba.ca/mailman/listinfo/epidata-list
_______________________________________________ EpiData-list mailing list EpiData-list@lists.umanitoba.ca http://lists.umanitoba.ca/mailman/listinfo/epidata-list
I also agree that missing is not equal to zero. I hope the vote is clear on that marcel
________________________________
Von: epidata-list@lists.umanitoba.ca [mailto:epidata-list@lists.umanitoba.ca] Gesendet: Fr 10.03.2006 13:57 An: epidata-list@lists.umanitoba.ca Betreff: RE: [EpiData-list] How should EpiData Analysis read a CSV(CommaSeparated File)
Hello!
I totally agree with you Max on this question.
Cheers, Bellinda
-----Original Message----- From: epidata-list-bounces@lists.umanitoba.ca [mailto:epidata-list-bounces@lists.umanitoba.ca] On Behalf Of epidata-list@lists.umanitoba.ca Sent: Thursday, March 09, 2006 6:35 PM To: epidata-list@lists.umanitoba.ca Subject: Re: [EpiData-list] How should EpiData Analysis read a CSV (CommaSeparated File)
Hello Jens,
I would strongly argue that a missing is a missing and a 0 (zero) is a very distinct value - hence never turn missings into zero by default... or in short: Option 2 Bests Max
On 10 Mar 2006, at 10:21, epidata-list@lists.umanitoba.ca wrote:
A question has come up.
Please consider how you find reading of a CSV file in analysis appropriate:
In a csv file the following data is found: id, s, pos, sex, ill 1,.,.,f,0 2...... etc (rest of records)
The data in line can be interpreted in two ways: Option 1: ID= 1 s= 0.0 pos=0.0 SEX = "f" ill = 0
Option 2: ID= 1 s= . pos=. SEX = "f" ill = 0
In other words the question is how to read ",.," should it be: Option 1: as 0.0 (which is current behaviour) or Option 2: .
Any comments on desired behaviour appreciated.
regards
Jens Lauritsen EpiData Association _______________________________________________ EpiData-list mailing list EpiData-list@lists.umanitoba.ca http://lists.umanitoba.ca/mailman/listinfo/epidata-list
_______________________________________________ EpiData-list mailing list EpiData-list@lists.umanitoba.ca http://lists.umanitoba.ca/mailman/listinfo/epidata-list
Agree..... misssing does NOT = 0
kelly
-----Original Message----- From: epidata-list@lists.umanitoba.ca [mailto:epidata-list@lists.umanitoba.ca] Sent: Sun 3/12/2006 2:58 PM To: epidata-list@lists.umanitoba.ca Cc: Subject: AW: [EpiData-list] How should EpiData Analysis read aCSV(CommaSeparated File)
I also agree that missing is not equal to zero. I hope the vote is clear on that marcel ________________________________ Von: epidata-list@lists.umanitoba.ca [mailto:epidata-list@lists.umanitoba.ca] Gesendet: Fr 10.03.2006 13:57 An: epidata-list@lists.umanitoba.ca Betreff: RE: [EpiData-list] How should EpiData Analysis read a CSV(CommaSeparated File) Hello! I totally agree with you Max on this question. Cheers, Bellinda -----Original Message----- From: epidata-list-bounces@lists.umanitoba.ca [mailto:epidata-list-bounces@lists.umanitoba.ca] On Behalf Of epidata-list@lists.umanitoba.ca Sent: Thursday, March 09, 2006 6:35 PM To: epidata-list@lists.umanitoba.ca Subject: Re: [EpiData-list] How should EpiData Analysis read a CSV (CommaSeparated File) Hello Jens, I would strongly argue that a missing is a missing and a 0 (zero) is a very distinct value - hence never turn missings into zero by default... or in short: Option 2 Bests Max On 10 Mar 2006, at 10:21, epidata-list@lists.umanitoba.ca wrote: > A question has come up. > > Please consider how you find reading of a CSV file in analysis > appropriate: > > > In a csv file the following data is found: > id, s, pos, sex, ill > 1,.,.,f,0 > 2...... etc (rest of records) > > The data in line can be interpreted in two ways: > Option 1: > ID= 1 > s= 0.0 > pos=0.0 > SEX = "f" ill = 0 > > Option 2: > ID= 1 > s= . > pos=. > SEX = "f" ill = 0 > > In other words the question is how to read ",.," should it be: > Option 1: as 0.0 (which is current behaviour) > or Option 2: . > > Any comments on desired behaviour appreciated. > > regards > > Jens Lauritsen > EpiData Association > _______________________________________________ > EpiData-list mailing list > EpiData-list@lists.umanitoba.ca > http://lists.umanitoba.ca/mailman/listinfo/epidata-list _______________________________________________ EpiData-list mailing list EpiData-list@lists.umanitoba.ca http://lists.umanitoba.ca/mailman/listinfo/epidata-list
participants (1)
-
epidata-list＠lists.umanitoba.ca