如何创建看起来像这个JSON文件的CSV文件

Question

我基本上想为NFT游戏（Axie Infinity）更新多个学者。它需要一个看起来像这样的JSON文件：

{
        "name": "Scholar 1",
        "ronin": "ronin:<account_s1_address>",
        "splits": [
            {
                "persona": "Manager",
                "percentage": 44,
                "ronin": "ronin:<manager_address>"
            },
            {
                "persona": "Scholar",
                "percentage": 40,
                "ronin": "ronin:<scholar_1_address>"
            },
            {
                "persona": "Other Person",
                "percentage": 6,
                "ronin": "ronin:<other_person_address>"
            },
            {
                "persona": "Trainer",
                "percentage": 10,
                "ronin": "ronin:<trainer_address>"
            }
        ]
    }

但是，由于有多个学者/播放器，我想知道是否有任何CSV文件上的某些内容，如果我使用JSON工具将其转换或导入它，它将看起来像上面的JSON？

您的帮助非常感谢..谢谢！

PS：

第一行：

"name": "Scholar 1",
            "ronin": "ronin:<account_s1_address>",
            "splits":

需要重复，因为再次有多个学者，即学者1，Scholar 2，Scholar 3 ...

Answer 1

CSV文件结构是列基库，如果Axie Infinity需要JSON文件，则可以通过Excel或Google Sheet创建CSV文件，然后转换为JSON。

也有类似的答案可以将CSV转换为JSON

Answer 2

starting from this CSV that has this structure

name	ronin	id_persona	persona	百分比	split_ronin
Scholar 1	ronin：＆lt; councel_s1_address＆gt;	1	经理	44	Ronin：＆lt; Manager_Address＆gt;
学者1	ronin：＆lt; councor_s1_address＆gt;	2	学者	40	Ronin：＆LT; Scholar_1_Address＆gt;
学者1	ronin：＆lt; councor_s1_address＆gt;	3	其他人	6	ronin：＆lt; shot_person_address＆gt;
学者1	ronin：＆lt; councor_s1_address＆gt;	4	教练	10	Ronin：＆lt; Trainer_Address＆gt;

您可以运行此 miller 命令

mlr --c2j reshape -r "^(p|s)" -o k,v  then \
put '$k="splits".".".${id_persona}.".".$k' then \
cut -x -f id_persona then \
reshape -s k,v out.csv

有

[
  {
    "name": "Scholar 1",
    "ronin": "ronin:<account_s1_address>",
    "splits": [
      {
        "persona": "Manager",
        "percentage": 44,
        "split_ronin": "ronin:<manager_address>"
      },
      {
        "persona": "Scholar",
        "percentage": 40,
        "split_ronin": "ronin:<scholar_1_address>"
      },
      {
        "persona": "Other Person",
        "percentage": 6,
        "split_ronin": "ronin:<other_person_address>"
      },
      {
        "persona": "Trainer",
        "percentage": 10,
        "split_ronin": "ronin:<trainer_address>"
      }
    ]
  }
]

一些注释：

• reshape -r“ （p | s）“ -ok，v，以将输入从宽到长；
• put'$ k =“ splits”。“。”。$ {id_persona}。“。$ k'，创建我将用作字段名称的值（splits.1） 。
• ​删除字段id_persona;
• 为宽度

reshape -sk，v，从长时间转换

+-----------+----------------------------+------------------+---------------------+-------------------------+------------------+---------------------+---------------------------+------------------+---------------------+------------------------------+------------------+---------------------+-------------------------+
| name      | ronin                      | splits.1.persona | splits.1.percentage | splits.1.split_ronin    | splits.2.persona | splits.2.percentage | splits.2.split_ronin      | splits.3.persona | splits.3.percentage | splits.3.split_ronin         | splits.4.persona | splits.4.percentage | splits.4.split_ronin    |
+-----------+----------------------------+------------------+---------------------+-------------------------+------------------+---------------------+---------------------------+------------------+---------------------+------------------------------+------------------+---------------------+-------------------------+
| Scholar 1 | ronin:<account_s1_address> | Manager          | 44                  | ronin:<manager_address> | Scholar          | 40                  | ronin:<scholar_1_address> | Other Person     | 6                   | ronin:<other_person_address> | Trainer          | 10                  | ronin:<trainer_address> |
+-----------+----------------------------+------------------+---------------------+-------------------------+------------------+---------------------+---------------------------+------------------+---------------------+------------------------------+------------------+---------------------+-------------------------+

。而不是使用它来创建最终的JSON输出