<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[judyqing的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/judyqing</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; judyqing]]></copyright><item><title><![CDATA[封装成.EXE文件]]></title><link>https://blog.youkuaiyun.com/judyqing/article/details/131246263</link><guid>https://blog.youkuaiyun.com/judyqing/article/details/131246263</guid><author>judyqing</author><pubDate>Fri, 16 Jun 2023 14:25:04 +0800</pubDate><description><![CDATA[变量值：C:\Python37\tcl\tcl8.6　　#换成你自己的路径。变量值：C:\Python37\tcl\tk8.6　　#换成你自己的路径。找到 需要打包的Python文件的路径。第一步：安装pyinstaller包。变量名：TCL_LIBRARY。变量名：TK_LIBRARY。第二步：配置环境变量。]]></description><category></category></item><item><title><![CDATA[pip install]]></title><link>https://blog.youkuaiyun.com/judyqing/article/details/131242158</link><guid>https://blog.youkuaiyun.com/judyqing/article/details/131242158</guid><author>judyqing</author><pubDate>Fri, 16 Jun 2023 10:41:10 +0800</pubDate><description><![CDATA[pip install 库包名 -i http://pypi.douban.com/simple/ --trusted-host pypi.douban.com。]]></description><category></category></item><item><title><![CDATA[调用同目录下文件中的函数]]></title><link>https://blog.youkuaiyun.com/judyqing/article/details/130201414</link><guid>https://blog.youkuaiyun.com/judyqing/article/details/130201414</guid><author>judyqing</author><pubDate>Mon, 17 Apr 2023 15:35:07 +0800</pubDate><description><![CDATA[原文链接：https://blog.youkuaiyun.com/weixin_42654528/article/details/129129127。版权声明：本文为优快云博主「天外飞仙007」的原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接及本声明。deftest.get_biggest() #  再调用文件中的函数。#   2.3-调用同目录下文件中的函数。]]></description><category></category></item><item><title><![CDATA[python 连接oracle]]></title><link>https://blog.youkuaiyun.com/judyqing/article/details/130124618</link><guid>https://blog.youkuaiyun.com/judyqing/article/details/130124618</guid><author>judyqing</author><pubDate>Thu, 13 Apr 2023 10:46:50 +0800</pubDate><description><![CDATA[2、navicate下instantclient_21_7文件夹中的oci.dll、oraocci11、oraociei11的3个DLL粘贴到PY目录的Libs/site-packages文件夹下面。1、下载cx_oracle,根据python版本下载whl，或者通过。下载地址： cx-Oracle · PyPI。前提，navicate成功连接oracle。]]></description><category></category></item><item><title><![CDATA[数据分析相关流程总结]]></title><link>https://blog.youkuaiyun.com/judyqing/article/details/123734170</link><guid>https://blog.youkuaiyun.com/judyqing/article/details/123734170</guid><author>judyqing</author><pubDate>Fri, 25 Mar 2022 14:27:12 +0800</pubDate><description><![CDATA[1、观察数据集，分析数据

数据质量评估：

分类：计数？唯一值？

数值型：最大值、最小值、均值等

随机取样、切片分析

分析各个特征的分布

分析数据之间得相关性，以及因果关系

查看特征得重要性

观察样本分布是否均衡（样本不均衡需要进行采样：上采样、下采样）

df.info() ;df.describe() ;df.dtypes() ;df.groupby()

2、根据观察结果对数据进行预处理

缺失值（missingno）、异常值、重复值、错误值

类型转换： one-hot编码、tf-id]]></description><category></category></item><item><title><![CDATA[hanlp用户自定义词典添加]]></title><link>https://blog.youkuaiyun.com/judyqing/article/details/85102686</link><guid>https://blog.youkuaiyun.com/judyqing/article/details/85102686</guid><author>judyqing</author><pubDate>Wed, 19 Dec 2018 18:20:53 +0800</pubDate><description><![CDATA[1、在字典路径下添加自定义的词典：CustomDictionary主词典文本路径是data/dictionary/custom/CustomDictionary.txt，用户可以在此增加自己的词语（不推荐）；也可以单独新建一个文本文件，通过配置文件；CustomDictionaryPath=data/dictionary/custom/CustomDictionary.txt; 我的词典.txt;...]]></description><category></category></item><item><title><![CDATA[py3安装pyhanlp]]></title><link>https://blog.youkuaiyun.com/judyqing/article/details/85088876</link><guid>https://blog.youkuaiyun.com/judyqing/article/details/85088876</guid><author>judyqing</author><pubDate>Wed, 19 Dec 2018 09:44:02 +0800</pubDate><description><![CDATA[直接pip install pyhanlp的时候会提示缺少Microsoft Visual c++环境，

