Code working on DQ but not on Jupyter

Q&A DQ Courses
#1

Hi everyone!

I’m currently on Transforming Data With Pandas (7. Reshaping Data with the Melt Function). The answer code worked on the website but not on my Jupyter*. It throws this error: TypeError: cannot convert the series to <type 'float'>

My machine has Python 2.7 so I thought that would be the case but I don’t see similar experiences in Stackoverflow. Would you know why it’s throwing a type error?

29
Screenshot 2019-06-12 at 19.11.29.png1440×900 177 KB
40
Screenshot 2019-06-12 at 19.11.40.png1440×900 202 KB

Sending the screenshots for your reference. Please let me know.

Thanks!

  • I do the exercises there so I can do more manipulation. The exercises tell me it’s wrong when I do other stuff from the instructions.

[UPDATE]
I found a workaround but still curious why the original code didn’t work on Jupyter

23
Screenshot 2019-06-12 at 19.46.23.png667×508 61.2 KB

#2

round function takes in a scalar (float) as a input. However, you are passing in a series. A series is not a float type. Hence the error occurs.

You can use assign the values first without the round method.

The use .apply to the new column to round.

df[percentage] = df[percentage].apply(lambda x: round(x, 2))