try to add two columns in pandas data frame, always get error

Question

please see code and return
new to Python and really appreciate your help!

df['Height'] = df['Wall Top'] - df['Elevation']

return error

provide rest of the code we can tell you where things got messy — Rayhane Mama, Jul 03 '17 at 22:12

Luis Miguel · Answer 1 · 2017-07-09T13:09:26.990

2

The columns of your df are of different types. if you type:

df.dtypes

You'll see that one is str and one is float, or both are object type. You need to do this:

df['Height'] = df['Wall Top'].astype(float) - df['Elevation'].astype(float)

It should do the calculation you want.

edited Jul 09 '17 at 13:09

answered Jul 03 '17 at 22:30

Luis Miguel

zdeeb · Answer 2 · 2017-07-03T22:34:45.247

-1

If you read the error, seems like a data type issue

df['Height'] = df['Wall Top'].astype(float) - df['Elevation'].astype(float)

or you can following existing post

edited Jul 03 '17 at 22:34

answered Jul 03 '17 at 22:28

zdeeb

you just changed your solution to mine...not cool – Luis Miguel Jul 03 '17 at 22:38

2 Answers2