FW: Re: importing data error question

classic Classic list List threaded Threaded
11 messages Options
Reply | Threaded
Open this post in threaded view
|

FW: Re: importing data error question

우지희
From:  "우지희" <[hidden email]>

Sent: Monday, January 14, 2019 9:40:26 AM

To:"Fox, John" <[hidden email]>

Subject:Re: [R] importing data error question

Thanks for your replies.

I'm using windows 7, I loaded FactoMineR, 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..

From:  "Fox, John" <[hidden email]>

Sent: Friday, January 11, 2019 10:48:38 PM

To:"PIKAL Petr" <[hidden email]>

Cc:"우지희" <[hidden email]>; "[hidden email]" <[hidden email]>

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 <[hidden email]> 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 <[hidden email]> On Behalf Of ???
 >> Sent: Friday, January 11, 2019 9:14 AM
 >> To: [hidden email]
 >> 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]]
 >>
 >> ______________________________________________
 >> [hidden email] 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/
 >
 > ______________________________________________
 > [hidden email] 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-mail   [hidden email]   Dir   Mobile  

  홈페이지 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]]

______________________________________________
[hidden email] 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.
Reply | Threaded
Open this post in threaded view
|

Re: importing data error question

Fox, John
Dear jihee,

> On Jan 13, 2019, at 9:28 PM, 우지희 <[hidden email]> wrote:
>
>  
>  
> From: "우지희" <[hidden email]>
> Sent: Monday, January 14, 2019 9:40:26 AM
> To:"Fox, John" <[hidden email]>
> 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" <[hidden email]>
> Sent: Friday, January 11, 2019 10:48:38 PM
> To:"PIKAL Petr" <[hidden email]>
> Cc:"우지희" <[hidden email]>; "[hidden email]" <[hidden email]>
> 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 <[hidden email]> 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 <[hidden email]> On Behalf Of ???
> >> Sent: Friday, January 11, 2019 9:14 AM
> >> To: [hidden email]
> >> 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]]
> >>
> >> ______________________________________________
> >> [hidden email] 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/
> >
> > ______________________________________________
> > [hidden email] 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-mail [hidden email] Dir Mobile
> 홈페이지 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-mail [hidden email] Dir Mobile
> 홈페이지 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

______________________________________________
[hidden email] 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.
Reply | Threaded
Open this post in threaded view
|

Re: importing data error question

우지희
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.

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.

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.

 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.....

i'll try R with English.

From:  "Fox, John" <[hidden email]>

Sent: Monday, January 14, 2019 11:15:36 PM

To:"우지희" <[hidden email]>

Cc:"<[hidden email]>" <[hidden email]></[hidden email]>

Subject:Re: [R] importing data error question

   Dear jihee,

  > On Jan 13, 2019, at 9:28 PM, 우지희 <[hidden email]> wrote:
  >
  >
  >
  > From: "우지희" <[hidden email]>
  > Sent: Monday, January 14, 2019 9:40:26 AM
  > To:"Fox, John" <[hidden email]>
  > 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" <[hidden email]>
  > Sent: Friday, January 11, 2019 10:48:38 PM
  > To:"PIKAL Petr" <[hidden email]>
  > Cc:"우지희" <[hidden email]>; "[hidden email]" <[hidden email]>
  > 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 <[hidden email]> 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 <[hidden email]> On Behalf Of ???
  > >> Sent: Friday, January 11, 2019 9:14 AM
  > >> To: [hidden email]
  > >> 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]]
  > >>
  > >> ______________________________________________
  > >> [hidden email] 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/
  > >
  > > ______________________________________________
  > > [hidden email] 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.
  >
  >
  >
  >
  > 우지희 연구원 / 초콜릿개발팀
  > [hidden email]
  > 홈페이지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
  >
  >
  >
  >
  > 우지희 연구원 / 초콜릿개발팀
  > [hidden email]
  > 홈페이지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]]

______________________________________________
[hidden email] 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.
Reply | Threaded
Open this post in threaded view
|

Re: importing data error question

Fox, John
In reply to this post by Fox, John
Dear jihee,

