aboutsummaryrefslogtreecommitdiffstats
path: root/python/fixup.py
blob: 8b939ff55fe3503daa0a7a185a78ea754e2f1500 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
import csv
import os.path
import pdb

if os.name=='nt':
    root = "//WDSENTINEL/share/CorpCDOs/"
elif os.name=='posix':
    root = "/home/share/CorpCDOs/"

root = os.path.join(root, "data")
fh1 = open(os.path.join(root, "clo_universe_intex_2012-11-20.txt"))
fh2 = open(os.path.join(root, "clo_universe_intex_2012-11-21.txt"))

dr1 = csv.DictReader(fh1, dialect = 'excel-tab')
dr2 = csv.DictReader(fh2, dialect = 'excel-tab')

for line1 in dr1:
    line2 = dr2.next()
    if line1['Deal,Tr/CUSIP/ISIN'] != line2['Deal,Tr/CUSIP/ISIN']:
        pdb.set_trace()
    if line1['Latest Update'] != line2['Latest Update']:
        print '{0}: {1}   {2}: {3}'.format(line1['Deal,Tr/CUSIP/ISIN'], line1['Latest Update'],
                                           line2['Deal,Tr/CUSIP/ISIN'], line2['Latest Update'])