I have Excel file consisting of two columns such as:
1.2.2014 23:35 |-0.007378
1.2.2014 23:40 |-0.004121
1.2.2014 23:45 |-0.000122
1.2.2014 23:50 |0.000117
1.2.2014 23:55 |-0.000542
When I import that in Mathematica, it creates list like:
List={{1.2.2014 23:35, -0.007378}, {1.2.2014 23:40, -0.004121}, ..., {2.2.2014 00:00, -0.004897}, {2.2.2014 00:05, -0.005179}, ...}
And I need to create a list where only the values from the second column will be and these values will create sublists based on the day of observations. So it should look like (based on "List" above):
List2={{-0.007378, -0.004121, ...}, {-0.004897, -0.005179, ...}, ...}.
The question may be very similar to this one: Split dataset based on the first column ...but I cannot figure out how the mentioned method should be applied in my case, where I have dates in the first column.
Thanks for any help. And sorry if it is an easy problem, but I am still begginer with Mathematica.
Import
, or at least a truncated version of it. Some or all of the data is probably inString
form, though this is not shown in your current excerpt. This will change how the data is handled. $\endgroup$list=Import[(*your file*)];
Partition[list[[All,2]],2]
$\endgroup$