Сохранение в excel файл в python

Мне надо написать сохранение спарсеных данных в excel файл, но сохраняется только одна статья, а их 4. Вот сам код:

from bs4 import BeautifulSoup as bs
import requests
import json
import pandas as pd

url = 'https://lainelir2.pythonanywhere.com/'
req = requests.get(url)
soup = bs(req.text, 'lxml')

items = {}
for i in soup.find_all('div', class_='container-link'):
    articles_url = 'https://lainelir2.pythonanywhere.com' + i.a['href']
    articles_name = i.text
    articles_name = articles_name.replace('\n', '') 
    items[articles_name] = articles_url

with open('articles_name.json', 'w', encoding='utf-8') as file:
    json.dump(items, file, indent=4, ensure_ascii=False)

with open('articles_name.json', encoding='utf-8') as f:
    data = json.load(f)

articles_text = []
for name, url in data.items():

    req = requests.get(url)
    soup = bs(req.text, 'lxml')

    for text_articles in soup.find_all('div', class_='container-view'):
        articles_text = soup.find('div', class_='text-view').text

        rep = ['\r', '\n', '\r\n\n\n\r\n', '\r\n']
        for items in rep:
            if items in articles_text:
                articles_text = articles_text.replace(items, '')

        comment_list = []
        for i in soup.find_all('a', class_='text-reply'):
            comment_text = i.text
            for comm in rep:
                if comm in comment_text:
                    comment_text = comment_text.replace(comm, '')
            comment_list.append(comment_text)
    
            articles_json = [{
            'name': name,
            'url': url,
            'text': articles_text,
            'comment': comment_list,
            }]

            df = pd.DataFrame(articles_json)
            writer = pd.ExcelWriter('text.xlsx', engine='xlsxwriter')
            df.to_excel(writer, sheet_name='welcom', index=False)
            writer.save()