<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[chealia的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/chealia</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; chealia]]></copyright><item><title><![CDATA[解析drugbank xml文件的代码。（先要把文件里的换行符删干净了）]]></title><link>https://blog.youkuaiyun.com/chealia/article/details/87934978</link><guid>https://blog.youkuaiyun.com/chealia/article/details/87934978</guid><author>chealia</author><pubDate>Tue, 26 Feb 2019 14:50:52 +0800</pubDate><description><![CDATA[
# -*- coding: utf-8 -*-
&quot;&quot;&quot;
Created on Wed Dec  5 16:43:28 2018

@author: chealia
&quot;&quot;&quot;

import xlrd
from  xlutils.copy import copy
from xml.parsers.expat import ParserCreate

rb=xlrd.open_workbook(r'c...]]></description><category></category></item><item><title><![CDATA[with open之后输出的内容如何换行，用print就行]]></title><link>https://blog.youkuaiyun.com/chealia/article/details/87898573</link><guid>https://blog.youkuaiyun.com/chealia/article/details/87898573</guid><author>chealia</author><pubDate>Sat, 23 Feb 2019 23:06:16 +0800</pubDate><description><![CDATA[
&amp;gt;&amp;gt;&amp;gt; with open('hello.txt','r') as f:
...     s=f.read()
...     s
...     print(s)
...
'1\t2\n3\t4\n5\t6'
1       2
3       4
5       6
&amp;gt;&amp;gt;&amp;gt;


在命令行直接输出f.read()，得到的结果是连续的，有\t制表符和\n换行符...]]></description><category></category></item><item><title><![CDATA[装饰器参数传递return decorator if isinstance(text,str) else decorator(text)的解释]]></title><link>https://blog.youkuaiyun.com/chealia/article/details/87377008</link><guid>https://blog.youkuaiyun.com/chealia/article/details/87377008</guid><author>chealia</author><pubDate>Fri, 15 Feb 2019 18:33:29 +0800</pubDate><description><![CDATA[起因是廖老师的一个作业：

https://www.liaoxuefeng.com/wiki/0014316089557264a6b348958f449949df42a6d3a2e542c000/0014318435599930270c0381a3b44db991cd6d858064ac0000#0



作业：


# -*- coding: utf-8 -*-
&quot;&quot;&quot;
Created on W...]]></description><category></category></item><item><title><![CDATA[DictReader出现列名不对的原因]]></title><link>https://blog.youkuaiyun.com/chealia/article/details/84568504</link><guid>https://blog.youkuaiyun.com/chealia/article/details/84568504</guid><author>chealia</author><pubDate>Tue, 27 Nov 2018 16:44:47 +0800</pubDate><description><![CDATA[
&amp;gt;&amp;gt;&amp;gt; with open('c:/users/chealia/zhongliu/country.csv','r',encoding='utf-8') as f:
...     reader=csv.DictReader(f)    #这里出错是因为编码的原因导致‘name’变成了'\ufeffname'
...     for row in reader:
...     ...]]></description><category></category></item><item><title><![CDATA[pandas orders.apply(lambda row: xxxx,axis=1)]]></title><link>https://blog.youkuaiyun.com/chealia/article/details/83094978</link><guid>https://blog.youkuaiyun.com/chealia/article/details/83094978</guid><author>chealia</author><pubDate>Tue, 16 Oct 2018 17:50:55 +0800</pubDate><description><![CDATA[&quot;'Series' object has no attribute 'gender'&quot;, u'occurred at index id')

这一类的报错都是因为没有axis=1




import pandas as pd

df = pd.DataFrame([
  ['JOHN SMITH', 'Male'],
  ['Jane Doe', 'Female'],
  ['joe schmo...]]></description><category></category></item><item><title><![CDATA[Numpy]]></title><link>https://blog.youkuaiyun.com/chealia/article/details/82833875</link><guid>https://blog.youkuaiyun.com/chealia/article/details/82833875</guid><author>chealia</author><pubDate>Tue, 25 Sep 2018 00:31:16 +0800</pubDate><description><![CDATA[
ipmort numpy as np
#求平均值
np.mean(array&amp;gt;9)#返回百分比值（不是百分位数）


np.mean(array,axis=1) #二位矩阵，axis=1 求row的均值。axis=0,求列的均值。]]></description><category></category></item><item><title><![CDATA[SQL]]></title><link>https://blog.youkuaiyun.com/chealia/article/details/82730119</link><guid>https://blog.youkuaiyun.com/chealia/article/details/82730119</guid><author>chealia</author><pubDate>Sun, 16 Sep 2018 21:51:57 +0800</pubDate><description><![CDATA[ update


update patients set Status='active' where id=7;

 create table


create table inactive_patients as  select * from patients where status='inactive';

delete from


delete from patients where ...]]></description><category></category></item><item><title><![CDATA[pandas read_cs; matplotlib pyplot; sklearn]]></title><link>https://blog.youkuaiyun.com/chealia/article/details/82706035</link><guid>https://blog.youkuaiyun.com/chealia/article/details/82706035</guid><author>chealia</author><pubDate>Fri, 14 Sep 2018 17:13:00 +0800</pubDate><description><![CDATA[如果含有中文或者英文长句子，里面很可能会有“，”,而CSV的逗号是分隔符（delimter,或Seperator）所以要加参数，把分隔符从逗号替换为‘\t’制表符

&amp;gt;&amp;gt;&amp;gt;pandas.read_csv('path',delimter='\t').head()

or

&amp;gt;&amp;gt;&amp;gt;file=pandas.read_csv('path',sep='\t')

&amp;gt;...]]></description><category></category></item><item><title><![CDATA[Mysql workbench 运行错误]]></title><link>https://blog.youkuaiyun.com/chealia/article/details/82629724</link><guid>https://blog.youkuaiyun.com/chealia/article/details/82629724</guid><author>chealia</author><pubDate>Tue, 11 Sep 2018 17:46:26 +0800</pubDate><description><![CDATA[ 



