Forum Discussion

Leandro's avatar
Leandro
Advocate I
7 years ago
Solved

Python Validate Email Error

Hi everyone!

I found this very usefull tutorial on youtube talking about how validate emails with PBI by using a Python script, this i'm getting this error:



Do you guys knows how to solve this?

the script is very simple:


from validate_email import validate_email

dataset['Valid Email'] = dataset['Email'].apply(lambda x:validate_email(x))


Thanks!

Need Help
Tutorial Requests
  • v-yuta-msft's avatar
    v-yuta-msft
    7 years ago

    Hi Leandro,

     

    Couldn't reproduce your issue. The python script works well on my side. It seems like there's something with your data type, are they text type in your dataset?

     

     

    Regards,

    Jimmy Tao

4 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    7 years ago

    Hi Leandro,

     

    Couldn't reproduce your issue. The python script works well on my side. It seems like there's something with your data type, are they text type in your dataset?

     

     

    Regards,

    Jimmy Tao

    • Leandro's avatar
      Leandro
      Advocate I
      7 years ago

      v-yuta-msft

       

      Thanks a lot for the atention.

       

      After some time, i realized that the problem was really the type as you said.

       

      Thanks! Best Regards!

       

  • SQUILES's avatar
    SQUILES
    Helper I
    6 years ago

    HELP... 

    I trying but PWBI get this error.. any help please

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi everyone,

    I followed the same tutorial but I get another error when running the script:

    I used the same code as the tutorial but there he only has 1 column in his dataset and mine consists of multiple columns with multiple date types.

    I tested the code and when I removed all other columns, it worked as expected.

    Can someone help me out?

     

    Thanks!

     

    DataSource.Error: ADO.NET: Python script error.
    <pi>sys:1: DtypeWarning: Columns (5,7,8,26,27) have mixed types.Specify dtype option on import or set low_memory=False.
    TypeError: expected string or bytes-like object
    </pi>
    Details:
    DataSourceKind=Python
    DataSourcePath=Python
    Message=Python script error.
    <pi>sys:1: DtypeWarning: Columns (5,7,8,26,27) have mixed types.Specify dtype option on import or set low_memory=False.
    TypeError: expected string or bytes-like object
    </pi>
    ErrorCode=-2147467259
    ExceptionType=Microsoft.PowerBI.Scripting.Python.Exceptions.PythonScriptRuntimeException