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
