python编程之实现批量csv文件内容合并
不用pandas模块合并csv文件的方法
import csv
import os
def new_csv():
path = r'c:/mmm/practice/python/house0412'
dirpath, dirnames, filenames = next(os.walk(path)) # 获取目标文件夹中的文件夹路径、子文件夹名称、文件名称
title = '房屋编码,小区,朝向,房屋单价,参考首付,参考单价,经度,纬度\n'
with open('c:/mmm/practice/python/house0412/new/new.csv', 'a', encoding='utf-8') as f:
f.write(title) # 将标题写入新文件
writer = csv.writer(f) # 将文件变为csv.writer()对象,以便调用相应的方法
for filename in filenames:
file = os.path.join(path, filename) # 拼接文件路径
with open(file, 'r', encoding='utf-8') as fr: # 以只读方式打开每个文件
fr1 = fr.readlines()[1:] # 读取所有内容并获取除第一行标题外的其它行
reader = csv.reader(fr1)
writer.writerows(reader) # 写入新文件
def main():
new_csv()
if __name__ == '__main__':
main()