0

I have a pandas dataframe with following columns.

id                                      term                    cross_ref
https://identifiers.org/meddra:10000059 Abdominal discomfort    http://snomed.info/id/43364001
https://identifiers.org/meddra:10000060 Abdominal distension    http://snomed.info/id/162068007
https://identifiers.org/meddra:10000081 Abdominal pain          http://snomed.info/id/21522001
https://identifiers.org/meddra:10029354 Neutropenia             http://snomed.info/id/165517008
https://identifiers.org/meddra:10029366 Neutrophil count decreased  http://snomed.info/id/165517008
https://identifiers.org/meddra:10029367 Neutrophil count less http://snomed.info/id/165517008

I would like to check if the value in 'cross_ref'column is identical then pass on the value of id (from another row) to a new column.

The expected output is:

id                                      term                    cross_ref                        id2           term2         
https://identifiers.org/meddra:10000059 Abdominal discomfort    http://snomed.info/id/43364001
https://identifiers.org/meddra:10000060 Abdominal distension    http://snomed.info/id/162068007
https://identifiers.org/meddra:10000081 Abdominal pain          http://snomed.info/id/21522001
https://identifiers.org/meddra:10029354 Neutropenia             http://snomed.info/id/165517008   https://identifiers.org/meddra:10029366   Neutrophil count decreased
https://identifiers.org/meddra:10029354 Neutropenia             http://snomed.info/id/165517008 https://identifiers.org/meddra:10029367 Neutrophil count less

Any help is highly appreciated.

rshar
  • 1,381
  • 10
  • 28

0 Answers0