TypeError: ('sequence item 0: expected string, numpy.int64 found', u'occurred at index 1')

Question

I am calculating the frequency of each sequence in df:

VD_1    VD_2    VD_2
35000   35090   31550
35000   35090   31550
35099   45097   
35099   45097   
35099   45097

If I do run the code given below, I get an error TypeError: ('sequence item 0: expected string, numpy.int64 found', u'occurred at index 1'). In fact, the code works fine on the other dataset, but here it fails:

df['data'] = df.apply(lambda x: '/'.join(x.dropna()), axis=1)
df = df.data.value_counts().rename_axis('count').reset_index()
df

The result should be this one:

data                count
35000/35090/31550   2
35099/45097         1

jezrael · Accepted Answer · 2017-02-16 13:11:09Z

2

It seems you need add astype(str) for cast int to string:

df['data'] = df.apply(lambda x: '/'.join(x.dropna().astype(str)), axis=1)

answered Feb 16, 2017 at 13:11

jezrael

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

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

Collectives™ on Stack Overflow

TypeError: ('sequence item 0: expected string, numpy.int64 found', u'occurred at index 1')

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related