Generate daily revenue based on a table
I have following table like this.
Invoice Date Payable Amount
--------------------------------
14 Sep 2015 114
23 Dec 2015 5153
28 Dec 2015 1145
28 Dec 2015 5500
28 Dec 2015 4500
29 Dec 2015 8359
30 Dec 2015 5954
30 Dec 2015 3017
30 Dec 2015 4660
31 Dec 2015 10500
31 Dec 2015 10500
So I used below code to re-format it,
Below code I converted my text column to date column using strptime.
data$`Invoice Date` = as.POSIXct(strptime(data$`Invoice Date`,format = "%d %b %Y"))
But I need to aggregate the sum(payable amount) based on date only. i.e I have 3 amount on single date(in this case 28 dec has 3 payable amount) I need to sum all three as one.
So I tried with below code,
data %>% group_by(`Invoice Date`=cut(`Invoice Date`,breaks = "day")) %>%
summarize(`Payable Amount` = sum(`Payable Amount`))
Which is not working, can anyone help.
The output I need is sum(amount) on 1 date only.
Thanks
r
asked Nov 14 '18 at 10:52
krishna31krishna31
568
add a comment |
I have following table like this.
Invoice Date Payable Amount
--------------------------------
14 Sep 2015 114
23 Dec 2015 5153
28 Dec 2015 1145
28 Dec 2015 5500
28 Dec 2015 4500
29 Dec 2015 8359
30 Dec 2015 5954
30 Dec 2015 3017
30 Dec 2015 4660
31 Dec 2015 10500
31 Dec 2015 10500
So I used below code to re-format it,
Below code I converted my text column to date column using strptime.
data$`Invoice Date` = as.POSIXct(strptime(data$`Invoice Date`,format = "%d %b %Y"))
But I need to aggregate the sum(payable amount) based on date only. i.e I have 3 amount on single date(in this case 28 dec has 3 payable amount) I need to sum all three as one.
So I tried with below code,
data %>% group_by(`Invoice Date`=cut(`Invoice Date`,breaks = "day")) %>%
summarize(`Payable Amount` = sum(`Payable Amount`))
Which is not working, can anyone help.
The output I need is sum(amount) on 1 date only.
Thanks
r
asked Nov 14 '18 at 10:52
krishna31krishna31
568
1
Following works, data %>% group_by(Invoice Date) %>% summarize(Payable Amount= sum(Payable Amount))
– krishna31
Nov 14 '18 at 11:10
be careful while handling date filelds
– sai saran
Nov 14 '18 at 11:11
Sure...Thank you
– krishna31
Nov 14 '18 at 11:17
add a comment |
I have following table like this.
Invoice Date Payable Amount
--------------------------------
14 Sep 2015 114
23 Dec 2015 5153
28 Dec 2015 1145
28 Dec 2015 5500
28 Dec 2015 4500
29 Dec 2015 8359
30 Dec 2015 5954
30 Dec 2015 3017
30 Dec 2015 4660
31 Dec 2015 10500
31 Dec 2015 10500
So I used below code to re-format it,
Below code I converted my text column to date column using strptime.
data$`Invoice Date` = as.POSIXct(strptime(data$`Invoice Date`,format = "%d %b %Y"))
But I need to aggregate the sum(payable amount) based on date only. i.e I have 3 amount on single date(in this case 28 dec has 3 payable amount) I need to sum all three as one.
So I tried with below code,
data %>% group_by(`Invoice Date`=cut(`Invoice Date`,breaks = "day")) %>%
summarize(`Payable Amount` = sum(`Payable Amount`))
Which is not working, can anyone help.
The output I need is sum(amount) on 1 date only.
Thanks
r
asked Nov 14 '18 at 10:52
krishna31krishna31
568
I have following table like this.
Invoice Date Payable Amount
--------------------------------
14 Sep 2015 114
23 Dec 2015 5153
28 Dec 2015 1145
28 Dec 2015 5500
28 Dec 2015 4500
29 Dec 2015 8359
30 Dec 2015 5954
30 Dec 2015 3017
30 Dec 2015 4660
31 Dec 2015 10500
31 Dec 2015 10500
So I used below code to re-format it,
Below code I converted my text column to date column using strptime.
data$`Invoice Date` = as.POSIXct(strptime(data$`Invoice Date`,format = "%d %b %Y"))
But I need to aggregate the sum(payable amount) based on date only. i.e I have 3 amount on single date(in this case 28 dec has 3 payable amount) I need to sum all three as one.
So I tried with below code,
data %>% group_by(`Invoice Date`=cut(`Invoice Date`,breaks = "day")) %>%
summarize(`Payable Amount` = sum(`Payable Amount`))
Which is not working, can anyone help.
The output I need is sum(amount) on 1 date only.
Thanks
r
r
asked Nov 14 '18 at 10:52
krishna31krishna31
568
asked Nov 14 '18 at 10:52
krishna31krishna31
568
asked Nov 14 '18 at 10:52
krishna31krishna31
568
asked Nov 14 '18 at 10:52
krishna31krishna31
568
asked Nov 14 '18 at 10:52
krishna31krishna31
568
568
1
Following works, data %>% group_by(Invoice Date) %>% summarize(Payable Amount= sum(Payable Amount))
– krishna31
Nov 14 '18 at 11:10
be careful while handling date filelds
– sai saran
Nov 14 '18 at 11:11
Sure...Thank you
– krishna31
Nov 14 '18 at 11:17
add a comment |
1
Following works, data %>% group_by(Invoice Date) %>% summarize(Payable Amount= sum(Payable Amount))
– krishna31
Nov 14 '18 at 11:10
be careful while handling date filelds
– sai saran
Nov 14 '18 at 11:11
Sure...Thank you
– krishna31
Nov 14 '18 at 11:17
1
1
Following works, data %>% group_by(
Invoice Date) %>% summarize(Payable Amount = sum(Payable Amount))– krishna31
Nov 14 '18 at 11:10
Following works, data %>% group_by(
Invoice Date) %>% summarize(Payable Amount = sum(Payable Amount))– krishna31
Nov 14 '18 at 11:10
be careful while handling date filelds
– sai saran
Nov 14 '18 at 11:11
be careful while handling date filelds
– sai saran
Nov 14 '18 at 11:11
Sure...Thank you
– krishna31
Nov 14 '18 at 11:17
Sure...Thank you
– krishna31
Nov 14 '18 at 11:17
add a comment |
1 Answer
1
active
oldest
votes
Following code works,
data %>% group_by(`Invoice Date`) %>%
summarize(`Payable Amount` = sum(`Payable Amount`))
answered Nov 14 '18 at 11:11
krishna31krishna31
568
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
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%2f53298493%2fgenerate-daily-revenue-based-on-a-table%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Following code works,
data %>% group_by(`Invoice Date`) %>%
summarize(`Payable Amount` = sum(`Payable Amount`))
answered Nov 14 '18 at 11:11
krishna31krishna31
568
add a comment |
Following code works,
data %>% group_by(`Invoice Date`) %>%
summarize(`Payable Amount` = sum(`Payable Amount`))
answered Nov 14 '18 at 11:11
krishna31krishna31
568
add a comment |
Following code works,
data %>% group_by(`Invoice Date`) %>%
summarize(`Payable Amount` = sum(`Payable Amount`))
answered Nov 14 '18 at 11:11
krishna31krishna31
568
Following code works,
data %>% group_by(`Invoice Date`) %>%
summarize(`Payable Amount` = sum(`Payable Amount`))
answered Nov 14 '18 at 11:11
krishna31krishna31
568
answered Nov 14 '18 at 11:11
krishna31krishna31
568
answered Nov 14 '18 at 11:11
krishna31krishna31
568
answered Nov 14 '18 at 11:11
krishna31krishna31
568
568
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
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%2f53298493%2fgenerate-daily-revenue-based-on-a-table%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
1
Following works, data %>% group_by(
Invoice Date) %>% summarize(Payable Amount= sum(Payable Amount))– krishna31
Nov 14 '18 at 11:10
be careful while handling date filelds
– sai saran
Nov 14 '18 at 11:11
Sure...Thank you
– krishna31
Nov 14 '18 at 11:17