when to export a numbers file to csv the minus signs don't work with R

Friends,

I have trouble getting the statistic program R to read my exported CSV-files from Numbers.

The minus sign doesn't work, R reads it as a factoric input rather than numeric.

Does anyone have a tip how to reformat this?



Jocke

OS X Mavericks (10.9.2)

Posted on Apr 11, 2014 9:58 AM

Reply
4 replies

Apr 11, 2014 11:26 PM in response to Yellowbox

Thanks, well we solved the prblem but in a lillte bit of an awkward way.

The problem is that the minus sugns in numbers is percieved as dashes in R

(http://www.R-project.org, a free-ware statistical analysis program, as an implementation of S programming language )


So where there is a numeric input with a minus sign R thinks it is a letter rather than a number.


We solved it by exporting the numbers file to CSV, opened it in text editor, copied the suspisios minus sign and pasted it into the search field to find all dashes/minus sign that didn't work and replaced them with a minus sign. After this operation, nothing different could be seen in the text but R saw the difference.

So this makes it difficult to explain by posting a screenshot - it looks the same but it isn't.


The funny thing is that the dashes that numbers use when to express a date are percieved as minus signs by R. And there is obiously a difference also in the text files as the dashes can be replaced by minus signs.


Can anyone understand what I just tried to explain? And if so, is there a simpler way to do this? We have a lot of minus signs to export to R..... Or could one hope for an update where this is solved by Apple?


best regard


Joachim

Apr 11, 2014 11:18 PM in response to Wayne Contello

Wayne, actually, I'm not sure but I think that factoric - or factorial is the denomination that R uses to say that somthing is rather a text than a numeric number - I'm pretty new to R.


But, anyway, we solved the problem but in a lillte bit of an awkward way.

The problem is that the minus sugns in numbers is percieved as dashes in R

(http://www.R-project.org, a free-ware statistical analysis program)


So where there is a numeric input with a minus sign R thinks it is a letter rather than a number.


We solved it by exporting the numbers file to CSV, opened it in text editor, copied the suspisios minus sign and pasted it into the search field to find all dashes/minus sign that didn't work and replaced them with a minus sign. After this operation, nothing different could be seen in the text but R saw the difference.

So this makes it difficult to explain by posting a screenshot - it looks the same but it isn't.


The funny thing is that the dashes that numbers use when to express a date are percieved as minus signs by R.


Can anyone understand what I tried to explain? And if so, is there a simpler way to do this? We have a lot of minus signs to export to R.....


best regard


Joachim

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

when to export a numbers file to csv the minus signs don't work with R

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.