converting lists to dataframe creates strings with 'b' before them

Asked May 04 '18 at 13:09

Active May 04 '18 at 13:13

Viewed 30 times

I have a list in python3.6 which when i turn into a Dataframe inputs a 'b' in front of the all the strings.

for example:

x=[['a','b','c',1,2,3],['a1','b1','c1',1,2,3]]
df=pd.DataFrame(x)

where df will be:

b'a',b'b',b'c',1,2,3
 b'a1','b'b1','b'c1',1,2,3

any ideas how to create a literal translation from a list to a dataframe

edited May 04 '18 at 13:13

asked May 04 '18 at 13:09

matthewr

1

check here https://stackoverflow.com/questions/6269765/what-does-the-b-character-do-in-front-of-a-string-literal – Joe May 04 '18 at 13:12
2

Can't reproduce, Python 3.6.4 and pandas 0.20.3. I also think you meant `x` to be `[['a','b','c',1,2,3],['a1','b1','c1',1,2,3]] ` – DeepSpace May 04 '18 at 13:12
@DeepSpace yeah sorry about that, changed it now. – matthewr May 04 '18 at 13:14
@matthewr You should add the exact code you are running which outputs the output you see – DeepSpace May 04 '18 at 13:15

0 Answers0