Plotting data of deedle data frame with Xplot plotly

Question

I have a Deedle data frame with DateTime values as key and two columns with data. Now I want to plot the data of column 1 with a Scatter chart from Plotly.

I am using FSLab and there is XPlot.Plotly 1.3.1 included.

But I can't use Plotly:

open XPlot.Plotly.Graph
open XPlot.Plotly
open XPlot.Plotly.HTML

let dataFrame = ...

Scatter(
  x = dataFrame.ColumnKeys,
  y = dataFrame.GetColumn("col1")
)
|> Chart.Plot
|> Chart.Show

I'm getting this error: "The field, constructor or member 'Plot' is not defined.

Do I am missing something?

Well, it's a bit drastic but you can just replace the dll in Fslab's xplotly directory with the 1.4.2 version. Then it works. I haven't edited the other scripts. — s952163
– s952163, Commented Oct 11, 2016 at 3:59

s952163 · Accepted Answer · 2016-10-11 04:14:28Z

1

Not sure what is the latest version of XPlot but I get 1.4.2 in nuget. So, to make things simple I avoided all the FSLab magic this time:

//#load @"..\..\FSLAB\packages\FsLab\FsLab.fsx"
#r @"..\packages\XPlot.Plotly.1.4.2\lib\net45\XPlot.Plotly.dll"
#r @"..\packages\Newtonsoft.Json.9.0.1\lib\net45\Newtonsoft.Json.dll"
open XPlot.Plotly
open XPlot.Plotly.Graph

let layout = Layout(title = "Basic Bar Chart")

["giraffes", 20; "orangutans", 14; "monkeys", 23]
|> Chart.Bar
|> Chart.WithLayout layout
|> Chart.WithHeight 500
|> Chart.WithWidth 700
|> Chart.Show


let lineTrace1 =
    Scatter(
        x = [1; 2; 3; 4],
        y = [10; 15; 13; 17],
        mode = "markers"
    )

lineTrace1 |> Chart.Plot   |> Chart.Show

Now, this will plot the charts in the browser. I believe you can bind it to WPF or winforms as well.

Edit

As this works for you, but you still need FSLab, the easy way out is to replace the XPlot.Plotly.dll and xml file in ...\FSLAB\packages\XPlot.Plotly\lib\net45.

Then you can call XPlot.Plotly without the need of referencing directly the dll.

#load @"..\..\FSLAB\packages\FsLab\FsLab.fsx"
open XPlot.Plotly
open XPlot.Plotly.Graph
open XPlot.Plotly.Html

let layout = Layout(title = "Basic Bar Chart")
["giraffes", 20; "orangutans", 14; "monkeys", 23]
|> Chart.Bar
|> Chart.WithLayout layout
|> Chart.WithHeight 500
|> Chart.WithWidth 700
|> Chart.Show

edited Oct 11, 2016 at 4:14

answered Oct 11, 2016 at 3:26

s952163

6,3224 gold badges26 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

CPA Over a year ago

I tried it as well and it is working with the latest version of XPlot library. But if I don't use the Fslab script, I get a lot of other errors. For example then I have to reference a lot of system packages (like System.Runtime) for my own. And I don't know why, because in the Fslab script there isn't any reference to these dlls.

s952163 Over a year ago

@cpa those error are probably coming from other things you might be using from FSLab, like Deedle. Maybe this means that there is some incompatibility between Xplotly and FSLab. Do you need to use Plotly? Googlecharts in Xplot worked when I checked (from the FSLAB script).

Collectives™ on Stack Overflow

Plotting data of deedle data frame with Xplot plotly

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related