python - Pandas: `item` has been deprecated

Question

So far I used this line of code here:

max_total_gross = event_data["max_total_gross"].loc[event_data["event_id"] == event_id].item()

Since I updated Pandas I receive the future warning:

/opt/conda/lib/python3.7/site-packages/ipykernel_launcher.py:12: FutureWarning: item has been deprecated and will be removed in a future version if sys.path[0] == '':

I tried to fix it that way, but it's not the same outcome:

event_data.loc[event_data.event_id == event_id, 'max_total_gross']

I expected a single integer.

Answer 1

You could also just use .iloc[0], but keep in mind that it will raise an IndexError if there is not at least one item in the series you're calling it on.

s = event_data.loc[event_data.event_id == event_id, 'max_total_gross']
s.iloc[0]