In [39]:
import csv
import re
# import csv and regex modules

In [49]:
basename = "../../Downloads/astro3_lo_2c.csv"
m = re.search('(?=).*.csv', basename)
print(m.group(0))


../../Downloads/astro3_lo_2c.csv

In [50]:
with open(basename) as filein:
    reader = csv.reader(filein, delimiter='\t', skipinitialspace = False) #

    uids = []
    names = []
    scores = []
    for row in reader:
        print(row[2:])
        uids.append(row[0])
        names.append(row[1])
        scores.append(row[2:])
        
    for i in range(8):
        filename = "../../Downloads/astro3_py_2c"+str(i+1)+".csv"
        with open(filename, 'w') as fileout:                            
            writer = csv.writer(fileout, delimiter='\t')
            for j in range(len(uids)):
                linestr = uids[j]+'\t'+names[j]+'\t'+scores[j][i]
                writer.writerow([uids[j], names[j], scores[j][i]])


['', '', '', '', '', '', '', '', '']
['Lab 1', 'Lab 2', 'Lab 3', 'Lab 4', 'Lab 5', 'Lab 6', 'Lab 7', 'Lab 8', 'Total']
['25', '', '', '', '', '', '', '', '']
['24', '25', '25', '23', '24', '24', '23.5', '24', '192.5']
['25', '22', '25', '23', '25', '25', '24.5', '23', '192.5']
['22', '25', '23.5', '24', '22', '23', '23', '24', '186.5']
['', '', '', '', '', '', '', '', '0']
['25', '22', '20', '24', '25', '25', '24', '5', '170']
['24', '24', '25', 'MU', '24', '25', '24', '25', '171']
['25', '25', '25', '23', '24', '25', '23.5', '22.5', '193']
['25', '24', '23', '24.5', '23', '24.5', '24.5', '25', '193.5']
['25', '25', '24', '25', '25', '25', '25', '23', '197']
['', '', '', '', '', '', '', '', '0']
['25', '24', '25', '23', '25', '24.5', '24', '24', '194.5']
['25', '25', '24', '24', '24', '24', '25', '22', '193']
['25', '25', '25', '25', '25', '25', '25', '25', '200']
['25', '', '', '', 'mu', '', '', '', '25']
['25', '25', '25', '24', '25', '23.5', '25', '25', '197.5']
['25', '25', '25', '23', '24', '25', '25', '23.5', '195.5']
['24', '25', '25', '24', '22', '23', '22', '', '165']
['', '', '', '', '', '', '', '', '0']
['25', '25', '25', '24', '25', '20', '24', '24', '192']
['25', '25', '25', '25', '25', '25', '23', '22.5', '195.5']
['25', '25', '25', '24', '24', '24', '24', '22', '193']
['24.5', '25', '25', '23', '24', '25', '24', '25', '195.5']
['25', '25', '24', '23', '24', '25', '23', '25', '194']
['25', '24', '24.5', '25', '24', '25', '24.5', '24.5', '196.5']
['25', '25', '23.5', '24', '25', '25', '24', '24.5', '196']
['', '', '', '', '', '', '', '', '0']
['25', '25', '25', '24', '23', '25', '24', '25', '196']
['25', '25', '23', '23', '25', '25', '24.5', '25', '195.5']
['25', '25', '23', '23', '23', '24.5', '24', '23', '190.5']
['25', '25', '23', '22', '25', '25', '25', '78', '248']

In [25]:
for row in reader:
    print(row)
    
        #xs, ys = zip(*reader)
    #print(reader)
    #zipped = zip(*reader)
    #print(next(zipped))
    #print(list(zipped)[0])
    
    #print(xs)
#print(ys)


---------------------------------------------------------------------------
ValueError                                Traceback (most recent call last)
<ipython-input-25-b2996c23800c> in <module>()
----> 1 for row in reader:
      2     print(row)

ValueError: I/O operation on closed file.

In [30]:
csv.writer?

In [32]:
file h = file('')


  File "<ipython-input-32-fba6c82bc7d8>", line 1
    file h = file('')
         ^
SyntaxError: invalid syntax

In [60]:


In [62]:



[[1, 2, 3], [2, 3, 4], [3, 2, 1]]