weixin_43139613-CSDN博客

原创 pandas数据可视化

#导入忽视警告模块import warningswarnings.filterwarnings('ignore')import pandas as pdimport numpy as npimport matplotlib.pyplot as plt#显示中文字符plt.rcParams['font.sans-serif'] = ['SimHei']#显示负号plt.rcPa...

2019-07-19 09:45:38 631

原创 matplotlib作图

import matplotlib.pyplot as plt%matplotlib notebook%matplotlib inlineplt.plot([1,2,3,4],[1,4,9,16],'m')plt.ylabel('y')plt.plot([1,2,3,4],[1,4,9,16],'ro')import numpy as npt = np.arange(0.,...

2019-07-19 09:39:33 185

原创 Pygal输出png问题 :dlopen() failed to load a library: cairo / cairo-2

pip install cairocffi成功安装 cairocffi 后导入模块失败，并提示：dlopen() failed to load a library: cairo / cairo-2。解决方案另须安装 cairo 依赖库即可：conda install -c conda-forge cairo...

2019-07-03 14:56:07 682 1

原创 python绘制中国地图，现实各个地区销量与销售额

1.pyproj2.geos3.matplotlib4.basemap (base on geos)https://www.lfd.uci.edu/~gohlke/pythonlibs/#basemappip install basemap-1.2.0-cp37-cp37m-win64.whl5.下载 shapefile of chinahttps://gadm.org/downlo...

2019-07-01 11:36:00 4088 1

原创 lambda x if转换的用法

list(map(lambda x:x if x%2 == 0 else x+1000 if x == 3 else x+1,[i for i in range(20)]))[0, 2, 2, 1003, 4, 6, 6, 8, 8, 10, 10, 12, 12, 14, 14, 16, 16, 18, 18, 20]如果能被2整除就是本身，如果 = 3 就加1000 否则就加一...

2019-06-18 11:39:26 4526

原创 np和pd简单练习

Jupyter Notebook Untitled Last Checkpoint: an hour ago (autosaved) Python 3Python 3FileEditViewInsertCellKernelWidgetsHelpimport numpy as npa = np.linspace(1,10,50)aarray([ 1. , ...

2019-06-16 18:14:10 1314

原创 pyautogui和xlrd经数据导入NC

# -*- coding: utf-8 -*-"""Created on Fri May 24 16:39:35 2019@author: Administrator"""# -*- coding: utf-8 -*-# by Damon import pyautogui,time,xlrd #i = int(wwhu('which group you want to...

2019-05-24 18:00:44 223

原创订单维护

# -*- coding: utf-8 -*-"""Spyder EditorThis is a temporary script file."""import pyautoguia = 0 s = 2 #一次性录入的个数，最多应该是27个吧m = 460 #erp其实高度n = 1 #已经录入的个数#切换到excelpyautogui.moveTo(x=607...

2019-05-23 09:29:38 348

原创房多多scrapy爬虫实例

# -*- coding: utf-8 -*-import scrapyimport osimport syssys.path.append("C:/Users/zhang-peng/scrapy/fhdodo")from fhdodo.items import FhdodoItemclass FhdoSpider(scrapy.Spider): name = 'fhdo...

2019-05-05 10:50:00 281

原创使用Threading模块创建线程

import threadingimport time exitFlag = 0 class myThread (threading.Thread): #继承父类threading.Thread def __init__(self, threadID, name, counter): threading.Thread.__init__(self) ...

2019-04-24 15:18:14 280

原创 scrapy爬虫实例

最开始学的爬虫就是小甲鱼的scrapy爬虫，不过当时都对pip install都没搞太懂所以学的是一头雾水，后来发现了可以用requests和美味汤来进行爬虫，用这个爬虫不要太简单啊，和scrapy爬虫比起来后来听说scrapy相比requests有优势吧那回头又来学习了scrapy爬虫首先还是在安装scrapy就卡了半天，按装scrapy需要先安装很多的包，不然一直会报错安装完成scr...

2019-04-22 14:43:29 785

原创 scarpy爬虫报错问题

import osimport syssys.path.append("C:/Users/z***g/scrapy/mypais") from mypais.items import ItcastItem不指定环境变量无法直接引用上一层的数据

2019-04-19 16:15:34 160

原创 python发邮件--中文附件报错问题

# -*- coding: utf-8 -*-"""Created on Thu Apr 11 14:01:30 2019@author: zhang-peng"""#coding: utf-8 import osimport sysimport smtplibfrom email.mime.text import MIMETextfrom email.mime.ima...

2019-04-11 15:38:13 842

原创 python--scipy--4离散概率分布：泊松分布

#导入包#数组包import numpy as np#绘图包import matplotlib.pyplot as plt#统计计算包的统计模块from scipy import stats'''arange用于生成一个等差数组，arange([start, ]stop, [step, ]使用见文档：https://docs.scipy.org/doc/numpy/refere...

2019-04-09 15:58:58 3396

原创 python--scipy--3离散概率分布：几何分布

#导入包#数组包import numpy as np#绘图包import matplotlib.pyplot as plt#统计计算包的统计模块from scipy import stats'''arange用于生成一个等差数组，arange([start, ]stop, [step, ]使用见文档：https://docs.scipy.org/doc/numpy/refere...

2019-04-09 15:30:41 1430

原创 python--scipy--2离散概率分布：二项分布

今天才知道原来文件名和库的名字不能一样了还有这样的bug#导入包#数组包import numpy as np#绘图包import matplotlib.pyplot as plt#统计计算包的统计模块from scipy import stats'''arange用于生成一个等差数组，arange([start, ]stop, [step, ]使用见文档：https://d...

2019-04-09 15:16:49 1787

原创 python--scipy--1离散概率分布：伯努利分布

#导入包#数组包import numpy as np#绘图包import matplotlib.pyplot as plt#统计计算包的统计模块from scipy import stats'''arange用于生成一个等差数组，arange([start, ]stop, [step, ]使用见文档：https://docs.scipy.org/doc/numpy/referen...

2019-04-09 14:37:46 1835

原创 python操作SQL和EXCEL进行数据比对

# -*- coding: utf-8 -*-import pandas as pdimport timeimport pyodbcstart = time.time()ytff = '****'riqi = '****'type_ = '****'wfjm = ****/{0}/{1}/{2}ok.xls'.format(ytff,riqi,type_)sn = '{}***...

2019-04-08 17:17:32 2348 2

原创使用python的pyodbc库操作sql server 2008并将结果保存为excel形式

# -*- coding: utf-8 -*-import pyodbcimport times = time.time()cnxn = pyodbc.connect(DRIVER='{SQL Server}',SERVER='192.168.12.10', DATABASE='PM',UID='zls',PWD='zls521')curs...

2019-04-03 11:36:16 879

原创链家二手房爬虫和获取经纬度

# -*- coding: utf-8 -*-"""Created on Mon Mar 25 10:10:22 2019@author: """# -*- coding: utf-8 -*-import bs4 import requestsimport time#引入time，计算下载时间import socketfrom urllib import errordef...

2019-03-28 16:17:06 3656

原创链家二手房在售爬虫

# -*- coding: utf-8 -*-"""Created on Mon Mar 25 21:13:13 2019@author: 盗号"""# -*- coding: utf-8 -*-"""Created on Mon Mar 25 10:10:22 2019@author: zhang-peng"""# -*- coding: utf-8 -*-impor...

2019-03-25 22:05:33 543

原创模拟器

http://npm.taobao.org/mirrors/chromedriver/

2019-03-21 13:45:37 143

原创贝叶斯定理

要了解贝叶斯定理，我们必须先知道什么是条件概率概率是什么我们大家都知道，它能够反映随机事件出现的可能性大小那什么是条件概率，现在有一位小明同学，上学总是迟到，迟到也是有概率的，小明每次迟到当然也是有原因的，假设小明迟到就是因为晚上打游戏早上经常睡过，如果前一天小明不玩游戏，第二天迟到的概率是20%如果小明前一天玩游戏，那第二天迟到的概率是60%这两个也就称之为条件概率，有条件的迟到...

2019-03-18 16:41:52 428

原创 python3使用pip安装pyautogui一直出错

之前安装pyautogui一直没问题的，重装系统以后怎么都安装不上，卸载了anaconda又装了一遍也没用直接pip install pyautogui报错UnicodeDecodeError: 'utf-8' codec can't decode byte 0xb5 in position 17: invalid start byteYou are using pip version...

2019-02-28 22:08:19 6028 3

原创 python---pyautogui

# -*- coding: utf-8 -*-import pyautoguiimport timeprint("解除现场引当")#切换到网页#pyautogui.moveTo(163,753,duration=0.2)#pyautogui.click()a = 344 b = 1c = 3n1 = time.time()count1 =0while count1 &lt...

2019-02-27 15:24:47 198

原创 python爬虫——链家苏州成交房价2

# -*- coding: utf-8 -*-import bs4 import requestsdef open_url(url):# url = 'https://su.lianjia.com/chengjiao/gongyeyuan/pg1/' hd = {} hd['User-Agent'] = 'Mozilla/5.0 (Windows NT 6.1) ...

2019-02-25 17:03:50 379

原创 sigmoid函数

# -*- coding: utf-8 -*-import numpy as npx = np.array([-1,1,2])y = x>0print(y)print(y.astype(np.int))#阶跃函数图像import matplotlib.pyplot as pltdef step_function(x): return np.array(x>...

2019-02-25 13:27:30 220

原创感知机的实现

与门、与非门、或门具有相同结构的感知机，区别只在于权重参数的值# -*- coding: utf-8 -*-def AND(x1,x2): w1, w2, theta = 0.5, 0.5, 0.7 tmp = x1*w1 + x2*w2 if tmp &lt; theta: return 0 elif tmp &gt;= theta: ...

2019-02-25 10:14:44 200

open_url('https://su.lianjia.com/chengjiao/107100984444.html')soup1 = bs4.BeautifulSoup(open_url('https://su.lianjia.com/chengjiao/107100984444.html').text,'html.parser')djjx = soup1.find_all("div",...

2019-02-22 17:18:32 200

原创 python爬虫——链家苏州成交房价

# -*- coding: utf-8 -*-import bs4 import requestsdef open_url(url):# url = 'https://su.lianjia.com/chengjiao/gongyeyuan/pg1/' hd = {} hd['User-Agent'] = 'Mozilla/5.0 (Windows NT 6.1) ...

2019-02-21 17:09:35 387

原创人鬼名单

import numpy as npimport pandas as pdjinglist = [ 'hylr','dsjp','cvmm', 'yusv','ufpj','vujn', 'bomk','mwho','dmfu', 'dcqu','jymu','waff', ...

2019-01-29 16:21:12 218

原创 SQL定义变量和格式化

SELECT @num:=4000/USEMUN FROM bom WHERE CHILD_ITEM_NO =141; SELECT PARENT_ITEM_NO, CHILD_ITEM_NO, FORMAT(USEAGE*@num,2), USEmun FROM bom WHERE PARENT_ITEM_NO IN (SELECT PARENT_ITEM_NO...

2018-12-18 22:27:09 261

原创 SQL如何让SELECT 查询结果额外增加自动递增序号

这个太有用了举个栗子表一t1p1p122019011220122201322013333表二t2p2p222019011190121901319013190将这个两个表拼接起来，看似简单，有一列是相同的，但是会出现笛卡尔乘积的问题SELECT t1.p1,t1.c1,t...

2018-12-06 23:24:13 4005

原创 SQL实际问题——列的替换和汇率打折问题

在一个表或者不同的表中，A列的某些值，用其对应的B列中的值替代举个栗子product_idproduct_nameproduct_typesale_pricepurchase_priceregist_date0001T恤衣服10005002009-09-200002打孔器办公用品5003202009-09-110003运动T恤衣服...

2018-12-04 20:03:32 1223

原创循环代码的优化

import timetime1 = time.time() a = ""for i in range(1000000): a += "sxt"time2 = time.time()print("运算时间："+str(time2-time1))time3 = time.time()li = []for i in range(1000000 ): li.appe...

2018-11-18 23:30:29 564

原创字典的解剖

a = ['名字','年龄','性别']b = ['Ken','18','男']c = dict(zip(a,b))print(c)s = ''print(s.center(60,'-'))print(c.items())print(s.center(60,'-'))print(c.values())print(s.center(60,'-'))print(c.keys(...

2018-11-18 23:27:30 145

原创修改字符串

import ios = "Hello, Ken"sio = io.StringIO(s)sio.seek(7)sio.write('may')print(sio.getvalue())Hello, may

2018-11-18 23:26:07 251

原创 format基本用法

a = "名字是:{0}，年龄:{1}。"print(a.format('Ken','18'))b = "我的名字时：{0}，喜欢数字{1:*^8}"print(b.format('Ken','66'))c = "我的名字时：{0}，喜欢数字{1:*>8}"print(c.format('Ken','66'))d = "我的名字时：{0}，喜欢数字{1:*<8}"p...

2018-11-18 23:24:45 210

原创闰年

# -*- coding:utf-8 -*-a = input("请输入你一个年份：")while not a.isdigit(): a = input("抱歉，输入有误，请输入一个整数：")year = int(a)if year%400 == 0: print(a+'是闰年！')else: if (year%4 == 0) and (year%10...

2018-11-18 23:22:56 135

原创 SQL——leetcode练习

Second Highest SalaryThe Employee table holds all employees. Every employee has an Id, a salary, and there is also a column for the department Id.+----+-------+--------+--------------+| Id | Name ...

2018-11-12 21:38:29 188

解密sycm data.zip

kettle下MySQL数据库驱动.zip

my.ini（mysql8.0.13 my.ini设置文件 Windows下的配置文件直接可用）

空空如也