Python Forum

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

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

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

(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