import csv
import pandas
import codecs
import os
import string
import re

colnames = ['AUTORES', 'TITULO', 'OUTROS', 'DATA','NOMEREVISTA','LOCAL','VOL','NUM','PAG','PAG2','ISBN','ISSN','ISSN2','ERC','IF','DOI','CODEN','WOS','SCOPUS','URL','CODIGO BIBLIOGRAFICO','INDEXAÇÕES',
            'EXTRAINFO']

data = pandas.read_csv('test1.csv', names=colnames, delimiter =r";", encoding='latin1')#, nrows=1
df = pandas.DataFrame(data=data)

with codecs.open('test1.txt', 'w', encoding='latin1') as fh:
    fh.write('@Article{Arp, ')
    fh.write('\n')

    counter = 0

    for row_number, row in df.iterrows():
        for colname in df.columns:
            counter = counter +1
            row_element = row[colname]

            if colname == 'AUTORES':
                fh.write('  Author                   = {%s},\n' % str(row_element))
            elif colname == 'TITULO':
                fh.write('  Title                    = {%s},\n' % str(row_element))
            elif colname == 'OUTROS':
                fh.write('  Note                     = {%s},\n' % str(row_element))
            elif colname == 'DATA':
                fh.write('  Year                     = {%s},\n' % str(row_element))
            elif colname == 'NOMEREVISTA':
                fh.write('  Journal                  = {%s},\n' % str(row_element))
            elif colname == 'LOCAL':
                fh.write('  Comment                  = {%s},\n' % str(row_element))
            elif colname == 'VOL':
                fh.write('  Volume                   = {%s},\n' % str(row_element))
            elif colname == 'NUM':
                fh.write('  Number                   = {%s},\n' % str(row_element))

            elif colname == 'PAG':
                fh.write('  Pages                    = {%s},\n' % str(row_element))
            elif colname == 'PAG2':
                fh.write('  Pages                    = {%s},\n' % str(row_element))



            elif colname == 'ISBN':
                fh.write('  Doi                      = {%s},\n' % str(row_element))
            elif colname == 'ISSN':
                fh.write('  Doi                      = {%s},\n' % str(row_element))
            elif colname == 'ISSN2':
                fh.write('  Doi                      = {%s},\n' % str(row_element))
            elif colname == 'ERC':
                fh.write('  Doi                      = {%s},\n' % str(row_element))
            elif colname == 'IF':
                fh.write('  Doi                      = {%s},\n' % str(row_element))
            elif colname == 'DOI':
                fh.write('  Doi                      = {%s},\n' % str(row_element))
            elif colname == 'CODEN':
                fh.write('  Doi                      = {%s},\n' % str(row_element))
            elif colname == 'WOS':
                fh.write('  Doi                      = {%s},\n' % str(row_element))
            elif colname == 'SCOPUS':
                fh.write('  Doi                      = {%s},\n' % str(row_element))
            elif colname == 'URL':
                fh.write('  Url                      = {%s},\n' % str(row_element))
            elif colname == 'CODIGO BIBLIOGRAFICO':
                fh.write('  Comment                  = {%s},\n' % str(row_element))
            elif colname == 'INDEXAÇÕES':
                fh.write('  Comment                  = {%s},\n' % str(row_element))
            elif colname == 'EXTRAINFO':
                fh.write('  Comment                  = {%s},\n' % str(row_element))


            else:
                fh.write('  Title                  = {%s},\n' % str(row_element))