![](https://img-blog.csdnimg.cn/20201014180756913.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
python
文章平均质量分 73
wuxi_joe
这个作者很懒,什么都没留下…
展开
-
python自动运行
# -*- coding:utf-8 -*-import subprocess,time,sysTIME = 3 #程序状态检测间隔(单位:分钟)CMD = "D:\mycode\Techingpython\daily.py" #需要执行程序的绝对路径,支持jar 如:D:\\calc.exe 或者D:\\test.ja...转载 2019-12-26 23:16:49 · 1675 阅读 · 0 评论 -
获取日交易数据
#encoding:utf-8import tushare as tsimport pandas as pdimport pymssql import datetimeimport timelocaltime = time.localtime(time.time())date_now= time.strftime("%Y%m%d", time.localtime())start_...原创 2019-12-26 18:59:22 · 356 阅读 · 0 评论 -
读取数据到sql
#encoding:utf-8import tushare as tsimport pandas as pdimport xlrdimport pymssql import datetimeimport sysfrom pandas import DataFrame, Seriesfrom sqlalchemy import create_enginefrom tushare....原创 2019-12-26 23:17:33 · 135 阅读 · 0 评论 -
sqlalchemy中create_engine用法
Database UrlsThe create_engine() function produces an Engine object based on a URL. These URLs follow RFC-1738, and usually can include username, password, hostname, database name as well as optiona...转载 2019-12-25 22:55:24 · 4851 阅读 · 0 评论