Python Validate Email Error

[Leandro]

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!

[Anonymous]

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

[SQUILES]

HELP... 

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

[v-yuta-msft · Accepted solution]

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]

@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!