flyDeDog的博客

### xlrd excel读```import xlrdfrom datetime import date, datetimeworkbook = xlrd.open_workbook(r'F:\demo.xlsx') # 打开文件workbook.sheet_names() # 获取所有sheet名字 [u'sheet1', u'sheet2'] sheet2 = workbook.shee

from sqlalchemy import create_engineengine = create_engine("mysql://root:@localhost:3306/webpy?charset=utf8",encoding="utf-8", echo=False)conn = engine.connect()conn.execute("SELECT * FROM user")

https://github.com/dbader/scheduleimport datetimeimport scheduleimport threadingimport timedef job1(): print("I'm working for job1") time.sleep(2) print("job1:", datetime.datetime....

关闭防火墙 systemctl stop firewalld.service（systemctl disable firewalld.service）/usr/local/python3.6.5/bin/virtualenv --python=/usr/local/python3.6.5/bin/python3.6 --no-site-packages stock_data_getpip i...

测试框架pytest, 文档方面感觉比nose好很多pip install pytest==3.4.2pip install pytest-html==1.16.1import os.pathimport pytestdef getssh(): # pseudo application code return os.path.join(os.path.expanduser("~ad

import loggingfrom logging import handlershandler = handlers.RotatingFileHandler('./flask2.log', encoding='UTF-8', maxBytes=124, backupCount=0)logging_format = logging.Formatter( '%(asctime)s - %

发送rpc请求parameters = {"jsonrpc": "2.0","method": "get_test_result","params": {},"id": "1"}result = requests.post("http://localhost:5000/api", json=parameters).json()

安装pip install sphinx假设现在我们有一个叫run.py的文件，如下# run.pydef run(name): """ this is how we run :param name name of people who runs """ print name, 'is running'创建一个文件夹demo/，并将

实际上是指定另一套环境变量安装 pip install virtualenv 创建工作目录 mkdir myproject cd myproject/ 创建独立的python运行环境，命名为venv virtualenv –python=/usr/local/python2.7/bin/python2.7 –no-site-packages env 进入名为venv的python环境

In [18]: bOut[18]: [1, 2, 3]In [19]: b?Type: listString form: [1, 2, 3]Length: 3Docstring:list() -> new empty listlist(iterable) -> new list initialized from iterable's items

> 测试函数要以 test或者Test 开头> setup:在测试用例开始时被执行> teardown:在测试用例结束后被执行> 对于上面的代码，nose实际的执行过程是这样的：setUp()->Testfunc1()->Testfunc2()->tearDown()

使用python中timedelta这个类实现月份的累加pip install dateutilsimport datetime import dateutilz=datetime.datetime(2016,12,17) z+dateutil.relativedelta.relativedelta(months=1)

django-celery定时任务安装库文件pip install celerypip install django-celery修改配置文件settings.pyimport djcelerydjcelery.setup_loader()CELERYBEAT_SCHEDULER = 'djcelery.schedulers.DatabaseScheduler' #定时任务需要BROKER_U

diango命令python manage.py makemigrations 生成migration文件python manage.py migrate 对数据库进行操作python manage.py validate – 检查在构建你的模型时是否有错误python manage.py sqlcustom polls – 输出为应用定义的任何 custom SQL statements

安装yum -y install gearmand pip install gearmanWorker 脚本gearman运行需要三部分：client,job,workerclient负责任务请求，job负责任务分发，worker负责任务执行启动jobgearmand –log-file gearmand.log –listen 115.28.6.1 –port=4730 –verbose=INF

* 创建ndarray(多维数组对象)data1 = [6, 7.5, 8, 0.1]arr1 = np.array(data1)arr1Out[40]:array([ 6. , 7.5, 8. , 0.1])

* namedtuple > namedtuple是一个函数，它用来创建一个自定义的tuple对象，并且规定了tuple元素的个数，并可以用属性而不是索引来引用tuple的某个元素。这样一来，我们用namedtuple可以很方便地定义一种数据类型，它具备tuple的不变性，又可以根据属性来引用，使用十分方便

conda create -n py36 python=3.6source anaconda3/bin/activate py36安装ziplineconda install -c Quantopian zipline安装TA_Libhttps://github.com/mrjbq7/ta-libhttp://prdownloads.sourceforge.net/ta-lib/...