How to save pandas dataframe into file fixed size of records?

Question

I have a dataframe that contains 1000 records. But I need to save only 100 records in the file. It should be starting at 100. Could you please suggest a solution.

Answer 1

Use the below code:

# Creating a dataframe with 1000 rows

df=pd.DataFrame()

df=df.append(["x"]*1000)

# Loop

i=0

while i <len(df)-1:

   df.iloc[i:i+100,:].to_excel("output_{0}_{1}.xlsx".format(i,i+100),index=False)

   i+=100

Improve your knowledge in data science from scratch using Data science online courses