Here's an example I ran with an excel file that I had, replace filename with one of your own and try it:
import pandas as pd from pathlib import Path import os def show_incremental_rows(filename, increment): df = pd.read_excel(filename) print(df.iloc[::increment, :]) def main(): os.chdir(os.path.abspath(os.path.dirname(__file__))) show_incremental_rows('GP2016Cty_637257362220392064.xls', 200) if __name__ == '__main__': main()
Output: ID Election OfficeName VoteFor BallotGroup ... CanAffilCommit County Votes PartyName PartyAbbrev
0 1 GP 2016 100TH REPRESENTATIVE 1 J ... NaN CALHOUN 525 REPUBLICAN REP
500 501 GP 2016 11TH REPUBLICAN DELEGATE 3 G ... BUSH WILL 409 REPUBLICAN REP
1000 1001 GP 2016 12TH REPUBLICAN ALTERNATE DELEGATE 3 G ... BUSH JACKSON 99 REPUBLICAN REP
1500 1501 GP 2016 12TH REPUBLICAN DELEGATE 3 G ... TRUMP WILLIAMSON 3549 REPUBLICAN REP
2000 2001 GP 2016 13TH REPUBLICAN ALTERNATE DELEGATE 3 G ... RUBIO MADISON 915 REPUBLICAN REP
2500 2501 GP 2016 14TH DEMOCRATIC DELEGATE 4 G ... CLINTON LAKE 3881 DEMOCRATIC DEM
3000 3001 GP 2016 15TH DEMOCRATIC DELEGATE 4 G ... CLINTON BOND 377 DEMOCRATIC DEM
3500 3501 GP 2016 15TH REPUBLICAN ALTERNATE DELEGATE 3 G ... CARSON EDWARDS 73 REPUBLICAN REP
4000 4001 GP 2016 15TH REPUBLICAN ALTERNATE DELEGATE 3 G ... CRUZ MOULTRIE 1091 REPUBLICAN REP
4500 4501 GP 2016 15TH REPUBLICAN DELEGATE 3 G ... PAUL RICHLAND 40 REPUBLICAN REP
5000 5001 GP 2016 16TH DEMOCRATIC DELEGATE 5 G ... SANDERS IROQUOIS 419 DEMOCRATIC DEM
5500 5501 GP 2016 16TH REPUBLICAN DELEGATE 3 G ... CARSON WINNEBAGO 435 REPUBLICAN REP
6000 6001 GP 2016 17TH DEMOCRATIC DELEGATE 6 G ... CLINTON MERCER 761 DEMOCRATIC DEM
6500 6501 GP 2016 17TH REPUBLICAN DELEGATE 3 G ... KASICH PEORIA 782 REPUBLICAN REP
7000 7001 GP 2016 18TH DEMOCRATIC DELEGATE 4 G ... SANDERS MORGAN 729 DEMOCRATIC DEM
7500 7501 GP 2016 18TH REPUBLICAN ALTERNATE DELEGATE 3 G ... FIORINA HANCOCK 16 REPUBLICAN REP
8000 8001 GP 2016 18TH REPUBLICAN DELEGATE 3 G ... KASICH MORGAN 698 REPUBLICAN REP
8500 8501 GP 2016 2ND REPUBLICAN DELEGATE 3 G ... FIORINA COOK 83 REPUBLICAN REP
9000 9001 GP 2016 57TH REPRESENTATIVE 1 J ... NaN LAKE 670 DEMOCRATIC DEM
9500 9501 GP 2016 6TH REPUBLICAN ALTERNATE DELEGATE 3 G ... CRUZ COOK 3096 REPUBLICAN REP
10000 10001 GP 2016 8TH REPUBLICAN DELEGATE 3 G ... CARSON KANE 59 REPUBLICAN REP
10500 10501 GP 2016 PRESIDENT 1 A ... NaN ADAMS 119 REPUBLICAN REP
11000 11001 GP 2016 PRESIDENT 1 A ... NaN CALHOUN 2 REPUBLICAN REP
11500 11501 GP 2016 PRESIDENT 1 A ... NaN LAKE 44823 DEMOCRATIC DEM
12000 12001 GP 2016 PRESIDENT 1 A ... NaN CRAWFORD 0 REPUBLICAN REP
12500 12501 GP 2016 UNITED STATES SENATOR 1 A ... NaN HAMILTON 62 DEMOCRATIC DEM
13000 13001 GP 2016 COMPTROLLER 1 B ... NaN LaSALLE 11592 REPUBLICAN REP