<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[almost_Mr的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/almost_Mr</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; almost_Mr]]></copyright><item><title><![CDATA[爬虫基础]]></title><link>https://blog.youkuaiyun.com/almost_Mr/article/details/54347455</link><guid>https://blog.youkuaiyun.com/almost_Mr/article/details/54347455</guid><author>almost_Mr</author><pubDate>Wed, 11 Jan 2017 20:06:23 +0800</pubDate><description><![CDATA[简单爬虫
import urllib2
import urllibresponse=urllib.urlopen("https://www.douban.com/")
print response.read()爬虫伪装浏览器-检查-network-XHR-request headers-User-Agent]]></description><category></category></item><item><title><![CDATA[excel函数]]></title><link>https://blog.youkuaiyun.com/almost_Mr/article/details/54317947</link><guid>https://blog.youkuaiyun.com/almost_Mr/article/details/54317947</guid><author>almost_Mr</author><pubDate>Tue, 10 Jan 2017 21:17:57 +0800</pubDate><description><![CDATA[日期函数
  WEEKDAY(A2,2)            返回某天为星期几，A2为日期格式
  
  TEXT(A2,”yyyymm”)     将A2的日期形式转为文本形式]]></description><category></category></item><item><title><![CDATA[tableau安装]]></title><link>https://blog.youkuaiyun.com/almost_Mr/article/details/54191274</link><guid>https://blog.youkuaiyun.com/almost_Mr/article/details/54191274</guid><author>almost_Mr</author><pubDate>Sat, 07 Jan 2017 23:41:23 +0800</pubDate><description><![CDATA[法一：Mac终端修改step1：sudo vi /etc/hosts
step2：password:
step3：i,enter
step4：输入需要添加的内容
step5：先按Esc 然后再按shift+： 冒号
step6：输入wq 保存并退出法二：文件夹修改step1：shift+command+G,调出前往文件夹
step2：输入路径参考链接： 
下载地址 
mac修改host文件]]></description><category></category></item><item><title><![CDATA[ODBC介绍]]></title><link>https://blog.youkuaiyun.com/almost_Mr/article/details/53999337</link><guid>https://blog.youkuaiyun.com/almost_Mr/article/details/53999337</guid><author>almost_Mr</author><pubDate>Tue, 03 Jan 2017 23:28:02 +0800</pubDate><description><![CDATA[Tableau 和 ODBC 
ODBC 代表 Open Database Connectivity（开放式数据库连接），是允许各种软件访问数据的行业标准。ODBC 的基本前提是 SQL 查询的标准语法，软件应用程序使用该语法连接到数据库并从数据库请求数据。几乎总是由数据库制造商提供的 ODBC 驱动程序接受采用此标准语法的请求，并将请求转换为目标数据库喜欢的本机格式。ODBC 驱动程序实际上只是一]]></description><category></category></item><item><title><![CDATA[postgreSQL学习资料]]></title><link>https://blog.youkuaiyun.com/almost_Mr/article/details/53981243</link><guid>https://blog.youkuaiyun.com/almost_Mr/article/details/53981243</guid><author>almost_Mr</author><pubDate>Mon, 02 Jan 2017 18:49:02 +0800</pubDate><description><![CDATA[PostgreSQL 9.4.4 中文手册博客随笔SQL优化（四） PostgreSQL存储过程Navicat for PostgreSQL 使用教程]]></description><category></category></item><item><title><![CDATA[爬虫框架scrapy，爬取豆瓣电影top250]]></title><link>https://blog.youkuaiyun.com/almost_Mr/article/details/53958940</link><guid>https://blog.youkuaiyun.com/almost_Mr/article/details/53958940</guid><author>almost_Mr</author><pubDate>Sat, 31 Dec 2016 23:09:11 +0800</pubDate><description><![CDATA[1 . 新建项目进入打算存储代码的目录，命令行运行如下语句
  scrapy startproject tutorial
