python

来源:互联网 发布:centos 7.2安装选项 编辑:程序博客网 时间:2024/06/09 19:32

infolite




demo

# coding: utf-8# ## pyquery 抓取腾讯新闻# In[7]:import requestsfrom pyquery import PyQuery as pqhtml = requests.get('http://news.qq.com/').textnews_items = pq(html).find('.linkto').items()news_arr = []for news in news_items:    news_arr.append({'title' : news.text(), 'url' : news.attr('href')})news_arr[0]# In[14]:import pandasimport datetimenews_df = pandas.DataFrame(news_arr)news_df.to_excel('{}.xlsx'.format(datetime.date.today().strftime('%Y-%m-%d')))