Home/ Questions/Learn how to fix error: cannot convert the series to
Next
Answered
Sasha Gagnon
  • 21
Asked: 2022-05-17T13:51:47+00:00 In:

Learn how to fix error: cannot convert the series to

  • 21

. Advertisement .

..3..

. Advertisement .

..4..

I’m trying to run a new project. I do a couple of things like this:

date A
 2001-01-02 1.0022
 2001-01-03 1.1033
 2001-01-04 1.1496
 2001-01-05 1.1033
 
 2015-03-30 126.3700
 2015-03-31 124.4300
 2015-04-01 124.2500
 2015-04-02 124.8900
df["B"] = math.log(df["A"] / df["A"].shift(1))
df["B"] .astype(float)

But in my program, I am getting the warning:

TypeError: cannot convert the series to <class 'float'>

Can someone explain why the “cannot convert the series to” issue happened? Where have I gone wrong? Thank you!

convert the series to
Share

2 Answers

  1. Best Answer
    Expert

    The cause:

    This error occurs due to you just write df["A"].astype(float), it can not change df .

    Solution:

    You can resolve this error by assigning the output of the astype method call to another method, consist of the existing series by using df['A'] = df['A'].astype(float). The other way to solve this issue is that you can either use numpy as @user3582076 suggestions or  .apply on the Series that is a result of dividing today’s value by yesterday’s.

     

    • 12

  2. To apply your functions to either the pandas series or data frame, you can use the lambda operator. You can convert every element in a column to an floating point number by using the lambda operator. 

    df['A'].apply(lambda x: float(x))

    Here, the lambda operator will take values from that column (as “x”) and return them as a floating value.

    • 10

Leave an answer

You must login to add an answer.

Need An Account,