TypeError: argument of type 'int' is not iterable (using lambda)

Question

 nb_products_per_basket['order_canceled'] =            
 nb_products_per_basket['InvoiceNo'].apply(lambda x:int('C' in x))

I have this :

TypeError: argument of type 'int' is not iterable

how can I fix it ?

What nb_products_per_basket['InvoiceNo'] contains? Provide an example, please — Mikhail Stepanov
– Mikhail Stepanov, Commented Jan 22, 2019 at 9:16

jezrael · Accepted Answer · 2019-01-22 09:28:54Z

1

There is problem one, multiple or all values are integers in column InvoiceNo.

Possible solution if mixed column values (C are in another values not shown in sample data) is cast it to strings by astype:

nb_products_per_basket['order_canceled'] =            
nb_products_per_basket['InvoiceNo'].astype(str).apply(lambda x:int('C' in x))

Another solution with str.contains:

nb_products_per_basket['order_canceled'] =            
nb_products_per_basket['InvoiceNo'].str.contains('C', na=False).astype(int)

If all values are integers there are no C, so always get 0.

answered Jan 22, 2019 at 9:24

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1