<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[Outsider_Lily的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/Outsider_Lily</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; Outsider_Lily]]></copyright><item><title><![CDATA[执行.sh脚本时出现$’\r’: 未找到命令]]></title><link>https://blog.youkuaiyun.com/Outsider_Lily/article/details/114934761</link><guid>https://blog.youkuaiyun.com/Outsider_Lily/article/details/114934761</guid><author>Outsider_Lily</author><pubDate>Wed, 17 Mar 2021 16:02:52 +0800</pubDate><description><![CDATA[执行.sh脚本时出现$’\r’: 未找到命令:是因为命令直接从windows 复制过来导致的

解决

　　yum install dos2unix

　　dos2unix **.sh 进行转换

　　再次执行即可
]]></description><category></category></item><item><title><![CDATA[wireshark打开一点击就卡死崩溃]]></title><link>https://blog.youkuaiyun.com/Outsider_Lily/article/details/108507489</link><guid>https://blog.youkuaiyun.com/Outsider_Lily/article/details/108507489</guid><author>Outsider_Lily</author><pubDate>Thu, 10 Sep 2020 09:36:31 +0800</pubDate><description><![CDATA[和 有道词典 冲突了
]]></description><category></category></item><item><title><![CDATA[如何恰当的关闭sqlalchemy数据库连接]]></title><link>https://blog.youkuaiyun.com/Outsider_Lily/article/details/107627991</link><guid>https://blog.youkuaiyun.com/Outsider_Lily/article/details/107627991</guid><author>Outsider_Lily</author><pubDate>Tue, 28 Jul 2020 08:57:22 +0800</pubDate><description><![CDATA[1.疑问来源

时常使用 sqlalchemy 建立 engine 连接 mysql 或者 postgres ，然后利用 pandas 与数据库进行交互。一般情况下，使用结束后，就随手将 jupyter notebook 关闭了，从来没有刻意的去管 sqlalchemy engine 没有关闭后，是否会造成数据库资源浪费的问题，于是就有了这个疑问。

2.疑问解决

to be continued

前期结论：

如果不是疯狂的建立连接，MySQL/Postgreps 会自动关闭连接。
3.资料汇总

3.]]></description><category></category></item><item><title><![CDATA[Python 文件读取操作方法]]></title><link>https://blog.youkuaiyun.com/Outsider_Lily/article/details/89602754</link><guid>https://blog.youkuaiyun.com/Outsider_Lily/article/details/89602754</guid><author>Outsider_Lily</author><pubDate>Fri, 22 May 2020 09:21:09 +0800</pubDate><description><![CDATA[遍历文件：   os.walk：  for root, dirs, files in os.walk(".", topdown=False)



选择特定类型文件：   file.endswith('.wav')
]]></description><category></category></item><item><title><![CDATA[sql]]></title><link>https://blog.youkuaiyun.com/Outsider_Lily/article/details/106193014</link><guid>https://blog.youkuaiyun.com/Outsider_Lily/article/details/106193014</guid><author>Outsider_Lily</author><pubDate>Mon, 18 May 2020 15:01:32 +0800</pubDate><description><![CDATA[1. group后不同列相加：直接栏位名相加即可


SELECT TO_CHAR(TMDT, 'yyyy-mm-dd hh24:mi') TMDT, 
       SUM(M1_COL+M2_COL) as sum_col
FROM "table_name" 
WHERE TMDT&gt; SYSDATE-60 
      AND "NAME" in ('condition1', 'condition2') 
GROUP BY TO_CHAR(TMDT, 'yyyy-mm-dd hh24:mi');
]]></description><category></category></item><item><title><![CDATA[LIST处理]]></title><link>https://blog.youkuaiyun.com/Outsider_Lily/article/details/103250254</link><guid>https://blog.youkuaiyun.com/Outsider_Lily/article/details/103250254</guid><author>Outsider_Lily</author><pubDate>Wed, 27 Nov 2019 08:23:12 +0800</pubDate><description><![CDATA[1. 列表拓展
a = [1, 2, 3, 4, 5]
lenn = len(a)
for i in range(0, len(a)):
    m = [a] * (lenn ** i)
    b = list(chain.from_iterable(zip(*m)))
    b = b*(lenn**(lenn-1-i))
    print(b)

2.排列组合

itertools....]]></description><category></category></item><item><title><![CDATA[部署问题]]></title><link>https://blog.youkuaiyun.com/Outsider_Lily/article/details/95193679</link><guid>https://blog.youkuaiyun.com/Outsider_Lily/article/details/95193679</guid><author>Outsider_Lily</author><pubDate>Tue, 09 Jul 2019 14:31:36 +0800</pubDate><description><![CDATA[1. linux/windows rz传输文件，一直失败   后来才发现是权限问题，切root秒传

2. 训练好的模型没有出现在应在的地方，程序却能正常执行。原理配置文件保存模型的绝对路径没有更改

3. python程序在linux下无法import自定义模块，环境变量设置没问题。实际上在最上层目录添加init.py就可以了
...]]></description><category></category></item><item><title><![CDATA[SVM调参]]></title><link>https://blog.youkuaiyun.com/Outsider_Lily/article/details/91411611</link><guid>https://blog.youkuaiyun.com/Outsider_Lily/article/details/91411611</guid><author>Outsider_Lily</author><pubDate>Tue, 11 Jun 2019 09:34:50 +0800</pubDate><description><![CDATA[https://www.cnblogs.com/pinard/p/6117515.html
]]></description><category></category></item><item><title><![CDATA[Python 类操作tips]]></title><link>https://blog.youkuaiyun.com/Outsider_Lily/article/details/89955727</link><guid>https://blog.youkuaiyun.com/Outsider_Lily/article/details/89955727</guid><author>Outsider_Lily</author><pubDate>Wed, 08 May 2019 15:35:39 +0800</pubDate><description><![CDATA[1. 对参数方便管理和赋值


