How to group by multiple columns and with only date part of datetime in pandas

Question

I a have dataframe like this

CELL ID	Party	LOC	Date & Time
10631	3009787	bwp	2021-10-01 8:20:30
10631	3009787	bwp	2021-10-01 8:40:50
50987	2275172	bwp	2021-10-02 7:50:20
50987	2275172	bwp	2021-10-02 7:23:16

I want output dataframe which contains grouped data .Use CELL ID, Party & Only Date Part of Date & time in group :

Output in this Format : https://i.sstatic.net/XFaDS.png

CELL ID -->Party --> Date & Time

Your Date & Time column currently only contains a date. What's the problem? Can you please provide a more representative sample dataframe? — ddejohn
– ddejohn, Commented Oct 8, 2021 at 16:28

ddejohn · Accepted Answer · 2021-10-08 17:09:02Z

1

Here you go:

# df["Date & Time"] = pd.to_datetime(df["Date & Time"])  # If not already datetime
df.set_index(["CELL ID", "Party", df["Date & Time"].dt.date])

Output:

                             LOC         Date & Time
CELL ID Party   Date & Time
10631   3009787 2021-10-01   bwp 2021-10-01 08:20:30
                2021-10-01   bwp 2021-10-01 08:40:50
50987   2275172 2021-10-02   bwp 2021-10-02 07:50:20
                2021-10-02   bwp 2021-10-02 07:23:16

edited Oct 8, 2021 at 17:09

answered Oct 8, 2021 at 16:38

ddejohn

9,0043 gold badges21 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Zulqarnain Sabir Over a year ago

Now how can we combines these groups into a single dataframe

ddejohn Over a year ago

Wait, if that's what you want to do, then why not just remove the time values altogether, and the drop duplicates?

Zulqarnain Sabir Over a year ago

I want a dataframe that contains all these groups

ddejohn Over a year ago

You're going to need to provide your desired outcome because it's no longer clear what you're asking for.

ddejohn Over a year ago

@ZulqarnainSabir see my edit

|

Collectives™ on Stack Overflow

How to group by multiple columns and with only date part of datetime in pandas

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related