我是Python新手，希望更改csv数据中的文本数据，其中列包含id，sequence，createdAt和createdBy？
文本文件
[{"id":1,"sequence":14,"createdAt":"2021-03-04xx:x:x","createdBy":"xxxxxxxxxxxx"}},
{"id":2,"sequence":14,"createdAt":"2021-03-04Txx:x:x","createdBy":"xxxxxxxxxxxx"}},
{"id":3,"sequence":14,"createdAt":"2021-03-04Txx:x:x","createdBy":"xxxxxxxxxxxx"}}]
1条答案
按热度按时间noj0wjuj1#
输入数据集似乎是JSON结构，我建议使用csvkithttps://csvkit.readthedocs.io/en/latest/index.html
具体来说，模块
in2csv-非常强大或者-使用pandas read_json -这将使您能够加载到DataFrame中