Mar-18-2020, 02:17 PM
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
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