Skip to main content
 首页 » 编程设计

python之使用 python 的 csv.writer 生成标题行

2024年11月01日8soundcode

我有一些生成 .csv 文件的 python 代码,但是我不知道如何添加列名或标题行。这是我的代码:

handle = open(sys.argv[1]) 
with open('protparams.csv', 'w') as fp:  
    writer = csv.writer(fp, delimiter=',') 
    for record in SeqIO.parse(handle, "fasta"):  
            seq = str(record.seq) 
            X = ProtParam.ProteinAnalysis(seq) 
            data = [seq,X.get_amino_acids_percent(),X.aromaticity(),X.gravy(),X.isoelectric_point(),X.secondary_structure_fraction(),X.molecular_weight(),X.instability_index()] 
            writer.writerow(data) 

我试过添加类似的内容:

writer = csv.writer(fp, delimiter=',',[seq,aa_percentage,aromaticity,gravy,isoelectric_point,secondary_structure_fraction,molecular_weight,instability_index]) 

但这显然行不通

有人有什么想法吗?

请您参考如下方法:

在循环之前写标题:

handle = open(sys.argv[1]) 
with open('protparams.csv', 'w') as fp: 
    writer = csv.writer(fp, delimiter=',') 
    writer.writerow(['heading1','heading2','heading3']) 
    for record in SeqIO.parse(handle, "fasta"): 
            seq = str(record.seq) 
            X = ProtParam.ProteinAnalysis(seq) 
            data = [seq,X.get_amino_acids_percent(),X.aromaticity(),X.gravy(),X.isoelectric_point(),X.secondary_structure_fraction(),X.molecular_weight(),X.instability_index()] 
            writer.writerow(data)