#!/usr/bin/env python
# -*- coding:utf-8 -*-
import pandas as pd
import csv

path1=r"/public/home/test1.csv"  #.csv文件路径
path2=r"/public/home/test2.csv"
path3=r"/public/home/test3.csv"
path4=r"/public/home/test4.txt"   #.txt文件路径

with open(path1,'r') as f:
    reader = csv.reader(f)    
    result = list(reader)
    print(result[0])   #读第一行
	#写入第一行
    wcsv = open(path2,'w',newline='')  #newline=''去除输出之后多余的空行
    write = csv.writer(wcsv)
    write.writerow(result[0])
    wcsv.close()

#更换表头位置，可以改变、更换表头名称,例如将Id和Name的位置更换 
df=pd.read_csv('test2.csv', header=0)
df.columns=['age', 'Id', 'Name']
df.to_csv('test3.csv', index=False)

fvile = open(path4,'r')
for i in file:
    print(i.strip())   #逐行输出  
    with open(path3,'r') as f:
        reader1 = csv.DictReader(f)
        for row in reader1:
            if (row['sampleId'] ==i.strip()):
                print(row)
                wcsv = open(path2,'a+',newline='')
                write = csv.DictWriter(wcsv,fieldnames=['age', 'Id', 'Name'])
                write.writerow(row)  
                wcsv.close()