cannot convert the series to (converter)

Package:

pandas

30911

Exception Class:

TypeError

Raise code

    """
    Install the scalar coercion methods.
    """

    def wrapper(self):
        if len(self) == 1:
            return converter(self.iloc[0])
        raise TypeError(f"cannot convert the series to {converter}")

    wrapper.__name__ = f"__{converter.__name__}__"
    return wrapper


# ----------------------------------------------------------------------
# Series class

Links to the raise (1)

https://github.com/pandas-dev/pandas/blob/b3e335254f46a526ee3ce9bb757eac4011d9d1fe/pandas/core/series.py#L185

Ways to fix

Summary: Cannot convert Series type to scalar type like int, float, and long

Code to reproduce (WRONG):

import pandas as pd

df = mock_df = pd.DataFrame(data={
    'A': [1,2,3]
})

int(df['A']) #Try to convert Series to an integer will throw the exception

Working version (Fixed)

import pandas as pd

df = mock_df = pd.DataFrame(data={
    'A': [1,2,3]
})

int("1") # convert string to integration is ok

Jun 06, 2021

phoang88 615

Add a possible fix

Please authorize to post fix