Dataframe.to_string() issue

Question

I have a dataframe with text value and int inside. I apply df.to_string() without a problem, then I call a the get_value() function on it and get rid of the possible space at the beginning and at the end:

df.get_value(index,column).rstrip(' ').lstrip(' ')

This works fine, however if the value type is int, i got this error :

AttributeError: 'numpy.int64' object has no attribute 'rstrip'

Why does df.to_string() not work ?

You can convert to string all values of DataFrame first - df = df.astype(str) — jezrael
– jezrael, Commented Mar 2, 2017 at 7:37
Maybe duplicated with this one. stackoverflow.com/a/17950531/5226708 — Levi
– Levi, Commented Mar 2, 2017 at 7:42

jezrael · Accepted Answer · 2017-03-02 07:42:11Z

3

It seems you need convert DataFrame to string by astype, for remove first and last whitespaces is better strip():

df = pd.DataFrame({'A':['  s  ','s','d'],
                   'B':[4,5,6],
                   'C':[7,8,9],
                   'D':[1,3,5],
                   'E':[5,3,6],
                   'F':[7,4,3]})

print (df)
       A  B  C  D  E  F
0    s    4  7  1  5  7
1      s  5  8  3  3  4
2      d  6  9  5  6  3

print (df.astype(str).get_value(0,'A').strip())
s

print (df.astype(str).loc[0,'A'].strip())
s

answered Mar 2, 2017 at 7:42

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

Dataframe.to_string() issue

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related