我正在尝试使用Python3.6打印到CSV。在控制台上打印时,它看起来很好,但是当我尝试打印到CSV时,它会打印出l i k e | | t h i s
。
即每个字符之间有空格,并且在每个空格之间有|。
我正在调用此处的translate函数。
示例响应:
{
"translations": [{
"translation": "Hola"
}],
"word_count": 1,
"character_count": 5
}
以下是相关摘录:
with open('C:\\Users\\SimonTheKing\\Desktop\\file.csv', 'w') as csvfile:
spamwriter = csv.writer(csvfile, delimiter=' ',
quotechar='|', quoting=csv.QUOTE_MINIMAL)
# Print the contents
for x in range(len(first_column)): #iterates over every row in an xlsx
translation = language_translator.translate(
model_id='123',
text=first_column[x].value #reads from openpyxl xlsx
)
print(translation) #prints as expected
spamwriter.writerow(translation) #prints a space between every char
请问有人可以提供一些指导吗?
delimiter=' '
。 - Mawg says reinstate Monicaquotechar
更改为逗号)? - Mawg says reinstate Monicaspamwriter.writerow([translation])
。 - pschill