import os, csv, re csv_file_name = "foodnutrition.csv" def clean_string(s): # Remove special characters s = re.sub(r'[^\w\s]', '', s) # Replace spaces with underscores s = re.sub(r'\s+', '_', s) # Convert to lowercase s = s.lower() return s def read_csv(filename): with open(filename, 'r') as f: reader = csv.DictReader(f) data = [row for row in reader] return data def create_paginated_listing(data, rows_per_page): # Generate a list of versus_clean_str values versus_clean_str_values = [] for i in range(len(data)): for j in range(i+1, len(data)): versus_clean_str = clean_string(data[i]['FoodDescription']) + '_versus_' + \ clean_string(data[j]['FoodDescription']) versus_clean_str_values.append(versus_clean_str) # Calculate the number of pages num_pages = len(versus_clean_str_values) // rows_per_page + (len(versus_clean_str_values) % rows_per_page > 0) for page_num in range(num_pages): with open(f'./htmloutput/foodindex{page_num + 1}.html', 'w') as f: f.write('Food Nutrition Comparison\n') # Write rows for each versus_clean_str on this page for i in range(rows_per_page): versus_clean_str_index = page_num * rows_per_page + i if versus_clean_str_index < len(versus_clean_str_values): f.write(f'\n') f.write('
{versus_clean_str_values[versus_clean_str_index]}
\n') # Write 'Previous' button if not on first page if page_num > 0: f.write(f'Previous\n') # Write 'Next' button if not on last page if page_num < num_pages - 1: f.write(f'Next\n') f.write('\n') # Call the function to create the paginated listing create_paginated_listing(read_csv(csv_file_name), 1000)