Python附加到没有whiteline的csv文件 [英] Python append to csv file without whiteline

问题描述

我在python写一个游戏。在每轮游戏后（是的，游戏有多轮）我想把数据写入CSV文件。

这是我的代码：

  csv'，'a'）as fp：
 for player in self.players：
a = csv.writer（fp，delimiter ='，'） 
 data = [[player.name，player.penalty（），player.score（）]]; 
 a.writerows（data）; 
  

CSV文件中此代码的输出（两轮后）为：

player1,10,10.0

player2,5,5.0

player1,20,15.0

player2,10,7.5

问题是每次脚本将数据附加到csv文件时，数据之间都有一条白线。而且我唯一想添加一条白线的时间是在回合之间。因此输出应如下所示：

player1,10,10.0

player2,5,5.0

player1,20,15.0

player2,10,7.5

<

我的新工作代码：

 
 code> with open（'take5.csv'，'ab'）as fp：
 for player in self.players：
a = csv.writer（fp，delimiter ='，'） 
 data = [[player.name，player.penalty（），player.score（）]]; 
 a.writerows（data）; 
 white_row = ['\\\
']; 
 a.writerows（white_row）; 
  

解决方案

Python 3： / p>

  with open（'data.csv'，'a'，newline =''）as fp：
 for player in self.players：
a = csv.writer（fp，delimiter ='，'）; 
 data = [[player.name，player.penalty（），player.score（）]]; 
 a.writerows（data）; 
 

对于python 3，CSV模块中有更改，您可以阅读这里

Python 2.x：

只需将 open（）改为binary open（'data.csv '，'ab'）

您可以使用以下命令设置控制引用：

csv.writer（fp，delimiter ='，'，quoting = csv.QUOTE_MINIMAL）

选项是：

csv.QUOTE_ALL指示作者对象引用所有字段。

csv.QUOTE_MINIMAL指示writer对象只引用包含特殊字符（如delimiter，quotechar或任何
的字符在lineterminator中）的字段
。

csv.QUOTE_NONNUMERIC指示编写器对象引用所有非数字
字段。

指示读者将所有非引用字段转换为类型float。 / p>

csv.QUOTE_NONE指示writer对象从不引用字段。当
时，当前分隔符出现在输出数据中，其前面是
当前escapechar字符。如果没有设置escapechar，如果任何需要转义的字符都是
，作者
将会引发Error。

I'm writing a game in python. And after each round of the game (yes, the game has multiple rounds) I want to write the data to a CSV file.

this is my code:

with open('data.csv', 'a') as fp:
            for player in self.players:
                a = csv.writer(fp, delimiter=',');
                data = [[player.name, player.penalty(), player.score()]];
                a.writerows(data);

the output for this code (after two rounds) in the CSV file is:

player1,10,10.0

player2,5,5.0

player1,20,15.0

player2,10,7.5

The problem is that every time the script appends data to the csv file, there is a white line between the data. And the only time I want to append a white line is between the rounds. So the output should look like this:

player1,10,10.0
player2,5,5.0

player1,20,15.0
player2,10,7.5

Is there a way I can accomplish this?

My new working code:

with open('take5.csv', 'ab') as fp:
            for player in self.players:
                a = csv.writer(fp, delimiter=',');
                data = [[player.name, player.penalty(), player.score()]];
                a.writerows(data);
            white_row = ['\n'];
            a.writerows(white_row);

解决方案

Python 3:

with open('data.csv', 'a', newline='') as fp:
    for player in self.players:
        a = csv.writer(fp, delimiter=',');
        data = [[player.name, player.penalty(), player.score()]];
        a.writerows(data);

With python 3 there is change in the CSV module you can read here

Python 2.x:

Just change the open() to binary open('data.csv', 'ab')

You can set control quoting using:

csv.writer(fp, delimiter=',',quoting=csv.QUOTE_MINIMAL)

As from docs your options are:

csv.QUOTE_ALL Instructs writer objects to quote all fields.

csv.QUOTE_MINIMAL Instructs writer objects to only quote those fields which contain special characters such as delimiter, quotechar or any of the characters in lineterminator.

csv.QUOTE_NONNUMERIC Instructs writer objects to quote all non-numeric fields.

Instructs the reader to convert all non-quoted fields to type float.

csv.QUOTE_NONE Instructs writer objects to never quote fields. When the current delimiter occurs in output data it is preceded by the current escapechar character. If escapechar is not set, the writer will raise Error if any characters that require escaping are encountered.

这篇关于Python附加到没有whiteline的csv文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！