I will use https://www.pgnmentor.com as a source for chess games in PGN format. This resource allows downloading zipped PGNs.

Downloading and saving archive with PGN file

Unpacking PGN file

Converting PGN to DataFrame

Finding out the top openings