[R] How to read.table with “Hebrew” column names (in R)?

[Tal Galili]

(I am reposting this question after a few months without a solution...)


Hi all,

I am trying to read a .txt file, with Hebrew column names, but without
success.

I uploaded an example file to: http://www.talgalili.com/files/aa.txt

And tried 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


 Trying to use something like:

read.table("http://www.talgalili.com/files/aa.txt",fileEncoding ="iso8859-8")

Has resulted in:

 V1
1  ?
Warning messages:
1: In read.table("http://www.talgalili.com/files/aa.txt";, fileEncoding
= "iso8859-8") :

  invalid input found on input connection
'http://www.talgalili.com/files/aa.txt'
2: In read.table("http://www.talgalili.com/files/aa.txt";, fileEncoding
= "iso8859-8") :

  incomplete final line found by readTableHeader on
'http://www.talgalili.com/files/aa.txt'

While also trying this:

Sys.setlocale("LC_ALL", "en_US.UTF-8")

Or this:

Sys.setlocale("LC_ALL", "en_US.UTF-8/en_US.UTF-8/C/C/en_US.UTF-8/en_US.UTF-8")

Get's me this:

[1] ""
Warning message:
In Sys.setlocale("LC_ALL", "en_US.UTF-8") :

  OS reports request to set locale to "en_US.UTF-8" cannot be honored



My output for:

l10n_info()

Is:

$MBCS
[1] FALSE

$`UTF-8`
[1] FALSE

$`Latin-1`
[1] TRUE

$codepage
[1] 1252

And for:

Sys.getlocale()

Is:

[1] "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"

Finally, here is the > sessionInfo()

R version 2.10.1 (2009-12-14)

i386-pc-mingw32

locale:
[1] LC_COLLATE=English_United States.1255  LC_CTYPE=English_United
States.1252    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

loaded via a namespace (and not attached):
[1] tools_2.10.1


Any suggestion or clarification will be appreciated.



Best,

Tal

----------------Contact
Details:-------------------------------------------------------
Contact me: tal.gal...@gmail.com |  972-52-7275845
Read me: www.talgalili.com (Hebrew) | www.biostatistics.co.il (Hebrew) |
www.r-statistics.com (English)
----------------------------------------------------------------------------------------------

        [[alternative HTML version deleted]]


______________________________________________
R-help@r-project.org 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.