Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Transposing Table
#1
how can i transpose a table in python like below

from

Name Account Amount
Jhon 1 45
Jhon 2 463
Michael 1 76
Michael 2 854
Michael 3 90
Jousef 1 54

To

Name Account#1 Accoucnt#2 Account#3
Jhon 45 463
Michaal 76 854 90
Jousef 54
Reply
#2
What have you tried? Hint: Transposing is the wrong term. You can split the text with splitlines and split.
Almost dead, but too lazy to die: https://sourceserver.info
All humans together. We don't need politicians!
Reply
#3
If this is not an assignment, you can use pandas.
The code would be something like this:

import pandas as pd
data = pd.read_csv('your_file.csv', sep=' ') # check additional options,e.g. header, etc. 
data.T # rotated data
data.T.to_csv('output.csv') # save rotated data to a file
Reply
#4
(Mar-02-2019, 06:35 AM)DeaD_EyE Wrote: What have you tried? Hint: Transposing is the wrong term. You can split the text with splitlines and split.
thanks,

i have tried split but not able to split objects somehow in pandas
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Transposing a dataframe without creating NaN values doug2019 2 932 Mar-18-2023, 03:14 PM
Last Post: jefsummers
  Transposing a Matrix WITHOUT numpy TreasureDragon 5 11,103 Mar-02-2019, 10:48 PM
Last Post: ichabod801
  Transposing in Excel and converting to txt muhsin 2 2,806 Dec-10-2017, 06:06 PM
Last Post: muhsin

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020