Dear all,> version_ platform i386-pc-mingw32 arch i386 os mingw32 system i386, mingw32 status major 1 minor 5.0 year 2002 month 04 day 29 language R OS: Win98 I have a strange problem with a particular data.frame built with an SQL query in a database (package RODBC). The query is simple and the data.frame is small (108 rows * 6 columns). The problem does not seem to be related with the format of the data source: it occurs with 2 different formats of the same table (MS Access and MS Visual FoxPro).> library(RODBC) > bd <- odbcConnect(dsn = "Baobab_VFP") > req <- "select * from lieu" > vill <- sqlQuery(channel = bd, query = req) > odbcClose(bd)[1] 1> dim(vill)[1] 108 6 The problem is limited to the 6th column (which contains labels: character string, 2 missing values) and the 93th row. The particular values in this record do not seem to matter: they are not the same in the Access table and in the FoxPro table (tables are the same but order is different).> vill[50:54, ]codelieu lati hemi longi meri nom 50 SNKOLDJI 12.8436 N 15.0192 O Djida Marietou 51 SNKOLHAM 12.9519 N 14.8467 O SARE HAMIDOU 52 SNKOLKIS 12.9767 N 14.8714 O MARAKISSA 53 SNKOLLAM 12.8594 N 15.0219 O SARE LAMINE 54 SNKOLLAY 12.8275 N 14.8803 O DIOULAYEL> vill[93, 1:5]codelieu lati hemi longi meri 93 SNFLLWAD NA <NA> NA <NA>> vill[ , 6] # ===> crash > vill[93, ] # ===> crashI was able to write the whole data.frame in a text file with write.table(). I can read this text file with read.table() but R crashes as before at the same place:> write.table(vill, "d:\\vill.txt") > temp <- read.table("d:\\vill.txt")> temp[50:54, ]codelieu lati hemi longi meri nom 50 SNKOLDJI 12.8436 N 15.0192 O Djida Marietou 51 SNKOLHAM 12.9519 N 14.8467 O SARE HAMIDOU 52 SNKOLKIS 12.9767 N 14.8714 O MARAKISSA 53 SNKOLLAM 12.8594 N 15.0219 O SARE LAMINE 54 SNKOLLAY 12.8275 N 14.8803 O DIOULAYEL> temp[ , 6] # ===> crash > temp[93, ] # ===> crashWhere does this come from ? For those interested, I attach the text file in a zip file (vill.zip, size = 3 ko) Thanks in advance, Renaud -- Dr Renaud Lancelot, v?t?rinaire CIRAD, D?partement Elevage et M?decine V?t?rinaire (CIRAD-Emvt) Programme Productions Animales http://www.cirad.fr/presentation/programmes/prod-ani.shtml ISRA-LNERV tel (221) 832 49 02 BP 2057 Dakar-Hann fax (221) 821 18 79 (CIRAD) Senegal e-mail renaud.lancelot at cirad.fr -------------- next part -------------- A non-text attachment was scrubbed... Name: vill.zip Type: application/x-zip-compressed Size: 2106 bytes Desc: not available Url : https://stat.ethz.ch/pipermail/r-help/attachments/20020504/4b16ff33/vill.bin
Dear Renaud,
This seems to work OK for me, using the same version of R (1.5.0), but
under Windows 2000:
> vill <- read.table('c:/temp/vill.txt')
> vill[50:54, ]
codelieu lati hemi longi meri nom
50 SNKOLDJI 12.8436 N 15.0192 O Djida Marietou
51 SNKOLHAM 12.9519 N 14.8467 O SARE HAMIDOU
52 SNKOLKIS 12.9767 N 14.8714 O MARAKISSA
53 SNKOLLAM 12.8594 N 15.0219 O SARE LAMINE
54 SNKOLLAY 12.8275 N 14.8803 O DIOULAYEL
> vill[ , 6]
[1] Barkeyel 2 Mbar Mback?
[3] Barkeyel MBELA NDOCK
[5] Mboss?dji Bara Tchiky
[7] Darou Marnane Ndi?gh?ne Hibra
[9] Ndock Peul NGAR GUEYE
[11] Gassel GUINGUINEO
[13] Guin?e Mass Gniby
[15] Gossas GOSSAS VILLAGE
[17] Guin?e Walo Keur Isma?la
[19] Keur Ndiouga Keur Cheickh Mbaye
[21] Keur Mor Djit? Ndi?nn? Lagane
[23] Ndock Diouma L?ourou Leyi
[25] NDIOLOFENE Mbadi?ne
[27] MBOSS Meth
[29] Moungouniane Ndiayene Waly
[31] Niangu? Ndock Diouma Coumba
[33] PETEGNE Panal Peul
[35] Panal Thiar?ne Sinthiou Thi?n?ba
[37] NDINGLER TAWFEKH THIADIA
[39] Thiab?di?ne SARE BAKARY
[41] SARE BAMBA SARE YORO BANA
[43] SARE BIDJI SARE BILALY
[45] SARE BORY SARE BOUBEL
[47] BANTHANGEL YORO DIAO BANTHANTO DEMBA
[49] SARE DIANAMBE Djida Marietou
[51] SARE HAMIDOU MARAKISSA
[53] SARE LAMINE DIOULAYEL
[55] MEDINA FASS MAHON OUSMANE
[57] MARAKISSA MEDINA SADIOUMA
[59] DIANABO SINDIAN ADAMA
[61] SAGHARE SARE SAMBOUDIANG
[63] SANTANKOYE SARE MAMADY
[65] SARE SOUNKARY WELIA DEMBEL
[67] DIALACOUNA KEUR DIANKO
[69] KEUR MOUSSA BA LEONA
[71] NDIAYENE NDAKHAR KARIM
[73] PADDAF 1 PADDAF 2
[75] PADDAF 3 PADDAF 4
[77] DIAGNE NDIOBEME SANTHIE
[79] DIONABE GARKI
[81] GUET ARDO KEUR MOUSSA KEBE
[83] KEUR MANDOUMBE NDEME
[85] NOUFLE TOURE ATMANE
[87] THIEMBAR TOURE FALL
[89] THIALAGA THIALENE
[91] THIAR PEULH THIAR WOLOFF
[93] Wadab? Nawar Lampsar Peulh
[95] Ouroube Madina
[97] Ndiack Fall Soutouboulbe
[99] Sowanabes Ndiol
[101] Lampsar Thil?ne
[103] Diawar <NA>
[105] Ndombo Ngandiaye
[107] <NA> Thiago
Levels: BANTHANGEL YORO DIAO BANTHANTO
DEMBA Barkeyel Barkeyel 2 Darou
Marnane DIAGNE DIALACOUNA
DIANABO Diawar DIONABE
DIOULAYEL Djida
Marietou GARKI Gassel
Gniby Gossas GOSSAS
VILLAGE GUET ARDO Guin?e
Mass Guin?e Walo GUINGUINEO Keur
Cheickh Mbaye KEUR DIANKO Keur
Isma?la KEUR MANDOUMBE Keur Mor
Djit? KEUR MOUSSA BA KEUR MOUSSA KEBE Keur
Ndiouga Lampsar Lampsar
Peulh LEONA Leyi
Madina MAHON
OUSMANE MARAKISSA Mbadi?ne
Mbar Mback? MBELA
NDOCK MBOSS Mboss?dji
Bara MEDINA FASS MEDINA
SADIOUMA Meth Moungouniane
NDAKHAR KARIM NDEME Ndiack
Fall NDIAYENE Ndiayene
Waly Ndi?gh?ne Hibra Ndi?nn?
Lagane NDINGLER TAWFEKH NDIOBEME
SANTHIE Ndiol NDIOLOFENE Ndock
Diouma Coumba Ndock Diouma L?ourou Ndock
Peul Ndombo Ngandiaye
NGAR
GUEYE Niangu? NOUFLE
Ouroube PADDAF 1 PADDAF
2 PADDAF 3 PADDAF
4 Panal Peul Panal
Thiar?ne PETEGNE SAGHARE
SANTANKOYE SARE BAKARY SARE
BAMBA SARE BIDJI SARE
BILALY SARE BORY SARE
BOUBEL SARE DIANAMBE SARE
HAMIDOU SARE LAMINE SARE
MAMADY SARE SAMBOUDIANG SARE
SOUNKARY SARE YORO BANA SINDIAN
ADAMA Sinthiou
Thi?n?ba Soutouboulbe Sowanabes Tchiky
Thiab?di?ne THIADIA
Thiago THIALAGA THIALENE
THIAR PEULH THIAR
WOLOFF THIEMBAR Thil?ne
TOURE ATMANE TOURE FALL Wadab?
Nawar WELIA DEMBEL
> vill[93, ]
codelieu lati hemi longi meri nom
93 SNFLLWAD NA <NA> NA <NA> Wadab? Nawar
>
R 1.5.0 appears to have some problems lining up the column names with the
columns, though -- see the result of vill[93, ]. (I got a neater listing
under 1.4.1).
I hope that this helps,
John
At 10:51 AM 5/4/2002 +0100, Renaud Lancelot wrote:>Dear all,
>
> > version
> _
>platform i386-pc-mingw32
>arch i386
>os mingw32
>system i386, mingw32
>status
>major 1
>minor 5.0
>year 2002
>month 04
>day 29
>language R
>
>OS: Win98
>
>I have a strange problem with a particular data.frame built with an SQL
>query in a database (package RODBC). The query is simple and the
>data.frame is small (108 rows * 6 columns). The problem does not seem to
>be related with the format of the data source: it occurs with 2
>different formats of the same table (MS Access and MS Visual FoxPro).
>
> > library(RODBC)
> > bd <- odbcConnect(dsn = "Baobab_VFP")
> > req <- "select * from lieu"
> > vill <- sqlQuery(channel = bd, query = req)
> > odbcClose(bd)
>[1] 1
> > dim(vill)
>[1] 108 6
>
>The problem is limited to the 6th column (which contains labels:
>character string, 2 missing values) and the 93th row. The particular
>values in this record do not seem to matter: they are not the same in
>the Access table and in the FoxPro table (tables are the same but order
>is different).
>
> > vill[50:54, ]
> codelieu lati hemi longi meri nom
>50 SNKOLDJI 12.8436 N 15.0192 O Djida Marietou
>51 SNKOLHAM 12.9519 N 14.8467 O SARE HAMIDOU
>52 SNKOLKIS 12.9767 N 14.8714 O MARAKISSA
>53 SNKOLLAM 12.8594 N 15.0219 O SARE LAMINE
>54 SNKOLLAY 12.8275 N 14.8803 O DIOULAYEL
>
> > vill[93, 1:5]
> codelieu lati hemi longi meri
>93 SNFLLWAD NA <NA> NA <NA>
>
> > vill[ , 6] # ===> crash
> > vill[93, ] # ===> crash
>
>I was able to write the whole data.frame in a text file with
>write.table(). I can read this text file with read.table() but R crashes
>as before at the same place:
>
> > write.table(vill, "d:\\vill.txt")
> > temp <- read.table("d:\\vill.txt")
>
> > temp[50:54, ]
> codelieu lati hemi longi meri nom
>50 SNKOLDJI 12.8436 N 15.0192 O Djida Marietou
>51 SNKOLHAM 12.9519 N 14.8467 O SARE HAMIDOU
>52 SNKOLKIS 12.9767 N 14.8714 O MARAKISSA
>53 SNKOLLAM 12.8594 N 15.0219 O SARE LAMINE
>54 SNKOLLAY 12.8275 N 14.8803 O DIOULAYEL
>
> > temp[ , 6] # ===> crash
> > temp[93, ] # ===> crash
>
>Where does this come from ?
>
>For those interested, I attach the text file in a zip file (vill.zip,
>size = 3 ko)
>
>Thanks in advance,
>
>Renaud
>
>
>--
>Dr Renaud Lancelot, v?t?rinaire
>CIRAD, D?partement Elevage et M?decine V?t?rinaire (CIRAD-Emvt)
>Programme Productions Animales
>http://www.cirad.fr/presentation/programmes/prod-ani.shtml
>
>ISRA-LNERV tel (221) 832 49 02
>BP 2057 Dakar-Hann fax (221) 821 18 79 (CIRAD)
>Senegal e-mail renaud.lancelot at cirad.fr
-----------------------------------------------------
John Fox
Department of Sociology
McMaster University
Hamilton, Ontario, Canada L8S 4M4
email: jfox at mcmaster.ca
phone: 905-525-9140x23604
web: www.socsci.mcmaster.ca/jfox
-----------------------------------------------------
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !) To: r-help-request at
stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
On 05/05/02 16:21, hkimscil wrote:>Hello all - >I must be wrong in using commands...Yes. scan() reads data horizontally, but matrix() fills up one column at a time starting at the left. You can change the behavior of matrix() with byrow=T.>The below is my data (test.data). Its size is 10 X 15. >1 1 1 1 1 1 0 1 1 1 1 1 0 1 0 >1 1 1 0 0 1 0 0 0 1 0 0 1 1 1 >1 1 1 0 0 1 0 1 0 0 0 1 1 1 1 >0 0 0 0 1 1 0 0 0 1 1 0 0 1 1 >1 1 1 1 0 1 0 1 0 1 0 0 0 1 1 >0 1 0 0 0 1 0 0 0 1 1 0 1 0 0 >1 1 0 1 0 1 1 1 0 0 1 0 1 0 0 >1 1 0 1 0 1 1 1 0 1 0 1 1 0 0 >0 1 1 1 1 1 1 0 1 1 0 1 1 0 0 >1 1 0 0 0 1 0 0 1 0 1 1 1 0 0 > >I am importing the data into a matrix test1, using scan. >> test1<-matrix(scan("test.data"),nrow=10,ncol=15)This should work if you say test1<-matrix(scan("test.data"),nrow=10,ncol=15,byrow=T)>Then, I do the same thing with read.table >> test2<-as.matrix(read.table("test.data")) > >Now, test1 and test2 are different (test2 is the correct one). > >test1: >1 1 1 1 0 1 1 0 1 1 1 1 0 0 1 >1 1 0 1 1 0 1 0 0 1 0 1 1 1 0 >1 0 0 1 1 0 1 0 0 0 1 1 1 1 0 >1 1 0 0 1 0 1 1 0 1 0 0 1 0 1 >1 0 1 0 1 1 0 1 1 0 0 1 1 0 0 >1 1 0 1 0 1 1 0 1 1 1 0 1 1 1 >0 1 0 0 0 0 0 1 0 1 1 1 1 1 1 >1 1 1 1 0 0 1 0 1 1 0 1 0 0 1 >1 0 1 0 0 1 0 0 0 0 1 0 1 0 0 >1 0 1 0 1 1 1 0 0 0 0 0 1 0 0 > >test2 >1 1 1 1 1 1 0 1 1 1 1 1 0 1 0 >1 1 1 0 0 1 0 0 0 1 0 0 1 1 1 >1 1 1 0 0 1 0 1 0 0 0 1 1 1 1 >0 0 0 0 1 1 0 0 0 1 1 0 0 1 1 >1 1 1 1 0 1 0 1 0 1 0 0 0 1 1 >0 1 0 0 0 1 0 0 0 1 1 0 1 0 0 >1 1 0 1 0 1 1 1 0 0 1 0 1 0 0 >1 1 0 1 0 1 1 1 0 1 0 1 1 0 0 >0 1 1 1 1 1 1 0 1 1 0 1 1 0 0 >1 1 0 0 0 1 0 0 1 0 1 1 1 0 0-- Jonathan Baron, Professor of Psychology, University of Pennsylvania Home page: http://www.sas.upenn.edu/~baron -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send "info", "help", or "[un]subscribe" (in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._