I have dataset of the following form. I have processed the dates to be DateObjects
and now would like to merge the hours per the date because sometimes multiple types of tasks were done on the same day.
I was a bit surprised there wasn't a built-in function to do this but perhaps there is and I missed it in the docs? Right now I thought I would ask for help before going too far down this path because I can see this getting very convoluted very quickly. Is there a more Mathematica-centric way to do this? In Python with pandas I'd probably use a for-loop
& append
a list with the sums.
comparelist = Partition[Range[Length@data],2,1]
MatchQ[data[#[[1]],"Date"],data[#[[2]],"Date"]] &/@ comparelist
{False,False,False,False,False,False,False,False,False,False,False,False,False,False,False,False,False,True,True,False,False,False,False,False,False,False,False,False,False,False,False,True,False,False,False,False,False,False,True,False,False,False,False,True,False,False,False,False,False,False,False,False,False,True,False,False,False,False,False,False,False,False,True,False,False,False,False,True}