Dropping rows from DataFrame with minutes in datetime object

Question

I have a DataFrame sy_wx as below:

And I wish to drop any row with minutes not equal to zero to look like.

Using

sy_wx = sy_wx[sy_wx['time_utc'].minute == 0]

gives AttributeError: 'Series' object has no attribute 'minute' error

but

In [50]: sy_wx['time_utc'][1].minute
Out[50]: 30

Where am I going wrong?

score 2 · Answer 1 · answered May 12 '20 at 00:02

first, make sure your datatype for time_utc column is DateTime. You can convert object(str) to DateTime using this code:

sy_wx['time_utc'] = pd.to_datetime(sy_wx['time_utc'])

then use this code to filter your data:

sy_wx = sy_wx[sy_wx['time_utc'].dt.minute == 0]

you are missing dt before minute

score 1 · Answer 2 · answered May 12 '20 at 00:02

1

We need use dt to get the minute

sy_wx = sy_wx[sy_wx['time_utc'].dt.minute == 0].copy() # also add copy at the end , for set copy error

answered May 12 '20 at 00:02

BENY

Thanks @YOBEN_S. Any chance you could elaborate on the .copy() at the end? – Tim May 12 '20 at 01:03
1

https://stackoverflow.com/questions/20625582/how-to-deal-with-settingwithcopywarning-in-pandas @Tim – BENY May 12 '20 at 01:21

2 Answers2