使用 python 更新 csv 文件

发布于 2024-11-03 09:29:51 字数 540 浏览 4 评论 0原文

我正在开发一个小项目，其中步骤之一是在 csv 文件上写入数据列表。我正在循环遍历列表，获取特定数据并将其写入 csv。问题是当处理写入操作时，它会删除 csv 文件的先前条目。我的 csv 写入方法如下：和一个示例

def csv_writer(data_list,file_path):
    import csv
    file_p = open(file_path, "wb")
    write_pattern = csv.writer(file_p, delimiter=",", quotechar=",")
    write_pattern.writerow(data_list)
    file_p.close()

示例数据列表是：

data_list = ['a', '', 'a', 'a', 'd', 'e']

我正在尝试在文件中包含数据，如下所示：

a,,a,d,e
a,b,c,d,e
a,g.j,l,m

提前致谢。

原文

I am working on a small project,where one of the step is to write on a csv file a list of data.
I am looping through a list,and fetching specific data and writing it to a csv.
The problem is when the write operation is being processed it removes previous entries of the csv file.My csv writing method is as follows:
and an example

def csv_writer(data_list,file_path):
    import csv
    file_p = open(file_path, "wb")
    write_pattern = csv.writer(file_p, delimiter=",", quotechar=",")
    write_pattern.writerow(data_list)
    file_p.close()

An example data list is:

data_list = ['a', '', 'a', 'a', 'd', 'e']

And I am trying to have data in the file as follows:

a,,a,d,e
a,b,c,d,e
a,g.j,l,m

Thanks in advance.

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

握住我的手 2024-11-10 09:29:51

也许以附加模式打开文件？

file_p = open(file_path, "ab")

Maybe open the file in append mode?

file_p = open(file_path, "ab")

回复收藏 0 原文

一袭白衣梦中忆 2024-11-10 09:29:51

当您打开文件时，尝试打开它进行附加，如下所示。

def csv_writer(data_list,file_path):
    import csv
    file_p = open(file_path, "a")
    write_pattern = csv.writer(file_p, delimiter=",", quotechar=",")
    write_pattern.writerow(data_list)
    file_p.close()

When you open the file, try opening it for appending, like this.

def csv_writer(data_list,file_path):
    import csv
    file_p = open(file_path, "a")
    write_pattern = csv.writer(file_p, delimiter=",", quotechar=",")
    write_pattern.writerow(data_list)
    file_p.close()

回复收藏 0 原文

绻影浮沉 2024-11-10 09:29:51

delimiter 和 quotechar 最好选择不同的

正如我理解的问题，目的是在 CSV 文件的所有内容之前插入一个新行。这是执行此操作的代码：

import csv

def csv_writer(data_list,file_path):
    file_p = open(file_path, "rb+")
    reader_pattern = csv.reader(file_p, delimiter=",", quotechar="$")
    write_pattern = csv.writer(file_p, delimiter=",", quotechar="$")

    content = list(reader_pattern)

    file_p.seek(0,0)
    write_pattern.writerow(data_list)
    write_pattern.writerows(content)
    file_p.truncate()
    file_p.close()


data_list = ['a', '', 'a', 'a', 'd', 'e']


csv_writer(data_list,'Copie de zozou.txt')

delimiter and quotechar must preferably be choosen as different

As I understood the question, the aim is to insert a new line before all the content of a CSV file. Here's the code to do that:

import csv

def csv_writer(data_list,file_path):
    file_p = open(file_path, "rb+")
    reader_pattern = csv.reader(file_p, delimiter=",", quotechar="$")
    write_pattern = csv.writer(file_p, delimiter=",", quotechar="$")

    content = list(reader_pattern)

    file_p.seek(0,0)
    write_pattern.writerow(data_list)
    write_pattern.writerows(content)
    file_p.truncate()
    file_p.close()


data_list = ['a', '', 'a', 'a', 'd', 'e']


csv_writer(data_list,'Copie de zozou.txt')

回复收藏 0 原文

~没有更多了~