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. ![]()
First Post!
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
Popular in Questions
Other popular topics
Categories:
Sub Categories:
Forums
Popular Tags
- #ecto
- #liveview
- #troubleshooting
- #learning-elixir
- #deployment
- #library
- #erlang
- #testing
- #genserver
- #mix
- #absinthe
- #remote-other
- #otp
- #plug
- #how-to-question
- #macros
- #postgres
- #channels
- #elixirconf
- #exunit
- #discussion
- #code-sync
- #javascript
- #podcasts
- #onsite
- #dialyzer
- #docker
- #authentication
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #ecto-query
- #elixir-ls
- #phoenix_html
- #iex
- #blog-post
- #graphql
- #genstage
- #ai
- #websockets
- #supervisor
- #elixirconf-us
- #advent-of-code
- #distillery
- #processes
- #forms
- #api
- #metaprogramming
- #security
- #hex









