Create an HTML sitemap for a list of URLs and their anchor text

url_to_html_sitemap.py

# Create anchors for all letters:

import string
print('<h3>' + '&nbsp;&nbsp;&nbsp;&nbsp;'.join([f'<a href="#{letter}">{letter}</a>' for letter in string.ascii_uppercase]) + '</h3>')

# Assuming you have a DataFrame with the columns "full_name" and "loc":

for letter in string.ascii_uppercase:
    df = players_df[players_static['full_name'].str[0].eq(letter)]
    print()
    print(f'<div id={letter}><h2>{letter}</h2></div>')
    print()
    for fullname, loc in df[['full_name', 'loc']].values:
        print(f'<a href="{loc}">{fullname}</a><br>')

Download an example HTML sitemap file (4.9k links): https://bit.ly/442pnqL

Start with a list of URLs and their anchor texts:

full_name	loc
Wayne Hightower	https://nbastats.pro/player/Wayne_Hightower
Gary Garland	https://nbastats.pro/player/Gary_Garland
Larry Owens	https://nbastats.pro/player/Larry_Owens
Chris Engler	https://nbastats.pro/player/Chris_Engler
Samuel Williams	https://nbastats.pro/player/Samuel_Williams
Lester Conner	https://nbastats.pro/player/Lester_Conner
Brian Howard	https://nbastats.pro/player/Brian_Howard
Craig Shelton	https://nbastats.pro/player/Craig_Shelton
George Feigenbaum	https://nbastats.pro/player/George_Feigenbaum
Jack George	https://nbastats.pro/player/Jack_George
Cory Blackwell	https://nbastats.pro/player/Cory_Blackwell
Metta World Peace	https://nbastats.pro/player/Metta_World_Peace
Eric Williams	https://nbastats.pro/player/Eric_Williams
Olumide Oyedeji	https://nbastats.pro/player/Olumide_Oyedeji
Travis Diener	https://nbastats.pro/player/Travis_Diener
Mark Price	https://nbastats.pro/player/Mark_Price
Julian Phillips	https://nbastats.pro/player/Julian_Phillips
Karl Malone	https://nbastats.pro/player/Karl_Malone
Doug Kistler	https://nbastats.pro/player/Doug_Kistler
John Brown	https://nbastats.pro/player/John_Brown

Make an HTML sitemap: