Ruby - Sorting by id and grouping by date in hash

user_7952432 0
Viewed 43

I've been struggling with this in a bit and could not get a satisfactory result. I have this hash:

{"idprj"=>13351, "prevInicioStr"=>"21/10/2019"}
{"idprj"=>14473, "prevInicioStr"=>"22/10/2019"}
{"idprj"=>14165, "prevInicioStr"=>"23/10/2019"}
{"idprj"=>14165, "prevInicioStr"=>"23/10/2019"}
{"idprj"=>14165, "prevInicioStr"=>"28/10/2019"}
{"idprj"=>14165, "prevInicioStr"=>"28/10/2019"}
{"idprj"=>14518, "prevInicioStr"=>"29/10/2019"}
{"idprj"=>14518, "prevInicioStr"=>"29/10/2019"}
{"idprj"=>13351, "prevInicioStr"=>"05/11/2019"}
{"idprj"=>14305, "prevInicioStr"=>"06/11/2019"}
{"idprj"=>14305, "prevInicioStr"=>"08/11/2019"}
{"idprj"=>14305, "prevInicioStr"=>"13/01/2020"}

And I wanted to sort by 'prevInicioStr' AND group by 'idprj' (you can see id 13351 isn't grouped as it should). To get this result I did this:

result.sort_by { |hash| [ Date.parse(hash['prevInicioStr']), hash['idprj'] ] }
grouping hash sorting ruby
1 Answers

You must group first, and then sort (actually, you sort the values):

data = [{"idprj"=>13351, "prevInicioStr"=>"21/10/2019"}, {"idprj"=>14473, "prevInicioStr"=>"22/10/2019"}, {"idprj"=>14165, "prevInicioStr"=>"23/10/2019"}, {"idprj"=>14165, "prevInicioStr"=>"23/10/2019"}, {"idprj"=>14165, "prevInicioStr"=>"28/10/2019"}, {"idprj"=>14165, "prevInicioStr"=>"28/10/2019"}, {"idprj"=>14518, "prevInicioStr"=>"29/10/2019"}, {"idprj"=>14518, "prevInicioStr"=>"29/10/2019"}, {"idprj"=>13351, "prevInicioStr"=>"05/11/2019"}, {"idprj"=>14305, "prevInicioStr"=>"06/11/2019"}, {"idprj"=>14305, "prevInicioStr"=>"08/11/2019"}, {"idprj"=>14305, "prevInicioStr"=>"13/01/2020"}]
pp data.group_by { |e| e['idprj'] }
       .transform_values { |values| values.sort_by { |e| e['prevInicioStr'] } }

# {13351=>
#   [{"idprj"=>13351, "prevInicioStr"=>"05/11/2019"},
#    {"idprj"=>13351, "prevInicioStr"=>"21/10/2019"}],
#  14473=>[{"idprj"=>14473, "prevInicioStr"=>"22/10/2019"}],
#  14165=>
#   [{"idprj"=>14165, "prevInicioStr"=>"23/10/2019"},
#    {"idprj"=>14165, "prevInicioStr"=>"23/10/2019"},
#    {"idprj"=>14165, "prevInicioStr"=>"28/10/2019"},
#    {"idprj"=>14165, "prevInicioStr"=>"28/10/2019"}],
#  14518=>
#   [{"idprj"=>14518, "prevInicioStr"=>"29/10/2019"},
#    {"idprj"=>14518, "prevInicioStr"=>"29/10/2019"}],
#  14305=>
#   [{"idprj"=>14305, "prevInicioStr"=>"06/11/2019"},
#    {"idprj"=>14305, "prevInicioStr"=>"08/11/2019"},
#    {"idprj"=>14305, "prevInicioStr"=>"13/01/2020"}]}
user_50251160
Related