sehHeiden

sehHeiden

Plot with two DataFrames

I am searching for version to plot two dataframes with the same colon name into a layer each. I tried it in VegLite Json:

{
  "$schema": "https://vega.github.io/schema/vega-lite/v5.json",
  "data": {
    "values": [
      {"x": 1, "y": 10},
      {"x": 2, "y": 20},
      {"x": 3, "y": 15}
    ],
    "name": "data1"
  },
  "layer": [
    {
      "data": {
        "values": [
          {"x": 2, "y": 30},
          {"x": 3, "y": 25},
          {"x": 4, "y": 35}
        ],
        "name": "data2"
      },
      "mark": "line",
      "encoding": {
        "x": {"field": "x", "type": "quantitative"},
        "y": {"field": "y", "type": "quantitative"},
        "color": {"value": "blue"}
      }
    },
    {
      "data": {"name": "data1"},
      "mark": "line",
      "transform": [
        {"filter": {"field": "x", "range": [2, 3]}}
      ],
      "encoding": {
        "x": {"field": "x", "type": "quantitative"},
        "y": {"field": "y", "type": "quantitative"},
        "color": {"value": "red"}
      }
    }
  ],
  "resolve": {
    "scale": {
      "x": "shared",
      "y": "independent"
    }
  }
}

What I came up with in Elixir draws the seconds DataFrame so that, it is WWWWAY to high over the correct place and the y range is evenly wrongly scaled:

  def create_compare_graph(data_a, data_b, title, col) do
    Vl.new(width: 500, height: 300, title: title)
    |> Vl.data_from_values(data_a, 
                          only: ["day", col])
    |> Vl.layers([
      Vl.new()
      |> Vl.mark(:line, color: "blue")
      |> Vl.encode_field(:x, "day",
                         type: :quantitative,
                         title: "Day of the year"
        )
      |> Vl.encode_field(:y, col, 
                        type: :quantitative,
                        scale: [domain: [0, 1]], 
                        title: "DF1"),
      Vl.new()
      |>Vl.data_from_values(data_b,
                            only: ["day", col])
      |> Vl.mark(:line, color: "red")
      |> Vl.encode_field(:x, "day", 
                         type: :quantitative, 
                         title: "Day of the year")
      |> Vl.encode_field(:y, party,
                         type: :quantitative,
                         scale: [domain: [0, 1]],
                         title: "DF2")
    ])
    |> Vl.resolve(:scale, y: :independent)
  end
end

Example Data:

DF1:
day value
| 250 | 0.125
| 251 | 0.13
| 252 | 0.13
| 256 | 0.14
| 257 | 0.14

DF2:
day value
| 250 | 0.36
| 251 | 0.36
| 252 | 0.36
| 256 | 0.36
| 257 | 0.36

If possible I would prefer to do it, in Tucan as the code locks much cleaner with it. :wink:

First Post!

sehHeiden

sehHeiden

A reply to myself.
VegaLite-datasets_from_values allows several sources.
I tried to apply it with:

def create_compare_graph(data_a, data_b, title, col) do
    Vl.new(width: 500, height: 300, title: title)
    |> Vl.data_from_values(a: data_a, 
                           b: data_b,
                           only: ["day", party])
    |> Vl.layers([
      Vl.new()
      |> Vl.data(name: "a")
      |> Vl.mark(:line, color: "blue")
      |> Vl.encode_field(:x, "day",
                         type: :quantitative,
                         title: "Day of the year"
        )
      |> Vl.encode_field(:y, party, 
                        type: :quantitative,
                        scale: [domain: [0, 1]], 
                        title: "Sentiment"),
      Vl.new()
      |> Vl.data(name: "b")
      |> Vl.mark(:line, color: "red")
      |> Vl.encode_field(:x, "day", 
                         type: :quantitative, 
                         title: "Day of the year")
      |> Vl.encode_field(:y, party,
                         type: :quantitative,
                         scale: [domain: [0, 1]],
                         title: "Polls")
    ])
    |> Vl.resolve(:scale, y: :independent)
  end
end

Error:

expected valid tabular data, but got ... (*Desribes the dataframe*)

Edited: the error Because chcnage Vl.Data → Vl.data

Last Post!

sehHeiden

sehHeiden

Solved it somewhat with Annotate.

Where Next?

Popular in Questions Top

JeremM34
Hello, how can I check the Phoenix version ? Thanks !
New
Emily
I have VueJS GUIs with the project generated using Webpack. I have Elixir modules that will need to be used by the VueJS GUIs. I forese...
New
lastday4you
I wanted to check elixir version in phoenix because i found that my elixir is 1.5 but when i use Enum.chunk_by it said the function is un...
New
sen
Hi All, I set a environment variables in dev.exs , like below code. when i start server, how can i set the ${enable} value? thanks. d...
New
siddhant3030
Hi, I have to write a raw query for one of my project. But till now I have used ecto queries and don’t have much experience writing raw ...
New
marius95
Hello everyone, I try to use an Javascript Event Handler in my root.html.leex file. Therefore I created a function in the app.js file: ...
New
svb
Hi! Currently I want to submit a form by pressing the Enter key. However, since my input field is of type “textarea” this is just adds a...
New

Other popular topics Top

Qqwy
Update: How to use the Blogs & Podcasts section You can post links to your blog posts or podcasts either in one of the Official Blog...
3271 130286 1222
New
KronicDeth
Elixir plugin for JetBrain’s IntelliJ Platform (including Rubymine) This is a plugin that adds support for Elixir to JetBrains IntelliJ...
289 36654 110
New
Darmani72
If I have a post route which an argument: post /my_post_route/:my_param1, MyController.my_post_handler How would get the post params ...
New
joeerl
Hello again - after a longish gap I’ve decided I really must dig into Elixir and see what’s been happening here - so I have a few questio...
New
dogweather
I wrote this comment on r/haskell, and it’s not popular there. :wink: But I think I’m on to something… Haskell reminds me of Java, and e...
New
Patoshizzle
After calling mix ecto.create I get this error: 17:00:32.162 [error] GenServer #PID<0.412.0> terminating ** (Postgrex.Error) FATAL...
New

We're in Beta

About us Mission Statement