def ReadCSV(folder_name, input_type): """ This method used to read the information from CSV files in the given folder name str, str => [Objects, Objects] """ RequestTypespath = 'CSVdata/' + folder_name + '/RequestTypes.csv' print 'START read RequestTypes' RequestType_dict = SaveRequestTypes(RequestTypespath) Requestspath = 'CSVdata/' + folder_name + '/Requests.csv' print 'START read Request' requests = SaveRequests(Requestspath, RequestType_dict) print 'START read Loads' Loadspath = 'CSVdata/' + folder_name + '/Loads.csv' load_lists = SaveLoad(Loadspath, input_type) getAvailabePeriod(requests) # add the available time attribute Result = (requests, load_lists) return Result
def CollectData(file_name): """ used to collect all kinds of information form excel file str => ([Requests, Requests...], [int, int, ...]) """ Type_dict = {} #create an empty dict print 'START read RequestTypes' Return_Type = ReadExcel(file_name, 'RequestTypes', Type_dict) Type_dict = Return_Type[1] #update the dict information print 'START read Request' Return_Request = ReadExcel(file_name, 'Requests', Type_dict) #save the request information print 'START read Loads' Loads = ReadExcel(file_name, 'Loads', Type_dict) Result = (Return_Request, Loads) getAvailabePeriod(Return_Request) # add the available time attribute return Result