Ggthjy

Grade 10 Analytic Geometry Question 23- Incredibly hard

A starship is travelling at 0.9c and collides with a small rock. Will it leave a clean hole through, or will more happen?

Chess tournament winning streaks

Why are the books in the Game of Thrones citadel library shelved spine inwards?

Slow moving projectiles from a hand-held weapon - how do they reach the target?

Why did other German political parties disband so fast when Hitler was appointed chancellor?

Check if the digits in the number are in increasing sequence in python

How to acknowledge an embarrassing job interview, now that I work directly with the interviewer?

Why does a metal block make a shrill sound but not a wooden block upon hammering?

Can you earn endless XP using a Flameskull and its self-revival feature?

Using only 1s, make 29 with the minimum number of digits

Compress command output by piping to bzip2

What is the most triangles you can make from a capital "H" and 3 straight lines?

How would a Dictatorship make a country more successful?

Why would the Pakistan airspace closure cancel flights not headed to Pakistan itself?

Program that converts a number to a letter of the alphabet

Cat is tipping over bed-side lamps during the night

Do authors have to be politically correct in article-writing?

How would one buy a used TIE Fighter or X-Wing?

Why Normality assumption in linear regression

Strange Sign on Lab Door

Recrystallisation of dibenzylideneacetone

What's the most convenient time of year to end the world?

Is a debit card dangerous for an account with low balance and no overdraft protection?

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

9

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

share|improve this question

edited 13 hours ago

macyyy33

asked 13 hours ago

macyyy33macyyy33

665

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 | 

9

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

share|improve this question

edited 13 hours ago

macyyy33

asked 13 hours ago

macyyy33macyyy33

665

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

share|improve this question

edited 13 hours ago

macyyy33

asked 13 hours ago

macyyy33macyyy33

665

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.

one   two

 a    12

 b    32

 c    12

 a   b   c 

12  32  12

share|improve this question

edited 13 hours ago

macyyy33

asked 13 hours ago

macyyy33macyyy33

665

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.

share|improve this question

edited 13 hours ago

macyyy33

asked 13 hours ago

macyyy33macyyy33

665

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 13 hours ago

macyyy33macyyy33

665

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 13 hours ago

macyyy33macyyy33

665

3 Answers
3

active

oldest

votes

5

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

share|improve this answer

answered 13 hours ago

Scott BostonScott Boston

55.9k73156

add a comment | 

3

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?

share|improve this answer

answered 13 hours ago

Niklas MertschNiklas Mertsch

473115

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You can use a.T for short.
  
  – Scott Boston
  13 hours ago
  
  
  

  
  
  
  

add a comment | 

2

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

share|improve this answer

answered 12 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.

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

Name

Email

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

Name

Email

Required, but never shown

5

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

share|improve this answer

answered 13 hours ago

Scott BostonScott Boston

55.9k73156

add a comment | 

5

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

share|improve this answer

answered 13 hours ago

Scott BostonScott Boston

55.9k73156

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

share|improve this answer

answered 13 hours ago

Scott BostonScott Boston

55.9k73156

a.set_index('one').T

one   a   b   c

two  12  32  12

<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

share|improve this answer

answered 13 hours ago

Scott BostonScott Boston

55.9k73156

answered 13 hours ago

Scott BostonScott Boston

55.9k73156

answered 13 hours ago

Scott BostonScott Boston

55.9k73156

3

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?

share|improve this answer

answered 13 hours ago

Niklas MertschNiklas Mertsch

473115

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You can use a.T for short.
  
  – Scott Boston
  13 hours ago
  
  
  

  
  
  
  

add a comment | 

3

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?

share|improve this answer

answered 13 hours ago

Niklas MertschNiklas Mertsch

473115

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You can use a.T for short.
  
  – Scott Boston
  13 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?

share|improve this answer

answered 13 hours ago

Niklas MertschNiklas Mertsch

473115

a = pd.DataFrame([("a", 12), ("b", 32), ("c", 12)], columns=["one", "two"])

  one  two

0   a   12

1   b   32

2   c   12

      0   1   2

one   a   b   c

two  12  32  12

share|improve this answer

answered 13 hours ago

Niklas MertschNiklas Mertsch

473115

answered 13 hours ago

Niklas MertschNiklas Mertsch

473115

answered 13 hours ago

Niklas MertschNiklas Mertsch

473115

2

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

share|improve this answer

answered 12 hours ago

ALollzALollz

14.2k31636

add a comment | 

2

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

share|improve this answer

answered 12 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

share|improve this answer

answered 12 hours ago

ALollzALollz

14.2k31636

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

share|improve this answer

answered 12 hours ago

ALollzALollz

14.2k31636

answered 12 hours ago

ALollzALollz

14.2k31636

answered 12 hours ago

ALollzALollz

14.2k31636