How to divide up data through rows in excel using python

Question

I need to divide data in an excel and put it into another excel using python

For Example, suppose i have an excel which has 1000 rows of data as follows

Name    Number

name1   number1
name2   number2
name3   number3

and so on

Now suppose there are 1000 rows and i need to select 200 rows at a time and put those values in another excel and then remove these 200 values from this excel and then take the next 200 values and put it into another excel How can i do it using python

N.Moudgil · Accepted Answer · 2020-01-30 12:33:59Z

3

You can achieve it using pandas library:

import pandas as pd    
dfs = pd.read_excel(file_name, sheetname=None)

#divide
df1=dfs[:200]
df2=dfs[200:400] and so on...

#saving divided dataframes to different excels
df1.to_excel("df1.xlsx")

Hope it helps.

answered Jan 30, 2020 at 12:33

N.Moudgil

9097 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Gavya Mehta Over a year ago

but what if i don't know how many rows are there and i need to find the last row and then divide accordingly?

N.Moudgil Over a year ago

@GavyaMehta you can use len(dfs) or len(df.index) to count the rows

sahil · Accepted Answer · 2020-01-30 12:43:55Z

0

pip install pandas.
Convert excel file to data-frame using pandas.
Then Slice the data-fame to 200 using simple python slicing method [:200]
now write the data-frame to new excel file
Again slice the old excel data-frame to ignore first 200 records.

answered Jan 30, 2020 at 12:43

sahil

391 silver badge8 bronze badges

Collectives™ on Stack Overflow

How to divide up data through rows in excel using python

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related