2 . 定义Itemimport scrapyclass DoubanItem(scrapy.Item):
    # define the fields for your item here like:
    # name = scrapy.Field()
    title]]></description><category></category></item><item><title><![CDATA[python学习资料]]></title><link>https://blog.youkuaiyun.com/almost_Mr/article/details/53958887</link><guid>https://blog.youkuaiyun.com/almost_Mr/article/details/53958887</guid><author>almost_Mr</author><pubDate>Sat, 31 Dec 2016 22:57:49 +0800</pubDate><description><![CDATA[python核心编程]]></description><category></category></item><item><title><![CDATA[函数]]></title><link>https://blog.youkuaiyun.com/almost_Mr/article/details/53844298</link><guid>https://blog.youkuaiyun.com/almost_Mr/article/details/53844298</guid><author>almost_Mr</author><pubDate>Fri, 23 Dec 2016 21:56:18 +0800</pubDate><description><![CDATA[存储过程与函数：PL/SQL块分类
匿名块：不保存在数据库；无名称；不可重复调用
命名块：保存在数据库中；有名称；可重复调用 
常见命名块：存储过程、函数、包、触发器
存储过程VS函数
相同： 
都是一个子程序，用来完成特定功能
不同： 
存储过程：无返回值；可以独立调用
函数：必须包含一个返回值；只能作为表达式的一部分使用]]></description><category></category></item><item><title><![CDATA[环境变量的配置]]></title><link>https://blog.youkuaiyun.com/almost_Mr/article/details/53782444</link><guid>https://blog.youkuaiyun.com/almost_Mr/article/details/53782444</guid><author>almost_Mr</author><pubDate>Wed, 21 Dec 2016 11:32:45 +0800</pubDate><description><![CDATA[postgreSQL增加环境变量- Mac OS增删环境变量1 . 首先查看shell版本
  echo $SHELL    #Mac OS X 10.3之后默认的是Bourne Shell
2 . 针对Bourne Shell添加环境变量
打开~/.bash_profile 文件
  touch ~/.bash_profile 
  open -t ~/.bash_profile 新增环境变量]]></description><category></category></item><item><title><![CDATA[Sublime text 2不支持raw_input输入的问题]]></title><link>https://blog.youkuaiyun.com/almost_Mr/article/details/53710775</link><guid>https://blog.youkuaiyun.com/almost_Mr/article/details/53710775</guid><author>almost_Mr</author><pubDate>Sat, 17 Dec 2016 18:36:11 +0800</pubDate><description><![CDATA[1、command+shift+P，调出工具，输入install packages，安装SublimeREPL2、选择包含raw_input的py文件，顶部标签栏tools-sublimerepl-python-run current file3、推荐双窗口运行，便于比较 
view-layout-columns:2注：未免避免报错，先将.py文件 command+s保存后，在run current]]></description><category></category></item><item><title><![CDATA[爬取人人贷]]></title><link>https://blog.youkuaiyun.com/almost_Mr/article/details/53639514</link><guid>https://blog.youkuaiyun.com/almost_Mr/article/details/53639514</guid><author>almost_Mr</author><pubDate>Wed, 14 Dec 2016 14:45:46 +0800</pubDate><description><![CDATA[import sys 
reload(sys) 
sys.setdefaultencoding("utf-8")  
import urllib2    
import urllib 
import re 
import pandas as pd
import numpy as np
import matplotlib.pyplot as plturl='https://www.we.com/loa]]></description><category></category></item><item><title><![CDATA[文章标题]]></title><link>https://blog.youkuaiyun.com/almost_Mr/article/details/53613006</link><guid>https://blog.youkuaiyun.com/almost_Mr/article/details/53613006</guid><author>almost_Mr</author><pubDate>Tue, 13 Dec 2016 20:19:34 +0800</pubDate><description><![CDATA[Mac 上安装和使用PostgreSQL的方法存储过程定义http://www.yiibai.com/html/postgresql/2013/080784.htmlhttp://www.postgres.cn/docs/9.4/plpgsql-statements.html]]></description><category></category></item><item><title><![CDATA[埋点]]></title><link>https://blog.youkuaiyun.com/almost_Mr/article/details/53562744</link><guid>https://blog.youkuaiyun.com/almost_Mr/article/details/53562744</guid><author>almost_Mr</author><pubDate>Sat, 10 Dec 2016 23:18:41 +0800</pubDate><description><![CDATA[客户端埋点 Vs. 在后端记录 Event友盟、百度统计等传统分析工具，都是在客户端嵌入 SDK 进行埋点，但是，我们强烈推荐在后端记录 Event，这是出于以下一些考虑： 1、很多行为，如下单等，他们的很多字段在前端（App 和 Web 界面）是拿不到的。甚至有些行为，如用户线下消费等，前端根本就没有提供相应的功能，就更拿不到对应的数据。
 2、后端修改程序更加方便便捷，如果是在 App 端记录数]]></description><category></category></item><item><title><![CDATA[python爬取百度贴吧]]></title><link>https://blog.youkuaiyun.com/almost_Mr/article/details/53546315</link><guid>https://blog.youkuaiyun.com/almost_Mr/article/details/53546315</guid><author>almost_Mr</author><pubDate>Fri, 09 Dec 2016 22:46:52 +0800</pubDate><description><![CDATA[import sys
