Math Ceiling Function Convert to Float error

Asked May 10 '20 at 17:36

Active May 10 '20 at 17:38

Viewed 28 times

I have the following code that's giving me an error... I have no idea why - thoughts?

file = r"C:\Users\xxxxx"
xls = xlrd.open_workbook(file, on_demand=True)

def roundup(x):
    return int(math.ceil(x / 10000.0)) * 10000

df = pd.read_excel(file, sheet_name='Sheet2')
cols = ['Id','Total Cost','Custom']
df = df[cols]
df['Total Cost'] = df['Total Cost'].astype(float)
df['cSum'] = df['Total Cost'].cumsum()
print(roundup(df['cSum']))

Error: TypeError: cannot convert the series to class 'float'

edited May 10 '20 at 17:38

wjandrea

16,334
5
30
53

asked May 10 '20 at 17:36

RCarmody

1

Please post the full error with traceback, so we can see where the error is occurring – wjandrea May 10 '20 at 17:39
`df['cSum']` is a SERIES and `math.ceil(x / 10000.0)` wants `x` to be a float... use the appropriate numpy methods to do so – Patrick Artner May 10 '20 at 17:42

Math Ceiling Function Convert to Float error

0 Answers0