摘要: 1. #各类文章数统计 def class_text_num(): sql="SELECT count(channelName) as num,channelName FROM new_class.newdata group by channelName;" res=query_mysql(sql) 阅读全文
posted @ 2021-11-25 22:48 风吹过半夏 阅读(27) 评论(0) 推荐(0) 编辑
摘要: 1.将多工作表分开 2.数据库建表 3.利用pandas存入数据库 file_path = "data/其他.xlsx" df = pd.read_excel(file_path) print(df.shape[0]) print(df.iloc[0,:]["content"]) for i in 阅读全文
posted @ 2021-11-25 22:43 风吹过半夏 阅读(22) 评论(0) 推荐(0) 编辑