python 数据分析基础 day5－读写csv文件基础python读写csv文件通过pandas模块读写csv文件通过csv模块读写csv文件

inputFile="要读取的文件名"
outputFile=“写入数据的csv文件名”
with open(inputFile,"r")  as fileReader:
  with open(outputFile,"w") as fileWriter:
    for row in fileReader:
      fileWriter.write(row)

import os
import glob
inputPath="读取csv文件的路径"
outputFile="写入数据的csv文件名"
firstFile=True
for file in glob.glob(os.path.join(inputPath,"*.csv")):
    with open(file,'r') as fileReader:
        with open(outputFile,"a") as fileWriter:
            if firstFile:
                for row in fileReader:
                    fileWriter.write(row)
                firstFile=False
                fileWriter.write("\n")
            else:
                header=fileReader.readline()
                for row in fileReader:
                    fileWriter.write(row)

import pandas as pd
inputFile="要读取的文件名"
outputFile=“写入数据的csv文件名”
df=pd.read_csv(inputFile)
df.to_csv(outputFile)

import os
import glob
import pandas as pd
i
nputPath="读取csv文件的路径"
outputFile="写入数据的csv文件名"
dataFrameList=[]
for file in glob.glob(os.path.join(inputPath,"*.csv")): 
    df=pd.read_csv(file)
    dataFrameList.append(df)
allDataFrame=pd.concat(dataFrameList,axis=0,ignore_index=True)
allDataFrame.to_csv(outputFile)

import csv
inputFile="要读取的文件名"
outputFile=“写入数据的csv文件名”
with open(inputFile,"r",newline='') as fileReader:
    with open(outputFile,"w",newline='') as fileWriter:
        csvReader=csv.reader(fileReader,delimiter=',')
        csvWriter=csv.writer(fileWriter,delimiter=',')
        for row in csvReader:
            print(row)
            csvWriter.writerow(row)

import csv
import glob
import os

inputPath=r"读取csv文件的路径"
outputFile=r"输出文件的路径"
firstFile=True
for file in glob.glob(os.path.join(inputFile,"*.csv")):
    with open(file,"r") as fileReader:
        with open(outputFile,"a") as fileWriter:
            csvReader=csv.reader(fileReader)
            csvWriter=csv.writer(fileWriter)
            if firstFile:
                for row in csvReader:
                    csvWriter(row)
                firstFile=False
            else:
                header=next(csvReader,None)
                for row in csvReader:
                    csvWriter(row)