Home »
Public Forums »
archive »
code help
| code help [message #75589] |
Thu, 31 March 2011 05:22 |
smuzz
Messages: 7
Registered: January 2011
|
Junior Member |
|
|
Hi ---
I am new to programming in IDL and am trying to write a code to avoid
wasting hundreds of hours fighting with excel.
My data: I have a .csv file with 2 columns. One column has the date
(mm/dd/yyyy) and the second column has timestamps (hh:mm:ss). Each
timestamp represents an incidence of a whale call occurrence. See
below:
11/20/2007 00:00:53
11/20/2007 00:10:42
11/20/2007 00:17:50
11/20/2007 05:23:56
11/20/2007 05:00:10
11/20/2007 07:10:01
11/21/2007 01:20:23
11/21/2007 01:21:34
...........
My objectives: I would like to sum the number of whale call
occurrences in each hour for the day (hours 0 - 23). Most days have
hours without any whale call occurrences, so those are not accounted
for in my .csv file above. Ideally for each day I am trying to get my
data to look like this (including both absence and presence of whale
call occurrences):
11/20/2007
0 3
1 0
2 0
3 0
4 0
5 2
6 0
7 1
8 0
9 0
10 0
....
23
11/21/2007
0
1
2
3
....
23
Any suggestions would be greatly appreciated!
Thanks, S
|
|
|
|
Current Time: Wed Oct 08 11:44:10 PDT 2025
Total time taken to generate the page: 0.00483 seconds
comp.lang.idl-pvwave archive
Members
Search
Help
Login
Home
