How to pivot a dataframe with two columns with no index
I am trying to pivot my current two column dataframe which currently looks like this:
one two
a 12
b 32
c 12
I want to pivot this resulting in neither column becoming the index. My expected result is:
a b c
12 32 12
a, b, and c are the new columns. 12, 32, 12 are the values in the row.
Thanks
python pandas
New contributor
add a comment |
I am trying to pivot my current two column dataframe which currently looks like this:
one two
a 12
b 32
c 12
I want to pivot this resulting in neither column becoming the index. My expected result is:
a b c
12 32 12
a, b, and c are the new columns. 12, 32, 12 are the values in the row.
Thanks
python pandas
New contributor
add a comment |
I am trying to pivot my current two column dataframe which currently looks like this:
one two
a 12
b 32
c 12
I want to pivot this resulting in neither column becoming the index. My expected result is:
a b c
12 32 12
a, b, and c are the new columns. 12, 32, 12 are the values in the row.
Thanks
python pandas
New contributor
I am trying to pivot my current two column dataframe which currently looks like this:
one two
a 12
b 32
c 12
I want to pivot this resulting in neither column becoming the index. My expected result is:
a b c
12 32 12
a, b, and c are the new columns. 12, 32, 12 are the values in the row.
Thanks
python pandas
python pandas
New contributor
New contributor
edited yesterday
macyyy33
New contributor
asked yesterday
macyyy33macyyy33
1026
1026
New contributor
New contributor
add a comment |
add a comment |
3 Answers
3
active
oldest
votes
Use set_index
to move column 'one' into the index, then use T
to transpose.
a.set_index('one').T
Output:
one a b c
two 12 32 12
Info:
<class 'pandas.core.frame.DataFrame'>
Index: 1 entries, two to two
Data columns (total 3 columns):
a 1 non-null int64
b 1 non-null int64
c 1 non-null int64
dtypes: int64(3)
memory usage: 28.0+ bytes
None
add a comment |
If this is your input:
a = pd.DataFrame([("a", 12), ("b", 32), ("c", 12)], columns=["one", "two"])
one two
0 a 12
1 b 32
2 c 12
Then a.transpose()
results in this:
0 1 2
one a b c
two 12 32 12
Is this what you were looking for?
You can usea.T
for short.
– Scott Boston
yesterday
add a comment |
Giving everything the same index with .pivot_table
df.pivot_table(columns='one', index=df.index//len(df), values='two').rename_axis(None, axis=1)
#or with pivot
df = df.pivot(columns='one', index=df.index//len(df)).rename_axis([None, None], axis=1)
df.columns = [y for _,y in df.columns]
a b c
0 12 32 12
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
});
}
});
macyyy33 is a new contributor. Be nice, and check out our Code of Conduct.
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%2f54950958%2fhow-to-pivot-a-dataframe-with-two-columns-with-no-index%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
3 Answers
3
active
oldest
votes
3 Answers
3
active
oldest
votes
active
oldest
votes
active
oldest
votes
Use set_index
to move column 'one' into the index, then use T
to transpose.
a.set_index('one').T
Output:
one a b c
two 12 32 12
Info:
<class 'pandas.core.frame.DataFrame'>
Index: 1 entries, two to two
Data columns (total 3 columns):
a 1 non-null int64
b 1 non-null int64
c 1 non-null int64
dtypes: int64(3)
memory usage: 28.0+ bytes
None
add a comment |
Use set_index
to move column 'one' into the index, then use T
to transpose.
a.set_index('one').T
Output:
one a b c
two 12 32 12
Info:
<class 'pandas.core.frame.DataFrame'>
Index: 1 entries, two to two
Data columns (total 3 columns):
a 1 non-null int64
b 1 non-null int64
c 1 non-null int64
dtypes: int64(3)
memory usage: 28.0+ bytes
None
add a comment |
Use set_index
to move column 'one' into the index, then use T
to transpose.
a.set_index('one').T
Output:
one a b c
two 12 32 12
Info:
<class 'pandas.core.frame.DataFrame'>
Index: 1 entries, two to two
Data columns (total 3 columns):
a 1 non-null int64
b 1 non-null int64
c 1 non-null int64
dtypes: int64(3)
memory usage: 28.0+ bytes
None
Use set_index
to move column 'one' into the index, then use T
to transpose.
a.set_index('one').T
Output:
one a b c
two 12 32 12
Info:
<class 'pandas.core.frame.DataFrame'>
Index: 1 entries, two to two
Data columns (total 3 columns):
a 1 non-null int64
b 1 non-null int64
c 1 non-null int64
dtypes: int64(3)
memory usage: 28.0+ bytes
None
answered yesterday
Scott BostonScott Boston
55.9k73156
55.9k73156
add a comment |
add a comment |
If this is your input:
a = pd.DataFrame([("a", 12), ("b", 32), ("c", 12)], columns=["one", "two"])
one two
0 a 12
1 b 32
2 c 12
Then a.transpose()
results in this:
0 1 2
one a b c
two 12 32 12
Is this what you were looking for?
You can usea.T
for short.
– Scott Boston
yesterday
add a comment |
If this is your input:
a = pd.DataFrame([("a", 12), ("b", 32), ("c", 12)], columns=["one", "two"])
one two
0 a 12
1 b 32
2 c 12
Then a.transpose()
results in this:
0 1 2
one a b c
two 12 32 12
Is this what you were looking for?
You can usea.T
for short.
– Scott Boston
yesterday
add a comment |
If this is your input:
a = pd.DataFrame([("a", 12), ("b", 32), ("c", 12)], columns=["one", "two"])
one two
0 a 12
1 b 32
2 c 12
Then a.transpose()
results in this:
0 1 2
one a b c
two 12 32 12
Is this what you were looking for?
If this is your input:
a = pd.DataFrame([("a", 12), ("b", 32), ("c", 12)], columns=["one", "two"])
one two
0 a 12
1 b 32
2 c 12
Then a.transpose()
results in this:
0 1 2
one a b c
two 12 32 12
Is this what you were looking for?
answered yesterday
Niklas MertschNiklas Mertsch
473115
473115
You can usea.T
for short.
– Scott Boston
yesterday
add a comment |
You can usea.T
for short.
– Scott Boston
yesterday
You can use
a.T
for short.– Scott Boston
yesterday
You can use
a.T
for short.– Scott Boston
yesterday
add a comment |
Giving everything the same index with .pivot_table
df.pivot_table(columns='one', index=df.index//len(df), values='two').rename_axis(None, axis=1)
#or with pivot
df = df.pivot(columns='one', index=df.index//len(df)).rename_axis([None, None], axis=1)
df.columns = [y for _,y in df.columns]
a b c
0 12 32 12
add a comment |
Giving everything the same index with .pivot_table
df.pivot_table(columns='one', index=df.index//len(df), values='two').rename_axis(None, axis=1)
#or with pivot
df = df.pivot(columns='one', index=df.index//len(df)).rename_axis([None, None], axis=1)
df.columns = [y for _,y in df.columns]
a b c
0 12 32 12
add a comment |
Giving everything the same index with .pivot_table
df.pivot_table(columns='one', index=df.index//len(df), values='two').rename_axis(None, axis=1)
#or with pivot
df = df.pivot(columns='one', index=df.index//len(df)).rename_axis([None, None], axis=1)
df.columns = [y for _,y in df.columns]
a b c
0 12 32 12
Giving everything the same index with .pivot_table
df.pivot_table(columns='one', index=df.index//len(df), values='two').rename_axis(None, axis=1)
#or with pivot
df = df.pivot(columns='one', index=df.index//len(df)).rename_axis([None, None], axis=1)
df.columns = [y for _,y in df.columns]
a b c
0 12 32 12
answered yesterday
ALollzALollz
14.2k31636
14.2k31636
add a comment |
add a comment |
macyyy33 is a new contributor. Be nice, and check out our Code of Conduct.
macyyy33 is a new contributor. Be nice, and check out our Code of Conduct.
macyyy33 is a new contributor. Be nice, and check out our Code of Conduct.
macyyy33 is a new contributor. Be nice, and check out our Code of Conduct.
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%2f54950958%2fhow-to-pivot-a-dataframe-with-two-columns-with-no-index%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