![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
python基础学习
文章平均质量分 67
jsj_ilu_jsj
一个热爱学习的金融人
展开
-
python_8.2_表格拼接
#表的纵向拼接import pandas as pddf1 = pd.read_excel(r"C:\Users\jsjilu\Desktop\jsj\data12.xlsx",sheet_name = "Sheet1")df2 = pd.read_excel(r"C:\Users\jsjilu\Desktop\jsj\data12.xlsx",sheet_name = "Sheet2")df3 = pd.read_excel(r"C:\Users\jsjilu\Desktop\jsj\data.原创 2021-05-29 20:53:57 · 144 阅读 · 0 评论 -
python_6_表格转换
#转置行列import pandas as pdimport numpy as npdf = pd.read_excel(r"C:\Users\jsjilu\Desktop\jsj\data5.xlsx")df.Tdf.T.T #二次转置不变原创 2021-05-29 20:50:36 · 146 阅读 · 0 评论 -
python_6_时间序列
from datetime import datetimedatetime.now()#返回当前的时间点datetime.now().yeardatetime.now().monthdatetime.now().day原创 2021-05-29 19:35:45 · 69 阅读 · 0 评论 -
python_xlwings
#xlwings#creat excel and do some proimport xlwings as xw# APP函数,两个参数,一个是窗口是否可视,第二个是是否直接创建工作簿app = xw.App(visible =False,add_book =False)#books的子函数add用于新建工作簿workbook =app.books.add()#保存workbook.save('D:\\pythonfile\list\example.xlsx')#关闭并退出wor.原创 2021-05-29 19:32:19 · 264 阅读 · 0 评论 -
python_7_数据分组
import pandas as pddf = pd.read_excel(r"C:\Users\jsjilu\Desktop\jsj\data10.xlsx")df原创 2021-05-29 19:28:51 · 279 阅读 · 0 评论 -
python_8_表格拼接
import pandas as pddf1= pd.read_excel(r"C:\Users\jsjilu\Desktop\jsj\data11.xlsx",sheet_name = "Sheet1")df2= pd.read_excel(r"C:\Users\jsjilu\Desktop\jsj\data11.xlsx",sheet_name = "Sheet2")df3 = pd.read_excel(r"C:\Users\jsjilu\Desktop\jsj\data11.xlsx",sh.原创 2021-05-29 19:25:56 · 716 阅读 · 0 评论 -
python_6_简单算术
import pandas as pddf=pd.read_excel(r"C:\Users\jsjilu\Desktop\jsj\data8.xlsx")df原创 2021-05-29 19:21:31 · 83 阅读 · 0 评论 -
python_4_pandas基础
import pandas as pddf = pd.read_excel(r"C:\Users\jsjilu\Desktop\jsj\data1.xlsx")dfimport pandas as pddf = pd.read_excel(r"C:\Users\jsjilu\Desktop\jsj\data1.xlsx",sheet_name = "Sheet1",index= 0)df原创 2021-05-28 18:47:29 · 112 阅读 · 0 评论 -
python_9_数据可视化之坐标系
#导入matplotkib库中的pyplot并起名为pltimport matplotlib.pyplot as plt原创 2021-05-28 18:31:43 · 285 阅读 · 0 评论 -
python_10_绘制图表
#绘制折线图import matplotlib.pyplot as plt%matplotlib inlineplt.rcParams["font.sans-serif"]='SimHei'plt.rcParams['axes.unicode_minus'] = Falsefig = plt.figure()plt.figure(figsize = (8,6))plt.subplot(1,1,1)#指明x和y值import numpy as npx = np.array([1,2,3原创 2021-05-28 18:03:24 · 466 阅读 · 0 评论