pandas string values are not getting proper format

Question

Before reading into pandas my data looks like in sas dataset

Name 
Alfred
Alice

After reading into pandas data is getting as

Name 
b'Alfred'
b'Alice'

Why I am getting the data is different? Steps followed:

Import pandas as pd
df=pd.read_sas(r'C:/ProgramData/Anaconda3/Python_local/class.sas7bdat',format='sas7bdat')

Need your help.

It is actually the same. SAS stores bytes you get bytes. It is only how python present bytes — Lee
– Lee, Commented Jan 14, 2020 at 12:22

E. Sommer · Accepted Answer · 2020-01-14 06:30:15Z

0

SAS files need to be imported with special encoding

df=pd.read_sas(r'C:/ProgramData/Anaconda3/Python_local/class.sas7bdat',format='sas7bdat', encoding='iso-8859-1')

answered Jan 14, 2020 at 6:30

E. Sommer

7501 gold badge8 silver badges32 bronze badges

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

1 Answer 1