7
votes
5answers
178 views

How to do DateDifference on table items containing dates

I have a Table with data in form {{date}, value}: ...
0
votes
2answers
117 views

How to partition three years of data into daily samples

I'm trying to find mean of temperature data list. The temperature data list has 3 hours steps which means I have 365*8=2920 temperature measurements per year. My data are temperatures of 13 years. ...
1
vote
1answer
148 views

Splitting dates into groups in half year steps

list = DayRange[{1999, 1, 1}, {2014, 2, 6}] I want to split this list into sublists one and a half year long, moving a half year forward every time. That would ...
3
votes
4answers
190 views

Finding the location of the last day of the month in a list of dates

My question differs from earlier questions about getting the eom dates from a list; I want to get the position of those dates so I can get the corresponding values from other lists. My problem seems ...
3
votes
4answers
229 views

Test whether date is in a certain period

I have one table which contains time periods ("start" and "end") and a "type" for every ...
6
votes
2answers
517 views

Select elements of list within a date range

I have a list which consists of elements each of which has a date in DateList format, a number and a flag (Y/N). e.g. ...
7
votes
3answers
307 views

Find all the last weekends in a year

In order to obtain the weekends of a year you'd use something like this: ...
6
votes
5answers
318 views

Handling holidays in financial time series

I have two lists: list1and list2, which are financial time series with only 2 variables—date and price. The problem is: these ...
5
votes
2answers
494 views

Finding the intersection of two date lists

I've got two lists that look like this ...
7
votes
3answers
394 views

Filter list based on date

What I would like to do is remove entries from a list of instrument data when it is in maintenance. The maintenance data I have is a series of dates which look like this; ...
11
votes
3answers
515 views

Simpler way to fill date gaps with zero values

One basic problem when working with data like sales and dates is the case where you dont't have sales in all days, so you have to fill it to take information as average or to make a plot. See this toy ...
6
votes
3answers
241 views

Importing and manipulating strings - time data

I have a list of time durations, which are strings of the form: "hh:mm:ss". Here's a sample for you to play with: ...
6
votes
2answers
191 views

DateList Segmentation of data

I've been trying to separate large segments of DateList formatted data (years worth at a time) into individual days using the Split function. The data has the form: ...
10
votes
7answers
211 views

DateList coupled with String Operations

Through some webscraping, I have the following list: ...
5
votes
2answers
373 views

From a list of dates get a list of the last date available in a each month

I wondered if anyone has another or even a more direct way of finding the last dates of each month available from a list of successive dates? I currently do the following (note: nothing special about ...