Breaking News: Grepper is joining You.com. Read the official announcement!

how to control chunksize manually in pandas python

Grumpy Gerbil answered on October 25, 2022 Popularity 8/10 Helpfulness 2/10

answer how to control chunksize manually in pandas python

how to control chunksize manually in pandas python

Comment

df = pd.read_excel('/path/excel.xlsx')
df_size = df.shape[0]
columns = df.columns.values
chunksize = 1000
for i in range(0, df_size - chunksize, chunksiz):
    df_chunk = pd.read_excel('/path/excel.xlsx', skiprows=i, skip_footer= (df_size - chunksize*(i+1)), names=columns)

Popularity 8/10 Helpfulness 2/10 Language python

Source: stackoverflow.com

Tags: pandas python

Link to this answer
Share Copy Link