> On Jan 14, 2019, at 9:00 PM, 우지희 <[hidden email]> 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" <[hidden email]>
>
> Sent: Monday, January 14, 2019 11:15:36 PM
>
> To:"우지희" <[hidden email]>
>
> Cc:"<[hidden email]>" <[hidden email]></[hidden email]>
>
> Subject:Re: [R] importing data error question
>
>    Dear jihee,
>
>> On Jan 13, 2019, at 9:28 PM, 우지희 <[hidden email]> wrote:
>>
>>
>>
>> From: "우지희" <[hidden email]>
>> Sent: Monday, January 14, 2019 9:40:26 AM
>> To:"Fox, John" <[hidden email]>
>> 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" <[hidden email]>
>> Sent: Friday, January 11, 2019 10:48:38 PM
>> To:"PIKAL Petr" <[hidden email]>
>> Cc:"우지희" <[hidden email]>; "[hidden email]" <[hidden email]>
>> 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 <[hidden email]> 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 <[hidden email]> On Behalf Of ???
>>>> Sent: Friday, January 11, 2019 9:14 AM
>>>> To: [hidden email]
>>>> 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]]
>>>>
>>>> ______________________________________________
>>>> [hidden email] 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/
>>>
>>> ______________________________________________
>>> [hidden email] 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.
>>
>>
>>
>>
>> 우지희 연구원 / 초콜릿개발팀
>> [hidden email]
>> 홈페이지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
>>
>>
>>
>>
>> 우지희 연구원 / 초콜릿개발팀
>> [hidden email]
>> 홈페이지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]]
>
> ______________________________________________
> [hidden email] 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.

______________________________________________
[hidden email] 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.
Reply | Threaded
Open this post in threaded view
|

Re: importing data error question

Fox, John
In reply to this post by Fox, John
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 <[hidden email]> wrote:
>
> Dear jihee,
>
>> On Jan 14, 2019, at 9:00 PM, 우지희 <[hidden email]> 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" <[hidden email]>
>>
>> Sent: Monday, January 14, 2019 11:15:36 PM
>>
>> To:"우지희" <[hidden email]>
>>
>> Cc:"<[hidden email]>" <[hidden email]></[hidden email]>
>>
>> Subject:Re: [R] importing data error question
>>
>>   Dear jihee,
>>
>>> On Jan 13, 2019, at 9:28 PM, 우지희 <[hidden email]> wrote:
>>>
>>>
>>>
>>> From: "우지희" <[hidden email]>
>>> Sent: Monday, January 14, 2019 9:40:26 AM
>>> To:"Fox, John" <[hidden email]>
>>> 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" <[hidden email]>
>>> Sent: Friday, January 11, 2019 10:48:38 PM
>>> To:"PIKAL Petr" <[hidden email]>
>>> Cc:"우지희" <[hidden email]>; "[hidden email]" <[hidden email]>
>>> 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 <[hidden email]> 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 <[hidden email]> On Behalf Of ???
>>>>> Sent: Friday, January 11, 2019 9:14 AM
>>>>> To: [hidden email]
>>>>> 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]]
>>>>>
>>>>> ______________________________________________
>>>>> [hidden email] 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/
>>>>
>>>> ______________________________________________
>>>> [hidden email] 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.
>>>
>>>
>>>
>>>
>>> 우지희 연구원 / 초콜릿개발팀
>>> [hidden email]
>>> 홈페이지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
>>>
>>>
>>>
>>>
>>> 우지희 연구원 / 초콜릿개발팀
>>> [hidden email]
>>> 홈페이지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]]
>>
>> ______________________________________________
>> [hidden email] 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.
>
> ______________________________________________
> [hidden email] 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.

______________________________________________
[hidden email] 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.
Reply | Threaded
Open this post in threaded view
|

Re: 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.

Best,

Jihee

From:  "Fox, John" <[hidden email]>

Sent: Thursday, January 17, 2019 1:59:03 AM

To:"우지희" <[hidden email]>

