How do I move down an element in same row using pandas?

Question

0.00/5 (No votes)

See more:

64 66 81 02 73 -column 1 64 96 34 81 22 - column 2

I have two columns with 5 elements. I want to transpose it.
Expected Output :
64
66
81
02
73 - column 1
61
96
34
81
22 - column 2

What I have tried:

I have tried transposing but I end up getting
64 66 81 02 73 - column 1
61 96 34 81 22 - column 2

But I want this:
66
81
02
73 - column 1
61
96
34
81
22 - column 2

Posted 10-Mar-22 4:01am

Member 15561848

Updated 10-Mar-22 7:36am

Add a Solution

Comments

Richard MacCutchan 10-Mar-22 10:39am

You need to show your code. We cannot guess what you are doing.

Member 15561848 10-Mar-22 11:08am

import numpy as np
import pandas as pd
df1 = pd.read_table("A.txt",header=None)
print(df1)
df1_t = df1.T
print(df1_t)

Richard MacCutchan 10-Mar-22 11:17am

You need to show the output of the two print statements as well as the code. Please use the Improve question link above, and add complete details.

Richard MacCutchan 10-Mar-22 11:54am

I have made a guess as to the format of the data in your text file, and get the following results:

    0   1   2   3            4
0  64  66  81   2  73-column-1
1  64  96  34  81  22-column-2
             0            1
0           64           64
1           66           96
2           81           34
3            2           81
4  73-column-1  22-column-2

Member 15561848 10-Mar-22 12:23pm

The text file looks like this:
64 66 81 02 73
64 96 34 81 22
So, it is considering 64 66 81 02 73 as first row and 64 96 34 81 22 as second row. when I transpose, 64 66 81 02 73 64 96 34 81 22. This is what it looks like.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Accepted Answer · 2022-03-10T07:36:00

Solution 2

Seems you want to use pandas.DataFrame.melt[^], which unpivot a DataFrame from wide to long format, optionally leaving identifiers set. Follow the link for examples.

Posted 10-Mar-22 7:36am

Maciej Los