方法1

可以先安装jpype1，然后在pip install pyhanlp就行了。

1、离线安装jpyter1

jpyter1地址：

https://www.lfd.uci.edu/~gohlke/pythonlibs/#jpype

pip install JPype1-0.6....]]></description><category></category></item><item><title><![CDATA[sql对字段增删改]]></title><link>https://blog.youkuaiyun.com/judyqing/article/details/85006191</link><guid>https://blog.youkuaiyun.com/judyqing/article/details/85006191</guid><author>judyqing</author><pubDate>Fri, 14 Dec 2018 16:44:54 +0800</pubDate><description><![CDATA[增加列信息

修改列类型

删除列

alter table tableName add columnName varchar(30)  
	alter table tableName alter column columnName varchar(4000)  
	alter table tableName drop column columnName   
...]]></description><category></category></item><item><title><![CDATA[Spyder is already running. If you want to open a new instance, please pass to it the --new-instance]]></title><link>https://blog.youkuaiyun.com/judyqing/article/details/84889684</link><guid>https://blog.youkuaiyun.com/judyqing/article/details/84889684</guid><author>judyqing</author><pubDate>Sat, 08 Dec 2018 09:36:01 +0800</pubDate><description><![CDATA[运行spyder --new-instance就ok啦~~]]></description><category></category></item><item><title><![CDATA[dataframe按列/行遍历数据]]></title><link>https://blog.youkuaiyun.com/judyqing/article/details/84635975</link><guid>https://blog.youkuaiyun.com/judyqing/article/details/84635975</guid><author>judyqing</author><pubDate>Thu, 29 Nov 2018 16:57:27 +0800</pubDate><description><![CDATA[
import pandas as pd

dict=[[1,2,3,4,5,6],[0,0,0,0,0,0]]
data=pd.DataFrame(dict)
print(data)
for indexs in data.index:
    print(data.loc[indexs].values[0:-1])

( 按行遍历数据)


import pandas as pd

dict=[...]]></description><category></category></item><item><title><![CDATA[String和StringBuffer/StingBuilder之间的转换:append()、tostring()]]></title><link>https://blog.youkuaiyun.com/judyqing/article/details/84578505</link><guid>https://blog.youkuaiyun.com/judyqing/article/details/84578505</guid><author>judyqing</author><pubDate>Wed, 28 Nov 2018 09:15:34 +0800</pubDate><description><![CDATA[String和StringBuffer之间的转换、String和StringBuilder之间的转换：
构造方法、append( )、toString( )


（1）A -- B的转换：我们把A转换为B，其实是为了使用B的功能。

（2）B -- A的转换：我们可能要的结果是A类型，所以还得转回来。

2、String和StringBuffer的相互转换?
    一：String ——&amp;gt;...]]></description><category></category></item><item><title><![CDATA[通过TSNE将高维数据聚类结果以二维的方式展示出来]]></title><link>https://blog.youkuaiyun.com/judyqing/article/details/84528420</link><guid>https://blog.youkuaiyun.com/judyqing/article/details/84528420</guid><author>judyqing</author><pubDate>Mon, 26 Nov 2018 10:50:18 +0800</pubDate><description><![CDATA[
#!/usr/bin/env python
#-*- coding:utf-8 -*-

#接k_means.py
#k_means.py中得到三维规范化数据data_zs；
#r增加了最后一列，列索引为“聚类类别”

from sklearn.manifold import TSNE

tsne=TSNE()
tsne.fit_transform(data_zs)  #进行数据降维,降成两维
...]]></description><category></category></item><item><title><![CDATA[python encoder方法]]></title><link>https://blog.youkuaiyun.com/judyqing/article/details/83587544</link><guid>https://blog.youkuaiyun.com/judyqing/article/details/83587544</guid><author>judyqing</author><pubDate>Wed, 31 Oct 2018 17:25:16 +0800</pubDate><description><![CDATA[from sklearn import preprocessing

1、Label Encoder

2、OneHot Encoder

encoder.fit() 不接收一维数组，只能是二维，不能直接处理string

3、import pandas

get_dummies(二值化)

