(我不能编辑这个问题的标题:Add an array to a DataFrame我想我没有标题的答案。。。。我希望这能有所帮助)
我正在从differents.csv读取信息,需要将其转换为.json
1.csv是:
字段1:1value1,字段2:1value2,字段3:1value3
2.csv有很多行,我必须按1value3进行过滤
row1field1:2value1,row1field2:2value2,row1field3:1value3,row1field4:3.csv,row2field1:2value4,row2field2:2value5,row2field3:1value3,row2field4:4.csv
3.csv是:
字段1:3value1,字段2:3value2
4.csv是:
字段1:4value1,字段2:4value2
我需要我的最终json如下所示:
{
"field1": "1value1",
"field2": "1value2",
"field3": "1value3",
"talbes": [
{
"row1field1": "2value1",
"row1field2": "2value2",
"row1field3": "1value3",
"fieldsFromTable": [
{
"field1": "3value1",
"field2": "3value2"
}
]
},
{
"row2field1": "2value4",
"row1field2": "2value5",
"row1field3": "1value3",
"fieldsFromTable": [
{
"field1": "4value1",
"field2": "4value2"
}
]
}
]
}
我正在尝试使用dataFrame.to_json()转换dataFrame,但无法将dataFrame数组存储到其他dataFrame中。。。真的,我不知道这是最好的解释
谢谢
(我知道这个解释有点混乱。。。(对不起)
目前没有回答
相关问题 更多 >
编程相关推荐