reload(sys)
sys.setdefaultencoding('utf-8')
import urllib2  
import re#----------- 处理页面上的各种标签 -----------  
class HTML_Tool:  
    # 用非 贪婪模式 匹配 \t 或者 \n 或者 空格 或者 超链接 或者 图片  
    BgnCharToNon]]></description><category></category></item><item><title><![CDATA[python爬取链家数据]]></title><link>https://blog.youkuaiyun.com/almost_Mr/article/details/53496364</link><guid>https://blog.youkuaiyun.com/almost_Mr/article/details/53496364</guid><author>almost_Mr</author><pubDate>Wed, 07 Dec 2016 00:31:06 +0800</pubDate><description><![CDATA[V1版import sys 
reload(sys) 
sys.setdefaultencoding("utf-8")  #设定编码要放在最上面。之前放在引用库的最下面，然后加到pandas的DataFrame老是出现中文字符为问号的乱码
import pandas as pd 
import urllib2    
import urllib   
import time
import re
fr]]></description><category></category></item><item><title><![CDATA[python 爬取糗事百科]]></title><link>https://blog.youkuaiyun.com/almost_Mr/article/details/53471750</link><guid>https://blog.youkuaiyun.com/almost_Mr/article/details/53471750</guid><author>almost_Mr</author><pubDate>Mon, 05 Dec 2016 23:50:54 +0800</pubDate><description><![CDATA[step 1：构建一个提取糗事百科笑话的函数import urllib2    
import urllib    
import re    
import thread    
import time 
import sys 
reload(sys) 
sys.setdefaultencoding("utf-8")  def GetPage(page):    
        myUrl =]]></description><category></category></item><item><title><![CDATA[正则表达式]]></title><link>https://blog.youkuaiyun.com/almost_Mr/article/details/53458209</link><guid>https://blog.youkuaiyun.com/almost_Mr/article/details/53458209</guid><author>almost_Mr</author><pubDate>Mon, 05 Dec 2016 00:10:32 +0800</pubDate><description><![CDATA[re模块
re.compile
import sys
reload(sys)
sys.setdefaultencoding('utf-8')import re  
b = re.compile(r"\d+\.\d*")  
match21 = b.match('3.1415')  
match22 = b.match('33')   if match21:  
    # 使用Match获得分组信息]]></description><category></category></item><item><title><![CDATA[python爬虫]]></title><link>https://blog.youkuaiyun.com/almost_Mr/article/details/53455593</link><guid>https://blog.youkuaiyun.com/almost_Mr/article/details/53455593</guid><author>almost_Mr</author><pubDate>Sun, 04 Dec 2016 18:21:26 +0800</pubDate><description><![CDATA[# -*- coding: utf-8 -*-
#---------------------------------------  
#爬取百度贴吧关于sandy的资料
#操作：输入带分页的地址，去掉最后面的数字，设置一下起始页数和终点页数。  
#功能：下载对应页码内的所有页面并存储为html文件
#---------------------------------------  import s]]></description><category></category></item><item><title><![CDATA[协程]]></title><link>https://blog.youkuaiyun.com/almost_Mr/article/details/53426416</link><guid>https://blog.youkuaiyun.com/almost_Mr/article/details/53426416</guid><author>almost_Mr</author><pubDate>Thu, 01 Dec 2016 20:28:26 +0800</pubDate><description><![CDATA[协程、yield用法]]></description><category></category></item><item><title><![CDATA[python收发邮件]]></title><link>https://blog.youkuaiyun.com/almost_Mr/article/details/53363491</link><guid>https://blog.youkuaiyun.com/almost_Mr/article/details/53363491</guid><author>almost_Mr</author><pubDate>Sun, 27 Nov 2016 11:15:17 +0800</pubDate><description><![CDATA[python发邮件]]></description><category></category></item></channel></rss>