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
3
votes
1 answer

Changing data type in a Deedle Frame

I imported some data in a Deedle Frame, and I'm trying to convert values type in integer type. I used the following code: let myFrmK01 = Frame.ReadCsv(@"QuandlDataSample.csv", hasHeaders=true) let myFrmK02 = myFrmK01 |>…
Felice Bruno
  • 195
  • 1
  • 12
3
votes
1 answer

How do I convert missing values into strings?

I have a Deedle DataFrame of type Frame that contains some missing values. I would like to convert the missing values into empty strings "". I tried to use the valueOr function but that did not help. Is there a way to do this? Here is my…
Soldalma
  • 4,636
  • 3
  • 25
  • 38
3
votes
1 answer

Working with missing values in Deedle Time Series in F# (3)

This is another follow-up to Working with missing values in Deedle Time Series in F# (2) I have written this function to map2 series, returning a missing value when either input is missing. let map2series (f:'T1->'T2->'R)(series1:Series<'K,'T1…
Fagui Curtain
  • 1,867
  • 2
  • 19
  • 34
3
votes
1 answer

Deedle Equivalent to pandas.merge

I am looking to merge two Deedle (F#) frames based on a specific column in each frame in a similar manner as pandas.DataFrame.Merge.The perfect example of this would be a primary frame that contains columns of data and a (city, state) column along…
Darien Shannon
  • 167
  • 10
3
votes
2 answers

Considerations for time-series

We are looking into using Azure Table Storage (ATS) together with Deedle (or other libraries with similar functionality) for our time-series storage, manipulations and calculations. From what I can read, F# also seems like a good choice for…
Pal-B
  • 139
  • 1
  • 7
3
votes
1 answer

Is there a bug in Series.hasNot?

The help for function Series.hasNot in Deedle says: Returns true when the series does not contains value for the specified key The function does not seem to be working this way in the following example: let election = [ "Party A", 304 …
Soldalma
  • 4,636
  • 3
  • 25
  • 38
3
votes
1 answer

Why does Frame.tryValues fail in this simple example?

The help for Frame.tryValues has the following: "Given a data frame containing columns of type tryval<'T>, returns a new data frame that contains the underlying values of type 'T." I interpreted this as meaning that the function would strip the type…
Soldalma
  • 4,636
  • 3
  • 25
  • 38
3
votes
1 answer

Is there a bug in Frame.denseCols?

The Visual Studio 2017 Quick Info tooltip for Frame.denseCols says "it skips columns that contain missing value in any row." The following example seems to suggest otherwise: let dateRange (first:System.DateTime) count frac = seq {for i in…
Soldalma
  • 4,636
  • 3
  • 25
  • 38
3
votes
1 answer

How to index a Deedle Frame with Excel's dates as keys?

Say I'm given a column "Date" with values that look like: 03/10/86, 06/10/86, 07/10/86, etc... It is not as simple as doing Frame.indexRowsDate("Date"). My current solution is to create on the Excel 3 extra columns: Year Month Day with…
Lay González
  • 2,901
  • 21
  • 41
3
votes
3 answers

F#: How to run fillMissing on only some specific columns of a Deedle data frame

After an outer join of two data frames, I have the resulting data frame f that now contains columns A, B, C and D that all have missing values in them. I would like to fill in the missing values using fillMissing, but only for columns C and D.
mt99
  • 589
  • 3
  • 13
3
votes
1 answer

A straightforward functional way to rename columns of a Deedle data frame

Is there a concise functional way to rename columns of a Deedle data frame f? f.RenameColumns(...) is usable, but mutates the data frame it is applied to, so it's a bit of a pain to make the renaming operation idempotent. I have something like…
mt99
  • 589
  • 3
  • 13
3
votes
1 answer

Pretty Printing in Deedle Data Frame

I was wondering if there is a simple way to add pretty printing to a custom type used in a Deedle data frame. In the following example: open Deedle type PrimaryContactInfo = | Default of int | NonDefault of int | Missing type Account…
jeremyh
  • 612
  • 4
  • 14
3
votes
2 answers

F# deedle cast column datatype

I have load a csv file to a Frame, deedle automatically infers that one column as decimal, whichi in fact should be int. I have use the following line to do the casting into the correct type, df?ColumnName <- df.GetColumn("ColumnName") I am…
tesla1060
  • 2,621
  • 6
  • 31
  • 43
3
votes
2 answers

F# read zipped csv file

is that possible to use F# deedle to read zipped csv directly like the read_csv function in pandas? if this is not possible, is that possible to use csv type provider to do this ?
tesla1060
  • 2,621
  • 6
  • 31
  • 43
3
votes
1 answer

Deedle frame save to csv file in millisecond

I am trying to save a Deedle frame which contains a DateTime column to csv file. But in CSV file, the DateTime column does not contain the milisecond. I would like to save it with milisecond in format [yyyy-mm-dd hh:mm:ss.000]. I tried converting…
hoan hoang
  • 33
  • 4
1 2
3
…
18 19