[R] Large data set
Hi all, Have a problem. Trying to read in a data set that has about 112,000,000 rows and 8 columns and obviously enough it was too big for R to handle. The columns are mode up of 2 integer columns and 6 logical columns. The text file is about 4.2 Gb in size. Also I have 4 Gb of RAM and 218 Gb of available space on the hard drive. I tried the dumpDF function but it was too big. Also tried bring in the data is 10 sets of about 12,000,000. Are there are other ways of getting around the size of the data. Regards, Lorcan [[alternative HTML version deleted]] __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
[R] Network help
Dear Sir/ Madam, I was wondering if someone could help me. I am trying to calculate closeness centrality in R with a toy example: ida,idb 1,2 1,5 2,4 3,2 6,1 2,6 7,2 d- read.table(D:/data test/snatest.txt, header=F, sep=,) attach(d) d e-network(d,directed=F,bipartite=7) plot(e) d-as.matrix(d,colnames=F) l-graph.edgelist(d) summary(l) g - graph(d,n=7) summary(g) closeness(g) The problem is whenever I look at the summary for l it says I have 8 vertices even though there should be only 7? Is it my code or am I using the wrong function. Kind Regards, Lorcan Treanor [[alternative HTML version deleted]] __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
[R] RODBC tables
Dear Sir/Madam, I am desperately in need of some help. I am trying to access tables from the oracle database and inserting them into R via a data frame and I keep getting an error saying that Error in .Call(C_RODBCFetchRows, attr(channel, handle_ptr), max, buffsize, : negative length vectors are not allowed. My connection is fine and my code for this is: check-odbcConnect(dsn=,uid=*,pwd=**) There are terms instead of the *'s but I am not sure if I should disclose them because this is work-related. I have looked all over the internet and tried hundreds of solutions but have had no luck. These are the code I tried to use to get the table i called ANYTHING into R for which the negative length vectors errors came up. sqlTables(check,schema=**) nowfetchmewillwheaton-sqlFetch(check,ANYTHING) Do the errors imply that my connection is wrong, my code is wrong or that the table is not in the correct place in oracle. Please let me know if you can help or if you can give me the email address of someone who can. Kind Regards, Lorcan Treanor [[alternative HTML version deleted]] __ R-help@r-project.org mailing list 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.