Mercurial Hosting > traffic-intelligence
comparison scripts/process.py @ 1061:671426ce0f3e
minor
author | Nicolas Saunier <nicolas.saunier@polymtl.ca> |
---|---|
date | Wed, 11 Jul 2018 17:31:26 -0400 |
parents | a87b3072bd26 |
children | a2e20aba0740 |
comparison
equal
deleted
inserted
replaced
1060:c04550f957ab | 1061:671426ce0f3e |
---|---|
278 | 278 |
279 if args.analyze == 'event': # aggregate event data by 15 min interval (arg.intervalDuration), count events with thresholds | 279 if args.analyze == 'event': # aggregate event data by 15 min interval (arg.intervalDuration), count events with thresholds |
280 data = pd.read_csv(args.eventFilename, parse_dates = [2]) | 280 data = pd.read_csv(args.eventFilename, parse_dates = [2]) |
281 #data = pd.read_csv('./speeds.csv', converters = {'time': lambda s: datetime.datetime.strptime(s, "%H:%M:%S").time()}, nrows = 5000) | 281 #data = pd.read_csv('./speeds.csv', converters = {'time': lambda s: datetime.datetime.strptime(s, "%H:%M:%S").time()}, nrows = 5000) |
282 # create time for end of each 15 min, then group by, using the agg method for each data column | 282 # create time for end of each 15 min, then group by, using the agg method for each data column |
283 headers = ['sites', 'date', 'intervalend15', 'duration', 'count'] | 283 headers = ['site', 'date', 'intervalend15', 'duration', 'count'] |
284 aggFunctions, tmpheaders = utils.aggregationMethods(args.aggMethods, args.aggCentiles) | 284 aggFunctions, tmpheaders = utils.aggregationMethods(args.aggMethods, args.aggCentiles) |
285 dataColumns = list(data.columns[4:]) | 285 dataColumns = list(data.columns[4:]) |
286 for h in dataColumns: | 286 for h in dataColumns: |
287 for h2 in tmpheaders: | 287 for h2 in tmpheaders: |
288 headers.append(h+'-'+h2) | 288 headers.append(h+'-'+h2) |