Python Forum
reformatting data frame
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
reformatting data frame
#1
I am trying to convert a pandas data frame with multiple rows and multiple columns to one with singles rows and multiple columns. The current format is

CIMG2_001282-T3 7f27bf6e5247569ff98ecea451351a47 701 PRINTS PR00503 Bromodomain signature 473 486 5.0E-20 T 06-03-2020 IPR001487 Bromodomain GO:0005515
CIMG2_001282-T3 7f27bf6e5247569ff98ecea451351a47 701 PRINTS PR00503 Bromodomain signature 523 542 5.0E-20 T 06-03-2020 IPR001487 Bromodomain GO:0005515
CIMG2_001282-T3 7f27bf6e5247569ff98ecea451351a47 701 ProSitePatterns PS00633 Bromodomain signature. 475 534 - T 06-03-2020 IPR018359 Bromodomain, conserved site
CIMG2_001282-T3 7f27bf6e5247569ff98ecea451351a47 701 Pfam PF00439 Bromodomain 267 342 2.7E-19 T 06-03-2020 IPR001487 Bromodomain GO:0005515
CIMG2_001282-T3 7f27bf6e5247569ff98ecea451351a47 701 Pfam PF00439 Bromodomain 459 545 9.4E-21 T 06-03-2020 IPR001487 Bromodomain GO:0005515
CIMG2_001029-T4 5832f01825886c7d91335db67a8d061e 583 Pfam PF00005 ABC transporter 314 463 5.5E-35 T 06-03-2020 IPR003439 ABC transporter-like GO:0005524|GO:0016887
CIMG2_001029-T4 5832f01825886c7d91335db67a8d061e 583 Pfam PF00664 ABC transporter transmembrane region 19 251 1.3E-40 T 06-03-2020 IPR011527 ABC transporter type

The first column is the gene identifier. I want all the CIMG2_001282-T3 results to be in one row, all the CIMG2_001029-T4 results to be in another. How can I do this in Pandas?

Thanks Theo
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Grouping in pandas/multi-index data frame Aleqsie 3 607 Jan-06-2024, 03:55 PM
Last Post: deanhystad
  Filtering Data Frame, with another value NewBiee 9 1,331 Aug-21-2023, 10:53 AM
Last Post: NewBiee
  Exporting data frame to excel dyerlee91 0 1,606 Oct-05-2021, 11:34 AM
Last Post: dyerlee91
  Pandas Data frame column condition check based on length of the value aditi06 1 2,655 Jul-28-2021, 11:08 AM
Last Post: jefsummers
  Adding a new column to a Panda Data Frame rsherry8 2 2,083 Jun-06-2021, 06:49 PM
Last Post: jefsummers
  grouped data frame glitter 0 1,577 Feb-02-2021, 11:22 AM
Last Post: glitter
  how to filter data frame dynamically with the columns psahay 0 2,379 Aug-24-2020, 01:10 PM
Last Post: psahay
  Dropping Rows From A Data Frame Based On A Variable JoeDainton123 1 2,188 Aug-03-2020, 02:05 AM
Last Post: scidam
  How to shift data frame rows of specified column Mekala 0 1,861 Jul-21-2020, 02:42 PM
Last Post: Mekala
  HELP- DATA FRAME INTO TIME SERIES- BASIC bntayfur 0 1,733 Jul-11-2020, 09:04 PM
Last Post: bntayfur

Forum Jump:

User Panel Messages

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