简单pandas存入

来源:互联网 发布:淘宝单主持怎样找商家 编辑:程序博客网 时间:2024/06/08 16:26
import requestsfrom bs4 import BeautifulSoupimport pandasurl = 'http://www.imsdn.cn/'#解析网址re = requests.get(url)soup = BeautifulSoup(re.text,'lxml').select('#main')#美丽汤方法for i in soup:    title = i.select('dl dt')    content = i.select('dl dd')    list = []    for title,content in zip(title, content):        li = []        li.append(title.get_text())        li.append(content.get_text())        list.append(li)        print(list) #将数据放入list中pan = pandas.DataFrame(list, columns=['wenjian', 'url'])#使用pandaspan.to_excel('sj.xlsx')#存入excel