Calculate mean for each date using the 11 unique entries on/before that date
I want to calculate the mean for Approve and also (can be done separately) Disapprove for every given date using the newest 11 polls were the poll name is unique.
So when calculating the average for 2018-11-03 I would take the average of row numbers 6,7,8,9,10,11,12,15,etc down the column with no duplicates.
head(newpoll1,n=16)
Poll Approve Disapprove Spread Date
2 NBC News/Wall St. JrnlNBC/WSJ 46 52 -6 2018-11-04
3 CNNCNN 41 57 -16 2018-11-04
4 Rasmussen ReportsRasmussen 50 49 +1 2018-11-04
5 GallupGallup 40 54 -14 2018-11-04
6 ABC News/Wash PostABC/WP 44 52 -8 2018-11-03
7 IBD/TIPPIBD/TIPP 40 53 -13 2018-11-03
8 Economist/YouGovEconomist 44 52 -8 2018-10-30
9 NPR/PBS/MaristNPR/PBS/Marist 41 53 -12 2018-10-30
10 Harvard-HarrisHarvard-Harris 44 56 -12 2018-10-30
11 Reuters/IpsosReuters 45 54 -9 2018-10-30
12 GallupGallup 40 54 -14 2018-10-28
13 Economist/YouGovEconomist 45 52 -7 2018-10-23
14 NPR/PBS/MaristNPR/PBS/Marist 41 53 -12 2018-10-23
15 USA Today/SuffolkUSA Today 43 54 -11 2018-10-23
16 Reuters/IpsosReuters 46 52 -6 2018-10-23
17 GallupGallup 44 50 -6 2018-10-21
grouping unique mean
edited Nov 12 '18 at 11:48
user6910411
32.6k86995
asked Nov 12 '18 at 0:32
Helena H
123
add a comment |
I want to calculate the mean for Approve and also (can be done separately) Disapprove for every given date using the newest 11 polls were the poll name is unique.
So when calculating the average for 2018-11-03 I would take the average of row numbers 6,7,8,9,10,11,12,15,etc down the column with no duplicates.
head(newpoll1,n=16)
Poll Approve Disapprove Spread Date
2 NBC News/Wall St. JrnlNBC/WSJ 46 52 -6 2018-11-04
3 CNNCNN 41 57 -16 2018-11-04
4 Rasmussen ReportsRasmussen 50 49 +1 2018-11-04
5 GallupGallup 40 54 -14 2018-11-04
6 ABC News/Wash PostABC/WP 44 52 -8 2018-11-03
7 IBD/TIPPIBD/TIPP 40 53 -13 2018-11-03
8 Economist/YouGovEconomist 44 52 -8 2018-10-30
9 NPR/PBS/MaristNPR/PBS/Marist 41 53 -12 2018-10-30
10 Harvard-HarrisHarvard-Harris 44 56 -12 2018-10-30
11 Reuters/IpsosReuters 45 54 -9 2018-10-30
12 GallupGallup 40 54 -14 2018-10-28
13 Economist/YouGovEconomist 45 52 -7 2018-10-23
14 NPR/PBS/MaristNPR/PBS/Marist 41 53 -12 2018-10-23
15 USA Today/SuffolkUSA Today 43 54 -11 2018-10-23
16 Reuters/IpsosReuters 46 52 -6 2018-10-23
17 GallupGallup 44 50 -6 2018-10-21
grouping unique mean
edited Nov 12 '18 at 11:48
user6910411
32.6k86995
asked Nov 12 '18 at 0:32
Helena H
123
add a comment |
I want to calculate the mean for Approve and also (can be done separately) Disapprove for every given date using the newest 11 polls were the poll name is unique.
So when calculating the average for 2018-11-03 I would take the average of row numbers 6,7,8,9,10,11,12,15,etc down the column with no duplicates.
head(newpoll1,n=16)
Poll Approve Disapprove Spread Date
2 NBC News/Wall St. JrnlNBC/WSJ 46 52 -6 2018-11-04
3 CNNCNN 41 57 -16 2018-11-04
4 Rasmussen ReportsRasmussen 50 49 +1 2018-11-04
5 GallupGallup 40 54 -14 2018-11-04
6 ABC News/Wash PostABC/WP 44 52 -8 2018-11-03
7 IBD/TIPPIBD/TIPP 40 53 -13 2018-11-03
8 Economist/YouGovEconomist 44 52 -8 2018-10-30
9 NPR/PBS/MaristNPR/PBS/Marist 41 53 -12 2018-10-30
10 Harvard-HarrisHarvard-Harris 44 56 -12 2018-10-30
11 Reuters/IpsosReuters 45 54 -9 2018-10-30
12 GallupGallup 40 54 -14 2018-10-28
13 Economist/YouGovEconomist 45 52 -7 2018-10-23
14 NPR/PBS/MaristNPR/PBS/Marist 41 53 -12 2018-10-23
15 USA Today/SuffolkUSA Today 43 54 -11 2018-10-23
16 Reuters/IpsosReuters 46 52 -6 2018-10-23
17 GallupGallup 44 50 -6 2018-10-21
grouping unique mean
edited Nov 12 '18 at 11:48
user6910411
32.6k86995
asked Nov 12 '18 at 0:32
Helena H
123
I want to calculate the mean for Approve and also (can be done separately) Disapprove for every given date using the newest 11 polls were the poll name is unique.
So when calculating the average for 2018-11-03 I would take the average of row numbers 6,7,8,9,10,11,12,15,etc down the column with no duplicates.
head(newpoll1,n=16)
Poll Approve Disapprove Spread Date
2 NBC News/Wall St. JrnlNBC/WSJ 46 52 -6 2018-11-04
3 CNNCNN 41 57 -16 2018-11-04
4 Rasmussen ReportsRasmussen 50 49 +1 2018-11-04
5 GallupGallup 40 54 -14 2018-11-04
6 ABC News/Wash PostABC/WP 44 52 -8 2018-11-03
7 IBD/TIPPIBD/TIPP 40 53 -13 2018-11-03
8 Economist/YouGovEconomist 44 52 -8 2018-10-30
9 NPR/PBS/MaristNPR/PBS/Marist 41 53 -12 2018-10-30
10 Harvard-HarrisHarvard-Harris 44 56 -12 2018-10-30
11 Reuters/IpsosReuters 45 54 -9 2018-10-30
12 GallupGallup 40 54 -14 2018-10-28
13 Economist/YouGovEconomist 45 52 -7 2018-10-23
14 NPR/PBS/MaristNPR/PBS/Marist 41 53 -12 2018-10-23
15 USA Today/SuffolkUSA Today 43 54 -11 2018-10-23
16 Reuters/IpsosReuters 46 52 -6 2018-10-23
17 GallupGallup 44 50 -6 2018-10-21
grouping unique mean
grouping unique mean
edited Nov 12 '18 at 11:48
user6910411
32.6k86995
asked Nov 12 '18 at 0:32
Helena H
123
edited Nov 12 '18 at 11:48
user6910411
32.6k86995
asked Nov 12 '18 at 0:32
Helena H
123
edited Nov 12 '18 at 11:48
user6910411
32.6k86995
edited Nov 12 '18 at 11:48
user6910411
32.6k86995
edited Nov 12 '18 at 11:48
user6910411
32.6k86995
32.6k86995
asked Nov 12 '18 at 0:32
Helena H
123
asked Nov 12 '18 at 0:32
Helena H
123
asked Nov 12 '18 at 0:32
Helena H
123
123
add a comment |
add a comment |
active
oldest
votes
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%2f53254636%2fcalculate-mean-for-each-date-using-the-11-unique-entries-on-before-that-date%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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%2f53254636%2fcalculate-mean-for-each-date-using-the-11-unique-entries-on-before-that-date%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
