这些代码是近期跟着《python数据分析基础》这本书学习的,把代码放到网上保存,随时随地都找得到!
#1.读写CSV文件1
import sys
input_file=sys.argv[1]
output_file=sys.argv[2]
with open(input_file,'r',newline='')as filereader:
with open(output_file,'w',newline='') as filewriter:
header=filereader.readline()
header=header.strip()
header_list=header.split(',')
print(header_list)
filewriter.write(','.join(map(str,header_list))+'\n')
for row in filereader:
row=row.strip()
row_list=row.strip(',')
print(row_list)
filewriter.write(','.join(map(str,header_list))+'\n')
#读写CSV文件2
import csv,sys
input_file=sys.argv[1]
output_file=sys.argv[2]
with open(input_file,'r',newline='') as csv_in_file:
with open(output_file,'w',newline='') as csv_out_file:
filereader=csv.reader(csv_in_file,)
filewriter=csv.writer(csv_out_file)
for row in filereader:
print(row)
filewriter.writerow(row)
#2.保留特定行-行中的值满足某个条件
import sys,csv
input_file=sys.argv[1]
output_file=sys.argv[2]
with open(input_file,'r',newline='') as csv_in_file:
with open(output_file,'w',newline='') as csv_out_file:
filereader=csv.reader(csv_in_file)
filewriter=csv.writer(csv_out_file)
header=next(filereader)
filewriter.writerow(header)
print(header)
for row in filereader:
supplier=str(r