Python Forum
Convert row data to columns based on keyword
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Convert row data to columns based on keyword
#1
I have two columns of data with string names and values (x, y). I would like to convert it to columns.

For example
Column 1 Column 2
String1 String 2
x1 y1
x2 y2
x3 y3

String1 String2
x1 y1
x2 y2
x3 y3

String1 String2
x1 y1
x2 y2
x3 y3


What is the best way to get this data into columns so that it can be graphed. String1 and String2 have the same names. Any help would be appreciated.
Reply
#2
What have you tried?
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Find a specific keyword after another keyword and change the output sgtmcc 5 746 Oct-05-2023, 07:41 PM
Last Post: deanhystad
  Convert File to Data URL michaelnicol 3 1,082 Jul-08-2023, 11:35 AM
Last Post: DeaD_EyE
  Grouping Data based on 30% bracket purnima1 4 1,142 Mar-10-2023, 07:38 PM
Last Post: deanhystad
  Extracting Data into Columns using pdfplumber arvin 17 5,201 Dec-17-2022, 11:59 AM
Last Post: arvin
  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
  openpyxl convert data to float jacklee26 13 5,716 Nov-19-2022, 11:59 AM
Last Post: deanhystad
  conditionals based on data frame mbrown009 1 873 Aug-12-2022, 08:18 AM
Last Post: Larz60+
  I have written a program that outputs data based on GPS signal kalle 1 1,134 Jul-22-2022, 12:10 AM
Last Post: mcmxl22
  Convert nested sample json api data into csv in python shantanu97 3 2,726 May-21-2022, 01:30 PM
Last Post: deanhystad
Question Change elements of array based on position of input data Cola_Reb 6 2,063 May-13-2022, 12:57 PM
Last Post: Cola_Reb

Forum Jump:

User Panel Messages

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