Re: Date density diagram

Tobias Weber wrote:
Hi

I have a lot of data like "list of dates it did not rain in London" and want to do diagrams that show when something occurs more often than usual.

I tried assigning a value of 1 to each date and doing subtotals by week. Unfortunately this kind of histogram will smooth over a significant rise in density if e.g. Saturday and Tuesday were sunny.

So I calculated in a column how many days ago the last event occured, which projected over time and inverted kind of works, but breaks down when the event occurs every third day on average but every day at high times. The differences are just too small.

What I'd need is something that grows when dates cluster.

And something less annoying than Excel. I looked into R, but dates seem to be second class citizens there.


Without an example it is rather difficult to see what you want.


Re R and dates have a look at the chron and zoo packages.

--
John Kane, Kingston ON Canada
.

Loading