Re: [R] How to use read.table with Hebrew column names ?

Tal Galili Mon, 04 Jan 2010 01:04:31 -0800

Hi David, Jorge and everyone else.

I tried loading the file (with the Hebrew columns) on two machines.
On one of them if loaded fine, and on the other it didn't.
I also see a difference with the sessionInfo() of the two machines.
You're advice would be most welcomed.


On both machines I tried the following command:
read.table("http://www.talgalili.com/files/aa.txt";, header = T, fileEncoding
= "UTF-8", sep = "\t")


Here are the details of the computer on which the command *didn't work*:
> read.table("http://www.talgalili.com/files/aa.txt
", header = T, fileEncoding = "UTF-8", sep = "\t")
[1] X.
<0 rows> (or 0-length row.names)
Warning messages:
1: In read.table("http://www.talgalili.com/files/aa.txt";, header = T,  :
  invalid input found on input connection '
http://www.talgalili.com/files/aa.txt'
2: In read.table("http://www.talgalili.com/files/aa.txt";, header = T,  :
  incomplete final line found by readTableHeader on '
http://www.talgalili.com/files/aa.txt'
It says the same thing if I read the file saved on my PC.

My sessionInfo():

R version 2.10.1 (2009-12-14)
i386-pc-mingw32

locale:
[1] LC_COLLATE=English_United States.1252
[2] LC_CTYPE=English_United States.1252
[3] LC_MONETARY=English_United States.1252
[4] LC_NUMERIC=C
[5] LC_TIME=English_United States.1252

attached base packages:
[1] stats     graphics  grDevices utils     datasets  methods   base

other attached packages:
[1] MASS_7.3-4


Here are the details of the computer on which the command *did work*:

> sessionInfo()
R version 2.10.0 (2009-10-26)
i386-pc-mingw32

locale:
[1] LC_COLLATE=Hebrew_Israel.1255  LC_CTYPE=Hebrew_Israel.1255
 LC_MONETARY=Hebrew_Israel.1255 LC_NUMERIC=C
[5] LC_TIME=Hebrew_Israel.1255

attached base packages:
[1] splines   stats     graphics  grDevices utils     datasets  methods
base

other attached packages:
 [1] combinat_0.0-7   cluster_1.12.1   colorspace_1.0-1 reshape_0.8.3
 plyr_0.1.9       lattice_0.17-26  MASS_7.3-3       Hmisc_3.7-0
 [9] survival_2.35-7  ellipse_0.3-5

loaded via a namespace (and not attached):
[1] grid_2.10.0  tools_2.10.0
>



Any idea what to try next ?

Many thanks !

Tal














----------------Contact
Details:-------------------------------------------------------
Contact me: [email protected] |  972-52-7275845
Read me: www.talgalili.com (Hebrew) | www.biostatistics.co.il (Hebrew) |
www.r-statistics.com/ (English)
----------------------------------------------------------------------------------------------




On Sat, Jan 2, 2010 at 11:01 AM, Tal Galili <[email protected]> wrote:

> Hi David,
> Thank you for responding, but it didn't work.
>
> I get the following error:
>
>> [1] X.
>
> <0 rows> (or 0-length row.names)
>
> Warning messages:
>
> 1: In read.table("http://www.talgalili.com/files/aa.txt";, header = T,  :
>
>   invalid input found on input connection '
>> http://www.talgalili.com/files/aa.txt'
>
> 2: In read.table("http://www.talgalili.com/files/aa.txt";, header = T,  :
>
>   incomplete final line found by readTableHeader on '
>> http://www.talgalili.com/files/aa.txt'
>
>
>
>
> My OS is:
> PC - windows XP SP2
>
> My session info is:
>
>> R version 2.9.1 (2009-06-26)
>
> i386-pc-mingw32
>
>
>> locale:
>
> LC_COLLATE=English_United States.1252;LC_CTYPE=English_United
>> States.1252;LC_MONETARY=English_United
>> States.1252;LC_NUMERIC=C;LC_TIME=English_United States.1252
>
>
>> attached base packages:
>
> [1] stats     graphics  grDevices datasets  tcltk     utils     methods
>> base
>
>
>> other attached packages:
>
> [1] rcom_2.2-1      rscproxy_1.3-1  svSocket_0.9-43 svMisc_0.9-48
>> TinnR_1.0.3     R2HTML_1.59-1
>
> [7] Hmisc_3.6-0
>
>
>> loaded via a namespace (and not attached):
>
> [1] cluster_1.12.0  grid_2.9.1      lattice_0.17-25 tools_2.9.1
>
>
>
>
> I would like to emphasis that my question was posed to me by several R
> users here in Israel, so the solution to which is sought out here by more
> then just me :)
>
> Thanks all,
> Tal
>
>
>
>
>
>
>
>
>
>
> ----------------Contact
> Details:-------------------------------------------------------
> Contact me: [email protected] |  972-52-7275845
> Read me: www.talgalili.com (Hebrew) | www.biostatistics.co.il (Hebrew) |
> www.r-statistics.com/ (English)
>
> ----------------------------------------------------------------------------------------------
>
>
>
>
> On Sat, Jan 2, 2010 at 12:49 AM, David Winsemius 
> <[email protected]>wrote:
>
>> You might try:
>>
>> read.table("http://www.talgalili.com/files/aa.txt";, header = T,
>> fileEncoding = "UTF-8", sep = "\t")
>>
>> --
>> David.
>>
>>
>> On Jan 1, 2010, at 5:37 PM, Tal Galili wrote:
>>
>>  Hi Jorge,
>>> Thank you for the answer, it is a lead.
>>> Though I am unsure as to what to do next with it :)
>>>
>>> Here is my session info:
>>>
>>>
>>>>  sessionInfo()
>>>>
>>>
>>> R version 2.9.1 (2009-06-26)
>>>
>>> i386-pc-mingw32
>>>
>>>
>>> locale:
>>>
>>> LC_COLLATE=English_United States.1252;LC_CTYPE=English_United
>>> States.1252;LC_MONETARY=English_United
>>> States.1252;LC_NUMERIC=C;LC_TIME=English_United States.1252
>>>
>>>
>>> attached base packages:
>>>
>>> [1] stats     graphics  grDevices datasets  tcltk     utils     methods
>>>
>>> [8] base
>>>
>>>
>>> other attached packages:
>>>
>>> [1] rcom_2.2-1      rscproxy_1.3-1  svSocket_0.9-43 svMisc_0.9-48
>>>
>>> [5] TinnR_1.0.3     R2HTML_1.59-1   Hmisc_3.6-0
>>>
>>>
>>> loaded via a namespace (and not attached):
>>>
>>> [1] cluster_1.12.0  grid_2.9.1      lattice_0.17-25 tools_2.9.1
>>>
>>>
>>>
>>> Tal
>>>
>>>
>>>
>>> ----------------Contact
>>> Details:-------------------------------------------------------
>>> Contact me: [email protected] |  972-52-7275845
>>> Read me: www.talgalili.com (Hebrew) | www.biostatistics.co.il (Hebrew) |
>>> www.r-statistics.com/ (English)
>>>
>>> ----------------------------------------------------------------------------------------------
>>>
>>>
>>>
>>>
>>> On Sat, Jan 2, 2010 at 12:29 AM, Jorge Ivan Velez
>>> <[email protected]>wrote:
>>>
>>>  Hi Tal,
>>>>
>>>> I am not even sure what is going on, but I think it is OS specific. When
>>>> I
>>>> run your script on a Mac, I got the desired result:
>>>>
>>>>  read.table("http://www.talgalili.com/files/aa.txt";, header = T, sep =
>>>>>
>>>> "\t")
>>>>  ×××ª ×©×ª××× ×©×××©
>>>> 1  12    97    6
>>>> 2 123   354   44
>>>> 3   6     1    3
>>>>
>>>> This is the sessionInfo():
>>>>
>>>> R version 2.10.1 (2009-12-14)
>>>> x86_64-apple-darwin9.8.0
>>>>
>>>> locale:
>>>> [1] en_US.UTF-8/en_US.UTF-8/C/C/en_US.UTF-8/en_US.UTF-8
>>>>
>>>> attached base packages:
>>>> [1] stats     graphics  grDevices utils     datasets  methods   base
>>>>
>>>>
>>>> When doing the same on a PC via virtual machines on the same Mac, I got:
>>>>
>>>>  read.table("http://www.talgalili.com/files/aa.txt";, header = T, sep =
>>>>>
>>>> "\t", as.is = TRUE)
>>>>  X.....Âª X...Âª...... X...Å....
>>>> 1      12          97         6
>>>> 2     123         354        44
>>>> 3       6           1         3
>>>>
>>>> Here is the sessionInfo():
>>>>
>>>> R version 2.10.1 Patched (2009-12-21 r50814)
>>>> i386-pc-mingw32
>>>>
>>>> locale:
>>>> [1] LC_COLLATE=English_United States.1252  LC_CTYPE=English_United
>>>> States.1252
>>>> [3] LC_MONETARY=English_United States.1252 LC_NUMERIC=C
>>>>
>>>> [5] LC_TIME=English_United States.1252
>>>>
>>>> attached base packages:
>>>> [1] stats     graphics  grDevices utils     datasets  methods   base
>>>>
>>>> HTH,
>>>> Jorge
>>>>
>>>> On Fri, Jan 1, 2010 at 4:47 PM, Tal Galili <> wrote:
>>>>
>>>>  Hello dear R help group,
>>>>>
>>>>> I am trying to read a .txt file, with Hebrew column names, while
>>>>> keeping
>>>>> the
>>>>> column names looking well in R - but without success.
>>>>>
>>>>> I uploaded an example file to:
>>>>> http://www.talgalili.com/files/aa.txt
>>>>>
>>>>> And am trying the command:
>>>>> read.table("http://www.talgalili.com/files/aa.txt";, header = T, sep =
>>>>> "\t")
>>>>>
>>>>> This returns me with:
>>>>>
>>>>> X.....Âª X...Âª...... X...Å....
>>>>> 1      12          97         6
>>>>> 2     123         354        44
>>>>> 3       6           1         3
>>>>>
>>>>> Instead of:
>>>>>
>>>>> ×××ª     ×©×ª×××   ×©×××©
>>>>> 12      97      6
>>>>> 123     354     44
>>>>> 6       1       3
>>>>>
>>>>>
>>>>> Any suggestion or clarification will be appreciated.
>>>>>
>>>>> Best,
>>>>> Tal
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> ----------------Contact
>>>>> Details:-------------------------------------------------------
>>>>> Contact me: [email protected] |  972-52-7275845
>>>>> Read me: www.talgalili.com (Hebrew) | www.biostatistics.co.il (Hebrew)
>>>>> |
>>>>> www.r-statistics.com/ (English)
>>>>>
>>>>>
>>>>> ----------------------------------------------------------------------------------------------
>>>>>
>>>>>      [[alternative HTML version deleted]]
>>>>>
>>>>>
>>>>> ______________________________________________
>>>>> [email protected] mailing list
>>>>> 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.
>>>>>
>>>>>
>>>>>
>>>>
>>>        [[alternative HTML version deleted]]
>>>
>>> ______________________________________________
>>> [email protected] mailing list
>>> 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.
>>>
>>
>> David Winsemius, MD
>> Heritage Laboratories
>> West Hartford, CT
>>
>>
>

        [[alternative HTML version deleted]]

______________________________________________
[email protected] mailing list
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.

Re: [R] How to use read.table with Hebrew column names ?

Reply via email to