How do I merge rows of data in python?

Asked Apr 08 '18 at 15:35

Active Apr 08 '18 at 16:02

Viewed 46 times

I have a CSV with rows of data in the rows:

Data:

jobID | industry | clicks

job1, healthcare, 20

job1, healthcare, 30

job2, medicine, 40

job2, medicine, 50

Expected Output:

job1, healthcare, 50

job2, medicine, 90

There are multiple jobIDs and each row represents a day. How can I concatenate the rows with the same jobID with the clicks being added? I'm using python with pandas.

I tried using the pd.concantenate() but there are so many rows of the same jobID so I'd have to write every row.

edited Apr 08 '18 at 16:01

asked Apr 08 '18 at 15:35

Sunisc

It seems need `df[df['jobID'] == df['clicks']` – jezrael Apr 08 '18 at 15:36
@jezrael Will do thank you. – Sunisc Apr 08 '18 at 15:39
@jezrael I added the information, can you take a look at it. I want to be able to have it so that there's just one job, with all the clicks being added. – Sunisc Apr 08 '18 at 15:59
1

Use `df = df.groupby(['jobID', 'industry'], as_index=False)['clicks'].sum()` – jezrael Apr 08 '18 at 16:01

How do I merge rows of data in python?

0 Answers0