Cc:"[hidden email]" <[hidden email]>

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 <[hidden email]> wrote:
 >
 > Dear jihee,
 >
 >> On Jan 14, 2019, at 9:00 PM, 우지희 <[hidden email]> 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" <[hidden email]>
 >>
 >> Sent: Monday, January 14, 2019 11:15:36 PM
 >>
 >> To:"우지희" <[hidden email]>
 >>
 >> Cc:"<[hidden email]>" <[hidden email]></[hidden email]>
 >>
 >> Subject:Re: [R] importing data error question
 >>
 >> Dear jihee,
 >>
 >>> On Jan 13, 2019, at 9:28 PM, 우지희 <[hidden email]> wrote:
 >>>
 >>>
 >>>
 >>> From: "우지희" <[hidden email]>
 >>> Sent: Monday, January 14, 2019 9:40:26 AM
 >>> To:"Fox, John" <[hidden email]>
 >>> 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" <[hidden email]>
 >>> Sent: Friday, January 11, 2019 10:48:38 PM
 >>> To:"PIKAL Petr" <[hidden email]>
 >>> Cc:"우지희" <[hidden email]>; "[hidden email]" <[hidden email]>
 >>> 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 <[hidden email]> 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 <[hidden email]> On Behalf Of ???
 >>>>> Sent: Friday, January 11, 2019 9:14 AM
 >>>>> To: [hidden email]
 >>>>> 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]]
 >>>>>
 >>>>> ______________________________________________
 >>>>> [hidden email] 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/
 >>>>
 >>>> ______________________________________________
 >>>> [hidden email] 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.
 >>>
 >>>
 >>>
 >>>
 >>> 우지희 연구원 / 초콜릿개발팀
 >>> [hidden email]
 >>> 홈페이지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
 >>>
 >>>
 >>>
 >>>
 >>> 우지희 연구원 / 초콜릿개발팀
 >>> [hidden email]
 >>> 홈페이지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]]
 >>
 >> ______________________________________________
 >> [hidden email] 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.
 >
 > ______________________________________________
 > [hidden email] 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]]

______________________________________________
[hidden email] 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.
Reply | Threaded
Open this post in threaded view
|

Re: importing data error question

Fox, John
Dear Jihee,

Probably the easiest way to change the language to English temporarily in R is to enter the command

        Sys.setenv(LANGUAGE="en")

at the R command prompt prior to loading the Rcmdr package.

I hope that this helps,
 John


> On Jan 16, 2019, at 7:02 PM, 우지희 <[hidden email]> wrote:
>
> 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.
>  
> Best,
> Jihee
>  
> From: "Fox, John" <[hidden email]>
> Sent: Thursday, January 17, 2019 1:59:03 AM
> To:"우지희" <[hidden email]>
> Cc:"[hidden email]" <[hidden email]>
> 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 <[hidden email]> wrote:
> >
> > Dear jihee,
> >
> >> On Jan 14, 2019, at 9:00 PM, 우지희 <[hidden email]> 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" <[hidden email]>
> >>
> >> Sent: Monday, January 14, 2019 11:15:36 PM
> >>
> >> To:"우지희" <[hidden email]>
> >>
> >> Cc:"<[hidden email]>" <[hidden email]></[hidden email]>
> >>
> >> Subject:Re: [R] importing data error question
> >>
> >> Dear jihee,
> >>
> >>> On Jan 13, 2019, at 9:28 PM, 우지희 <[hidden email]> wrote:
> >>>
> >>>
> >>>
> >>> From: "우지희" <[hidden email]>
> >>> Sent: Monday, January 14, 2019 9:40:26 AM
> >>> To:"Fox, John" <[hidden email]>
> >>> 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" <[hidden email]>
> >>> Sent: Friday, January 11, 2019 10:48:38 PM
> >>> To:"PIKAL Petr" <[hidden email]>
> >>> Cc:"우지희" <[hidden email]>; "[hidden email]" <[hidden email]>
> >>> 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 <[hidden email]> 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 <[hidden email]> On Behalf Of ???
> >>>>> Sent: Friday, January 11, 2019 9:14 AM
> >>>>> To: [hidden email]
> >>>>> 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]]
> >>>>>
> >>>>> ______________________________________________
> >>>>> [hidden email] 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/
> >>>>
> >>>> ______________________________________________
> >>>> [hidden email] 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.
> >>>
> >>>
> >>>
> >>>
> >>> 우지희 연구원 / 초콜릿개발팀
> >>> [hidden email]
> >>> 홈페이지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
> >>>
> >>>
> >>>
> >>>
> >>> 우지희 연구원 / 초콜릿개발팀
> >>> [hidden email]
> >>> 홈페이지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]]
> >>
> >> ______________________________________________
> >> [hidden email] 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.
> >
> > ______________________________________________
> > [hidden email] 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-mail [hidden email] Dir Mobile
> 홈페이지 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

______________________________________________
[hidden email] 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.
Reply | Threaded
Open this post in threaded view
|

Re: importing data error question

