/Python/Read large SAS file ilarger than memory n Python

Read large SAS file ilarger than memory n Python

import pandas as pd
import pyreadstat
filename = 'foo.SAS7BDAT'
CHUNKSIZE = 50000
offset = 0
allChunk,_ = getChunk(row['filePath'], row_limit=CHUNKSIZE, row_offset=offset)
allChunk = allChunk.astype('category')

while True:
    offset += CHUNKSIZE
    # for xpt data, use pyreadstat.read_xpt()
    chunk, _ = pyreadstat.read_sas7bdat(filename, row_limit=CHUNKSIZE, row_offset=offset)
    if chunk.empty: break  # if chunk is empty, it means the entire data has been read, so break

    for eachCol in chunk:  #converting each column to categorical 
        colUnion = pd.api.types.union_categoricals([allChunk[eachCol], chunk[eachCol]])
        allChunk[eachCol] = pd.Categorical(allChunk[eachCol], categories=colUnion.categories)
        chunk[eachCol] = pd.Categorical(chunk[eachCol], categories=colUnion.categories)

    allChunk = pd.concat([allChunk, chunk])  #Append each chunk to the resulting dataframe

Source: stackoverflow.com

Similar codes

3 votes120 views5 answers
Nltk python
Python
0 vote135 views1 answer
C="He is {} and he is {}".format(a,b) python
Python
0 vote126 views1 answer
InvalidVersionSpec: Invalid version ' 0 . 7 . 1 2 ': invalid character(s)
Python
-1 vote131 views1 answer
Let’s add a docstring to the greeting method. How about, “Outputs a message with the name of the person”.
Python
1 vote133 views2 answers
Python does string contain space
Python
4 votes133 views4 answers
Speech to write anything python code
Python
3 votes173 views1 answer
The authorization mechanism you have provided is not supported. Please use AWS4-HMAC-SHA256
Python
34 votes256 views6 answers
Simple flask app
Python Flask
0 vote118 views1 answer
Install ansible with pip
Python
3 votes124 views2 answers
How to change cursor on hover of button in tkinter
Python