How to convert Values from to type in a Deedle frame?

Question

I need to perform something like:

var myTotal = myFrame.Sum();

However, the values are string type and I get an error. How could I convert the values of the frame to a double type?

I'm using only 3 decimals "0.000", is there anything more practical than double that Deedle can handle?

Unlike forum sites, we don't use "Thanks", or "Any help appreciated", or signatures on [so]. See "[Should 'Hi', 'thanks,' taglines, and salutations be removed from posts?](http://meta.stackexchange.com/questions/2950/should-hi-thanks-taglines-and-salutations-be-removed-from-posts). BTW, it's "Thanks in advance", not "Thanks in advanced". — John Saunders, Jun 06 '15 at 23:20

Yuval Itzchakov · Answer 1 · 2015-06-02T10:54:34.140

0

How could I convert the values of the frame to a double type?

Assuming myFrame is some sort of a collection of strings which are parseable to double, you'll want to parse those strings first into doubles, and then invoke a sum:

var myTotal = myFrame.Sum(x => double.Parse(x));

edited Jun 02 '15 at 10:54

answered Jun 02 '15 at 10:52

Yuval Itzchakov

146,575
32
257
321

1

Short form: `var myTotal = myFrame.Sum(x => double.Parse(x));` – General-Doomer Jun 02 '15 at 10:53
@General-Doomer Definitely. Thanks for the heads up. – Yuval Itzchakov Jun 02 '15 at 10:54
myFrame is a Deedle data frame http://bluemountaincapital.github.io/Deedle/csharpframe.html – Jorge Thomas Jun 02 '15 at 12:01

score 0 · Answer 2 · answered Jun 02 '15 at 13:09

It is possible to build a Time Series with the Values as double, so:

var myTimeSeriesColumn = myFrame.GetColumn<double>("Column Title"); // Returns <series>

Then a new Frame can be created and later just add the columns:

myNewDoubleValuesFrame.AddColumn("my Column Title", myTimeSeriesColumn );

How to convert Values from to type in a Deedle frame?

2 Answers2