将unicode数据写入cs时出现问题

2024-09-27 00:15:34 发布

您现在位置:Python中文网/ 问答频道 /正文

我无法理解如何将此数据类型写入csv文件。我在Python2.7中使用了请求,这将作为<type 'unicode'>返回。这只是数据的一个片段:

"sizeOfApplication":0,"totalFailedFolders":0,"totalFailedFiles":0,"isVisible":true,"localizedStatus":"Running","isAged":false,"totalNumOfFiles":0,"jobId":955329,"sizeOfMediaOnDisk":0,"status":"Running","lastUpdateTime":1528140228,"percentSavings":0,"localizedOperationName":"Auxiliary Copy","statusColor":"greenspan","backupLevel":0,"jobElapsedTime":1732834,"jobStartTime":1526389208,"currentPhaseName":"Auxi"sizeOfApplication":179325630,"backupSetName":"Databases","totalFailedFolders":0,"totalFailedFiles":0,"isVisible":true,"localizedStatus":"Running","isAged":false,"totalNumOfFiles":54,"jobId":971203,"sizeOfMediaOnDisk":27870043,"status":"Running","lastUpdateTime":1527914335,"percentSavings":84.4584,"localizedOperationName":"Backup","statusColor":"greenspan","backupLevel":1,"jobElapsedTime":241877,"jobStartTime":1527897616,"currentPhaseName":"Backup","jobType":"Backup","backupLevelName":"Full"

当我试图将其设置为文本值时,我得到一个值错误:字符串格式错误,当我查找时,我认为是因为输出中有十进制数据,而ast不支持十进制

cvData = ast.literal_eval(str(r.text))

我试过以下方法也不起作用:

with open('mycsvfile.csv', 'wb') as f:
    w = csv.DictWriter(f, r.text.keys())
    w.writeheader()
    w = csv.DictWriter(writerow(r.text))

显然,这是主席和键盘之间的问题,我提前道歉,因为我的python技能非常缺乏

有没有办法让它正确输出或者删除/转换小数(假设这就是问题所在)


Tags: csv数据textfalsetruerunningbackupjobid

热门问题