您可以获取调用的唯一值
unique,对其进行迭代,构建文件名并将其写到csv中:
In [78]:genes = df['Gene'].unique()for gene in genes: outfilename = gene + '.pdf' print(outfilename) df[df['Gene'] == gene].to_csv(outfilename)HAPPY.pdfSAD.pdfLEG.pdf
一种更流行的方法是对“ Gene”进行分组,然后遍历各组:
In [93]:gp = df.groupby('Gene')# groups() returns a dict with 'Gene':indices as k:v pairfor g in gp.groups.items(): print(df.loc[g[1]]) chr start end Gene Value MoreData0 chr1 123 123 HAPPY 41.1 3.41 chr1 125 129 HAPPY 45.9 4.52 chr1 140 145 HAPPY 39.3 4.1 chr start end Gene Value MoreData3 chr1 342 355 SAD 34.2 9.04 chr1 360 361 SAD 44.3 8.15 chr1 390 399 SAD 29.0 7.26 chr1 400 411 SAD 35.6 6.5 chr start end Gene Value MoreData7 chr1 462 470 LEG 20 2.7


