bgbg bgbg - 1 year ago 81
Python Question

How to group pandas DataFrame entries by date in a non-unique column

A Pandas

contains column named "date" that contains non-unique
I can group the lines in this frame using:


However, this splits the data by the
values. I would like to group these data by the year stored in the "date" column. This page shows how to group by year in cases where the time stamp is used as an index, which is not true in my case.

How do I achieve this grouping?

Answer Source

ecatmur's solution will work fine. This will be better performance on large datasets, though:

data.groupby(data['date'].map(lambda x: x.year))
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download