MR_comentropy的博客

numpy pandas 总结import numpy as npar = np.array([[[1,2,3,4,5,6],[2,3,4,5,6,7],[3,4,5,6,7,8]]])print(ar,ar.ndim)#维度数组print(ar.shape)print(ar.data)ar1 = np.array(range(10))ar2 = np.arange(10)ar3 = np.array([[1,2,3,4,5,6]])ar4 = np.random.rand(10).re

dataframe数据的选取和操作import pandas as pdimport numpy as npimport cx_Oraclecon =cx_Oracle.connect('scott/123@localhost:1521/orcl',encoding='utf-8')sql =f''' SELECT e.empno, e.ename, e.sal, e.deptno FROM emp e UNION ALL SELECT dept

flask_oracle###1.service 文件import cx_Oracleimport pandas as pdcon=cx_Oracle.connect("scott/123@localhost:1521/orcl",encoding='utf-8')# 一.service 文件# 1.查询员工信息（无参数时返回全量信息）def SearchEmpInfor(n_deptno): v_where = ' and 1=1 ' if n_deptno != "":

python 写入一年的时间到数据库中from calendar import Calendarfrom db.db_opt import Oraclec = Calendar(firstweekday=0)list_date =[]for item in c.yeardatescalendar(2018,12): for i in item: for a in i: for b in a: list_date.ap

3.列表，字典# 列表常见生成方式list_one = list(range(1,11)) # 注意range(1,11)是左闭右开list_two = [x*x for x in range(1,11) if x%2==0] # 列表生成式（条件可以不写），偶数的平方list_three = [x+y for x in 'ABC' for y in '123'] # 双层循环，生成全排列import stringprint(string.ascii_letters+string.digits

2.流程控制语句# 网吧禁止入内标语age = 18if age < 18: print('您还未满18岁，禁止入内')else: print('欢迎光临！')# 网吧禁止入内标语if 3 - 1: print('非零的数在布尔表达中都为True')else: print('0 代表False') # 逻辑运算符，not,and,ora = 4 < 1b = 4 < 1c = 4 == 1print(a and b)

1.字符串与变量# print 函数# def print(self, *args, sep=' ', end='\n', file=None)print('hello world')print('锄禾日当午,\n汗滴禾下土。') # \n 换行输出print('12','34','56',sep='+',end='') # 输出的结果之间用+连接，默认是空格连接，end指后面3.14的输入同行输出，默认换行print(3.14) # 数字不需要引号，编译器也能识别# 制表符与换行符\t,\

jupyternotebook 基础设置1.修改默认的工作目录（1）打开anaconda prompt 输入: jupyter notebook --generate-config（2）按上目录打开 jupyter_notebook_config.py的文件，找到 c.NotebookApp.notebook_dirx该行， 然后将''修改为'D:\\目标目录'或者是'/home/work/yynbook'(注意window是的目录是用'\\',linix用'/') 注意：如果你的这一