Help to organize data

Hi everybody,

My name is Jackson and come here ask for a help to organize data.
I really need help from you. I have several data sets to organize.

I have to summarize precipitation data collected in different days and
months in only one table.
However, those data are disperse in days and times. Those rainy days have a
more observations than drought ones.

Below you can find a hypothetical example of what I have and I what I need
comes in sequence.

The following table is what I have for a single year.
Notice that number of observations varies from day to day entire year.



*Day*

*Time*

*Prec*

Jan



1

7:00

20mm

1

7:20

15mm

1

7:30

5mm

2

6:00

10mm

2

15:00

16mm

...

...

...mm

31

7:00

2mm

Feb

1

9:00

6mm

1

9:45

30mm

2

6:45

12mm

2

16:00

20mm

2

22:00

60mm

*...*

*...*

*...mm*

28

11:30

25mm

*...*

*...*

*...*

*...mm*

Dec

31

*...*

*...mm*

That way is hard to develop analysis comparing to another year.
Thus, I would like summarize all information in a new (reasonable) table.

I need a command that says: Sum all January 1st, Sum all January 2nd  until
December 31st resulting in something as follows.

*Month       Day->*

*1*

*2*

*3*

*4*

*...*

*31*

*Jan*

40mm

16mm

50mm

66mm

...mm

90mm

*Feb*

60mm

120mm

25mm

45mm

...mm


*...*

...mm

...mm

...mm

...mm

...mm

...mm

*Dec*

120mm

30mm

26mm

90mm

...mm

5mm

The question is: How to manage it?

Does anybody could help me?

Thank you very much in advance

With the best wishes

Jackson M. Rodrigues

This is pretty badly mangled (please don't post in html), but
?aggregate
is probably what you want.

Sarah

On Sun, Jun 25, 2017 at 5:27 PM, Jackson Rodrigues
<jacksonmrodrigues at gmail.com> wrote:

Hi everybody,

My name is Jackson and come here ask for a help to organize data.
I really need help from you. I have several data sets to organize.

I have to summarize precipitation data collected in different days and
months in only one table.
However, those data are disperse in days and times. Those rainy days

have a

more observations than drought ones.

Below you can find a hypothetical example of what I have and I what I

need

comes in sequence.

The following table is what I have for a single year.
Notice that number of observations varies from day to day entire year.



*Day*

*Time*

*Prec*

Jan



1

7:00

20mm

1

7:20

15mm

1

7:30

5mm

2

6:00

10mm

2

15:00

16mm

...

...

...mm

31

7:00

2mm

Feb

1

9:00

6mm

1

9:45

30mm

2

6:45

12mm

2

16:00

20mm

2

22:00

60mm

*...*

*...*

*...mm*

28

11:30

25mm

*...*

*...*

*...*

*...mm*

Dec

31

*...*

*...mm*

That way is hard to develop analysis comparing to another year.
Thus, I would like summarize all information in a new (reasonable) table.

I need a command that says: Sum all January 1st, Sum all January 2nd

until

December 31st resulting in something as follows.

*Month       Day->*

*1*

*2*

*3*

*4*

*...*

*31*

*Jan*

40mm

16mm

50mm

66mm

...mm

90mm

*Feb*

60mm

120mm

25mm

45mm

...mm


*...*

...mm

...mm

...mm

...mm

...mm

...mm

*Dec*

120mm

30mm

26mm

90mm

...mm

5mm

The question is: How to manage it?

Does anybody could help me?

Thank you very much in advance

With the best wishes

Jackson M. Rodrigues

--
Sarah Goslee
http://www.functionaldiversity.org