The issue is with your resample method. You’re using resample('30T') but you should use resample('30min'). This will group every 30 minutes in the ‘agenttimestamp’ column.

Also, try to create a boolean mask for the minute part of the timestamp and then apply that mask to filter the rows.

Here’s an example:

df[df['agenttimestamp'].dt.minute % 30 == 0]

This will give you all rows where the minute part is either 0 or 30.

Alternatively, if you want to group every 30 minutes and perform some operation on each group, you can use the resample function like this:

df_resampled = df.resample('30min', on='agenttimestamp').mean()

This will give you a new dataframe with the mean of all values in the original dataframe for every 30 minute interval.

If you want to remove duplicates, first convert your ‘agenttimestamp’ column to datetime format and then use drop_duplicates method.

df['agenttimestamp'] = pd.to_datetime(df['agenttimestamp'])
df = df.drop_duplicates(subset='agenttimestamp')

You can combine these steps as needed depending on what you’re trying to achieve with your dataframe.

Last modified on 2025-02-01