将string转化为integers...]]></description><category></category></item><item><title><![CDATA[python dataframe oracle]]></title><link>https://blog.youkuaiyun.com/judyqing/article/details/83536466</link><guid>https://blog.youkuaiyun.com/judyqing/article/details/83536466</guid><author>judyqing</author><pubDate>Tue, 30 Oct 2018 09:12:22 +0800</pubDate><description><![CDATA[方法一 通过dataframe 存入oracle 


#直接将dataframe 存入oracle  cx_Oracle 6.0b1处于测试阶段，我建议使用官方发行版5.3。
import cx_Oracle
conn_string='oracle+cx_oracle://xxx:xxx@192.168.1.123:1234/xxx'
from sqlalchemy import create_...]]></description><category></category></item><item><title><![CDATA[JAVA使用Runtime.getRuntime()执行python脚本文件]]></title><link>https://blog.youkuaiyun.com/judyqing/article/details/83269287</link><guid>https://blog.youkuaiyun.com/judyqing/article/details/83269287</guid><author>judyqing</author><pubDate>Mon, 22 Oct 2018 10:31:20 +0800</pubDate><description><![CDATA[java调用python（含anaconda）

注意：

1、python脚本必须都用的是绝对路径（可以拼接）

2、python脚本调用自定义的模块时要将模块路径添加到环境中。如果用sys.append(模块绝对路径)，要每一个脚本都要添加项目所在的路径。

cmd命令行执行：  环境路径 空格 项目路径

用Runtime.getRuntime().exec(）


public class...]]></description><category></category></item><item><title><![CDATA[用pandas中的DataFrame时选取行或列]]></title><link>https://blog.youkuaiyun.com/judyqing/article/details/83145653</link><guid>https://blog.youkuaiyun.com/judyqing/article/details/83145653</guid><author>judyqing</author><pubDate>Thu, 18 Oct 2018 14:02:31 +0800</pubDate><description><![CDATA[ 用pandas中的DataFrame时选取行或列


import numpy as np
import pandas as pd
from pandas import Sereis, DataFrame

ser = Series(np.arange(3.))

data = DataFrame(np.arange(16).reshape(4,4),index=list('abcd'),col...]]></description><category></category></item><item><title><![CDATA[python 远程连接oracle/mysql]]></title><link>https://blog.youkuaiyun.com/judyqing/article/details/83000631</link><guid>https://blog.youkuaiyun.com/judyqing/article/details/83000631</guid><author>judyqing</author><pubDate>Wed, 10 Oct 2018 17:46:19 +0800</pubDate><description><![CDATA[远程连接oracle出现的问题
oracle客户端的版本，cx_Oracle的版本，要与Python版本和位数对应：

我的Python版本：Python3.5   64位；

cx_Oracle的版本：cx_Oracle-7.0.0-cp35-cp35m-win_amd64.whl

oracle客户端的版本：instantclient-basic-win64-11.2.0.1.0；

 


...]]></description><category></category></item><item><title><![CDATA[oracle整理2]]></title><link>https://blog.youkuaiyun.com/judyqing/article/details/82996580</link><guid>https://blog.youkuaiyun.com/judyqing/article/details/82996580</guid><author>judyqing</author><pubDate>Wed, 10 Oct 2018 14:29:01 +0800</pubDate><description><![CDATA[https://blog.youkuaiyun.com/daizongxue/article/details/78038965

https://blog.youkuaiyun.com/weixin_40733475/article/details/79136123]]></description><category></category></item><item><title><![CDATA[oracle整理]]></title><link>https://blog.youkuaiyun.com/judyqing/article/details/82996535</link><guid>https://blog.youkuaiyun.com/judyqing/article/details/82996535</guid><author>judyqing</author><pubDate>Wed, 10 Oct 2018 14:27:10 +0800</pubDate><description><![CDATA[https://blog.youkuaiyun.com/neweastsun/article/details/51852304

https://blog.youkuaiyun.com/makecontral/article/details/71539238

https://blog.youkuaiyun.com/iamlaosong/article/details/74909785]]></description><category></category></item><item><title><![CDATA[Python远程连接服务器上的Oracle数据库/mysql]]></title><link>https://blog.youkuaiyun.com/judyqing/article/details/82991933</link><guid>https://blog.youkuaiyun.com/judyqing/article/details/82991933</guid><author>judyqing</author><pubDate>Wed, 10 Oct 2018 09:32:19 +0800</pubDate><description><![CDATA[读取ORACLE数据库
1、安装plsql以及配置文件instanctclient
在配置文件中添加数据库ip、端口等

BZPDA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 111.111.1.111)(PORT = 1234))
    )
    (CONNECT_DATA ...]]></description><category></category></item></channel></rss>