how to read sas file in chunks in python pandas?

Question

I've got code as follows:

asm_data=[]
asm=pd.read_sas('path_to_my_file',encoding='utf-8',chunksize=10000,iterator=True)
for chunk in asm:
    asm_data.append(asm)

the output is asm_data as list of sas7bdatreader files. How can I concat all this files in one dataframe. pd.concat doesn't work since this are sas files

data_b77 · Accepted Answer · 2020-07-10 09:28:38Z

2

found it :)

asm_data=[]
asm=pd.read_sas('path_to_my_file',encoding='utf-8',chunksize=10000,iterator=True)

for chunk in asm:
    asm_data.append(chunk)
asm_data_df=pd.concat(asm_data)

The point was append 'chunk' as above. My mistake.

answered Jul 10, 2020 at 9:28

data_b77

4337 silver badges22 bronze badges

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

Collectives™ on Stack Overflow

how to read sas file in chunks in python pandas?

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