'''Renaming the genes in the 12 csv files
Julia Preziosi
25 Feb 2016

create a dictionary of old : new names
import csv file
check each name for a name in our dictionary
if the name matches completely!!! (not 'contains') then replace with : new
rewrite csv ? or make a new copy
'''

import dictmaker
import csv

names = dictmaker.namedict

filelist = ['intestine_fed_5.genes.csv','intestine_fed_6.genes.csv','intestine_no_1.genes.csv',
            'intestine_no_2.genes.csv','intestine_no_3.genes.csv','Liver_no_1.genes.csv',
            'Liver_no_2.genes.csv','Liver_no_3.genes.csv','Liver_fed_4.genes.csv','Liver_fed_5.genes.csv',
            'Liver_fed_6.genes.csv']
            

for excelfile in filelist:

    csvname = excelfile
    
    csvnewname = 'updated_' + csvname
    
    with open(csvnewname, 'w') as mynewportal:
        filewriter = csv.writer(mynewportal, delimiter = ',')
    
        with open(csvname,'rU') as myportal:
            filereader = csv.reader(myportal, delimiter = ',')
            firstline = True
            for row in filereader:
                if firstline:
                    firstline = False
                    headers = row
                    filewriter.writerow(headers)
                else:
                    if row[0] in names:
                        unknown = row[0]
                        newname = names[unknown]
                        listrow = [newname,newname,row[2],row[3],row[4],row[5],row[6]]
                        
                    else:
                        listrow = [row[0],row[1],row[2],row[3],row[4],row[5],row[6]]
                    filewriter.writerow(listrow)