Fox, John
Dear Jihee,

This appears to be a different problem. You were  apparently able to access the spreadsheet file, but the R Commander didn't find a suitable worksheet in it.

Try downloading and reading the file at <https://socialsciences.mcmaster.ca/jfox/Courses/R/ICPSR/Prestige.xlsx>. If that works, send me privately (i.e., directly) your Excel spreadsheet file and I'll take a look at it.

Best,
 John

> On Jan 16, 2019, at 9:49 PM, 우지희 <[hidden email]> wrote:
>
> Dear John,
>  
> now i can use english thank you very much!!
>  
> um.. but nothing's changed... with that {r} message at R Markdown.
>  
> There's no dataset.
>  
> i tried both .xls and .xlsx .
>  
>  
> Jihee
>  
>  
>  
> <fbe6254214d94e74b98569b08bb3bf07.png>
>  
>  
>  
> From: "Fox, John" <[hidden email]>
> Sent: Thursday, January 17, 2019 10:59:44 AM
> To:"우지희" <[hidden email]>
> Cc:"<[hidden email]>" <[hidden email]></[hidden email]>
> Subject:Re: [R] importing data error question
>  
>  
> Dear Jihee,
>
> Probably the easiest way to change the language to English temporarily in R is to enter the command
>
> Sys.setenv(LANGUAGE="en")
>
> at the R command prompt prior to loading the Rcmdr package.
>
> I hope that this helps,
> John
>
>
> > On Jan 16, 2019, at 7:02 PM, 우지희 <[hidden email]> wrote:
> >
> > 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.
> >  
> > Best,
> > Jihee
> >  
> > From: "Fox, John" <[hidden email]>
> > Sent: Thursday, January 17, 2019 1:59:03 AM
> > To:"우지희" <[hidden email]>
> > Cc:"[hidden email]" <[hidden email]>
> > 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 <[hidden email]> wrote:
> > >
> > > Dear jihee,
> > >
> > >> On Jan 14, 2019, at 9:00 PM, 우지희 <[hidden email]> 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" <[hidden email]>
> > >>
> > >> Sent: Monday, January 14, 2019 11:15:36 PM
> > >>
> > >> To:"우지희" <[hidden email]>
> > >>
> > >> Cc:"<[hidden email]>" <[hidden email]></[hidden email]>
> > >>
> > >> Subject:Re: [R] importing data error question
> > >>
> > >> Dear jihee,
> > >>
> > >>> On Jan 13, 2019, at 9:28 PM, 우지희 <[hidden email]> wrote:
> > >>>
> > >>>
> > >>>
> > >>> From: "우지희" <[hidden email]>
> > >>> Sent: Monday, January 14, 2019 9:40:26 AM
> > >>> To:"Fox, John" <[hidden email]>
> > >>> 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" <[hidden email]>
> > >>> Sent: Friday, January 11, 2019 10:48:38 PM
> > >>> To:"PIKAL Petr" <[hidden email]>
> > >>> Cc:"우지희" <[hidden email]>; "[hidden email]" <[hidden email]>
> > >>> 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 <[hidden email]> 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 <[hidden email]> On Behalf Of ???
> > >>>>> Sent: Friday, January 11, 2019 9:14 AM
> > >>>>> To: [hidden email]
> > >>>>> 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]]
> > >>>>>
> > >>>>> ______________________________________________
> > >>>>> [hidden email] 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/
> > >>>>
> > >>>> ______________________________________________
> > >>>> [hidden email] 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.
> > >>>
> > >>>
> > >>>
> > >>>
> > >>> 우지희 연구원 / 초콜릿개발팀
> > >>> [hidden email]
> > >>> 홈페이지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
> > >>>
> > >>>
> > >>>
> > >>>
> > >>> 우지희 연구원 / 초콜릿개발팀
> > >>> [hidden email]
> > >>> 홈페이지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]]
> > >>
> > >> ______________________________________________
> > >> [hidden email] 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.
> > >
> > > ______________________________________________
> > > [hidden email] 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-mail [hidden email] Dir Mobile
> > 홈페이지 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-mail [hidden email] Dir Mobile
> 홈페이지 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

______________________________________________
[hidden email] 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.
Reply | Threaded
Open this post in threaded view
|

Re: importing data error question

Fox, John
Dear Jihee,

