Oct-16-2020, 09:57 AM
I have a pandas dataframe and want to transform
partyID SourceID Text 1 Name 1 Text 2 Name 2
1 1 ramesh kumar jhon pop
1 2 cherry honey juliet mariyo
transpose to dataframe
partyID SourceID Text Name
1 1 ramesh kumar
1 1 jhon pop
1 2 cherry honey
1 2 juliet mariyo
I have multiple sets with Text 1 .... 10 and Name 1 to 10) as columns in the source
partyID SourceID Text 1 Name 1 Text 2 Name 2
1 1 ramesh kumar jhon pop
1 2 cherry honey juliet mariyo
transpose to dataframe
partyID SourceID Text Name
1 1 ramesh kumar
1 1 jhon pop
1 2 cherry honey
1 2 juliet mariyo
I have multiple sets with Text 1 .... 10 and Name 1 to 10) as columns in the source