Running into error: 'float' object is not subscriptable

Question

I created a defined function to add one month if the 'SR_NUMBER' is the same as the row above. I get the error message: 'float' object is not subscriptable. Here is the code I ran and the desired output:

dtypes: SR_Number: object

year_month_end: datetime64[ns]

Code attempt:

def SRfunction(row):
    if row['SR_NUMBER'] == row['SR_NUMBER'].shift(1):
        return row['year_month_end'] + MonthEnd(1)
    else:
        return row['year_month_end']

df['SR_NUMBER'] = df['SR_NUMBER'].apply(SRfunction)

Error message: 'float' object is not subscriptable

Original df:


df = pd.DataFrame({'SR_NUMBER':      ['2-15642332176', '3-22596843941', '3-22596843941', '3-22596843941', '3-22596843941'],
                   'year_month_end': ['2020-02-28', '2020-04-30', '2020-04-30', '2020-04-30', '2020-04-30']})

Desired output:

df = pd.DataFrame({'SR_NUMBER':       ['2-15642332176', '3-22596843941', '3-22596843941', '3-22596843941', '3-22596843941'],
                   'year_month_end':  ['2020-02-28', '2020-04-30', '2020-05-31', '2020-06-30', '2020-07-31']})

0x5453 · Accepted Answer · 2021-11-09 18:33:39Z

1

pd.DataFrame.apply is different from pd.Series.apply.

In this case row is not a row at all, but a single float value from the SR_NUMBER column.

If your applied function needs data that spans multiple columns, you need to use the DataFrame form of apply, but you are currently using the Series form.

answered Nov 9, 2021 at 18:33

0x5453

13.7k2 gold badges36 silver badges70 bronze badges

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

1 Comment

Deke Marquardt Over a year ago

THank you! Could you maybe elaborate further on how the full code would look if you were to fix it?

Collectives™ on Stack Overflow

Running into error: 'float' object is not subscriptable

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related