Data Transformation using Python throwing error.

[Anonymous]

I'm rewriting a panda series in a dataframe based on a condition. I feel it is not allowed in powerBI. I tried making a new column but still getting the same error. Can someone help?

DataSource.Error: ADO.NET: Python script error. PythonScriptWrapper.PY:82: SettingWithCopyWarning:

A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy
dataframe['Feature']=dataframe['Feature'].map(lambda x: 'Unavailable' if x not in predefined_classes['Pri_Clases'] else x)

[v-yuta-msft · Accepted solution]

@Anonymous ,

To avoid the error message, you need to add .loc function, please refer to the solution in link below:

https://stackoverflow.com/questions/20625582/how-to-deal-with-settingwithcopywarning-in-pandas

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.