Query Revolution R Enterprise (How to read a csv file; convert to xdf format; and load in Rev-R-Ent)

[Amit]

Hi,

I am trying to open a large CSV file. 13GB. It is dataset from kaggle competition. 

R is not able to open it, so I turned towards Revolution r enterprise. Can you please help as to how can I read a CSV file on my system and can convert it into xdf format and load in Revolution R enterprise to run further analysis. 

My file path is "C:\Users\admin\Desktop\Kaggle\dog_1_both_marked.csv"

I tried something like this but got error.

sampleDataDir <- rxGetOption("Kaggle")

inputFile <- file.path("C:\Users\admin\Desktop\Kaggle\dog_1_both_marked.csv", "dog_1_both_marked.csv")

outputFile <- file.path(tempdir(), "basicClaims.xdf")

rxTextToXdf(inFile = inputFile, outFile = outputFile, overwrite = TRUE)

rxGetInfo(data = outputFile, getVarInfo = TRUE, numRows = 100000)

file.remove(outputFile)

Thanks,

Amit

[David Smith]

Hi Amit,

This is a good question to ask at the Revolution R Enterprise RevoScaleR forums at 

https://revolutionanalytics.zendesk.com/forums/22705538-RevoScaleR

Kind regards,
# David Smith

-- 

David M Smith <da...@revolutionanalytics.com>
Chief Community Officer, Revolution Analytics  http://blog.revolutionanalytics.com
Tel: +1 (650) 646-9523 (Chicago IL, USA)

Twitter: @revodavid

--
You received this message because you are subscribed to the Google Groups "Revolution R Open" group.
To unsubscribe from this group and stop receiving emails from it, send an email to rropen+un...@googlegroups.com.
To post to this group, send email to rro...@googlegroups.com.
Visit this group at http://groups.google.com/group/rropen.
To view this discussion on the web visit https://groups.google.com/d/msgid/rropen/771069c7-45bf-4768-8bf4-42fbd7c433e3%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Revolution R Plus

Subscribe to Technical Support & Indemnification for R

[Amit]

Okay, I will do that, Thank you David.