2019年12月_sara686

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

import pandas as pdimport ospwb = "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 1234

原创 python操作excel合并单元格

import xlwtimport xlwings as xwdef 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 1541

原创栈

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

2019-12-12 18:50:24 110

原创子图

import matplotlib.pyplot as pltimport numpy as npx = 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 126

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

import numpy as npimport matplotlib.pyplot as pltfrom scipy.interpolate import spliney1 =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 215

原创颜色和样式

import numpy as npimport matplotlib.pyplot as plty = 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 176

原创箱型图

import numpy as npimport matplotlib.pyplot as pltnp.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 116

原创饼状图

import matplotlib.pyplot as pltlabels = "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 137

原创直方图

mu = 100 # mean of distributionsigma = 20 # standard devition of distributionx = 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 93

原创条形图

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

2019-12-09 14:15:30 90

原创散点图和折线图等

import matplotlib.pyplot as pltimport 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 299

原创可视化

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

2019-12-02 09:50:13 236

原创时间日期

import pandas as pdimport numpy as npfrom datetime import datetimefrom datetime import timedeltanow = datetime.now()nowdatetime.datetime(2019, 11, 30, 17, 47, 19, 223904)now.year, now.month, n...

2019-12-01 21:30:55 86

sara686的博客