[R] importing data error question

Fox, John j|ox @end|ng |rom mcm@@ter@c@
Fri Jan 18 16:51:38 CET 2019


Dear Jihee,

> -----Original Message-----
> From: R-help [mailto:r-help-bounces using r-project.org] On Behalf Of ???
> Sent: Wednesday, January 16, 2019 7:02 PM
> To: Fox, John <jfox using mcmaster.ca>
> Cc: r-help using r-project.org
> Subject: Re: [R] importing data error question
> 
> Thanks for your help!
> 
> I was having trouble with finding how to use english...
> 
> Even though I try to use english language, I couldn't change language of R
> commander. (it is still korean)
> 
> Sorry but.. do you know how to change language of "R commander"? I have
> no idea why it doesn't change.

But the screenshots you sent in previous messages *did* show the Rcmdr in English, so you apparently successfully changed the language, I assume via the command Sys.setenv(LANGUAGE="en") that I suggested.

John

> 
> Best,
> 
> Jihee
> 
> From:  "Fox, John" <jfox using mcmaster.ca>
> 
> Sent: Thursday, January 17, 2019 1:59:03 AM
> 
> To:"우지희" <wjh1518 using ht.co.kr>
> 
> Cc:"r-help using r-project.org" <r-help using r-project.org>
> 
> Subject:Re: [R] importing data error question
> 
>   Dear jihee,
> 
>  I've looked into this problem further, using my Mac where it's easier to
> temporarily change languages and character sets than on Windows, and I
> discovered the following:
> 
>  I was able to duplicate your problem with importing Excel files when working
> in Korean. There's a similar problem with the import SAS b7dat files but not
> with the other file-import dialogs.
> 
>  I observed a similar problem when working in Chinese (LANG="zh") but not in
> simplified Chinese (zh_CN) or Japanese (ja), so the problem isn't simply with
> non-Latin character sets. There is no problem in English, Spanish (es), or
> French (fr), and I didn't check the other languages into which the Rcmdr is
> translated.
> 
>  I think that the problem originates in the Korean and Chinese translation files
> and I'll contact the translators to see whether they can fix it.
> 
>  Thank you for reporting this issue.
> 
>  John
> 
>  > On Jan 14, 2019, at 11:36 PM, Fox, John <jfox using mcmaster.ca> wrote:
>  >
>  > Dear jihee,
>  >
>  >> On Jan 14, 2019, at 9:00 PM, 우지희 <wjh1518 using ht.co.kr> wrote:
>  >>
>  >> You said previously that you were using a Mac, so I'm surprised that you
> now say that you're using Windows. I don't have a Windows 7 system, but I
> can confirm that importing from Excel files works perfectly fine under
> Windows 10, as I just verified, and I'd be surprised if the Windows version
> matters.
>  >>
>  >> --> no, I never said i was using a Mac.
>  >
>  > Sorry, I guess I got that from the error message you originally reported,
> which was "Error in structure(.External(.C_dotTclObjv, objv), class = "tclObj") :
> [tcl] bad Macintosh file type "“*”"." I've never seen that error and it seems
> peculiar that it would occur on a Windows system.
>  >
>  >>
>  >> You still haven't reported the versions of R, the Rcmdr package, and the
> other packages that you're using. The easiest way to do this is to show the
> output of the sessionInfo() command.
>  >>
>  >> --> sessionInfo()
>  >> R version 3.5.2 (2018-12-20)
>  >> Platform: x86_64-w64-mingw32/x64 (64-bit)  >> Running under: Windows
> 7 x64 (build 7601) Service Pack 1  >>  >> Matrix products: default  >>  >>
> locale:
>  >> [1] LC_COLLATE=Korean_Korea.949 LC_CTYPE=Korean_Korea.949  >> [3]
> LC_MONETARY=Korean_Korea.949 LC_NUMERIC=C  >> [5]
> LC_TIME=Korean_Korea.949  >>  >> attached base packages:
>  >> [1] tcltk splines stats graphics grDevices utils datasets methods  >> [9] base
> >>  >> other attached packages:
>  >> [1] RcmdrPlugin.SensoMineR_1.11-01 RcmdrPlugin.FactoMineR_1.6-0  >>
> [3] Rcmdr_2.5-1 effects_4.1-0  >> [5] RcmdrMisc_2.5-1 sandwich_2.5-0  >> [7]
> car_3.0-2 carData_3.0-2  >> [9] SensoMineR_1.23 FactoMineR_1.41  >>  >>
> loaded via a namespace (and not attached):
>  >> [1] gtools_3.8.1 Formula_1.2-3 latticeExtra_0.6-28  >> [4] cellranger_1.1.0
> pillar_1.3.1 backports_1.1.3  >> [7] lattice_0.20-38 digest_0.6.18
> RColorBrewer_1.1-2  >> [10] checkmate_1.8.5 minqa_1.2.4 colorspace_1.3-2
> >> [13] survey_3.35 htmltools_0.3.6 Matrix_1.2-15  >> [16] plyr_1.8.4
> pkgconfig_2.0.2 haven_2.0.0  >> [19] scales_1.0.0 openxlsx_4.1.0 rio_0.5.16
> >> [22] lme4_1.1-19 htmlTable_1.13.1 tibble_1.4.2  >> [25] relimp_1.0-5
> ggplot2_3.1.0 nnet_7.3-12  >> [28] lazyeval_0.2.1 survival_2.43-3 magrittr_1.5
> >> [31] crayon_1.3.4 readxl_1.2.0 nlme_3.1-137  >> [34] MASS_7.3-51.1
> forcats_0.3.0 foreign_0.8-71  >> [37] class_7.3-14 tools_3.5.2
> data.table_1.11.8  >> [40] hms_0.4.2 tcltk2_1.2-11 stringr_1.3.1  >> [43]
> munsell_0.5.0 cluster_2.0.7-1 zip_1.0.0  >> [46] flashClust_1.01-2
> compiler_3.5.2 e1071_1.7-0  >> [49] rlang_0.3.1 grid_3.5.2 nloptr_1.2.1  >>
> [52] rstudioapi_0.9.0 htmlwidgets_1.3 leaps_3.0  >> [55] base64enc_0.1-3
> gtable_0.2.0 abind_1.4-5  >> [58] curl_3.2 reshape2_1.4.3 AlgDesign_1.1-7.3
> >> [61] gridExtra_2.3 zoo_1.8-4 knitr_1.21  >> [64] nortest_1.0-4 Hmisc_4.1-1
> KernSmooth_2.23-15  >> [67] stringi_1.2.4 Rcpp_1.0.0 rpart_4.1-13  >> [70]
> acepack_1.4.1 scatterplot3d_0.3-41 xfun_0.4  >>  >> This was the status that I
> tried to import Excel data.
>  >
>  > These packages seem up-to-date.
>  >
>  >>
>  >> Also, have you tried importing an Excel file in the Rcmdr *without* the two
> plug-in packages loaded, as I suggested in my original response?
>  >>
>  >> --> I tried without plug-in packages, but It didn't work.
>  >
>  > OK, so you tried the setup that works for me and, I assume from the lack of
> similar error reports, for others.
>  >
>  >>
>  >> It occurs to me that the problem may be produced by using the Rcmdr
> under R with a non-Latin set, but if that were the case I would have expected
> the problem to have surfaced earlier. Did you try reading another kind of file,
> such as a plain-text data file?
>  >>
>  >> --> I don't know what is plain-text data file.....
>  >
>  > A plain-text data file could, e.g., be created from an Excel file by exporting a
> worksheet as a .csv (comma-separated-values) file; you could read this into
> the Rcmdr via Data > Import data > from text file, specifying the field
> separator as commas.
>  >
>  >>
>  >> i'll try R with English.
>  >
>  > I'm curious to see what happens.
>  >
>  > Best,
>  > John
>  >
>  >>
>  >> From: "Fox, John" <jfox using mcmaster.ca>  >>  >> Sent: Monday, January 14,
> 2019 11:15:36 PM  >>  >> To:"우지희" <wjh1518 using ht.co.kr>  >>  >> Cc:"<r-
> help using r-project.org>" <r-help using R-project.org></r-help using r-project.org>
>  >>
>  >> Subject:Re: [R] importing data error question  >>  >> Dear jihee,  >>  >>> On
> Jan 13, 2019, at 9:28 PM, 우지희 <wjh1518 using ht.co.kr> wrote:
>  >>>
>  >>>
>  >>>
>  >>> From: "우지희" <wjh1518 using ht.co.kr>
>  >>> Sent: Monday, January 14, 2019 9:40:26 AM  >>> To:"Fox, John"
> <jfox using mcmaster.ca>  >>> Subject:Re: [R] importing data error question  >>>
> >>>  >>> Thanks for your replies.
>  >>>
>  >>> I'm using windows 7, I loaded FactoMineR,  >>  >> You said previously
> that you were using a Mac, so I'm surprised that you now say that you're using
> Windows. I don't have a Windows 7 system, but I can confirm that importing
> from Excel files works perfectly fine under Windows 10, as I just verified, and
> I'd be surprised if the Windows version matters.
>  >>
>  >>> SensoMineR and then Rcmdr. (Downloaded FacroMineR, SensoMineR,
> Rcmdr, Rcmdrplugin.FactomineR, Rcmdrplugin.SensomineR and other
> required packages that downloaded automatically)  >>> This problem
> occurred when I select Data > Import data > From Excel file.
>  >>> I checked FactoMineR and SensoMineR packages are loaded and using..
>  >>
>  >> You still haven't reported the versions of R, the Rcmdr package, and the
> other packages that you're using. The easiest way to do this is to show the
> output of the sessionInfo() command.
>  >>
>  >> Also, have you tried importing an Excel file in the Rcmdr *without* the two
> plug-in packages loaded, as I suggested in my original response?
>  >>
>  >> It occurs to me that the problem may be produced by using the Rcmdr
> under R with a non-Latin set, but if that were the case I would have expected
> the problem to have surfaced earlier. Did you try reading another kind of file,
> such as a plain-text data file?
>  >>
>  >> Best,
>  >> John
>  >>
>  >>>
>  >>>
>  >>>
>  >>> From: "Fox, John" <jfox using mcmaster.ca>  >>> Sent: Friday, January 11,
> 2019 10:48:38 PM  >>> To:"PIKAL Petr" <petr.pikal using precheza.cz>  >>>
> Cc:"우지희" <wjh1518 using ht.co.kr>; "r-help using R-project.org" <r-help using r-
> project.org>  >>> Subject:Re: [R] importing data error question  >>>  >>>  >>>
> Dear Petr and jihee,  >>>  >>> The Rcmdr can import Excel files, and as I just
> verified, it can do so on a Mac listing files of all types (*) in the open-file dialog
> box (which is the default).
>  >>>
>  >>> So, as Petr suggests, more information is required to help you, including
> the versions of macOS, R, and all packages you have loaded. In particular,
> does the problem occur when you try to read the Excel file *without*
> FactoMineR and SensoMineR loaded? Also, when the does problem occur --
> immediately when you select Data > Import data > From Excel file, or at some
> other point?
>  >>>
>  >>> Best,
>  >>> John
>  >>>
>  >>> -------------------------------------------------
>  >>> John Fox, Professor Emeritus
>  >>> McMaster University
>  >>> Hamilton, Ontario, Canada
>  >>> Web: http::/socserv.mcmaster.ca/jfox  >>>  >>>> On Jan 11, 2019, at 5:07
> AM, PIKAL Petr <petr.pikal using precheza.cz> wrote:
>  >>>>
>  >>>> Hi
>  >>>>
>  >>>> I do not use Rcmdr but from documentation it seems to me that it does
> not have much to do with importing data from Excel.
>  >>>>
>  >>>> So without some additional info from your side (at least used
> commands) you hardly get any reasonable answer.
>  >>>>
>  >>>> Cheers
>  >>>> Petr
>  >>>>
>  >>>>> -----Original Message-----
>  >>>>> From: R-help <r-help-bounces using r-project.org> On Behalf Of ???
>  >>>>> Sent: Friday, January 11, 2019 9:14 AM  >>>>> To: r-help using R-
> project.org  >>>>> Subject: [R] importing data error question  >>>>>  >>>>> Hi
> I'm jihee and I have a question about error...
>  >>>>>
>  >>>>> I'm using R 3.5.2 and tried to use Rcmdr package.
>  >>>>>
>  >>>>> and using FactoMineR and SensoMineR to analyze sensory data
> through PCA  >>>>>  >>>>> but i can't import excel data with Rcmdr.
>  >>>>>
>  >>>>> it has this messege :
>  >>>>>
>  >>>>> Error in structure(.External(.C_dotTclObjv, objv), class = "tclObj") :
>  >>>>> [tcl] bad Macintosh file type "“*”"
>  >>>>>
>  >>>>> what is wrong with my R??? T_T
>  >>>>>
>  >>>>> Thanks for your help.
>  >>>>>
>  >>>>> jihee.
>  >>>>> [[alternative HTML version deleted]]  >>>>>  >>>>>
> ______________________________________________
>  >>>>> R-help using r-project.org mailing list -- To UNSUBSCRIBE and more, see
> >>>>> 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.
>  >>>> Osobní údaje: Informace o zpracování a ochraně osobních údajů
> obchodních partnerů PRECHEZA a.s. jsou zveřejněny na:
> https://www.precheza.cz/zasady-ochrany-osobnich-udaju/ | Information
> about processing and protection of business partner’s personal data are
> available on website: https://www.precheza.cz/en/personal-data-protection-
> principles/
>  >>>> Důvěrnost: Tento e-mail a jakékoliv k němu připojené dokumenty jsou
> důvěrné a podléhají tomuto právně závaznému prohláąení o vyloučení
> odpovědnosti: https://www.precheza.cz/01-dovetek/ | This email and any
> documents attached to it may be confidential and are subject to the legally
> binding disclaimer: https://www.precheza.cz/en/01-disclaimer/
>  >>>>
>  >>>> ______________________________________________
>  >>>> R-help using r-project.org mailing list -- To UNSUBSCRIBE and more, see
> >>>> 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.
>  >>>
>  >>>
>  >>>
>  >>>
>  >>> 우지희 연구원 / 초콜릿개발팀
>  >>> e-mailwjh1518 using ht.co.krDirMobile
>  >>> 홈페이지www.ht.co.kr페이스북www.facebook.com/haitaico
>  >>> Address서울특별시 용산구 한강대로 72길 3 (남영동)
> 해태제과식품(주) 04352  >>> 상기 메일은 지정된 수신인만을 위한
> 것이며, 부정경쟁방지 및 영업비밀보호에 관한 법률을 포함하여 관련
> 법령에 따라 보호의 대상이 되는 영업비밀, 산업기술 등을 포함하고 있을
> 수 있습니다. 본 문서에 포함된 정보의 전부 또는 일부를 무단으로
> 제3자에게 공개, 배포, 복사 또는 사용하는 것은 엄격히 금지됩니다. 본
> 메일이 잘못 전송된 경우, 발신인에게 알려주시고 본 메일을 즉시
> 삭제하여 주시기 바랍니다.
>  >>> The above message is intended solely for the named addressee and may
> contain trade secret. Industrial technology or privileged and confidential
> information otherwise protected under applicable law including the Unfair
> Competition Prevention and Trade Secret Protection Act. Any unauthorized
> dissemination, distribution, copying or use of the information contained in
> this communication is strictly prohibited. If you have received this
> communication in error, please notify the sender by email and delete this
> communication immediately  >>>  >>>  >>>  >>>  >>> 우지희 연구원 /
> 초콜릿개발팀  >>> e-mailwjh1518 using ht.co.krDirMobile  >>>
> 홈페이지www.ht.co.kr페이스북www.facebook.com/haitaico
>  >>> Address서울특별시 용산구 한강대로 72길 3 (남영동)
> 해태제과식품(주) 04352  >>> 상기 메일은 지정된 수신인만을 위한
> 것이며, 부정경쟁방지 및 영업비밀보호에 관한 법률을 포함하여 관련
> 법령에 따라 보호의 대상이 되는 영업비밀, 산업기술 등을 포함하고 있을
> 수 있습니다. 본 문서에 포함된 정보의 전부 또는 일부를 무단으로
> 제3자에게 공개, 배포, 복사 또는 사용하는 것은 엄격히 금지됩니다. 본
> 메일이 잘못 전송된 경우, 발신인에게 알려주시고 본 메일을 즉시
> 삭제하여 주시기 바랍니다.
>  >>> The above message is intended solely for the named addressee and may
> contain trade secret. Industrial technology or privileged and confidential
> information otherwise protected under applicable law including the Unfair
> Competition Prevention and Trade Secret Protection Act. Any unauthorized
> dissemination, distribution, copying or use of the information contained in
> this communication is strictly prohibited. If you have received this
> communication in error, please notify the sender by email and delete this
> communication immediately  >> [[alternative HTML version deleted]]  >>  >>
> ______________________________________________
>  >> R-help using r-project.org mailing list -- To UNSUBSCRIBE and more, see  >>
> 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.
>  >
>  > ______________________________________________
>  > R-help using r-project.org mailing list -- To UNSUBSCRIBE and more, see  >
> 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]]
> 
> ______________________________________________
> R-help using r-project.org mailing list -- To UNSUBSCRIBE and more, see
> 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.


More information about the R-help mailing list