Convert 2nd column values to rows when column 1 is the same name

[Craigc3814]

I have 2 columns

Column 1 is the name of a street and that street name is repeated for each task that was completed on the street. I want to group the street name so that there is only 1 line but a new column for each task

10th street Repair pothole
10th street New Stop Sign
10th street New curb
11th street Repair Pothole
11th street Add Stoplight

so the data would look like this when complete

10th street Repair pothole New stop sign new curb
11th street Repair pothole Add stoplight

Is this done with a modulo column? I cannot seem to remember how I figured it out in the past.

 

[harry780]

yes, but this depends on your data source. pandas supports various data sources you can build a dataframe from

I have a large excel spreadsheet that is generated from a python script containing data in this format:

[TABLE="width: 1301"]
<tbody>[TR]
[TD]GUID[/TD]
[TD]Chemical[/TD]
[TD]Association[/TD]
[TD]Term[/TD]
[/TR]
[TR]
[TD]{2EFD7D98-C03D-4821-B43F-BC1DBAD7F6B8}[/TD]
[TD](1,1-Dimethylethyl)benzaldehyde[/TD]
[TD]exactMatch[/TD]
[TD]tert-Butylbenzaldehyde :- {(1,1-Dimethylethyl)benzaldehyde}[/TD]
[/TR]
[TR]
[TD]{2EFD7D98-C03D-4821-B43F-BC1DBAD7F6B8}[/TD]
[TD](1,1-Dimethylethyl)benzaldehyde[/TD]
[TD]exactMatch[/TD]
[TD]tert-Butylbenzaldehyde[/TD]
[/TR]
[TR]
[TD]{09114BCC-72B9-4A86-A18C-5C60304C4944}[/TD]
[TD](1,1-Dimethylethyl)benzene[/TD]
[TD]exactMatch[/TD]
[TD]tert-Butylbenzene[/TD]
[/TR]
[TR]
[TD]{09114BCC-72B9-4A86-A18C-5C60304C4944}[/TD]
[TD](1,1-Dimethylethyl)benzene[/TD]
[TD]exactMatch[/TD]
[TD]tert-Butylbenzene :- {(1,1-Dimethylethyl)benzene}[/TD]
[/TR]
</tbody>[/TABLE]

But I am wanting to represent this data like this:

[TABLE="width: 1051"]
<tbody>[TR]
[TD]GUID[/TD]
[TD]Chemical[/TD]
[TD]Association[/TD]
[TD]Term[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]{2EFD7D98-C03D-4821-B43F-BC1DBAD7F6B8}[/TD]
[TD](1,1-Dimethylethyl)benzaldehyde[/TD]
[TD]exactMatch[/TD]
[TD]tert-Butylbenzaldehyde :- {(1,1-Dimethylethyl)benzaldehyde}[/TD]
[TD]tert-Butylbenzaldehyde[/TD]
[/TR]
[TR]
[TD]{09114BCC-72B9-4A86-A18C-5C60304C4944}[/TD]
[TD](1,1-Dimethylethyl)benzene[/TD]
[TD]exactMatch[/TD]
[TD]tert-Butylbenzene[/TD]
[TD]tert-Butylbenzene :- {(1,1-Dimethylethyl)benzene}[/TD]
[/TR]
</tbody>[/TABLE]

Is there a way to do this with pandas ?
Sorry I am fairly new to python programming
Many thanks