Mixing
Pivot-like transformation of a tibble?
0
I have a...
# A tibble: 6 x 10
CCG18CD CCG18CDH CCG18NM STP18CD STP18NM LAD18CD LAD18NM PCON16CD PCON16NM Dummy
<chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr> <dbl>
1 E38000035 07T NHS City and Hackney CCG E54000029 North East London E09000001 City of Lon~ E140006~ Cities of Lond~ 1
2 E38000035 07T NHS City and Hackney CCG E54000029 North East London E09000001 City of Lon~ E140006~ Cities of Lond~ 1
3 E38000035 07T NHS City and Hackney CCG E54000029 North East London E09000001 City of Lon~ E140006~ Cities of Lond~ 1
4 E38000035 07T NHS City and Hackney CCG E54000029 North East London E09000001 City of Lon~ E140006~ Cities of Lond~ 1
5 E38000004 07L NHS Barking and Dagenham CCG E54000029 North East London E09000002 Barking and~ E140005~ Barking 1
6 E38000004 07L NHS Barking and Dagenham CCG E54000029 North East London E09000002 Barking and~ E140005~ Barking 1
I want to do a pivot-like transformation of the PCON16CD column, with:
* each distinct variable in this column/field taking a row of a new tibble
* columns generated from the variables in the current column CCG18CD
* Values being populated with a count of the column Dummy, with results shown as a percent of row total.
...that is, all bread and butter stuff in Excel, but a task I'm struggling to get my head round for R
r pivot tibble
asked Nov 21 '18 at 16:22
RHinksRHinks
113
add a comment |
0
I have a...
# A tibble: 6 x 10
CCG18CD CCG18CDH CCG18NM STP18CD STP18NM LAD18CD LAD18NM PCON16CD PCON16NM Dummy
<chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr> <dbl>
1 E38000035 07T NHS City and Hackney CCG E54000029 North East London E09000001 City of Lon~ E140006~ Cities of Lond~ 1
2 E38000035 07T NHS City and Hackney CCG E54000029 North East London E09000001 City of Lon~ E140006~ Cities of Lond~ 1
3 E38000035 07T NHS City and Hackney CCG E54000029 North East London E09000001 City of Lon~ E140006~ Cities of Lond~ 1
4 E38000035 07T NHS City and Hackney CCG E54000029 North East London E09000001 City of Lon~ E140006~ Cities of Lond~ 1
5 E38000004 07L NHS Barking and Dagenham CCG E54000029 North East London E09000002 Barking and~ E140005~ Barking 1
6 E38000004 07L NHS Barking and Dagenham CCG E54000029 North East London E09000002 Barking and~ E140005~ Barking 1
I want to do a pivot-like transformation of the PCON16CD column, with:
* each distinct variable in this column/field taking a row of a new tibble
* columns generated from the variables in the current column CCG18CD
* Values being populated with a count of the column Dummy, with results shown as a percent of row total.
...that is, all bread and butter stuff in Excel, but a task I'm struggling to get my head round for R
r pivot tibble
asked Nov 21 '18 at 16:22
RHinksRHinks
113
habe a look at the tidyr package (Functions spread and gather).
– floe
Nov 21 '18 at 16:37
if speed is an issue (of when dealing woith large datasets), take a look atdata.table'sdcast-function
– Wimpel
Nov 21 '18 at 17:33
add a comment |
0
0
0
I have a...
# A tibble: 6 x 10
CCG18CD CCG18CDH CCG18NM STP18CD STP18NM LAD18CD LAD18NM PCON16CD PCON16NM Dummy
<chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr> <dbl>
1 E38000035 07T NHS City and Hackney CCG E54000029 North East London E09000001 City of Lon~ E140006~ Cities of Lond~ 1
2 E38000035 07T NHS City and Hackney CCG E54000029 North East London E09000001 City of Lon~ E140006~ Cities of Lond~ 1
3 E38000035 07T NHS City and Hackney CCG E54000029 North East London E09000001 City of Lon~ E140006~ Cities of Lond~ 1
4 E38000035 07T NHS City and Hackney CCG E54000029 North East London E09000001 City of Lon~ E140006~ Cities of Lond~ 1
5 E38000004 07L NHS Barking and Dagenham CCG E54000029 North East London E09000002 Barking and~ E140005~ Barking 1
6 E38000004 07L NHS Barking and Dagenham CCG E54000029 North East London E09000002 Barking and~ E140005~ Barking 1
I want to do a pivot-like transformation of the PCON16CD column, with:
* each distinct variable in this column/field taking a row of a new tibble
* columns generated from the variables in the current column CCG18CD
* Values being populated with a count of the column Dummy, with results shown as a percent of row total.
...that is, all bread and butter stuff in Excel, but a task I'm struggling to get my head round for R
r pivot tibble
asked Nov 21 '18 at 16:22
RHinksRHinks
113
I have a...
# A tibble: 6 x 10
CCG18CD CCG18CDH CCG18NM STP18CD STP18NM LAD18CD LAD18NM PCON16CD PCON16NM Dummy
<chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr> <dbl>
1 E38000035 07T NHS City and Hackney CCG E54000029 North East London E09000001 City of Lon~ E140006~ Cities of Lond~ 1
2 E38000035 07T NHS City and Hackney CCG E54000029 North East London E09000001 City of Lon~ E140006~ Cities of Lond~ 1
3 E38000035 07T NHS City and Hackney CCG E54000029 North East London E09000001 City of Lon~ E140006~ Cities of Lond~ 1
4 E38000035 07T NHS City and Hackney CCG E54000029 North East London E09000001 City of Lon~ E140006~ Cities of Lond~ 1
5 E38000004 07L NHS Barking and Dagenham CCG E54000029 North East London E09000002 Barking and~ E140005~ Barking 1
6 E38000004 07L NHS Barking and Dagenham CCG E54000029 North East London E09000002 Barking and~ E140005~ Barking 1
I want to do a pivot-like transformation of the PCON16CD column, with:
* each distinct variable in this column/field taking a row of a new tibble
* columns generated from the variables in the current column CCG18CD
* Values being populated with a count of the column Dummy, with results shown as a percent of row total.
...that is, all bread and butter stuff in Excel, but a task I'm struggling to get my head round for R
r pivot tibble
r pivot tibble
asked Nov 21 '18 at 16:22
RHinksRHinks
113
asked Nov 21 '18 at 16:22
RHinksRHinks
113
asked Nov 21 '18 at 16:22
RHinksRHinks
113
asked Nov 21 '18 at 16:22
RHinksRHinks
113
asked Nov 21 '18 at 16:22
RHinksRHinks
113
113
habe a look at the tidyr package (Functions spread and gather).
– floe
Nov 21 '18 at 16:37
if speed is an issue (of when dealing woith large datasets), take a look atdata.table'sdcast-function
– Wimpel
Nov 21 '18 at 17:33
add a comment |
habe a look at the tidyr package (Functions spread and gather).
– floe
Nov 21 '18 at 16:37
if speed is an issue (of when dealing woith large datasets), take a look atdata.table'sdcast-function
– Wimpel
Nov 21 '18 at 17:33
habe a look at the tidyr package (Functions spread and gather).
– floe
Nov 21 '18 at 16:37
habe a look at the tidyr package (Functions spread and gather).
– floe
Nov 21 '18 at 16:37
if speed is an issue (of when dealing woith large datasets), take a look at
data.table's dcast-function– Wimpel
Nov 21 '18 at 17:33
if speed is an issue (of when dealing woith large datasets), take a look at
data.table's dcast-function– Wimpel
Nov 21 '18 at 17:33
add a comment |
0
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
});
}
});
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%2f53416398%2fpivot-like-transformation-of-a-tibble%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
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.
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%2f53416398%2fpivot-like-transformation-of-a-tibble%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
habe a look at the tidyr package (Functions spread and gather).
– floe
Nov 21 '18 at 16:37
if speed is an issue (of when dealing woith large datasets), take a look at
data.table'sdcast-function– Wimpel
Nov 21 '18 at 17:33