Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import MySQLdb
- import sys
- host = 'localhost'
- username = 'capillary'
- password = 'deal20hunt'
- database = 'veneno_data_details'
- #con = MySQLdb.connect(host, username, password, database);
- #cursor = con.cursor()
- file = open('somefile.csv', 'r')
- file_inp = file.readlines()
- some_map = {}
- for a in file_inp:
- nsadmin_id, org_id, message_id = a.rstrip().split(',')
- nsadmin_id = nsadmin_id.strip('"')
- org_id = org_id.strip('"')
- message_id = message_id.strip('"')
- if (message_id, org_id) not in some_map:
- some_map[(message_id, org_id)] = list()
- some_map[(message_id, org_id)].append(nsadmin_id);
- #print nsadmin_id, org_id, message_id;
- for a, b in some_map:
- print key, value
Add Comment
Please, Sign In to add comment