While loop stops working but the process continues running in python

  csv, python, urllib

I use a while loop in Python to download several pdf documents given by a csv file.
The code runs smoothly without any issue but the loop stops working after several loops (sometimes 100 other times 40 or 140).

Below is my code which is used:

import pandas as pd
import os
import urllib
from urllib import request
import requests
import csv
import numpy as np

df = pd.read_csv('Linklist.csv', sep = ';') # can also index sheet by name or fetch all sheets

df.head() #get relevant columns
url_list = df['URL'].tolist() #column with links
name_list = df['Name'].tolist() #column with name
name_list_2 =df['Year'].to_list() #column with second identifier here a year for example

Year_date = []

for element in name_list_2:

max_length = len(url_list)
i = 0

f = open('results.csv', 'w')
writer = csv.writer(f)

while i <= max_length-1:

    response = requests.get(url_list[i])
    opener =      urllib.request.build_opener()
    opener.addheaders = [('User-Agent', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.0 Safari/605.1.15')]
    if response.status_code != 200:
        i += 1
        a = str(response.status_code)
        write_a = (name_list[i], Year_date[i], a)
        print(name_list[i]+' '+ Year_date[i]+ ' ' +a)
        request.urlretrieve( url_list[i],'/targetpath/'+ name_list[i] + Year_date[i] + '.pdf') #.pdf if it is a pdf doc you want to download
        b = str(response.status_code)
        write_b = (name_list[i], Year_date[i], b)
        print(name_list[i]+' '+ Year_date[i] + ' '+ b)
    i += 1


Source: Python Questions