2019年12月_sara686

原创 python合并多个excel表格到一张表中

import pandas as pd import os pwb = "D:/PY/合并文件" df_list = [] for path, dirs, files, in os.walk(pwb): for file in files: file_path = os.path.join(path, file) df = pd.read_excel(f...

2019-12-17 14:54:12 1245

原创 python操作excel合并单元格

import xlwt import xlwings as xw def set_style(name, height, bold=False): style = xlwt.XFStyle() font = xlwt.Font() font.bold = bold font.colour_index = 4 font.height = height ...

2019-12-17 13:33:44 1550

原创栈

文章目录栈栈 Stack() 创建一个新的空栈 push(item) 添加一个新的元素item到栈顶 pop() 弹出栈顶元素 peek() 返回栈顶元素 is_empty() 判断栈是否为空 size() 返回栈的元素个数 # -*-coding:utf-8_*- class Stack(object): """栈""" def __init__(self): ...

2019-12-12 18:50:24 112

import matplotlib.pyplot as plt import numpy as np x = np.arange(1,100) fig = plt.figure() ax1 = fig.add_subplot(221) ax1.plot(x,x) ax2 = fig.add_subplot(222) ax2.plot(x,-x) ax3 = fig.add_subplot(223)...

2019-12-09 19:41:03 132

原创自己举例-三条平滑折线图

import numpy as np import matplotlib.pyplot as plt from scipy.interpolate import spline y1 =np.array([10,15,22,16,36]) y2 =np.array([9,14,20,20,40]) y3 =np.array([11,19,18,15,23]) x = np.array([1,2,3,...

2019-12-09 17:34:48 220

原创颜色和样式

import numpy as np import matplotlib.pyplot as plt y = np.arange(1, 5) plt.plot(y, color="g") plt.plot(y+1, color="0.5") plt.plot(y+2, color="#FF00FF") plt.plot(y+3, color=(0.1, 0.2, 0.3)) plt.show() ...

2019-12-09 15:34:51 182

原创箱型图

import numpy as np import matplotlib.pyplot as plt np.random.seed(100) data = np.random.normal(size=1000,loc=0,scale=1) plt.boxplot(data, sym="o", whis=1.5) # whis 代表虚线的长度，用来调节异常值的包括范围。 plt.show() n...

2019-12-09 15:10:34 123

原创饼状图

import matplotlib.pyplot as plt labels = "A","B","C","D" fracs = [15,30,45,10] explode = [0,0.1,0,0] plt.axes(aspect=1) # 比例为1：1，即转化为正圆。 plt.pie(x=fracs, labels=labels, autopct="%.0f%%", explode=explo...

2019-12-09 14:56:15 146

原创直方图

mu = 100 # mean of distribution sigma = 20 # standard devition of distribution x = mu + sigma*np.random.randn(2000) plt.hist(x,bins=50,color="red",normed=False) plt.show() 结果： x = np.random.randn(10...

2019-12-09 14:31:30 103

原创条形图

import numpy as np import matplotlib.pyplot as plt N=5 y=[20,10,30,25,15] index = np.arange(N) pl = plt.bar(left=index, height=y) plt.show() 结果是： N=5 y=[20,10,30,25,15] index = np.arange(N) pl = p...

2019-12-09 14:15:30 95

原创散点图和折线图等

import matplotlib.pyplot as plt import numpy as np # x = np.loadtxt("test1201.csv", delimiter=",", skiprows=1,usecols=(1,3,5),unpack=False) # print(x) # open,close,volume = np.loadtxt("test1201.csv",...

2019-12-06 09:38:00 305

原创可视化

%matplotlib inline import pandas as pd import numpy as np ts = pd.Series(np.random.randn(1000),index=pd.date_range("2000/1/1",periods=1000)) ts = ts.cumsum() ts.describe() count 1000.000000 mean ...

2019-12-02 09:50:13 241

原创时间日期

import pandas as pd import numpy as np from datetime import datetime from datetime import timedelta now = datetime.now() now datetime.datetime(2019, 11, 30, 17, 47, 19, 223904) now.year, now.month, n...

2019-12-01 21:30:55 91

sara686的博客