Python爬蟲如何實(shí)現(xiàn)自動(dòng)翻頁(yè)并將數(shù)據(jù)存入csv中？

求大神指導(dǎo)，本人剛接觸到python爬蟲，有一些問題，再此感激不盡?。。。?br>我想爬取一些英文新聞標(biāo)題，然后把他們存在一個(gè)csv文件里面
我的代碼如下

 import csv, requests, re
 from bs4 import BeautifulSoup

 urls = ['https://www.defense.gov/News/Archive/?Page={}'.format(str(i)) for i in range(1,10)]

def get_titles(urls,data = None):
    html = requests.get(urls).text
    soup = BeautifulSoup(html, 'html.parser')
    articles = []
    for article in soup.find_all(class_='info'):
        Label = 'Archive'
        News = article.find(class_='title').get_text()
        articles.append([Label,News])
        with open(r'1.csv','a', newline='') as f:
             writer = csv.writer(f)
             writer.writerow(['Label','News'])
             for row in articles:
                 writer.writerow(row)

for titles in urls:
get_titles(titles)

想這樣來(lái)爬取1-9頁(yè)的新聞標(biāo)題，但是最后運(yùn)行結(jié)果是這樣

每增加一個(gè)新聞標(biāo)題都會(huì)把之前的標(biāo)題重復(fù)寫入csv中。

求大神指導(dǎo)??！