Your latest attempt has gotten farther than the previous one but has produced a different error. The command to read the data set was generated properly. You can see whether the data set was in fact read by typing prestige (the name you gave to the data set) at the > command prompt in the R console. Assuming that the data set was read, an error occurred when the Rcmdr tried to make it the active data set. I'm afraid that I don't understand how this could happen because this procedure works correctly for me and for others. The underlying code is invoked whenever the Rcmdr reads a dara set.

I suggest that you try two additional things:

(1) I noticed that you loaded the FactoMineR and SensoMineR plug-ins. Try again without loading these plug-ins.

(2) Download and try reading the plain-text data file from <https://socialsciences.mcmaster.ca/jfox/Courses/R/ICPSR/Prestige.xlsx>, using "Data > Import data > From text file, clipboard, or URL"; you can take all of the defaults in the resulting dialog box.

If neither of these works then I'm afraid that I'm out of ideas. There's something peculiar about your R installation that I can't detect.

Best,
 John



> On Jan 17, 2019, at 12:24 AM, 우지희 <[hidden email]> wrote:
>
> Dear John,
>  
> I tried with your file. R commander could read the file but there's still no active dataset....
>  
> Anyway I'll send my file, too
>  
> Jihee
>  
> <528c421a382d426895f6446b32fbc6f0.png>
>  
> From: "Fox, John" <[hidden email]>
> Sent: Thursday, January 17, 2019 2:09:52 PM
> To:"우지희" <[hidden email]>
> Cc:"<[hidden email]>" <[hidden email]></[hidden email]>
> Subject:Re: [R] importing data error question
>  
>  
> Dear Jihee,
>
> This appears to be a different problem. You were apparently able to access the spreadsheet file, but the R Commander didn't find a suitable worksheet in it.
>
> Try downloading and reading the file at <https://socialsciences.mcmaster.ca/jfox/Courses/R/ICPSR/Prestige.xlsx>. If that works, send me privately (i.e., directly) your Excel spreadsheet file and I'll take a look at it.
>
> Best,
> John
>
> > On Jan 16, 2019, at 9:49 PM, 우지희 <[hidden email]> wrote:
> >
> > Dear John,
> >  
> > now i can use english thank you very much!!
> >  
> > um.. but nothing's changed... with that {r} message at R Markdown.
> >  
> > There's no dataset.
> >  
> > i tried both .xls and .xlsx .
> >  
> >  
> > Jihee
> >  
> >  
> >  
> > <fbe6254214d94e74b98569b08bb3bf07.png>
> >  
> >  
> >  
> > From: "Fox, John" <[hidden email]>
> > Sent: Thursday, January 17, 2019 10:59:44 AM
> > To:"우지희" <[hidden email]>
> > Cc:"<[hidden email]>" <[hidden email]></[hidden email]>
> > Subject:Re: [R] importing data error question
> >  
> >  
> > Dear Jihee,
> >
> > Probably the easiest way to change the language to English temporarily in R is to enter the command
> >
> > Sys.setenv(LANGUAGE="en")
> >
> > at the R command prompt prior to loading the Rcmdr package.
> >
> > I hope that this helps,
> > John
> >
> >
> > > On Jan 16, 2019, at 7:02 PM, 우지희 <[hidden email]> wrote:
> > >
> > > 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.
> > >  
> > > Best,
> > > Jihee
> > >  
> > > From: "Fox, John" <[hidden email]>
> > > Sent: Thursday, January 17, 2019 1:59:03 AM
> > > To:"우지희" <[hidden email]>
> > > Cc:"[hidden email]" <[hidden email]>
> > > 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 <[hidden email]> wrote:
> > > >
> > > > Dear jihee,
> > > >
> > > >> On Jan 14, 2019, at 9:00 PM, 우지희 <[hidden email]> 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" <[hidden email]>
> > > >>
> > > >> Sent: Monday, January 14, 2019 11:15:36 PM
> > > >>
> > > >> To:"우지희" <[hidden email]>
> > > >>
> > > >> Cc:"<[hidden email]>" <[hidden email]></[hidden email]>
> > > >>
> > > >> Subject:Re: [R] importing data error question
> > > >>
> > > >> Dear jihee,
> > > >>
> > > >>> On Jan 13, 2019, at 9:28 PM, 우지희 <[hidden email]> wrote:
> > > >>>
> > > >>>
> > > >>>
> > > >>> From: "우지희" <[hidden email]>
> > > >>> Sent: Monday, January 14, 2019 9:40:26 AM
> > > >>> To:"Fox, John" <[hidden email]>
> > > >>> 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" <[hidden email]>
> > > >>> Sent: Friday, January 11, 2019 10:48:38 PM
> > > >>> To:"PIKAL Petr" <[hidden email]>
> > > >>> Cc:"우지희" <[hidden email]>; "[hidden email]" <[hidden email]>
> > > >>> 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 <[hidden email]> 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 <[hidden email]> On Behalf Of ???
> > > >>>>> Sent: Friday, January 11, 2019 9:14 AM
> > > >>>>> To: [hidden email]
> > > >>>>> 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]]
> > > >>>>>
> > > >>>>> ______________________________________________
> > > >>>>> [hidden email] 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/
> > > >>>>
> > > >>>> ______________________________________________
> > > >>>> [hidden email] 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.
> > > >>>
> > > >>>
> > > >>>
> > > >>>
> > > >>> 우지희 연구원 / 초콜릿개발팀
> > > >>> [hidden email]
> > > >>> 홈페이지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
> > > >>>
> > > >>>
> > > >>>
> > > >>>
> > > >>> 우지희 연구원 / 초콜릿개발팀
> > > >>> [hidden email]
> > > >>> 홈페이지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]]
> > > >>
> > > >> ______________________________________________
> > > >> [hidden email] 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.
> > > >
> > > > ______________________________________________
> > > > [hidden email] 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-mail [hidden email] Dir Mobile
> > > 홈페이지 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-mail [hidden email] Dir Mobile
> > 홈페이지 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-mail [hidden email] Dir Mobile
> 홈페이지 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
> <mass2.xlsx>

