python3 csv 模板_Python3 CSV操作

小咪咪 2022-10-31 13:51 109阅读 0赞

import csv

import os

import zipfile

def append\_csv(file\_path, add\_info):

\# 新增的数据行，以列表的形式表示

\# add\_info = \["Guo", 150\]

csvFile = open(file\_path, "a", encoding="UTF-8", newline='')

writer = csv.writer(csvFile)

writer.writerow(add\_info)

csvFile.close()

def read\_csv\_map\_0\_1(file\_path):

\# 读取csv至字典

csvFile = open(file\_path, "r", encoding="UTF-8")

reader = csv.reader(csvFile)

\# 建立空字典

result = \{\}

for item in reader:

if len(item) > 1:

result\[item\[0\]\] = item\[1\]

csvFile.close()

return result

def read\_csv\_map\_0\_2(file\_path):

\# 读取csv至字典

csvFile = open(file\_path, "r", encoding="UTF-8")

reader = csv.reader(csvFile)

\# 建立空字典

result = \{\}

for item in reader:

if len(item) > 2:

result\[item\[0\]\] = item\[2\]

csvFile.close()

return result

def read\_csv\_map\_x\_x(file\_path, one, two):

\# 读取csv至字典

csvFile = open(file\_path, "r", encoding="UTF-8")

reader = csv.reader(csvFile)

\# 建立空字典

result = \{\}

for item in reader:

if len(item) > two:

result\[item\[one\]\] = item\[two\]

csvFile.close()

return result

def read\_csv\_list\_0(file\_path): \# 读取第一列

csvFile = open(file\_path, "r", encoding="UTF-8")

reader = csv.reader(csvFile)

result = \[\]

for item in reader:

if len(item) > 0:

if item\[0\]:

result.append(item\[0\])

csvFile.close()

return result

def read\_csv\_list\_2(file\_path): \# 读取第三列

csvFile = open(file\_path, "r", encoding="UTF-8")

reader = csv.reader(csvFile)

result = \[\]

for item in reader:

if len(item) > 2:

if item\[2\]:

result.append(item\[2\])

csvFile.close()

return result

def read\_csv\_list\_1(file\_path): \# 读取第二列

csvFile = open(file\_path, "r", encoding="UTF-8")

reader = csv.reader(csvFile)

result = \[\]

for item in reader:

if len(item) > 1:

if item\[1\]:

result.append(item\[1\])

csvFile.close()

return result

def read\_csv\_list\_one\_line\_by\_first(file\_path, key):

csvFile = open(file\_path, "r", encoding="UTF-8")

reader = csv.reader(csvFile)

result = \[\]

for item in reader:

if len(item) > 0:

if item\[0\] == key:

for num in range(1, len(item)):

result.append(item\[num\])

csvFile.close()

return result

def read\_csv\_all(file\_path):

csvFile = open(file\_path, "r", encoding="UTF-8")

reader = csv.reader(csvFile)

result = \[\]

for item in reader:

result.append(item)

return result

def replace\_one\_line\_by\_key\_0(file\_path, line\_new):

res = \[\]

csvreadfile = open(file\_path, 'r')

reader = csv.reader(csvreadfile)

for line in reader:

res.append(line)

csvreadfile.close()

num = -1

for new in range(len(res)):

one\_line\_old = res\[new\]

print(one\_line\_old\[0\] + "||" + line\_new\[0\])

if one\_line\_old\[0\] == line\_new\[0\]:

print(new)

num = new

if num != -1:

res\[num\] = line\_new

csvfile = open(file\_path, 'w')

writer = csv.writer(csvfile)

writer.writerows(res)

csvfile.close()

python3 csv 模板_Python3 CSV操作

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 python-csv文件操作

相关 Python进阶 -- 3.处理CSV格式

相关 python3 csv 模板_Python3 CSV操作

相关 python3处理csv文件

相关 3.2.4 Python读取CSV文件

相关 python3写Csv文件

相关 python3 csv 中文乱码

相关 Python3中使用csv输出文件

相关 python3：csv的读写

相关 python3读取csv文件并操作数据写出csv