<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[Vict_99的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/Vict_99</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; Vict_99]]></copyright><item><title><![CDATA[visual studio code 无法使用plantuml]]></title><link>https://blog.youkuaiyun.com/Vict_99/article/details/134200433</link><guid>https://blog.youkuaiyun.com/Vict_99/article/details/134200433</guid><author>Vict_99</author><pubDate>Fri, 03 Nov 2023 12:14:57 +0800</pubDate><description><![CDATA[最后，仔细阅读visual studio code中的plantuml的说明，提示使用plantuml必须安装java（因为plantuml是用的java）和graphviz。visual studio code 找到plantuml，安装之后，使用ALT+D，plantuml preview没有反应。找了一些教材，安装了grahpviz，并且将路径加到环境变量中，也没用。第二部，安装java，并将以下路径加到系统环境变量中。把左侧栏展示出来 activity bar。]]></description><category></category></item><item><title><![CDATA[word打开遇到错误，提示检查文档或驱动器文件权限，确保有足够的内存和磁盘空间的报错修复]]></title><link>https://blog.youkuaiyun.com/Vict_99/article/details/130603887</link><guid>https://blog.youkuaiyun.com/Vict_99/article/details/130603887</guid><author>Vict_99</author><pubDate>Wed, 10 May 2023 16:32:30 +0800</pubDate><description><![CDATA[]]></description><category></category></item><item><title><![CDATA[python计算N年一遇的降水经历]]></title><link>https://blog.youkuaiyun.com/Vict_99/article/details/130537142</link><guid>https://blog.youkuaiyun.com/Vict_99/article/details/130537142</guid><author>Vict_99</author><pubDate>Sat, 06 May 2023 23:13:29 +0800</pubDate><description><![CDATA[原文链接：https://blog.youkuaiyun.com/weixin_46604505/article/details/107231556。版权声明：本文为优快云博主「毛发浓密的猿工」的原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接及本声明。data = np.array(data)  # data为ndarray格式。data = pd.read_excel(r'D:\降水量.xlsx')@Features of this code:重现期。]]></description><category></category></item><item><title><![CDATA[excel多级联动和不规则分组转置]]></title><link>https://blog.youkuaiyun.com/Vict_99/article/details/122533744</link><guid>https://blog.youkuaiyun.com/Vict_99/article/details/122533744</guid><author>Vict_99</author><pubDate>Mon, 17 Jan 2022 11:01:52 +0800</pubDate><description><![CDATA[1、原始数据

从数据库导出的原始数据的省、市、区，结构如下：







2、构建省市数据

1）、省份数据

id
			省
		1
			河北
		2
			山西
		3
			内蒙古
		4
			辽宁
		5
			吉林
		6
			黑龙江
		7
			上海
		8
			江苏
		9
			浙江
		10
			安徽
		11
			福建
		12
			江西
		13
			山东
		14
			河南
		15
			湖北
		16
			湖南
		17
			广东
		18
			..]]></description><category></category></item><item><title><![CDATA[mysql查询]]></title><link>https://blog.youkuaiyun.com/Vict_99/article/details/114629092</link><guid>https://blog.youkuaiyun.com/Vict_99/article/details/114629092</guid><author>Vict_99</author><pubDate>Wed, 10 Mar 2021 10:30:34 +0800</pubDate><description><![CDATA[查单条

select * from jcr_data where issn='1001-0742'

查多条

select * from jcr_data where issn in ('1001-0742','1780-2393','1223-7027','1661-5751','1547-0083','1226-8763','0308-518X','1836-716X','0031-0220','1521-6918','0158-4197','1437-2940','0003-9438','0...]]></description><category></category></item><item><title><![CDATA[dataframe写入excel]]></title><link>https://blog.youkuaiyun.com/Vict_99/article/details/114439105</link><guid>https://blog.youkuaiyun.com/Vict_99/article/details/114439105</guid><author>Vict_99</author><pubDate>Sat, 06 Mar 2021 13:54:58 +0800</pubDate><description><![CDATA[writimport pandas as pd



er = pd.ExcelWriter("white_newspaper .xlsx")
data_white_newspaper.to_excel(writer, "sheet1")
writer.save()
print("数据保存成功")
]]></description><category></category></item><item><title><![CDATA[Word文档多级标题编号及编号前黑条解决方案]]></title><link>https://blog.youkuaiyun.com/Vict_99/article/details/113859447</link><guid>https://blog.youkuaiyun.com/Vict_99/article/details/113859447</guid><author>Vict_99</author><pubDate>Fri, 19 Feb 2021 11:25:11 +0800</pubDate><description><![CDATA[参考：https://blog.youkuaiyun.com/itmm_wang/article/details/105962315 （文章很详细，不过中间有一个比较关键的顺序问题，评论的同学指出了）

