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
4
votes
3 answers

Map over values of one column

I want to map over the values of the Title column of my dataframe. The solution I came up with is the following: df.Columns.[ [ "Title"; "Amount" ] ] |> Frame.mapCols(fun k s -> if k = "Title" then s |> Series.mapValues (string >>…
Kimserey
  • 73
  • 1
  • 5
4
votes
1 answer

F# deedle how to convert frame to list of tuples

say I have a Frame of the following, type Person = { Name:string; Age:int; Comp1:float; Comp2:float } let peopleRecds = [ { Name = "Joe"; Age = 51; Comp1=12.1; Comp2 =20.3 } { Name = "Tomas"; Age = 28; Comp1=1.1; Comp2 =29.3 } …
tesla1060
  • 2,621
  • 6
  • 31
  • 43
4
votes
1 answer

How to merge data frames in deedle with overlapping rows?

What is the best way to merge two deedle frames that have overlapping rows? I would like to keep the rows unique, though. As far as I understand, merge() does not allow overlapping rows.
alexshchep
  • 268
  • 1
  • 15
4
votes
1 answer

Duplicate Key in index of Deedle Series

I have a list of events that occur in a system. My goal is to take the list of events and create a sliding window of the series to determine rate event occurrences. The events are loaded into the events list from an application outside of this scope…
Elan Hasson
  • 1,214
  • 1
  • 19
  • 29
4
votes
2 answers

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

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…
Jorge Thomas
  • 127
  • 5
4
votes
1 answer

Deedle: grouping time series in top 3 and rest

I have a Deedle series with election data like: "Party A", 304 "Party B", 25 "Party C", 570 .... "Party Y", 2 "Party Z", 258 I'd like to create a new series like this: "Party C", 570 "Party A", 304 "Party Z", 258 …
forki23
  • 2,784
  • 1
  • 28
  • 42
4
votes
1 answer

Is there an easy way to apply a mass transformation to a Deedle frame?

I have a Deedle frame in fsharp with 45 columns where every column contains floats. I'd like to create a new frame by applying a transformation to every entry in the original frame. The transformation is simple function as follows: let…
Vijesh
  • 251
  • 2
  • 8
4
votes
1 answer

Deedle - create empty list and series

I am new to F#, looking at it as an alternative to Matlab. In reference to this question, how can I create an empty Serie and an empty Frame. If I did not just miss it, why an empty Serie or Frame has not been designed in the library, something…
NoIdeaHowToFixThis
  • 4,484
  • 2
  • 34
  • 69
3
votes
1 answer

Rearrange rows and columns in Deedle

I have a table like Month Cluster Year ActualAmount TargetedAmount 1 1 2015 100 200 1 1 2016 300 400 1 1 2017 300 400 2 1 2015 500 …
jim108dev
  • 101
  • 1
  • 6
3
votes
1 answer

C# Create Deedle DataFrame from JSON response

I'm having a bit of trouble loading a JSON response from this request into a Deedle DataFrame:https://sampleserver6.arcgisonline.com/arcgis/rest/services/Earthquakes_Since1970/FeatureServer/0/query?where=OBJECTID%3C10&returnGeometry=false&f=json In…
TapeHead
  • 120
  • 7
3
votes
1 answer

F#, Deddle and R.Net: seq<'a> [] vs. IEnumerable array

I’m trying to convert a Deedle Frame into an R DataFrame using R.Net. I tried 3 different approaches: open RDotNet REngine.SetEnvironmentVariables(@"C:\Program Files\R\R-3.6.3\bin\x64",@"C:\Program Files\R\R-3.6.3") let engine =…
FRocha
  • 942
  • 7
  • 11
3
votes
6 answers

Concatenating two string columns using Deedle in C#

The function add_ints correctly adds two integer columns A,B 2,3 5,7 9,11 in a CSV file. Why does the function add_strings not correctly concatenate two string columns L,R "a","b" "c","d" "e","f" into a third…
Vrokipal
  • 784
  • 5
  • 18
3
votes
1 answer

Speed issue: Creating Series with Deedle/Getting unique values in F#

I have used the solution suggested by Tomas Petricek in this question: Count unique in a Deedle Series I have done a quick test python python and the solution above. I have slightly modified the function suggested by Tomas to sort the counts in the…
Jeff_hk
  • 421
  • 3
  • 12
3
votes
1 answer

Is it correct that Deedle/Series is slow compared to a list?

I am working on a data "intensive" app and I am not sure if I should use Series./DataFrame. It seems very interesting but it looks also way slower than the equivalent done with a List ... but I may not use the Series properly when I filter. Please…
Jeff_hk
  • 421
  • 3
  • 12
3
votes
0 answers

Calculation performance of Deedle Frame significantly slower than that of Series?

I am currently evaluating Deedle for my project, and regarding that I have done some rudimentary performance tests. I have attached the code I used to do this. Basically it's doing two operations: generate two 1000x10 data frames and multiplying…
Pyry
  • 31
  • 2
1
2
3
…
18 19