converting rownames back to column format
0
I want to convert rownames in my dataframe into first column
Example intput:
y
species1 3.783584
species2 3.696341
species3 3.968285
Desired output:
x y
species1 3.783584
species2 3.696341
species3 3.968285
r
add a comment |
0
I want to convert rownames in my dataframe into first column
Example intput:
y
species1 3.783584
species2 3.696341
species3 3.968285
Desired output:
x y
species1 3.783584
species2 3.696341
species3 3.968285
r
add a comment |
0
0
0
I want to convert rownames in my dataframe into first column
Example intput:
y
species1 3.783584
species2 3.696341
species3 3.968285
Desired output:
x y
species1 3.783584
species2 3.696341
species3 3.968285
r
I want to convert rownames in my dataframe into first column
Example intput:
y
species1 3.783584
species2 3.696341
species3 3.968285
Desired output:
x y
species1 3.783584
species2 3.696341
species3 3.968285
r
r
asked Nov 16 '18 at 4:44
user4400727
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
1
Just assign the row names to a new column:
df$x <- rownames(df)
df <- df[,c("x", "y")]
The second step is only necessary if, for some reason, you care about column order.
If you also want to revert the row names to the numerical sequence they would have by default, you may do so via:
rownames(df) <- seq(nrow(df))
answered Nov 16 '18 at 4:46
Tim BiegeleisenTim Biegeleisen
234k1399157
but that doesn't preserve the the column order. when I do it, it puts column x after column y and still leaves the 1st column row names as is
– user4400727
Nov 16 '18 at 4:59
@user3683803 I didn't know this was an issue for you. I updated my answer.
– Tim Biegeleisen
Nov 16 '18 at 5:01
I get an Error: undefined columns selected
– user4400727
Nov 16 '18 at 5:04
Then I think your code has a problem. My answer should be working.
– Tim Biegeleisen
Nov 16 '18 at 5:04
i tried again and now it has the order I want (x in first column and y in second column) but it preserves the row names which i want removed
– user4400727
Nov 16 '18 at 5:12
|
show 3 more comments
0
you can do it using
df$x <- rownames(df)
answered Nov 16 '18 at 4:46
HunaidkhanHunaidkhan
1,014516
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
});
}
});
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%2f53331576%2fconverting-rownames-back-to-column-format%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
1
Just assign the row names to a new column:
df$x <- rownames(df)
df <- df[,c("x", "y")]
The second step is only necessary if, for some reason, you care about column order.
If you also want to revert the row names to the numerical sequence they would have by default, you may do so via:
rownames(df) <- seq(nrow(df))
answered Nov 16 '18 at 4:46
Tim BiegeleisenTim Biegeleisen
234k1399157
but that doesn't preserve the the column order. when I do it, it puts column x after column y and still leaves the 1st column row names as is
– user4400727
Nov 16 '18 at 4:59
@user3683803 I didn't know this was an issue for you. I updated my answer.
– Tim Biegeleisen
Nov 16 '18 at 5:01
I get an Error: undefined columns selected
– user4400727
Nov 16 '18 at 5:04
Then I think your code has a problem. My answer should be working.
– Tim Biegeleisen
Nov 16 '18 at 5:04
i tried again and now it has the order I want (x in first column and y in second column) but it preserves the row names which i want removed
– user4400727
Nov 16 '18 at 5:12
|
show 3 more comments
1
Just assign the row names to a new column:
df$x <- rownames(df)
df <- df[,c("x", "y")]
The second step is only necessary if, for some reason, you care about column order.
If you also want to revert the row names to the numerical sequence they would have by default, you may do so via:
rownames(df) <- seq(nrow(df))
answered Nov 16 '18 at 4:46
Tim BiegeleisenTim Biegeleisen
234k1399157
but that doesn't preserve the the column order. when I do it, it puts column x after column y and still leaves the 1st column row names as is
– user4400727
Nov 16 '18 at 4:59
@user3683803 I didn't know this was an issue for you. I updated my answer.
– Tim Biegeleisen
Nov 16 '18 at 5:01
I get an Error: undefined columns selected
– user4400727
Nov 16 '18 at 5:04
Then I think your code has a problem. My answer should be working.
– Tim Biegeleisen
Nov 16 '18 at 5:04
i tried again and now it has the order I want (x in first column and y in second column) but it preserves the row names which i want removed
– user4400727
Nov 16 '18 at 5:12
|
show 3 more comments
1
1
1
Just assign the row names to a new column:
df$x <- rownames(df)
df <- df[,c("x", "y")]
The second step is only necessary if, for some reason, you care about column order.
If you also want to revert the row names to the numerical sequence they would have by default, you may do so via:
rownames(df) <- seq(nrow(df))
answered Nov 16 '18 at 4:46
Tim BiegeleisenTim Biegeleisen
234k1399157
Just assign the row names to a new column:
df$x <- rownames(df)
df <- df[,c("x", "y")]
The second step is only necessary if, for some reason, you care about column order.
If you also want to revert the row names to the numerical sequence they would have by default, you may do so via:
rownames(df) <- seq(nrow(df))
answered Nov 16 '18 at 4:46
Tim BiegeleisenTim Biegeleisen
234k1399157
edited Nov 16 '18 at 5:00
answered Nov 16 '18 at 4:46
Tim BiegeleisenTim Biegeleisen
234k1399157
answered Nov 16 '18 at 4:46
Tim BiegeleisenTim Biegeleisen
234k1399157
answered Nov 16 '18 at 4:46
Tim BiegeleisenTim Biegeleisen
234k1399157
234k1399157
but that doesn't preserve the the column order. when I do it, it puts column x after column y and still leaves the 1st column row names as is
– user4400727
Nov 16 '18 at 4:59
@user3683803 I didn't know this was an issue for you. I updated my answer.
– Tim Biegeleisen
Nov 16 '18 at 5:01
I get an Error: undefined columns selected
– user4400727
Nov 16 '18 at 5:04
Then I think your code has a problem. My answer should be working.
– Tim Biegeleisen
Nov 16 '18 at 5:04
i tried again and now it has the order I want (x in first column and y in second column) but it preserves the row names which i want removed
– user4400727
Nov 16 '18 at 5:12
|
show 3 more comments
but that doesn't preserve the the column order. when I do it, it puts column x after column y and still leaves the 1st column row names as is
– user4400727
Nov 16 '18 at 4:59
@user3683803 I didn't know this was an issue for you. I updated my answer.
– Tim Biegeleisen
Nov 16 '18 at 5:01
I get an Error: undefined columns selected
– user4400727
Nov 16 '18 at 5:04
Then I think your code has a problem. My answer should be working.
– Tim Biegeleisen
Nov 16 '18 at 5:04
i tried again and now it has the order I want (x in first column and y in second column) but it preserves the row names which i want removed
– user4400727
Nov 16 '18 at 5:12
but that doesn't preserve the the column order. when I do it, it puts column x after column y and still leaves the 1st column row names as is
– user4400727
Nov 16 '18 at 4:59
but that doesn't preserve the the column order. when I do it, it puts column x after column y and still leaves the 1st column row names as is
– user4400727
Nov 16 '18 at 4:59
@user3683803 I didn't know this was an issue for you. I updated my answer.
– Tim Biegeleisen
Nov 16 '18 at 5:01
@user3683803 I didn't know this was an issue for you. I updated my answer.
– Tim Biegeleisen
Nov 16 '18 at 5:01
I get an Error: undefined columns selected
– user4400727
Nov 16 '18 at 5:04
I get an Error: undefined columns selected
– user4400727
Nov 16 '18 at 5:04
Then I think your code has a problem. My answer should be working.
– Tim Biegeleisen
Nov 16 '18 at 5:04
Then I think your code has a problem. My answer should be working.
– Tim Biegeleisen
Nov 16 '18 at 5:04
i tried again and now it has the order I want (x in first column and y in second column) but it preserves the row names which i want removed
– user4400727
Nov 16 '18 at 5:12
i tried again and now it has the order I want (x in first column and y in second column) but it preserves the row names which i want removed
– user4400727
Nov 16 '18 at 5:12
|
show 3 more comments
0
you can do it using
df$x <- rownames(df)
answered Nov 16 '18 at 4:46
HunaidkhanHunaidkhan
1,014516
add a comment |
0
you can do it using
df$x <- rownames(df)
answered Nov 16 '18 at 4:46
HunaidkhanHunaidkhan
1,014516
add a comment |
0
0
0
you can do it using
df$x <- rownames(df)
answered Nov 16 '18 at 4:46
HunaidkhanHunaidkhan
1,014516
you can do it using
df$x <- rownames(df)
answered Nov 16 '18 at 4:46
HunaidkhanHunaidkhan
1,014516
answered Nov 16 '18 at 4:46
HunaidkhanHunaidkhan
1,014516
answered Nov 16 '18 at 4:46
HunaidkhanHunaidkhan
1,014516
answered Nov 16 '18 at 4:46
HunaidkhanHunaidkhan
1,014516
1,014516
add a comment |
add a comment |
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%2f53331576%2fconverting-rownames-back-to-column-format%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
