刚开始学python QAQ开个会员激励一下寄几！！

颜栩栩

【python】将输出结果保存到txt：

1. 
   
2. import requests
   
3. url = "https://voice.baidu.com/act/newpneumonia/newpneumonia/?from=osari_pc_1"
   
4. headers = {"User-Agent": "Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/83.0.4103.14 Safari/537.36 Edg/83.0.478.13"}
   
5. html = requests.get(url=url,headers=headers).content.decode()
   
6. with open('C:/Users/admin/Desktop/application/22.txt','w') as f:
   
7.     f.write(html)
   
8.     f.close()
   

复制代码

颜栩栩

【SQL】查询结果导出csv换行出错的处理

1. SELECT [Id]
   
2.       ,[casno]
   
3.       ,[关键词]
   
4.       ,[百科标题]
   
5.           ,REPLACE(REPLACE([简介], CHAR(10) , '<br>'), CHAR(13) , '<br>') [简介]
   
6.   FROM [chem960-zyq].[dbo].[baike]
   

复制代码

可用如上语句把回车符和换行符替换