CODEWITHSUNDEEP
r
illbill
illbill

Reputation: 401

File too big to open in R?

Hi one additional question. I've managed to open my files from excel into R by converting them into text files. The problem is that they are very large files, pushing the limits of excel. I now get this error in R. Any idea how i can work around it?

[ reached getOption("max.print") -- omitted 463885 rows ]]

Upvotes: 2

Views: 4215

Answers (4)

NPE
NPE

Reputation: 500663

One useful trick is to run str(data), where data is the name of your variable. This will display the layout of the structure that's been loaded, including the number of rows. The latter will tell you if the entire file has been loaded.

Upvotes: 1

Tyler
Tyler

Reputation: 10032

If that's the error you're getting, I think your data loaded into R just fine, but R has a limit on how many rows of data it will print to the console. Which makes sense - you probably don't want to sift through a half-million rows on a text terminal.

You can check the actual size of your object with the dim() function, to see how many rows R thinks are there.

Upvotes: 1

Dirk is no longer here
Dirk is no longer here

Reputation: 368399

Benjamin is spot on: Warning != error. Try 

 summary(myDataVar)

 dim(myDataVar)

 str(myDataVar)

for more.

Upvotes: 2

Benjamin
Benjamin

Reputation: 11860

That is just a warning telling you that not all the data was displayed. It's still probably loading. You get the same when trying to display large matrices or data frames. For example you will get the same warning if you try matrix(nrow=10000000)

Upvotes: 4

Related Questions