1 是运行选定的代码。如果不选就运行所有的包括没有光标的空白行。

2 是只运行光标所在的那一行。]]></description><category></category></item><item><title><![CDATA[git]]></title><link>https://blog.youkuaiyun.com/chealia/article/details/82493610</link><guid>https://blog.youkuaiyun.com/chealia/article/details/82493610</guid><author>chealia</author><pubDate>Fri, 07 Sep 2018 11:14:23 +0800</pubDate><description><![CDATA[1 . git 合并分支的时候，首先要转换到master：


$ git checkout master &quot;转换到master分支&quot;

$ git merge dev

$ git branch -d dev &quot;删除dev分支&quot;



 ]]></description><category></category></item><item><title><![CDATA[20180707]]></title><link>https://blog.youkuaiyun.com/chealia/article/details/80950492</link><guid>https://blog.youkuaiyun.com/chealia/article/details/80950492</guid><author>chealia</author><pubDate>Sun, 08 Jul 2018 00:24:56 +0800</pubDate><description><![CDATA[这样写也可以。时：([0-1][0-9]|2[0-3]|[0-9])————————————————————————————————————————]]></description><category></category></item><item><title><![CDATA[20180706日志]]></title><link>https://blog.youkuaiyun.com/chealia/article/details/80936442</link><guid>https://blog.youkuaiyun.com/chealia/article/details/80936442</guid><author>chealia</author><pubDate>Sat, 07 Jul 2018 13:51:26 +0800</pubDate><description><![CDATA[文件操作和目录：首先找到路径（linux和windows不一样）,然后用join合成新目录，再mkdir创建这个目录(去这个路径下可以找到testdir文件夹)，rmdir可以删除这个目录/文件夹.在已经确认这个路径怎么表示的前提下，也可以直接mkdir创建。————————————————————————————————————————os.path.abspath(path)则是参数path的...]]></description><category></category></item><item><title><![CDATA[20180705更新]]></title><link>https://blog.youkuaiyun.com/chealia/article/details/80933795</link><guid>https://blog.youkuaiyun.com/chealia/article/details/80933795</guid><author>chealia</author><pubDate>Thu, 05 Jul 2018 22:16:48 +0800</pubDate><description><![CDATA[&amp;gt;&amp;gt;&amp;gt; with open('hello.txt','r') as f:...         for line in f.readlines():...             print(line.strip())——————————————————————————————写入的文件换行成功——————————————————————————————不仅是迭代器调用后没元素了...]]></description><category></category></item><item><title><![CDATA[迭代器调用过后内部就没有元素了吗..]]></title><link>https://blog.youkuaiyun.com/chealia/article/details/80471435</link><guid>https://blog.youkuaiyun.com/chealia/article/details/80471435</guid><author>chealia</author><pubDate>Sun, 27 May 2018 18:49:12 +0800</pubDate><description><![CDATA[迭代器调用过后内部就没有元素了,此时再计算sum(迭代器)=sum的默认值/初始值0或者此时来用for来遍历元素也不会有内容了例如：下图第一次for循环有结果，第二次就没有了。用sum也是一样的，第一次可以有和，第二次sum=0...]]></description><category></category></item><item><title><![CDATA[datetime astimezone和replace的区别。时区转换还是替换？]]></title><link>https://blog.youkuaiyun.com/chealia/article/details/80431819</link><guid>https://blog.youkuaiyun.com/chealia/article/details/80431819</guid><author>chealia</author><pubDate>Thu, 24 May 2018 11:19:49 +0800</pubDate><description><![CDATA[1）astimezone(timezone(timedelta(hours=int()))),这个是转换时区，转换，时间还是正确的，和被转换的时间是一样的，只是换个时区的表达。



2）dt.replace(tzinfo=timezon.utc)或者

dt.replace(tzinfo=timezone(timedelta(hours=int())))

是改变了时区，但是没改时间，比如9:...]]></description><category></category></item><item><title><![CDATA[Python入门小麻烦-命令行怎么调用.py文件]]></title><link>https://blog.youkuaiyun.com/chealia/article/details/79140728</link><guid>https://blog.youkuaiyun.com/chealia/article/details/79140728</guid><author>chealia</author><pubDate>Tue, 23 Jan 2018 15:59:38 +0800</pubDate><description><![CDATA[先安装了anaconda，会有一个anaconda prompt能够当做命令行使用，且含有python的环境变量。

关于调用.py文件时产生了小麻烦，应该这样输入：

1).   如果文件路径是这样的：C:\Users\sd\test.py，那么在命令行状态下输入：

C:\Users\sd&amp;gt; python test.py

 

2).   如果是交互式输入状态（&amp;gt;&amp;gt;&amp;gt;...]]></description><category></category></item></channel></rss>