condense multiple rows into 1 aggregated by other columns pandas

Question

How do I select a column that is grouped by other columns and put all the values of the column in 1 row (in a list). Input:

PropID    Manager    Manager_email      date
  1         A         a@aol.com       2021-02-01
  1         A         a@aol.com       2021-02-02
  1         A         a@aol.com       2021-02-03
  1         A         a@aol.com       2021-02-04
  2         B         b@aol.com       2021-02-08
  2         B         b@aol.com       2021-02-10
  2         B         b@aol.com       2021-02-12
  2         B         b@aol.com       2021-02-16

Desired Output:

PropID    Manager    Manager_email                      date
  1         A         a@aol.com       [2021-02-01,2021-02-02,2021-02-03,2021-02-04]
  2         B         b@aol.com       [2021-02-08,2021-02-10,2021-02-12,2021-02-16]

Does this answer your question? [How to group dataframe rows into list in pandas groupby](https://stackoverflow.com/questions/22219004/how-to-group-dataframe-rows-into-list-in-pandas-groupby) — Henry Ecker, Jul 20 '21 at 00:32

score 4 · Accepted Answer · answered Jul 19 '21 at 22:48

4

try this:

df.groupby(['PropID','Manager','Manager_email'])['date'].agg(list)

answered Jul 19 '21 at 22:48

rhug123

7,893
1
9
24

this one's changing the dataframe to a series. anyway I can retain the structure in a dataframe? – TheCluelessCoder Jul 26 '21 at 19:47
1

try adding `.reset_index()` to the end. – rhug123 Jul 27 '21 at 01:57

condense multiple rows into 1 aggregated by other columns pandas

1 Answers1