/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 votes125 views1 answer
Endswith python
Python
0 vote152 views1 answer
Change float column to percentage python
Python
4 votes198 views3 answers
How to check if a number is a perfect square python
Python
2 votes175 views1 answer
Python how to get the last element in a list
Python
0 vote163 views1 answer
Solidity compiler for python
Python
0 vote166 views1 answer
Python manually trigger exception
Python
0 vote173 views1 answer
Change edit last line python
Python
1 vote159 views1 answer
Find nth root of m using python
Python
0 vote214 views1 answer
DRF: get ip address
Python
0 vote158 views1 answer
Traceback (most recent call last): File "c:\Users\asus\OneDrive\Documents\anak sekolah\pip\string formating\no8.py", line 1, in <module> f = open("demofile.txt","r") FileNotFoundError: [Errno 2] No such file or dir
Python