u's in Pandas DataFrame

Question

Running the following code in Python 2.7:

import numpy as np
import pandas as pd

dates = pd.date_range('20190102', periods=6)
df = pd.DataFrame(np.random.randn(6,4), index=dates, columns=list('ABCD'))
print df.columns

produces this output:

Index([u'A', u'B', u'C', u'D'], dtype='object')

From other sources I gather that these are unicode labels. How do I get rid of them?

Does this work for you? `df.columns = [str(x) for x in df.columns]` — adrtam, Mar 28 '19 at 21:13

score 1 · Accepted Answer · answered Mar 28 '19 at 21:15

1

df.columns = [str(col_name) for col_name in df.columns]

More information can be found in this answer:

Removing u in list

answered Mar 28 '19 at 21:15

Christian Holmes

26
4

score 0 · Answer 2 · answered Nov 21 '19 at 13:35

0

you can also use 'str()' on the parsed data

answered Nov 21 '19 at 13:35

Antonin GAVREL

9,682
8
54
81

u's in Pandas DataFrame

2 Answers2