I have two columns in excel sheet that looks like this

I want to iterate in python (using dataframe if possible) to produce multiple excel sheets where my excel files would look like this

File_1 Output (Column 1 will get 10 cities, column 2 will have all persons)

File_2 Output (Column 1 will get the next 10 cities, column 2 will have all persons without any change)

The for loop will continue to iterate until all the rows are done.
Let’s say if I have 105 cities in column 1, the code will generate 11 output files where the last file will only have 5 cities in column 1.

I have tried to use the following code

rows_per_file = 10
n_chunks = PC // rows_per_file


for i in range(n_chunks):
    start = i*rows_per_file
    stop = (i+1) * rows_per_file
    sub_df= df(df.iloc[start:stop,0],0)
    sub_df2=df(df.iloc[0:UC,1],1)
    sub_df3= sub_df+sub_df2
    sub_df3.to_excel(f"test-{i}.xlsx", sheet_name="sheet")

But it gives me all data in single column and slices my 2nd column to 10 person too instead of all 26 person.
I have tried different ways but haven’t been able to figure out.

Any help is appreciated 🙂