+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: General Coding Help (https://python-forum.io/forum-8.html)
+--- Thread: Transposing Table (/thread-16485.html)
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 withthanks,splitlinesandsplit.
i have tried split but not able to split objects somehow in pandas