______________________________________________
[hidden email] 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.
Reply | Threaded
Open this post in threaded view
|

Re: importing data error question

Fox, John
Dear Jihee,

> On Jan 17, 2019, at 7:00 PM, 우지희 <[hidden email]> wrote:
>
> Dear John,
>  
> (1) I noticed that you loaded the FactoMineR and SensoMineR plug-ins. Try again without loading these plug-ins.
> not worked :(
>  
> <e6a62b753f314ee6a71b3092789009f2.png>

OK. I don't understand why that doesn't work. There is likely some peculiarity in your system, but I have no idea what it is, and I can't think what else I might do without access to your computer.

>  
>  
> (2) Download and try reading the plain-text data file from <https://socialsciences.mcmaster.ca/jfox/Courses/R/ICPSR/Prestige.xlsx>, using "Data > Import data > From text file, clipboard, or URL"; you can take all of the defaults in the resulting dialog box.
>  
> I think importing is working but I can't view data set. it says ERROR: DATA FRAME TOO WIDE
>  
> <ed5dee194ad648af865b37703567d20a.png>

You tried to read the Excel file Prestige.xlsx as if it were a plain-text file, which produces nonsense. This was my fault: I sent the wrong link; the correct file is at <https://socialsciences.mcmaster.ca/jfox/Courses/R/ICPSR/Prestige.txt>.

Best,
 John

>  
>  
>  
> I have no idea neither. ;(
> I might give up from now,,,,,,
>  
>  
> Thanks again!
>  
> Best,
> Jihee
>  
>  
>  
> From: "Fox, John" <[hidden email]>
> Sent: Friday, January 18, 2019 12:02:42 AM
> To:"우지희" <[hidden email]>
> Cc:"<[hidden email]>" <[hidden email]></[hidden email]>
> Subject:Re: [R] importing data error question
>  
>  
> Dear Jihee,
>
> Your latest attempt has gotten farther than the previous one but has produced a different error. The command to read the data set was generated properly. You can see whether the data set was in fact read by typing prestige (the name you gave to the data set) at the > command prompt in the R console. Assuming that the data set was read, an error occurred when the Rcmdr tried to make it the active data set. I'm afraid that I don't understand how this could happen because this procedure works correctly for me and for others. The underlying code is invoked whenever the Rcmdr reads a dara set.
>
> I suggest that you try two additional things:
>
> (1) I noticed that you loaded the FactoMineR and SensoMineR plug-ins. Try again without loading these plug-ins.
>
> (2) Download and try reading the plain-text data file from <https://socialsciences.mcmaster.ca/jfox/Courses/R/ICPSR/Prestige.xlsx>, using "Data > Import data > From text file, clipboard, or URL"; you can take all of the defaults in the resulting dialog box.
>
> If neither of these works then I'm afraid that I'm out of ideas. There's something peculiar about your R installation that I can't detect.
>
> Best,
> John
>
>
>
> > On Jan 17, 2019, at 12:24 AM, 우지희 <[hidden email]> wrote:
> >
> > Dear John,
> >  
> > I tried with your file. R commander could read the file but there's still no active dataset....
> >  
> > Anyway I'll send my file, too
> >  
> > Jihee
> >  
> > <528c421a382d426895f6446b32fbc6f0.png>
> >  
> > From: "Fox, John" <[hidden email]>
> > Sent: Thursday, January 17, 2019 2:09:52 PM
> > To:"우지희" <[hidden email]>
> > Cc:"<[hidden email]>" <[hidden email]></[hidden email]>
> > Subject:Re: [R] importing data error question
> >  
> >  
> > Dear Jihee,
> >
> > This appears to be a different problem. You were apparently able to access the spreadsheet file, but the R Commander didn't find a suitable worksheet in it.
> >
> > Try downloading and reading the file at <https://socialsciences.mcmaster.ca/jfox/Courses/R/ICPSR/Prestige.xlsx>. If that works, send me privately (i.e., directly) your Excel spreadsheet file and I'll take a look at it.
> >
> > Best,
> > John
> >
> > > On Jan 16, 2019, at 9:49 PM, 우지희 <[hidden email]> wrote:
> > >
> > > Dear John,
> > >  
> > > now i can use english thank you very much!!
> > >  
> > > um.. but nothing's changed... with that {r} message at R Markdown.
> > >  
> > > There's no dataset.
> > >  
> > > i tried both .xls and .xlsx .
> > >  
> > >  
> > > Jihee
> > >  
> > >  
> > >  
> > > <fbe6254214d94e74b98569b08bb3bf07.png>
> > >  
> > >  
> > >  
> > > From: "Fox, John" <[hidden email]>
> > > Sent: Thursday, January 17, 2019 10:59:44 AM
> > > To:"우지희" <[hidden email]>
> > > Cc:"<[hidden email]>" <[hidden email]></[hidden email]>
> > > Subject:Re: [R] importing data error question
> > >  
> > >  
> > > Dear Jihee,
> > >
> > > Probably the easiest way to change the language to English temporarily in R is to enter the command
> > >
> > > Sys.setenv(LANGUAGE="en")
> > >
> > > at the R command prompt prior to loading the Rcmdr package.
> > >
> > > I hope that this helps,
> > > John
> > >
> > >
> > > > On Jan 16, 2019, at 7:02 PM, 우지희 <[hidden email]> wrote:
> > > >
> > > > 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.
> > > >  
> > > > Best,
> > > > Jihee
> > > >  
> > > > From: "Fox, John" <[hidden email]>
> > > > Sent: Thursday, January 17, 2019 1:59:03 AM
> > > > To:"우지희" <[hidden email]>
> > > > Cc:"[hidden email]" <[hidden email]>
> > > > 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 <[hidden email]> wrote:
> > > > >
> > > > > Dear jihee,
> > > > >
> > > > >> On Jan 14, 2019, at 9:00 PM, 우지희 <[hidden email]> 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" <[hidden email]>
> > > > >>
> > > > >> Sent: Monday, January 14, 2019 11:15:36 PM
> > > > >>
> > > > >> To:"우지희" <[hidden email]>
> > > > >>
> > > > >> Cc:"<[hidden email]>" <[hidden email]></[hidden email]>
> > > > >>
> > > > >> Subject:Re: [R] importing data error question
> > > > >>
> > > > >> Dear jihee,
> > > > >>
> > > > >>> On Jan 13, 2019, at 9:28 PM, 우지희 <[hidden email]> wrote:
> > > > >>>
> > > > >>>
> > > > >>>
> > > > >>> From: "우지희" <[hidden email]>
> > > > >>> Sent: Monday, January 14, 2019 9:40:26 AM
> > > > >>> To:"Fox, John" <[hidden email]>
> > > > >>> 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" <[hidden email]>
> > > > >>> Sent: Friday, January 11, 2019 10:48:38 PM
> > > > >>> To:"PIKAL Petr" <[hidden email]>
> > > > >>> Cc:"우지희" <[hidden email]>; "[hidden email]" <[hidden email]>
> > > > >>> 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 <[hidden email]> 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 <[hidden email]> On Behalf Of ???
> > > > >>>>> Sent: Friday, January 11, 2019 9:14 AM
> > > > >>>>> To: [hidden email]
> > > > >>>>> 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]]
> > > > >>>>>
> > > > >>>>> ______________________________________________
> > > > >>>>> [hidden email] 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/
> > > > >>>>
> > > > >>>> ______________________________________________
> > > > >>>> [hidden email] 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.
> > > > >>>
> > > > >>>
> > > > >>>
> > > > >>>
> > > > >>> 우지희 연구원 / 초콜릿개발팀
> > > > >>> [hidden email]
> > > > >>> 홈페이지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
> > > > >>>
> > > > >>>
> > > > >>>
> > > > >>>
> > > > >>> 우지희 연구원 / 초콜릿개발팀
> > > > >>> [hidden email]
> > > > >>> 홈페이지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]]
> > > > >>
> > > > >> ______________________________________________
> > > > >> [hidden email] 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.
> > > > >
> > > > > ______________________________________________
> > > > > [hidden email] 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-mail [hidden email] Dir Mobile
> > > > 홈페이지 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-mail [hidden email] Dir Mobile
> > > 홈페이지 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-mail [hidden email] Dir Mobile
> > 홈페이지 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
> > <mass2.xlsx>
>
>
>  
>
>
> 우지희 연구원 / 초콜릿개발팀
> e-mail [hidden email] Dir Mobile
> 홈페이지 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

