In [15]:
import csv


with open('energy-comparison.dat', 'rt') as f:

    line = f.read()
print(line)

listed = []
for u in line.split(' '):
    listed.append(u)
print(listed)
#     for e in listed:
#     print(e)


#energy for 40atoms
allin    	-235.48996621		
I-x		-235.43594726	
I-z		-235.43770211
co-two-in	-235.48731293	
co-all-in	-235.48409892	
2inplane-2outofplane	-235.48576564 
pc-1		 -235.48409690 
pc-2		 -235.48731507		


['#energy', 'for', '40atoms\nallin', '', '', '', '\t-235.48996621\t\t\nI-x\t\t-235.43594726\t\nI-z\t\t-235.43770211\nco-two-in\t-235.48731293\t\nco-all-in\t-235.48409892\t\n2inplane-2outofplane\t-235.48576564', '\npc-1\t\t', '-235.48409690', '\npc-2\t\t', '-235.48731507\t\t\n\n']

In [ ]:
import csv

headers = ['Symbol','Price','Date','Time','Change','Volume']
rows = [('AA', 39.48, '6/11/2007', '9:36am', -0.18, 181800),
        ('AIG', 71.38, '6/11/2007', '9:36am', -0.15, 195500),
        ('AXP', 62.58, '6/11/2007', '9:36am', -0.46, 935000),
       ]
with open('stocks.csv','w') as f:
    f_csv = csv.writer(f)
    f_csv.writerow(headers)
    f_csv.writerows(rows)