| 123456789101112131415 |
- import pandas as pd
- def get_one_page_excel(weibo_content_str, weibo_mid_str, weibo_time_str, length):
- one_page_data = []
- for i in range(0, length):
- one_piece_data = (weibo_mid_str[i], weibo_time_str[i], weibo_content_str[i])
- column_name = ('文章ID', '发文时间', '文章内容')
- one_page_data.append(dict(zip(column_name, one_piece_data)))
- return one_page_data
- def save_to_excel(all_data, keyword, date_begin, date_end):
- df = pd.DataFrame(all_data)
- df.to_excel('微博爬取内容-' + keyword + '-' + date_begin + '-' + date_end + '.xlsx', index=False)
|