______________________________________________
[hidden email] 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.
Reply | Threaded
Open this post in threaded view
|

Re: importing data error question

Fox, John
In reply to this post by Fox, John
Dear Jihee,

> -----Original Message-----
> From: R-help [mailto:[hidden email]] On Behalf Of ???
> Sent: Wednesday, January 16, 2019 7:02 PM
> To: Fox, John <[hidden email]>
> Cc: [hidden email]
> 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" <[hidden email]>
>
> Sent: Thursday, January 17, 2019 1:59:03 AM
>
> To:"우지희" <[hidden email]>
>
> Cc:"[hidden email]" <[hidden email]>
>
> 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 <[hidden email]> wrote:
>  >
>  > Dear jihee,
>  >
>  >> On Jan 14, 2019, at 9:00 PM, 우지희 <[hidden email]> 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" <[hidden email]>  >>  >> Sent: Monday, January 14,
> 2019 11:15:36 PM  >>  >> To:"우지희" <[hidden email]>  >>  >> Cc:"<r-
> [hidden email]>" <[hidden email]></[hidden email]>
>  >>
>  >> Subject:Re: [R] importing data error question  >>  >> Dear jihee,  >>  >>> On
> Jan 13, 2019, at 9:28 PM, 우지희 <[hidden email]> wrote:
>  >>>
>  >>>
>  >>>
>  >>> From: "우지희" <[hidden email]>
>  >>> Sent: Monday, January 14, 2019 9:40:26 AM  >>> To:"Fox, John"
> <[hidden email]>  >>> 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" <[hidden email]>  >>> Sent: Friday, January 11,
> 2019 10:48:38 PM  >>> To:"PIKAL Petr" <[hidden email]>  >>>
> Cc:"우지희" <[hidden email]>; "[hidden email]" <r-help@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 <[hidden email]> 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 <[hidden email]> On Behalf Of ???
>  >>>>> Sent: Friday, January 11, 2019 9:14 AM  >>>>> To: r-help@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]]  >>>>>  >>>>>
> ______________________________________________
>  >>>>> [hidden email] 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/
>  >>>>
>  >>>> ______________________________________________
>  >>>> [hidden email] 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.
>  >>>
>  >>>
>  >>>
>  >>>
>  >>> 우지희 연구원 / 초콜릿개발팀
>  >>> [hidden email]
>  >>> 홈페이지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  >>>  >>>  >>>  >>>  >>> 우지희 연구원 /
> 초콜릿개발팀  >>> [hidden email]  >>>
> 홈페이지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]]  >>  >>
> ______________________________________________
>  >> [hidden email] 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.
>  >
>  > ______________________________________________
>  > [hidden email] 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]]
>
> ______________________________________________
> [hidden email] 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.
______________________________________________
[hidden email] 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.