使用jq将仅具有值的json数组转换为csv [英] Convert json array with values only to csv using jq

问题描述

我有一个下面的JSON，我需要将其转换为CSV.我遇到的问题是这些值没有键.

I have a below JSON and I need to convert it to a CSV. The problem I'm having is that those values have no key.

理想情况下，我希望CSV看起来像这样，我只是不知道如何使用jq.

Ideally I would like CSV to look like this, I just don't know how to do it using jq.

CSV

year;points;surname;name;point1;points2;points3;city;district;url
2020;54;Smith;John;;;London;Waterloo;URL
2015;380;Helen;Smith;;;New York;Manhattan;URL

JSON

{
  "draw": 0,
  "total": "44",
  "filtered": "8",
  "data": [
    [
      "2020",
      "54",
      "Smith ",
      "John",
      "",
      "",
      "",
      "London",
      "Waterloo",
      "URL"
    ],
    [
      "2015",
      "380",
      "Helen ",
      "Smith",
      "",
      "",
      "",
      "New York",
      "Manhattan",
      "URL"
    ]
  ],
  "District": []
}

推荐答案

在示例中，.data []是平面数组流，因此要生成数据的CSV行，您可以:

In the sample, .data[] is a stream of flat arrays, so to produce the CSV rows for the data, you could:

.data[] | @csv

这篇关于使用jq将仅具有值的json数组转换为csv的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！