In Postgres you can do: @user.comments.group(“DATE_TRUNC(‘month’, created_at)”).count to get: {“2012-08-01 00:00:00″=>152, “2012-07-01 00:00:00″=>57, “2012-09-01 00:00:00″=>132} It accepts values from “microseconds” to “millennium” for grouping: http://www.postgresql.org/docs/8.1/static/functions-datetime.html#FUNCTIONS-DATETIME-TRUNC
values = set(map(lambda x:x[1], mylist)) newlist = [[y[0] for y in mylist if y[1]==x] for x in values]
$arr = array(); foreach ($old_arr as $key => $item) { $arr[$item[‘id’]][$key] = $item; } ksort($arr, SORT_NUMERIC);
There should be more elegant solutions, but simplest one I can think of would be this. // The data you have pasted in the question $data = []; $groups = []; // Go through the entire array $data foreach($data as $item){ // If the key doesn’t exist in the new array yet, add it if(!array_key_exists($item[1], … Read more
Best way, if you have control over building the initial array, is just set things up like that at the start as you add entries. If not then build a temporary array to sort: foreach ($input_arr as $key => &$entry) { $level_arr[$entry[‘level’]][$key] = $entry; } Leaves you with the form you wanted and everything referenced … Read more
EDIT 2: To answer the OP new requirement ranges = [] for key, group in groupby(enumerate(data), lambda (index, item): index – item): group = map(itemgetter(1), group) if len(group) > 1: ranges.append(xrange(group[0], group[-1])) else: ranges.append(group[0]) Output: [xrange(2, 5), xrange(12, 17), 20] You can replace xrange with range or any other custom class. Python docs have a … Read more
You can use the PHP function array_merge_recursive. See the example: <?php $ar1 = array(“color” => array(“favorite” => “red”), 5); $ar2 = array(10, “color” => array(“favorite” => “green”, “blue”)); $result = array_merge_recursive($ar1, $ar2); print_r($result); ?>
itertools.groupby can do what you want: import itertools import operator L = [(‘grape’, 100), (‘grape’, 3), (‘apple’, 15), (‘apple’, 10), (‘apple’, 4), (‘banana’, 3)] def accumulate(l): it = itertools.groupby(l, operator.itemgetter(0)) for key, subiter in it: yield key, sum(item[1] for item in subiter) print(list(accumulate(L))) # [(‘grape’, 103), (‘apple’, 29), (‘banana’, 3)]
you can try array_reduce: $someVariable=”someValue”; $result = array_reduce(array_merge($array1, $array2), function ($carry, $item) use ($someVariable) { if (isset($carry[$item[‘category_id’]])) { $carry[$item[‘category_id’]] = array_merge($carry[$item[‘category_id’]], $item); } else { $carry[$item[‘category_id’]] = $item; } return $carry; }, array()); var_dump($result);
This function should do the job. function groupByPartAndType($input) { $output = Array(); foreach($input as $value) { $output_element = &$output[$value[‘part’] . “_” . $value[‘type’]]; $output_element[‘part’] = $value[‘part’]; $output_element[‘type’] = $value[‘type’]; !isset($output_element[‘count’]) && $output_element[‘count’] = 0; $output_element[‘count’] += $value[‘count’]; } return array_values($output); } If both databases are on the same database server you would be able to … Read more