Department Owner Date-open Ticket      Date-closed User dept. Category
0   IT  Sam     9/6/2017    Password reset  9/7/2017    CS  Training
1   IT  Sam     9/6/2017    Phone issue     9/7/2017    CS  Training
2   IT  John    9/7/2017    Replace display 9/7/2017    AR  Training
3   IT  John    9/7/2017    Network issue   9/8/2017    AR  Training
4   IT  John    9/7/2017    Blue screen     9/8/2017    CS  Training
5   IT  Tom     9/6/2017    Password reset  9/9/2017    AP  Training
6   IT  Tom     9/6/2017    Password reset  9/10/2017   WH  Training
7   IT  Tom     9/6/2017    RF issue        9/11/2017   WH  Training
8   IT  Tom     9/6/2017    Power failure   9/12/2017   PL  Training

user = {'Owner':'John', 'Department':'AR', 'Account': 'IT'}

ticketinfo = [
{'Id': 10, 'Ticket':'Replace display','Category':'Training', 'Department':'AR'},
{'Id': 20, 'Ticket':'Network issue', 'Category':'Training','Department':'AR'}
]

ticket_dates = [
{'Id': 10, 'Date-open':'9/7/2017', 'Date-closed':'9/8/2017'},
{'Id': 20, 'Date-open':'9/7/2017', 'Date-closed':'9/8/2017'}]

second = {'Owner':'John', 'Department':'CS', 'Account': 'IT'}

ticket_info_new = [{'Id': 10, 'Ticket':'Blue screen','Category':'Training'}]
ticket_dates_new = [{'Id': 10, 'Date-open':'9/7/2017', 'Date-closed':'9/8/2017'}]