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.