How do I create a dataset using computed values?
up vote
0
down vote
favorite
Please see here the input and desired output tables.
I have a dataset (df_report) that looks like this:
city <- c("New York","Mexico City","Cape Town")
A <- c(3,4,1)
B <- c(5,1,3)
C <- c(0,3,2)
category <- c("Complete","Incomplete","Complete")
df_report <- data.frame(city, category, A, B, C)
Then the logic/ formula for the variables:
RB_1 <- df_report["Complete","A"] + df_report["Complete","B"]
RB_2 <- sum(df_report["Incomplete",]) - df_report["Incomplete","C"]
RB_3 <- sum(df_report["Complete",])
RB_4 <- RB_1 + RB_2
How do I make a separate dataset with the following? Row header: Variable; Column: City
r dataset aggregate
asked Nov 9 at 13:15
tiffinie
613
|
show 2 more comments
up vote
0
down vote
favorite
Please see here the input and desired output tables.
I have a dataset (df_report) that looks like this:
city <- c("New York","Mexico City","Cape Town")
A <- c(3,4,1)
B <- c(5,1,3)
C <- c(0,3,2)
category <- c("Complete","Incomplete","Complete")
df_report <- data.frame(city, category, A, B, C)
Then the logic/ formula for the variables:
RB_1 <- df_report["Complete","A"] + df_report["Complete","B"]
RB_2 <- sum(df_report["Incomplete",]) - df_report["Incomplete","C"]
RB_3 <- sum(df_report["Complete",])
RB_4 <- RB_1 + RB_2
How do I make a separate dataset with the following? Row header: Variable; Column: City
r dataset aggregate
asked Nov 9 at 13:15
tiffinie
613
2
How your result should looks like?
– jogo
Nov 9 at 13:17
Do you want to create a data frame with specified column names like so:RB_4 <- data.frame(Variable=RB_1, City=RB_2)or what?
– eikooc
Nov 9 at 13:19
Sorry, corrected. The output should be, rows are RB_1, RB_2, etc. Columns are cities.
– tiffinie
Nov 9 at 13:20
1
Error in FUN(X[[i]], ...) : only defined on a data frame with all numeric variablesandError in FUN(X[[i]], ...) : only defined on a data frame with all numeric variables
– Andre Elrico
Nov 9 at 13:23
1
There's no row name'Complete'sodf_report["Complete","A"]results inNA. Did you meandf_report[df_report['category'] == "Complete","A"]? The latter subsetting results in vector of two elements - what should be a desired value ofRB_1?
– Kuba_
Nov 9 at 13:28
|
show 2 more comments
up vote
0
down vote
favorite
up vote
0
down vote
favorite
Please see here the input and desired output tables.
I have a dataset (df_report) that looks like this:
city <- c("New York","Mexico City","Cape Town")
A <- c(3,4,1)
B <- c(5,1,3)
C <- c(0,3,2)
category <- c("Complete","Incomplete","Complete")
df_report <- data.frame(city, category, A, B, C)
Then the logic/ formula for the variables:
RB_1 <- df_report["Complete","A"] + df_report["Complete","B"]
RB_2 <- sum(df_report["Incomplete",]) - df_report["Incomplete","C"]
RB_3 <- sum(df_report["Complete",])
RB_4 <- RB_1 + RB_2
How do I make a separate dataset with the following? Row header: Variable; Column: City
r dataset aggregate
asked Nov 9 at 13:15
tiffinie
613
Please see here the input and desired output tables.
I have a dataset (df_report) that looks like this:
city <- c("New York","Mexico City","Cape Town")
A <- c(3,4,1)
B <- c(5,1,3)
C <- c(0,3,2)
category <- c("Complete","Incomplete","Complete")
df_report <- data.frame(city, category, A, B, C)
Then the logic/ formula for the variables:
RB_1 <- df_report["Complete","A"] + df_report["Complete","B"]
RB_2 <- sum(df_report["Incomplete",]) - df_report["Incomplete","C"]
RB_3 <- sum(df_report["Complete",])
RB_4 <- RB_1 + RB_2
How do I make a separate dataset with the following? Row header: Variable; Column: City
r dataset aggregate
r dataset aggregate
asked Nov 9 at 13:15
tiffinie
613
asked Nov 9 at 13:15
tiffinie
613
edited Nov 9 at 13:39
asked Nov 9 at 13:15
tiffinie
613
asked Nov 9 at 13:15
tiffinie
613
asked Nov 9 at 13:15
tiffinie
613
613
2
How your result should looks like?
– jogo
Nov 9 at 13:17
Do you want to create a data frame with specified column names like so:RB_4 <- data.frame(Variable=RB_1, City=RB_2)or what?
– eikooc
Nov 9 at 13:19
Sorry, corrected. The output should be, rows are RB_1, RB_2, etc. Columns are cities.
– tiffinie
Nov 9 at 13:20
1
Error in FUN(X[[i]], ...) : only defined on a data frame with all numeric variablesandError in FUN(X[[i]], ...) : only defined on a data frame with all numeric variables
– Andre Elrico
Nov 9 at 13:23
1
There's no row name'Complete'sodf_report["Complete","A"]results inNA. Did you meandf_report[df_report['category'] == "Complete","A"]? The latter subsetting results in vector of two elements - what should be a desired value ofRB_1?
– Kuba_
Nov 9 at 13:28
|
show 2 more comments
2
How your result should looks like?
– jogo
Nov 9 at 13:17
Do you want to create a data frame with specified column names like so:RB_4 <- data.frame(Variable=RB_1, City=RB_2)or what?
– eikooc
Nov 9 at 13:19
Sorry, corrected. The output should be, rows are RB_1, RB_2, etc. Columns are cities.
– tiffinie
Nov 9 at 13:20
1
Error in FUN(X[[i]], ...) : only defined on a data frame with all numeric variablesandError in FUN(X[[i]], ...) : only defined on a data frame with all numeric variables
– Andre Elrico
Nov 9 at 13:23
1
There's no row name'Complete'sodf_report["Complete","A"]results inNA. Did you meandf_report[df_report['category'] == "Complete","A"]? The latter subsetting results in vector of two elements - what should be a desired value ofRB_1?
– Kuba_
Nov 9 at 13:28
2
2
How your result should looks like?
– jogo
Nov 9 at 13:17
How your result should looks like?
– jogo
Nov 9 at 13:17
Do you want to create a data frame with specified column names like so:
RB_4 <- data.frame(Variable=RB_1, City=RB_2) or what?– eikooc
Nov 9 at 13:19
Do you want to create a data frame with specified column names like so:
RB_4 <- data.frame(Variable=RB_1, City=RB_2) or what?– eikooc
Nov 9 at 13:19
Sorry, corrected. The output should be, rows are RB_1, RB_2, etc. Columns are cities.
– tiffinie
Nov 9 at 13:20
Sorry, corrected. The output should be, rows are RB_1, RB_2, etc. Columns are cities.
– tiffinie
Nov 9 at 13:20
1
1
Error in FUN(X[[i]], ...) : only defined on a data frame with all numeric variables and Error in FUN(X[[i]], ...) : only defined on a data frame with all numeric variables– Andre Elrico
Nov 9 at 13:23
Error in FUN(X[[i]], ...) : only defined on a data frame with all numeric variables and Error in FUN(X[[i]], ...) : only defined on a data frame with all numeric variables– Andre Elrico
Nov 9 at 13:23
1
1
There's no row name
'Complete' so df_report["Complete","A"] results in NA. Did you mean df_report[df_report['category'] == "Complete","A"]? The latter subsetting results in vector of two elements - what should be a desired value of RB_1?– Kuba_
Nov 9 at 13:28
There's no row name
'Complete' so df_report["Complete","A"] results in NA. Did you mean df_report[df_report['category'] == "Complete","A"]? The latter subsetting results in vector of two elements - what should be a desired value of RB_1?– Kuba_
Nov 9 at 13:28
|
show 2 more comments
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
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
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53226410%2fhow-do-i-create-a-dataset-using-computed-values%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
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
Required, but never shown
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
Required, but never shown
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
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
2
How your result should looks like?
– jogo
Nov 9 at 13:17
Do you want to create a data frame with specified column names like so:
RB_4 <- data.frame(Variable=RB_1, City=RB_2)or what?– eikooc
Nov 9 at 13:19
Sorry, corrected. The output should be, rows are RB_1, RB_2, etc. Columns are cities.
– tiffinie
Nov 9 at 13:20
1
Error in FUN(X[[i]], ...) : only defined on a data frame with all numeric variablesandError in FUN(X[[i]], ...) : only defined on a data frame with all numeric variables– Andre Elrico
Nov 9 at 13:23
1
There's no row name
'Complete'sodf_report["Complete","A"]results inNA. Did you meandf_report[df_report['category'] == "Complete","A"]? The latter subsetting results in vector of two elements - what should be a desired value ofRB_1?– Kuba_
Nov 9 at 13:28