Stack Overflow
Stack Overflow

Questions tagged [deedle]

Deedle is an easy to use library for data and time series manipulation. It supports working with data frames, ordered and unordered data, as well as time series. Deedle works well for exploratory programming using F#, but can be also used in efficient compiled .NET code.

Deedle is an easy to use library for data and time series manipulation and for scientific programming. It supports working with structured data frames, ordered and unordered data, as well as time series. Deedle is designed to work well for exploratory programming using F# and C# interactive console, but can be also used in efficient compiled .NET code.

The library implements a wide range of operations for data manipulation including advanced indexing and slicing, joining and aligning data, handling of missing values, grouping and aggregation, statistics and more.

For more information see:

The following tutorial is a good starting point:

274 questions
0
votes
1 answer

Deedle series index out of range

Hi I'm using the following code: let timeser = ser |> Series.sampleTimeInto(TimeSpan(0,5,0)) Direction.Backward Series.lastValue However often get the following error; System.IndexOutOfRangeException with the Additional information: Index was…
user3623025
  • 101
  • 6
0
votes
0 answers

Deedle 1.0.7 Frame row indexing doesn't enforce unique key

Since Deedle 1.0.7 release the index row function no longer validate whether the column being used as the key contain unique value. This behaviour is different what the comments suggest. How can I ensure only unique value can be used as the column…
casbby
  • 896
  • 7
  • 20
0
votes
1 answer

Resample time serie with Deedle

I want to resample a TimeSerie to a greater time granularity. I'm not sure which is the best way in Deedle to do so under the condition below. Let's assume I've a daily time serie from 2014-03-15 to 2014-09-15 generated as follows: var startDate =…
Andrea Cuneo
  • 69
  • 1
  • 9
0
votes
0 answers

Using Deedle with .NET 4.0

Is it possible to use Deedle if I'm stuck with .NET 4.0, VS 2010 and Windows 7? Currently it's complaing that I need FSharp.Core 4.3, but I only have 4.0 available. Maybe an older version of Deedle somewhere? I have to replace some scripts that use…
Blutkoete
  • 408
  • 3
  • 12
0
votes
1 answer

F# Live Charting Parallel

I am learning to use F# Live Charting and having difficulty making the code go parallel. I have this code which I wrote with help from some examples from some google searches. module liveChartData = let SampledData (tuple) (t:int) = let…
ll_jack
  • 1
  • 4
0
votes
2 answers

Immutible or not? Deedle frame filtering

this question might look a little trivial, it does happen in our process as the data is not clean. I have a data frame looks like let tt = Series.ofObservations[ 1=>10.0; 3=>20.0;5=> 30.0; 6=> 40.0; ] let tt2 = Series.ofObservations[1=> Double.NaN;…
casbby
  • 896
  • 7
  • 20
0
votes
1 answer

Deedle OptionalValue.Missing can't be dropped by Series.dropmissing

this is the code example from http://bluemountaincapital.github.io/Deedle/reference/deedle-seriesmodule.html let s1 = series [ 1 => 1.0; 2 => Double.NaN ] s1 |> Series.dropMissing the Missing value will be dropped as expected. however if I change…
casbby
  • 896
  • 7
  • 20
0
votes
1 answer

calculate timespan from two frame columns

I have a deedle frame with two columns containing DateTime timestamps. I would like to calculate the difference (timaspan) between the two type Test = { id : int; start : DateTime; finish : DateTime } let testData = [ {id = 1;…
NoIdeaHowToFixThis
  • 4,484
  • 2
  • 34
  • 69
0
votes
1 answer

C# Deedle equivalent to pandas df.drop_duplicates?

In Python pandas, I can easily drop duplicates in a DataFrame with: df1.drop_duplicates(['Service Date', 'Customer Number'], inplace=True) Is there anything in C# or Deedle that's this simple and fast? Or do I need to iterate over the entire frame…
user3478193
  • 57
  • 1
  • 8
0
votes
1 answer

error in installing Deedle.Rplugin

Hi I had an error when I tried to install Deedle.Rplugin PM> Install-Package Deedle.Rplugin Attempting to resolve dependency 'Deedle (≥ 0.9.12)'. Attempting to resolve dependency 'FSharp.Data (≥ 1.1.10)'. Attempting to resolve dependency 'RProvider…
uday
  • 6,453
  • 13
  • 56
  • 94
0
votes
1 answer

Deedle - how to select rows by slicing?

I want to select some rows based on multiple rows' value comparisons. say the data frame (df) is like: one two three four a 0 1 2 3 b 4 5 6 7 c 8 9 10 11 d 12 13 14 15 I want to get the rows where col["two"] >= 5…
Daniel Wang
  • 113
  • 1
  • 8
0
votes
1 answer

Extract row from Deedle and convert to Matrix

I am trying to extract a row from a Deedle Frame and convert it to a flat (1x4) DenseMatrix. All missing values have been dropped and the values in the Frame are numerical. My code: let matrix = let curr = seq { yield…
NoIdeaHowToFixThis
  • 4,484
  • 2
  • 34
  • 69
-1
votes
1 answer

Filter rows by DateTime which is unindexable

I have workout log data in the CSV format of shape: Just to give a little context on the data, the rows are not indexable by Date because the date column contains duplicates for each named workout. What I'm trying to do is to filter rows from the…
Vocaloidas
  • 360
  • 2
  • 17
-1
votes
1 answer

What using statements are needed to use Deedle in C#? "Could not load type 'Deedle.Frame'" exception

2nd Edit: I have found a MS log viewer, which does not enlighten me. Here is what it shows: *** Assembly Binder Log Entry (10/15/2020 @ 4:09:38 PM) *** The operation failed. Bind result: hr = 0x80070002. The system cannot find the file…
user2983936
  • 25
  • 5
-1
votes
1 answer

How to compute cumulative product (or sum) of a Series in Deedle (ideally in c# rather than F#)?

How to compute the cumulative product (or sum) of a Series in Deedle (ideally in c# rather than F#)? Anything smart with Windowing / Aggregation? Just a reference, i want to code using deedle the equivalent of this line of code in…
lampalork
  • 40
  • 4
1 2 3
…
18
19