search for: energykwh

Displaying 6 results from an estimated 6 matches for "energykwh".

Sum data according to date in sequence
2023 Nov 03
2
Sum data according to date in sequence
Hi, I tried this: # extract date from the time stamp dt1 <- cbind(as.Date(dt$EndDate, format="%m/%d/%Y"), dt$EnergykWh) head(dt1) colnames(dt1) <- c("date", "EnergykWh") and my dt1 becomes these, the dates are replace by numbers. dt1 <- cbind(as.Date(dt$EndDate, format="%m/%d/%Y"), dt$EnergykWh) dput(head(dt1)) colnames(dt1) <- c("date", "EnergykWh") dput(...
Sum data according to date in sequence
2023 Nov 02
4
Sum data according to date in sequence
Dear all, I have this set of data. I would like to sum the EnergykWh according date sequences. > head(dt1,20) StationName date time EnergykWh 1 PALO ALTO CA / CAMBRIDGE #1 1/14/2016 12:09 4.680496 2 PALO ALTO CA / CAMBRIDGE #1 1/14/2016 19:50 6.272414 3 PALO ALTO CA / CAMBRIDGE #1 1/14/2016 20:22 1.032782 4 PALO ALTO CA / CAMBRIDGE...
Sum data according to date in sequence
2023 Nov 03
1
Sum data according to date in sequence
...23", "18:17", "21:46", "10:19", "12:12", "14:12", "16:22", "19:16", "19:19", "20:24", "9:54", "12:16", "13:53", "19:03", "22:00", "8:58"), EnergykWh = c(4.680496, 6.272414, 1.032782, 11.004884, 10.096824, 6.658797, 4.808874, 1.469384, 2.996239, 0.303222, 4.988339, 8.131804, 0.117156, 3.285669, 1.175608, 3.677487, 1.068393, 8.820755, 8.138583, 9.0575)), row.names = c(NA, 20L), class = "data.frame") # convert date from character...
Sum data according to date in sequence
2023 Nov 04
2
Sum data according to date in sequence
...uot;, "18:17", "21:46", "10:19", "12:12", > "14:12", "16:22", "19:16", "19:19", "20:24", "9:54", "12:16", > "13:53", "19:03", "22:00", "8:58"), EnergykWh = c(4.680496, 6.272414, > 1.032782, 11.004884, 10.096824, 6.658797, 4.808874, 1.469384, > 2.996239, 0.303222, 4.988339, 8.131804, 0.117156, 3.285669, 1.175608, > 3.677487, 1.068393, 8.820755, 8.138583, 9.0575)), row.names = c(NA, > 20L), class = "data.frame") > > >...
Sum data according to date in sequence
2023 Nov 03
1
Sum data according to date in sequence
...ot;14:23", "18:17", "21:46", "10:19", "12:12", "14:12", "16:22", "19:16", "19:19", "20:24", "9:54", "12:16", "13:53", "19:03", "22:00", "8:58"), EnergykWh = c(4.680496, 6.272414, 1.032782, 11.004884, 10.096824, 6.658797, 4.808874, 1.469384, 2.996239, 0.303222, 4.988339, 8.131804, 0.117156, 3.285669, 1.175608, 3.677487, 1.068393, 8.820755, 8.138583, 9.0575)), row.names = c(NA, 20L), class = "data.frame") I would like to sum EnergykW data b...
Sum data according to date in sequence
2023 Nov 03
1
Sum data according to date in sequence
...*Data Munger Guru* *What is the problem that you are trying to solve?Tell me what you want to do, not how you want to do it.* On Thu, Nov 2, 2023 at 4:24?PM roslinazairimah zakaria <roslinaump at gmail.com> wrote: > Dear all, > > I have this set of data. I would like to sum the EnergykWh according date > sequences. > > > head(dt1,20) StationName date time EnergykWh > 1 PALO ALTO CA / CAMBRIDGE #1 1/14/2016 12:09 4.680496 > 2 PALO ALTO CA / CAMBRIDGE #1 1/14/2016 19:50 6.272414 > 3 PALO ALTO CA / CAMBRIDGE #1 1/14/2016 20:22 1.03278...