vega-lite：跳过无效的值，而不是将其视为0的总和

Question

当在列上进行汇总总和并使用Vega-Lite对其进行绘制时，是否可以跳过无效的值，而不是在加法时将其视为0？当缺少/无效的数据时，我想显示它，而不是0

。 N4IgJAzgxgFgpgWwIYgFwhgF0wBwqgegIDc4BzJAOjIEtMYBXAI0poHsDp5kTykBaADZ04JAKyUAVhDYA7EABoQAEzjQATjRyZ289AHE2bMoLgByCAAIImNlADWlnJqhxLbUuss6EcSopUkTBRUUGIkQQY1NABtUGUguDQQACYABhSU-jSARn50gLJkpBwcUwgAgA9kgDkkGoCAT1r6kABfBXjE5PTM7LyCpSL0NnUkWTJopWr0HLSmnvmOrswk9F6s3PycwuTR8cmK6eSAZnmlZvQ6huXA1cW+rZSdoeSyMZwpkBmQABZzkCXVJLTp3NbAx4DFK7dAlMpfH7XBazEErcEbfr5aGvdDvEoI5JzZEgJFtAC6HRAmDGsggADNRghYqAoBEoAxBN10DgkOoIHAAGKCNhBAAUCUwDAQMTMlTMZIAlAEkBV0NVbqzBOzOfdubz+UKRZhxUEpTLGvKlUoVclmrckGR3nxdXEQGwcMkIFKAnSaHBBMpktVrarvu1Qe7Pd6lL7-YH0M0Q7b2mShuo2AwcExLjEwSAKaCGQHYmGLvmNWyOVyQJI2DRZKKYhKpZR7HBGqnLGYAPpmK0gG3ofmaaLkpRwWRQNjKevDUAzUCx4voCVJJSYRqfZKrBA4faCdqUzmNODqZkgCdTmcTNCgS6Lv3LkDhSJrqmb8EARwY4x0wR0pDhiAU7CmeoQgEu8YgMOfpHO+W7oLIbAIPWESHkoyDqPYyTCLISS3Je06zregIkZByQvlEAQbghIDfr+dBBDQgGUiBoxkY+UEwV8NHgkhKGyGhbSUph2HgbxyR7vWmDUUYgg6B64FTrIqwqckhHXkUwnkm0QA" rel="nofollow noreferrer">graph is what I expect when aggregating on date to get the sums for x 和 y 。

而在此example, the y两个行的值 date = 2022-01-20 是NAN，所以我希望没有数据点 y 并将其显示为缺失数据，而不是为0。

有没有办法做到这一点？我仔细研究了文档，但可能错过了一些东西。 I've tried using filter

我正在思考pandas groupby.sum（min_coun = 1），因此，如果至少没有1个非nan值，则结果将显示为NAN。

Answer 1

好的，尝试将其删除Nan和Null但留下零。

Editor.

或这样可以消除无用转换的负载。

Editor< /a>

    {
      "$schema": "https://vega.github.io/schema/vega-lite/v5.json",
      "description": "Google's stock price over time.",
      "data": {
        "values": [
          {"date": "2022-01-20", "g": "apples", "x": "NaN", "y": "NaN"},
          {"date": "2022-01-20", "g": "oranges", "x": "10", "y": "20"},
          {"date": "2022-01-21", "g": "oranges", "x": "30", "y": "NaN"},
          {"date": "2022-01-21", "g": "grapes", "x": "40", "y": "20"},
          {"date": "2022-01-22", "g": "apples", "x": "NaN", "y": "NaN"},
          {"date": "2022-01-22", "g": "grapes", "x": "10", "y": "NaN"}
        ]
      },
      "transform": [
        {"calculate": "parseFloat(datum['x'])", "as": "x"},
        {"calculate": "parseFloat(datum['y'])", "as": "y"},
        {"fold": ["x", "y"]},
        **{"filter": {"field": "value", "valid": true}},**
        {
          "aggregate": [{"op": "sum", "field": "value", "as": "value"}],
          "groupby": ["date", "key"]
        }
      ],
      "encoding": {"x": {"field": "date", "type": "temporal"}},
      "layer": [
        {
          "encoding": {
            "y": {"field": "value", "type": "quantitative"},
            "color": {"field": "key", "type": "nominal"}
          },
          "mark": "line"
        },
        {
          "encoding": {
            "y": {"field": "value", "type": "quantitative"},
            "color": {"field": "key", "type": "nominal"}
          },
          "mark": {"type": "point", "tooltip": {"content": "encoding"}}
        }
      ]
    }