Can I Use List Values Or Datatable In R.Net

Question

0.00/5 (No votes)

See more:

Hi I am using R.Net Nuget package for R functionality in .Net.I can read csv files and save in dataframe and can do calculations.But I want to do calculations with data that I have already in a datatable or List(dotnet) without using csv.csv contains some rows and columns.I have same data in datatable.Now I want to use this datatable data in rengine to do calculation.Help me.Please go through the following code.

C#

DataTable blmValues = ReadFromCsv(fileName, separator);
            ds.Tables.Add(blmValues);
REngine.SetEnvironmentVariables();
            REngine engine = REngine.GetInstance();
            engine.Initialize();
            engine.Evaluate("library(quadprog)");
ataFrame dataset = engine.Evaluate("ds.DF").AsDataFrame();

Posted 12-Nov-14 0:14am

Aradhana Krishna

Add a Solution

Comments

BillWoodruff 12-Nov-14 7:17am

You are using R.Net, latest version ? In a Console App ?

Using which .NET Framework version ?

Aradhana Krishna 12-Nov-14 7:19am

Yes ..I am using latest version of R.Net .I am using windows Application..framework is 4.0

BillWoodruff 12-Nov-14 8:00am

In a Console Application, correct ?

Aradhana Krishna 12-Nov-14 8:02am

no...in a windows form application.In .cs

BillWoodruff 12-Nov-14 8:04am

I am puzzled by this: if you can read a .csv file and use its data, can't you use the same technique to read the data produced by some form of query (Linq) that transforms the data in the DataTable to a format like that of a .csv file ?

In other words, do you have a sense of what is holding you back right now in using the data in the DataTable ?

Aradhana Krishna 12-Nov-14 8:09am

Please check the following code.Actually I have some list of values.Leave about csv.Becuse I dont want to read csv.i have data in a list or datatable .But how to use that list in Rcode using Rengine?

REngine.SetEnvironmentVariables();
REngine engine = REngine.GetInstance();
engine.Initialize();
engine.Evaluate("library(quadprog)");

DataFrame dataset = engine.Evaluate("ds.DF").AsDataFrame();

engine.Evaluate(@"cov <- read.csv(""filename.csv"", header = TRUE, sep = ',')");
DataFrame cov = engine.GetSymbol("cov").AsDataFrame();

//engine.Evaluate("covm<-cbind(cov$AUS,cov$CAN,cov$FRA,cov$GER,+cov$JAP,cov$UK,cov$USA)");
var covm = engine.Evaluate("covm<-cbind(cov$AUS,cov$CAN,cov$FRA,cov$GER,+cov$JAP,cov$UK,cov$USA)").AsCharacter().ToArray();

//engine.Evaluate("print(covm)");

engine.Evaluate("mean_vect<-blm$equilibrium.expected.return");

engine.Evaluate("#muP<-seq(0.02,0.085,length=100)");

engine.Evaluate("Dmat<-2*covm");

engine.Evaluate("dvec<-(mean_vect)");

engine.Evaluate("Amat<-matrix(rep(1,nrow(covm)),nrow(covm))");

engine.Evaluate("bvec<-1");

//engine.Evaluate("result =solve.QP(Dmat,dvec,Amat=Amat,bvec=bvec,meq=1)");

var result = engine.Evaluate("result =solve.QP(Dmat,dvec,Amat=Amat,bvec=bvec,meq=1)").AsCharacter().ToArray();

//DataFrame result = engine.GetSymbol("result").AsDataFrame();

engine.Evaluate("print(result)");
//val = result[1, 5].ToString();
engine.Close();
engine.Dispose();

BillWoodruff 12-Nov-14 8:54am

For some reason I can't get the latest version of R.NET to work in a WinForms Project in VS 2013, using .NET FrameWork 4.0, and compiling to x64.

But, I note that this site seems to have an example where R is used with a DataSet:

http://psychwire.wordpress.com/2011/06/25/importing-and-displaying-a-data-frame-with-c-and-r-net/

Look like a lot of people have had problems getting R to work in various .NET versions .

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)