[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