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

Designing an F# module to be called by C# (Console/MVC/WPF)

I have been trying to use Deedle F# Library to write an F# batch program. It has worked perfectly. However, I am not sure about the best design for the following 2 tasks: Combine the F# module into a existing ASP.net MVC/Web Api system Create a WPF…
casbby
  • 896
  • 7
  • 20
9
votes
2 answers

Why Frame.X static methods from Deedle are generating warnings in VS 2017?

I downloaded the new VS 2017 yesterday and it is working fine, except that I am getting this warning on every line where I call the static method Frame.ReadCsv from the Deedle package: FS10001 This method is not intended for use from F# Calls to…
Soldalma
  • 4,636
  • 3
  • 25
  • 38
6
votes
2 answers

F# Deedle accessing a row

this is a basic question but i could not find the simple answer reading the tutorial suppose i have this simple frame type Person = { Name:string; Age:int; Countries:string list; } let peopleRecds = [ { Name = "Joe"; Age = 51; Countries = […
Fagui Curtain
  • 1,867
  • 2
  • 19
  • 34
6
votes
1 answer

How to pass data from a FSharp.Data.CsvProvider to a Deedle.Frame?

I'm trying to pass data from a FSharp.Data.CsvProvider to a Deedle.Frame. I'm almost new in F#, and I need to convert some CSV files from culture "it-IT" to "en-US", so I can use the data. I found Deedle, and I want to learn how to use it, but I was…
Felice Bruno
  • 195
  • 1
  • 12
6
votes
1 answer

How to do a left join on a non unique column/index in Deedle

I am trying to do a left join between two data frames in Deedle. Examples of the two data frames are below: let workOrders = Frame.ofColumns [ "workOrderCode" =?> series [ (20050,20050); (20051,20051); (20060,20060) ] …
jeremyh
  • 612
  • 4
  • 14
5
votes
1 answer

How do I display a Deedle DataFrame as a nice table in FSI?

Reading the article Analyzing and Visualizing Data with F# (https://www.oreilly.com/ideas/analyzing-and-visualizing-data-with-f-sharp/page/2/analyzing-data-using-f-and-deedle) I gathered (perhaps incorrectly) that one could display the contents of a…
Soldalma
  • 4,636
  • 3
  • 25
  • 38
5
votes
1 answer

Deedle normalize frame

How to normalize data in deedle frame ? I've tried this approach but one doesn't work let iris = Frame.ReadCsv("./iris.csv") let keys = iris.ColumnKeys |> Seq.toArray let x = iris.Columns.[keys.[0..4]] let mu = x |> Stats.mean let std = x |>…
baio
  • 1,102
  • 2
  • 12
  • 20
5
votes
1 answer

Change column order in deedle frame

What is the best way to change column order in deedle frame? For example if I have a deedle frame df with columns height, Name, and phone, but I need it in order Name, phone, and height.
alexshchep
  • 268
  • 1
  • 15
5
votes
1 answer

F#: How to create a Deedle Frame with SQL data source

I am trying to figure what is the best way in F# to create a Deedle Frame, when the data comes from an SQL server. I have tried things like the following. #I "../packages/Deedle.0.9.12" #load "Deedle.fsx" #r "System.dll" #r "System.Data.dll" #r…
Stefan
  • 1,835
  • 13
  • 20
4
votes
1 answer

Count unique in a Deedle Series

I want to have an overview of a Series in my dataframe, something like pandas' unique values counting. I don't know if there's a built-in function for that. So far i've done a function to just get the numbers of different features. I could manage to…
Youness Kafia
  • 173
  • 1
  • 5
4
votes
1 answer

Deedle - Weighted Average after filtering FilterRowValues

I am new to F#. I am attempting to calculate a weighted average after filtering my Frame by two timestamps and an instrument_id. example data: | trade_qty | trade_price | trade_timestamp | instrument_id | 1000 | 100.59 | 1/26/2018…
whalekayo
  • 75
  • 6
4
votes
1 answer

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

here is a small example where I want to deal with missing values on custom functions on series. suppose that i have obtained a series series4;;  val it : Series =  1 -> 1  2 -> 2  3 -> 3  4 -> for…
Fagui Curtain
  • 1,867
  • 2
  • 19
  • 34
4
votes
1 answer

How do I elegantly manipulate this Deedle.Frame in F#

I have been struggling with F# and especially working with Deedle.Frame and Deedle.Series. I need to create two new columns with values that depend on the other columns. For some rows, I need to insert a new row. My current solution is very ugly,…
Pontus Hultkrantz
  • 461
  • 3
  • 9
4
votes
1 answer

Format built-in types for pretty printing in Deedle

I understand that in order to pretty print things like discriminated unions in Deedle, you have to override ToString(). But what about built in types, like float? Specifically, I want floats in one column to be displayed as percentages, or at the…
Rei Miyasaka
  • 7,007
  • 6
  • 42
  • 69
4
votes
2 answers

C# Convert between Deedle Frame and DataTable

I am a newbie to C#/F#. There are very limited online resources demonstrating Deedle in C#, but I do need to use C# to conduct data analysis. The sample data is Titanic.csv, from here:…
chl111
  • 468
  • 3
  • 14
1
2 3
…
18 19