word编写文档的过程中，不同等级的标题需要设置标题编号联动，例如1，1.1，1.1.1 , 1.1.2,1.1.3 ; 1.2 ,1.2.1 ,1.2.2,...；2 , 2.1, 2.2...

10年前，毕业论文编写时，当时用到了这个编号功能，时隔多年，忘得差不多了，好在网上资源还是比较多，在此重新记录一下...]]></description><category></category></item><item><title><![CDATA[python合并word文件]]></title><link>https://blog.youkuaiyun.com/Vict_99/article/details/113743714</link><guid>https://blog.youkuaiyun.com/Vict_99/article/details/113743714</guid><author>Vict_99</author><pubDate>Sun, 07 Feb 2021 16:50:32 +0800</pubDate><description><![CDATA[参考学习https://blog.youkuaiyun.com/weixin_42921227/article/details/106054033




import os
import win32com.client as win32
word = win32.gencache.EnsureDispatch('Word.Application')
word.Visible = False
path = 'C:/Users/ThinkPad/Desktop/python-test/测试结果' #测试结果#需要合并..]]></description><category></category></item><item><title><![CDATA[python--基本操作]]></title><link>https://blog.youkuaiyun.com/Vict_99/article/details/113557456</link><guid>https://blog.youkuaiyun.com/Vict_99/article/details/113557456</guid><author>Vict_99</author><pubDate>Tue, 02 Feb 2021 14:54:36 +0800</pubDate><description><![CDATA[1、取纯文本数据


import re
def remove_number(text):#取文字文本，去掉数字和符号
    regStr = ".*?([\u4E00-\u9FA5]+).*?"
    aa = re.findall(regStr, text)
    return aa


]]></description><category></category></item><item><title><![CDATA[excel提取文字拼音首字母]]></title><link>https://blog.youkuaiyun.com/Vict_99/article/details/113541681</link><guid>https://blog.youkuaiyun.com/Vict_99/article/details/113541681</guid><author>Vict_99</author><pubDate>Tue, 02 Feb 2021 10:36:10 +0800</pubDate><description><![CDATA[目标是提取一段文案的拼音首字母，参考https://jingyan.baidu.com/article/0a52e3f43c3f6abf63ed7259.html



-- 百度经验原文---

在工作中，为了方便查询、排序或者编码，需要生成汉字内容信息的首字母，如果信息很多的话，一个个录入是一件很麻烦的事情，下面给大家介绍一个便捷的方法，轻松获取汉字拼音首字母信息。

   最终效果如下：



工具/原料


	Microsoft Excel 2010
	
一、新建Excel文件


	新建一...]]></description><category></category></item><item><title><![CDATA[python记录-excel批量数据导出为word表格]]></title><link>https://blog.youkuaiyun.com/Vict_99/article/details/113537122</link><guid>https://blog.youkuaiyun.com/Vict_99/article/details/113537122</guid><author>Vict_99</author><pubDate>Tue, 02 Feb 2021 09:28:43 +0800</pubDate><description><![CDATA[根据文章https://blog.youkuaiyun.com/weixin_46308408/article/details/104351792，自己捣鼓了一下，批量导入word，还是很不错的！

目前问题：调整表格中的字段对齐方式，不能自动居中



from docx import Document   #功能是打开文档
from docx.enum.text import WD_ALIGN_PARAGRAPH  # 功能是对齐
from docx.shared import Pt #设置磅数
from doc.]]></description><category></category></item><item><title><![CDATA[python记录--小木虫SCI的ISSN数据]]></title><link>https://blog.youkuaiyun.com/Vict_99/article/details/113381285</link><guid>https://blog.youkuaiyun.com/Vict_99/article/details/113381285</guid><author>Vict_99</author><pubDate>Fri, 29 Jan 2021 13:14:01 +0800</pubDate><description><![CDATA[获得小木虫SCI期刊的ISSN数据




import pandas as pd
import requests
from lxml import html

from lxml import etree
import xlwt
 
conn = requests.session()
headers = {'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; WOW64) '
                         'AppleWebKit/537.36 (.]]></description><category></category></item><item><title><![CDATA[Anaconda3-5.1.0下载和安装]]></title><link>https://blog.youkuaiyun.com/Vict_99/article/details/79432950</link><guid>https://blog.youkuaiyun.com/Vict_99/article/details/79432950</guid><author>Vict_99</author><pubDate>Sat, 03 Mar 2018 21:52:00 +0800</pubDate><description><![CDATA[下载安装anaconda的小插曲1、在官网上找到windows的32位的下载（毕竟是八年前的老本了，另一个本装的64位），结果网站上出现问题，没有成功下载2、万能的网络，终于找到可以下载的清华镜像地址：https://mirrors.tuna.tsinghua.edu.cn/anaconda/archive/3、安装过程之后，点击开始菜单查看程序中的Anaconda34、点击Anaconda P...]]></description><category></category></item></channel></rss>