How to pivot a dataframe with two columns with no indexHow to merge two dictionaries in a single...
Should I write a companion book/blog?
Isn't using the Extrusion Multiplier like cheating?
Difference between two quite-similar Terminal commands
Jumping Numbers
A starship is travelling at 0.9c and collides with a small rock. Will it leave a clean hole through, or will more happen?
Why did other German political parties disband so fast when Hitler was appointed chancellor?
Is it a fallacy if someone claims they need an explanation for every word of your argument to the point where they don't understand common terms?
How do you funnel food off a cutting board?
What is a jet (unit) shown in Windows 10 calculator?
Is there some relative to Dutch word "kijken" in German?
What is this metal M-shaped device for?
How to avoid being sexist when trying to employ someone to function in a very sexist environment?
Cryptic with missing capitals
How do I say "Brexit" in Latin?
Do authors have to be politically correct in article-writing?
Disable the ">" operator in Rstudio linux terminal
Compress command output by piping to bzip2
Every character has a name - does this lead to too many named characters?
Why doesn't "auto ch = unsigned char{'p'}" compile under C++ 17?
What kind of hardware implements Fourier transform?
Help Me simplify: C*(A+B) + ~A*B
Are there neural networks with very few nodes that decently solve non-trivial problems?
Would a National Army of mercenaries be a feasible idea?
What is the in-universe cost of a TIE fighter?
How to pivot a dataframe with two columns with no index
How to merge two dictionaries in a single expression?How do I check whether a file exists without exceptions?Finding the index of an item given a list containing it in PythonAccessing the index in 'for' loops?Add one row to pandas DataFrameAdding new column to existing DataFrame in Python pandas“Large data” work flows using pandasChange data type of columns in PandasSelect rows from a DataFrame based on values in a column in pandasHow to pivot a dataframe
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
asked 5 hours ago
macyyy33macyyy33
585
New contributor
macyyy33 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
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
asked 5 hours ago
macyyy33macyyy33
585
New contributor
macyyy33 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
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
asked 5 hours ago
macyyy33macyyy33
585
New contributor
macyyy33 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
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
asked 5 hours ago
macyyy33macyyy33
585
New contributor
macyyy33 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 5 hours ago
macyyy33macyyy33
585
New contributor
macyyy33 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 5 hours ago
macyyy33
asked 5 hours ago
macyyy33macyyy33
585
New contributor
macyyy33 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 5 hours ago
macyyy33macyyy33
585
asked 5 hours ago
macyyy33macyyy33
585
585
New contributor
macyyy33 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
macyyy33 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
macyyy33 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
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
answered 5 hours ago
Scott BostonScott Boston
55.8k73156
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?
answered 5 hours ago
Niklas MertschNiklas Mertsch
473115
You can usea.Tfor short.
– Scott Boston
5 hours ago
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
answered 4 hours ago
ALollzALollz
14.2k31636
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
answered 5 hours ago
Scott BostonScott Boston
55.8k73156
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
answered 5 hours ago
Scott BostonScott Boston
55.8k73156
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
answered 5 hours ago
Scott BostonScott Boston
55.8k73156
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 5 hours ago
Scott BostonScott Boston
55.8k73156
answered 5 hours ago
Scott BostonScott Boston
55.8k73156
answered 5 hours ago
Scott BostonScott Boston
55.8k73156
answered 5 hours ago
Scott BostonScott Boston
55.8k73156
55.8k73156
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?
answered 5 hours ago
Niklas MertschNiklas Mertsch
473115
You can usea.Tfor short.
– Scott Boston
5 hours ago
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?
answered 5 hours ago
Niklas MertschNiklas Mertsch
473115
You can usea.Tfor short.
– Scott Boston
5 hours ago
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?
answered 5 hours ago
Niklas MertschNiklas Mertsch
473115
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 5 hours ago
Niklas MertschNiklas Mertsch
473115
answered 5 hours ago
Niklas MertschNiklas Mertsch
473115
answered 5 hours ago
Niklas MertschNiklas Mertsch
473115
answered 5 hours ago
Niklas MertschNiklas Mertsch
473115
473115
You can usea.Tfor short.
– Scott Boston
5 hours ago
add a comment |
You can usea.Tfor short.
– Scott Boston
5 hours ago
You can use
a.T for short.– Scott Boston
5 hours ago
You can use
a.T for short.– Scott Boston
5 hours ago
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
answered 4 hours ago
ALollzALollz
14.2k31636
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
answered 4 hours ago
ALollzALollz
14.2k31636
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
answered 4 hours ago
ALollzALollz
14.2k31636
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 4 hours ago
ALollzALollz
14.2k31636
answered 4 hours ago
ALollzALollz
14.2k31636
answered 4 hours ago
ALollzALollz
14.2k31636
answered 4 hours ago
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
