Question Re: Python code error in dataflow in Technology Q&A

Python code error in dataflow

Edula — Sun, 01 Jun 2025 12:12:07 GMT

Hi,

I'm very new to python, I hvae a data set with 13 column , once of the called 'gender'. I want to filter the data and result moved to Target table.

However I'm getting below error message called "'method' object is not subscriptable"

Please my code below, unfortunatly we can't debug the code in datasphere

def transform(data):
specific_name = ['Male']
df = data['gender'].isin[('specific_name')]
#data[NV]
return df

Any input would be greatly appreciated

Kind regards

Hari

Re: Python code error in dataflow

XaviPolo — Mon, 02 Jun 2025 08:53:57 GMT

I believe there's a typo in your code, the isin function should be followed by parentheses () instead of brackets []
Like: df = data[data['gender'].isin(specific_name)]

Regards,

Re: Python code error in dataflow

Edula — Mon, 02 Jun 2025 09:42:07 GMT

Hi XaviPolo

Thanks for reply.

I have modified the code as you mentioend,however I'm still getting a syntax error as below.

def transform(data)
specific_name = ['Male']
df = data[data['gender'].isin(specific_name)]
return df

Kind regards

Hari

Re: Python code error in dataflow

XaviPolo — Mon, 02 Jun 2025 10:19:55 GMT

probably there is a typo related with tabs

def transform(data): specific_name = ['Male'] df = data[data['gender'].isin(specific_name)] return df

Re: Python code error in dataflow

Edula — Mon, 02 Jun 2025 10:26:46 GMT

Hi XaviPolo, The same code works in python notebooks or google colabs , but not in Datashpere . I hope that those "isin" functions not available yet in Datasphere.I can't write "import pandas " in datasphere.

Re: Python code error in dataflow

XaviPolo — Mon, 02 Jun 2025 11:13:59 GMT

the previous code works for me.
check that you don't have prints or calls to dataframes to show the data in the console.

pandas is already imported by SAP

Regards,

Re: Python code error in dataflow

Edula — Tue, 03 Jun 2025 19:25:49 GMT

Hi, Below code worked for me

def transform(data):

specific_name = ['Male']

nv = data['gender'].isin(specific_name)

df= data[nv]

return df

Kind regards

Hari