为什么panda只从我的变量向csv写入一个数据点

Question

我正在尝试将9个数据点写入csv。我的输出如下：

1991579
['NC_021181.2']
4843789
['NZ_CP010820.1']
4848754
['NZ_CP009756.1']
5227419
['NC_007530.2']
3018755
['NC_013205.1']
5190487
['NZ_LR134475.1']
5762608
['NZ_CP009909.1']
5598454
['NZ_CP050508.1']
4215606
['NC_000964.3']

我希望每个ID都与我的数据帧中的每个数字一起出现。我的代码目前只写一行。我是不是错过了什么？

work_dir = "/Users/
for path in glob.glob(os.path.join(work_dir, "*.gbff")):
with io.open(path, mode="r", encoding="utf-8") as file:
first_line = file.readline()
matches = int(re.search(r"(d+)", first_line[33:]).group(0))
print(matches)
name = os.path.basename(path).replace(".gbff", "")
names_list = []
names_list.append(name)
print(names_list)
#output as file
df = pd.DataFrame({'Accession_ID':names_list, 'Genome_size': matches})
print(df)
df.to_csv(r'/Users/, index=False)

谢谢！！

Answer 1

您正在清除每个循环上的names_list。您应该在循环开始之前对其进行一次初始化。