/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

0 vote127 views1 answer
How to find outliers in python
Python
2 votes144 views1 answer
Django.core.exceptions.ImproperlyConfigured: WSGI application 'souroSANOU.wsgi.application' could not be loaded; Error importing module.
Python Django
1 vote107 views1 answer
Python recursive sum of digit
Python
3 votes128 views3 answers
3d plots in python
Python
5 votes122 views5 answers
12 month movinf average in python for dataframe
Python
2 votes120 views1 answer
Def multiply(a, b): a * b
Python
2 votes147 views2 answers
Sigmoid in python from scratch
Python
2 votes156 views1 answer
Convert python pandas series dtype to datetime
Python
10 votes125 views3 answers
Accessing element from csv file in python
Python
0 vote228 views1 answer
Dictionary Get All Values
Python