def processRawCSV()

in rawdataprocessor/RawDataProcesser.py [0:0]


def processRawCSV(rawDataLocalPath):
    inputFile=open(rawDataLocalPath,'r')
    readerObj=csv.reader(inputFile)
    next(readerObj)
    cur_itemList=[]
    # get start and end date, get Rawdata Map
    cur_startDate=date.today()
    cur_endDate=None
    for row in readerObj:
       tmp_date_string=transformDateStringFormat(row[0])
       tmp_date=getDateFromString(tmp_date_string)
       tmp_item_string=row[1]
       if (not tmp_item_string in cur_itemList):
           cur_itemList.append(tmp_item_string)
       if (not tmp_date_string in vars.RawData):
           vars.RawData[tmp_date_string]={}
       if (not tmp_item_string in vars.RawData[tmp_date_string]):
           vars.RawData[tmp_date_string][tmp_item_string]={}
       tmp_object={}
       tmp_object["targetValue"]=row[2]
       tmp_object["relatedValue1"]=row[17]
       vars.RawData[tmp_date_string][tmp_item_string]=tmp_object
       #process start and end date
       if(tmp_date<cur_startDate):
           cur_startDate=tmp_date
       if (cur_endDate is None):
           cur_endDate=tmp_date
       if(tmp_date>cur_endDate):
           cur_endDate=tmp_date
    inputFile.close()

    vars.StartDate=cur_startDate
    vars.EndDate=cur_endDate
    vars.ItemList=cur_itemList