class Hparams:
    def __init__(self):
        self.param1= 'param1'
        self.param2= 'param2'

    def __setattr__(self, key, value):
        self.__dict__[key] = value

sq = Hpar...]]></description><category></category></item><item><title><![CDATA[keras 错误汇总]]></title><link>https://blog.youkuaiyun.com/Outsider_Lily/article/details/89348558</link><guid>https://blog.youkuaiyun.com/Outsider_Lily/article/details/89348558</guid><author>Outsider_Lily</author><pubDate>Wed, 17 Apr 2019 09:58:45 +0800</pubDate><description><![CDATA[1.安装tensorflow后pycharm崩溃或者numpy.core.multiarray failed to import

  solv: 卸载numpy 重装

2.TypeError: softmax() got an unexpected keyword argument 'axis'

  solv: keras与tensorflow版本不符

    ...]]></description><category></category></item><item><title><![CDATA[numpy操作方法]]></title><link>https://blog.youkuaiyun.com/Outsider_Lily/article/details/89333227</link><guid>https://blog.youkuaiyun.com/Outsider_Lily/article/details/89333227</guid><author>Outsider_Lily</author><pubDate>Tue, 16 Apr 2019 20:34:58 +0800</pubDate><description><![CDATA[np.unique(array, return_inverse=True)


np_utils.to_categorical(coded_id)

np.random

  随机数：


			rand(d0,d1,...,dn)
			
			
			随机值；给定形状，生成[0,1]之间均匀分布的随机样本

			np.random.rand(2，3) [[0.42085 0...]]></description><category></category></item><item><title><![CDATA[pandas操作方法]]></title><link>https://blog.youkuaiyun.com/Outsider_Lily/article/details/86595144</link><guid>https://blog.youkuaiyun.com/Outsider_Lily/article/details/86595144</guid><author>Outsider_Lily</author><pubDate>Tue, 22 Jan 2019 15:32:26 +0800</pubDate><description><![CDATA[1. pycharm print時顯示全部數據
    #显示所有列
    pd.set_option('display.max_columns', None)
    #显示所有行
    pd.set_option('display.max_rows', None)
    #设置value的显示长度为100，默认为50
    pd.set_option('max_colwidth',...]]></description><category></category></item><item><title><![CDATA[oracle Python  查询where无法查询字母 ORa-00902]]></title><link>https://blog.youkuaiyun.com/Outsider_Lily/article/details/86062609</link><guid>https://blog.youkuaiyun.com/Outsider_Lily/article/details/86062609</guid><author>Outsider_Lily</author><pubDate>Tue, 08 Jan 2019 09:51:34 +0800</pubDate><description><![CDATA[
sql = 'SELECT count(1) FROM table where 字段=&quot;ok&quot; '报错


要將雙引號改成單引號才能識別

sql = 'SELECT count(1) FROM table where 字段=\'ok\'  ']]></description><category></category></item><item><title><![CDATA[Python查询oracle数据库速度慢]]></title><link>https://blog.youkuaiyun.com/Outsider_Lily/article/details/85835016</link><guid>https://blog.youkuaiyun.com/Outsider_Lily/article/details/85835016</guid><author>Outsider_Lily</author><pubDate>Sat, 05 Jan 2019 09:40:04 +0800</pubDate><description><![CDATA[conn = cx_Oracle.connect('username/password@ip:port/servername')
cur = conn.cursor()
cur.execute('SELECT * FROM "db"."table"')
cur是一个迭代器,不要用fetchall一次性取完數據
直接 for row in cur 即可取数据

使用：sqlalchemy


My...]]></description><category></category></item><item><title><![CDATA[sorted 对字典排序是报错 IndexError: string index out of range]]></title><link>https://blog.youkuaiyun.com/Outsider_Lily/article/details/80784724</link><guid>https://blog.youkuaiyun.com/Outsider_Lily/article/details/80784724</guid><author>Outsider_Lily</author><pubDate>Sat, 23 Jun 2018 16:34:51 +0800</pubDate><description><![CDATA[不知道为什么b ={'1': 4, '2': 5, '3': 8, '4': 5, '5': 1, '0': 2}
t = sorted(b, key=lambda x: x[1], reverse=True)
print(t)当索引值为小于10的数时，就会报错： IndexError: string index out of range...]]></description><category></category></item><item><title><![CDATA[pycharm 不显示 plot 绘图]]></title><link>https://blog.youkuaiyun.com/Outsider_Lily/article/details/80446765</link><guid>https://blog.youkuaiyun.com/Outsider_Lily/article/details/80446765</guid><author>Outsider_Lily</author><pubDate>Fri, 25 May 2018 09:28:28 +0800</pubDate><description><![CDATA[查了很多，都是说加：plt.show()但加过之后仍然不显示后来，我把import matplotlib.pyplot as plt提到了另外几个import的前面，就正常显示了]]></description><category></category></item></channel></rss>