文件的读:
import csv
with open('test.csv', 'r') as csv_file:
reader = csv.reader(csv_file)
for line in reader:
print(line)
文件的写:
import csv
# 表头
file_header = ['houseInfo', 'houseName', 'housePosition', 'housePrice/万元', 'unitPrice', 'area', 'region', 'houseStatus', 'houseType']
# 要写入的数据
data_1 = ['新城', '新城', '建设路', '总价1万/套', '23', '建面 129-138㎡', 'xihu', '在售', '商业类']
data_2 = ['新城', '新城', '建设路', '总价1万/套', '23', '建面 129-138㎡', 'xihu', '在售', '商业类']
# 写入数据
with open('test.csv', 'w', newline='') as csv_file: # newline不指定为空时,会出现写入数据之间出现空行的问题
writer = csv.writer(csv_file)
# 写入的数据应以列表形式传入
# writer.writerow(file_header)
# writer.writerow(data_1)
# writer.writerow(data_2)
writer.writerows([file_header, data_1, data_2])
文件的追加:
import csv
csv_Add = ['asd', 'asd', 'asd', 'asd/套', 'asd', '建面 129-138㎡' ,'xihu', '在售', '商业类']
with open('test.csv', 'a', newline='') as csv_file:
writer = csv.writer(csv_file)
writer.writerow(csv_Add)
很简单、很实用的小技巧!