Anton T.
Offer Anton work on your next project.
Rating
Language proficiency level
Skills and abilities
Programming
Services
Portfolio
-
7 USD Book catalog parser with pagination → export to Excel
Data ParsingPage navigation: Loops through pages from 1 to 50 with a 1-second pause between requests (time.sleep(1)).
Data collection: Uses requests and BeautifulSoup to find book cards (), extracting the title (title attribute in the ) and the price ().
Saving: Writes data to Excel using pandas.
Formatting (openpyxl):
… Freezes the first row (header).
Makes the header bold and fills it with gray color.
Centers the "Price" column.
Automatically adjusts the width of columns to fit the length of the text.
Note: this script is a demo version.