Python Forum
Transposing Table - Printable Version

+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/Forum-Python-Coding)
+--- Forum: General Coding Help (https://python-forum.io/Forum-General-Coding-Help)
+--- Thread: Transposing Table (/Thread-Transposing-Table)



Transposing Table - salihozturk - Mar-02-2019

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


RE: Transposing Table - DeaD_EyE - Mar-02-2019

What have you tried? Hint: Transposing is the wrong term. You can split the text with splitlines and split.


RE: Transposing Table - scidam - Mar-02-2019

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



RE: Transposing Table - salihozturk - Mar-03-2019

(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