Python Forum
How to convert rows to columns.
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
How to convert rows to columns.
#1
I'm playing around with incomplete columnar ciphers. What is the fastest was to convert rows to columns when the columns may not all be the same length?

Example:

rows = [
'SOME',
'TEXT',
'OFSO',
'MELE',
'NGTH']
How do I get to columns the fastest way?
Example Continued:

columns = [
'STOMN',
'OEFEG',
'MXSLT',
'ETOEH']
I already did a try/except iteration loop but I'm told it is horribly slow. I also did the method from the Sweigart's book but it seems like it does not work right with complete columnar types. / 0 problems etc. I would also just like to know what is the fastest way code wise. I haven't learned C yet. I'm blowing it off as long as humanly possible for reasons I won't get into here. Trying to get every last ounce out of Python I can before I switch.

Thanks
Reply
#2
list(map(''.join, zip(*rows)))
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Converting a json file to a dataframe with rows and columns eyavuz21 13 4,178 Jan-29-2023, 03:59 PM
Last Post: eyavuz21
  How to properly format rows and columns in excel data from parsed .txt blocks jh67 7 1,802 Dec-12-2022, 08:22 PM
Last Post: jh67
  Check DataFrames with different sorting in columns and rows Foxyskippy 0 753 Nov-19-2022, 07:49 AM
Last Post: Foxyskippy
  The code I have written removes the desired number of rows, but wrong rows Jdesi1983 0 1,603 Dec-08-2021, 04:42 AM
Last Post: Jdesi1983
  making variables in my columns and rows in python kronhamilton 2 1,579 Oct-31-2021, 10:38 AM
Last Post: snippsat
  rows from sql query need to write to a file as columns sjcsvatt 6 2,336 Oct-09-2021, 12:45 AM
Last Post: snippsat
  Merging spreadsheets with the same columns and extracting rows with matching entries johnbernard 3 8,405 Aug-19-2021, 03:08 PM
Last Post: johnbernard
  Summing up rows and columns plumberpy 3 2,221 Aug-18-2021, 05:46 AM
Last Post: naughtyCat
  Pandas DataFrame combine rows by column value, where Date Rows are NULL rhat398 0 2,083 May-04-2021, 10:51 PM
Last Post: rhat398
  Indexing [::-1] to Reverse ALL 2D Array Rows, ALL 3D, 4D Array Columns & Rows Python Jeremy7 8 6,963 Mar-02-2021, 01:54 AM
Last Post: Jeremy7

Forum Jump:

User Panel Messages

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