Calculating the daily sums for multiple columns in xts files

[Thanos64]

Hello,
I have an xts file with 6000 columns and 50000 rows containing hourly values of precipitation. I try to calculate the sum of the daily precipitation on each column however the colSums function doesnt work for xts objects. Even when I tranform my xts file into numeric, I still get an error

p_79_84 is my xts file`
days1 are my daily endpoints

sum_79_84<-period.apply(p_79_84, days1, colSums)

p79_84<-coredata(p_79_84)
p79_84<-p79_84[,2:5786]
p79<-as.data.frame(as.numeric(p79_84))

sum_79_84<-period.apply(p79, days1, colSums)

Any help or idea is highly appreciated

[andresrcs]

Could you please turn this into a minimal REPRoducible EXample (reprex) including sample data on a copy/paste friendly format? A reprex makes it much easier for others to understand your issue and figure out how to help.

FAQ: What's a reproducible example (`reprex`) and how do I create one?

Why reprex? Getting unstuck is hard. Your first step here is usually to create a reprex, or reproducible example. The goal of a reprex is to package your code, and information about your problem so that others can run it and feel your pain. Then, hopefully, folks can more easily provide a solution. What's in a Reproducible Example? Parts of a reproducible example: background information - Describe what you are trying to do. What have you already done? complete set up - include any library() calls and data to reproduce your issue. data for a reprex: Here's a discussion on setting up data for a reprex make it run - include the minimal code required to reproduce your error on the data…

[Thanos64]

You are right, I'll try to be more specific

Thats the code I used:

library(zoo)
library(xts)
library(timeSeries)

days1<-endpoints(p_79_84,"days")
sum_79_84<-period.apply(p_79_84, days1, colSums)

And thats a sample of the xts file I used (I show only the first 5 columns and rows)

1979-01-01 07:00:00 || 8 || 9 || 1 || 1
1979-01-01 08:00:00 || 8 || 1 || 1 || 1
1979-01-01 09:00:00 || 3 || 3 || 3 || 2
1979-01-01 10:00:00 || 3 || 3 || 6 || 9
1979-01-01 11:00:00 || 2 || 1 || 1 || 2

Sorry if my depiction of the data and the code isn't very detailed, I'm new to this site and still try to figure out how it works