Adding Rows in R for large dataset
up vote
1
down vote
favorite
I am new to R . I have a large dataset with 1-minute resolution for one year . It makes total of 55940 observation all 1 minute apart with dates and times . I want to change it to six minute resolution data. It necessarily means adding first 6 rows then next 6 and so on so forth . Any good solutions ?
r
asked Nov 8 at 10:26
Shah
61
New contributor
Shah is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
up vote
1
down vote
favorite
I am new to R . I have a large dataset with 1-minute resolution for one year . It makes total of 55940 observation all 1 minute apart with dates and times . I want to change it to six minute resolution data. It necessarily means adding first 6 rows then next 6 and so on so forth . Any good solutions ?
r
asked Nov 8 at 10:26
Shah
61
New contributor
Shah is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add sample data or head(data)
– sai saran
Nov 8 at 10:28
What is your goal? You want end up with a dataset with less raws? Would you like average your values over each 6 rows interval? Would you like to pickup one row every six? Could this So question be useful? stackoverflow.com/questions/23279550/…
– paoloeusebi
Nov 8 at 10:46
Search for "rolling sum".
– zx8754
Nov 8 at 11:02
add a comment |
up vote
1
down vote
favorite
up vote
1
down vote
favorite
I am new to R . I have a large dataset with 1-minute resolution for one year . It makes total of 55940 observation all 1 minute apart with dates and times . I want to change it to six minute resolution data. It necessarily means adding first 6 rows then next 6 and so on so forth . Any good solutions ?
r
asked Nov 8 at 10:26
Shah
61
New contributor
Shah is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I am new to R . I have a large dataset with 1-minute resolution for one year . It makes total of 55940 observation all 1 minute apart with dates and times . I want to change it to six minute resolution data. It necessarily means adding first 6 rows then next 6 and so on so forth . Any good solutions ?
r
r
asked Nov 8 at 10:26
Shah
61
New contributor
Shah is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked Nov 8 at 10:26
Shah
61
New contributor
Shah is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked Nov 8 at 10:26
Shah
61
New contributor
Shah is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked Nov 8 at 10:26
Shah
61
asked Nov 8 at 10:26
Shah
61
61
New contributor
Shah is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Shah is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Shah is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add sample data or head(data)
– sai saran
Nov 8 at 10:28
What is your goal? You want end up with a dataset with less raws? Would you like average your values over each 6 rows interval? Would you like to pickup one row every six? Could this So question be useful? stackoverflow.com/questions/23279550/…
– paoloeusebi
Nov 8 at 10:46
Search for "rolling sum".
– zx8754
Nov 8 at 11:02
add a comment |
add sample data or head(data)
– sai saran
Nov 8 at 10:28
What is your goal? You want end up with a dataset with less raws? Would you like average your values over each 6 rows interval? Would you like to pickup one row every six? Could this So question be useful? stackoverflow.com/questions/23279550/…
– paoloeusebi
Nov 8 at 10:46
Search for "rolling sum".
– zx8754
Nov 8 at 11:02
add sample data or head(data)
– sai saran
Nov 8 at 10:28
add sample data or head(data)
– sai saran
Nov 8 at 10:28
What is your goal? You want end up with a dataset with less raws? Would you like average your values over each 6 rows interval? Would you like to pickup one row every six? Could this So question be useful? stackoverflow.com/questions/23279550/…
– paoloeusebi
Nov 8 at 10:46
What is your goal? You want end up with a dataset with less raws? Would you like average your values over each 6 rows interval? Would you like to pickup one row every six? Could this So question be useful? stackoverflow.com/questions/23279550/…
– paoloeusebi
Nov 8 at 10:46
Search for "rolling sum".
– zx8754
Nov 8 at 11:02
Search for "rolling sum".
– zx8754
Nov 8 at 11:02
add a comment |
2 Answers
2
active
oldest
votes
up vote
1
down vote
You could try something like this:
library(dplyr)
# original df
df <- data.frame(min = 1:60, val = rnorm(60))
# create a grouping variable and add to df
grp <- floor(df$min / 6)
df <- data.frame(grp, df)
# create new df at 6 min level
new.df <- df %>%
group_by(grp) %>%
summarise(new.val = sum(val))
answered Nov 8 at 10:49
Cleland
1356
add a comment |
up vote
1
down vote
Another option with a similar approach
library(dplyr)
# original dataframe
n <- 55940
df <- data.frame(id = 1:n , val = rnorm(n))
# new dataframe
df_new <- df %>%
group_by(cut(df$id, n/6)) %>%
summarise(new.val = sum(val))
answered Nov 8 at 11:11
paoloeusebi
36119
add a comment |
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
1
down vote
You could try something like this:
library(dplyr)
# original df
df <- data.frame(min = 1:60, val = rnorm(60))
# create a grouping variable and add to df
grp <- floor(df$min / 6)
df <- data.frame(grp, df)
# create new df at 6 min level
new.df <- df %>%
group_by(grp) %>%
summarise(new.val = sum(val))
answered Nov 8 at 10:49
Cleland
1356
add a comment |
up vote
1
down vote
You could try something like this:
library(dplyr)
# original df
df <- data.frame(min = 1:60, val = rnorm(60))
# create a grouping variable and add to df
grp <- floor(df$min / 6)
df <- data.frame(grp, df)
# create new df at 6 min level
new.df <- df %>%
group_by(grp) %>%
summarise(new.val = sum(val))
answered Nov 8 at 10:49
Cleland
1356
add a comment |
up vote
1
down vote
up vote
1
down vote
You could try something like this:
library(dplyr)
# original df
df <- data.frame(min = 1:60, val = rnorm(60))
# create a grouping variable and add to df
grp <- floor(df$min / 6)
df <- data.frame(grp, df)
# create new df at 6 min level
new.df <- df %>%
group_by(grp) %>%
summarise(new.val = sum(val))
answered Nov 8 at 10:49
Cleland
1356
You could try something like this:
library(dplyr)
# original df
df <- data.frame(min = 1:60, val = rnorm(60))
# create a grouping variable and add to df
grp <- floor(df$min / 6)
df <- data.frame(grp, df)
# create new df at 6 min level
new.df <- df %>%
group_by(grp) %>%
summarise(new.val = sum(val))
answered Nov 8 at 10:49
Cleland
1356
answered Nov 8 at 10:49
Cleland
1356
answered Nov 8 at 10:49
Cleland
1356
answered Nov 8 at 10:49
Cleland
1356
1356
add a comment |
add a comment |
up vote
1
down vote
Another option with a similar approach
library(dplyr)
# original dataframe
n <- 55940
df <- data.frame(id = 1:n , val = rnorm(n))
# new dataframe
df_new <- df %>%
group_by(cut(df$id, n/6)) %>%
summarise(new.val = sum(val))
answered Nov 8 at 11:11
paoloeusebi
36119
add a comment |
up vote
1
down vote
Another option with a similar approach
library(dplyr)
# original dataframe
n <- 55940
df <- data.frame(id = 1:n , val = rnorm(n))
# new dataframe
df_new <- df %>%
group_by(cut(df$id, n/6)) %>%
summarise(new.val = sum(val))
answered Nov 8 at 11:11
paoloeusebi
36119
add a comment |
up vote
1
down vote
up vote
1
down vote
Another option with a similar approach
library(dplyr)
# original dataframe
n <- 55940
df <- data.frame(id = 1:n , val = rnorm(n))
# new dataframe
df_new <- df %>%
group_by(cut(df$id, n/6)) %>%
summarise(new.val = sum(val))
answered Nov 8 at 11:11
paoloeusebi
36119
Another option with a similar approach
library(dplyr)
# original dataframe
n <- 55940
df <- data.frame(id = 1:n , val = rnorm(n))
# new dataframe
df_new <- df %>%
group_by(cut(df$id, n/6)) %>%
summarise(new.val = sum(val))
answered Nov 8 at 11:11
paoloeusebi
36119
answered Nov 8 at 11:11
paoloeusebi
36119
answered Nov 8 at 11:11
paoloeusebi
36119
answered Nov 8 at 11:11
paoloeusebi
36119
36119
add a comment |
add a comment |
Shah is a new contributor. Be nice, and check out our Code of Conduct.
draft saved
draft discarded
Shah is a new contributor. Be nice, and check out our Code of Conduct.
Shah is a new contributor. Be nice, and check out our Code of Conduct.
Shah is a new contributor. Be nice, and check out our Code of Conduct.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53205808%2fadding-rows-in-r-for-large-dataset%23new-answer', 'question_page');
}
);
Post as a guest
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
add sample data or head(data)
– sai saran
Nov 8 at 10:28
What is your goal? You want end up with a dataset with less raws? Would you like average your values over each 6 rows interval? Would you like to pickup one row every six? Could this So question be useful? stackoverflow.com/questions/23279550/…
– paoloeusebi
Nov 8 at 10:46
Search for "rolling sum".
– zx8754
Nov 8 at 11:02