- 博客(14)
- 收藏
- 关注
原创 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 152
原创 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 153
原创 python_6_时间序列
from datetime import datetimedatetime.now()#返回当前的时间点datetime.now().yeardatetime.now().monthdatetime.now().day
2021-05-29 19:35:45 73
原创 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 271
原创 python_7_数据分组
import pandas as pddf = pd.read_excel(r"C:\Users\jsjilu\Desktop\jsj\data10.xlsx")df
2021-05-29 19:28:51 296
原创 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 724
原创 python_6_简单算术
import pandas as pddf=pd.read_excel(r"C:\Users\jsjilu\Desktop\jsj\data8.xlsx")df
2021-05-29 19:21:31 94
原创 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 117
原创 finance_work2_形态分析
import akshare as akimport pandas as pdd1 = stock_zh_a_daily_qfq_df = ak.stock_zh_a_daily(symbol="sh600690", start_date='20190401', end_date='20210401', adjust="qfq")print(d1)writer = pd.ExcelWriter(r"C:\Users\jsjilu\Desktop\finance data\work2\data5.x.
2021-05-28 18:38:24 99
原创 finance_work1_K线形态分析
import mpl_finance as mpffrom matplotlib import pyplot as pltimport numpy as npimport pandas as pdfig = plt.figure(figsize=(12,8))ax = fig.add_subplot(111)# 加载数据df_ma = pd.DataFrame()original_data = pd.read_csv(r"C:\Users\jsjilu\Desktop\financ...
2021-05-28 18:35:23 98
原创 python_9_数据可视化之坐标系
#导入matplotkib库中的pyplot并起名为pltimport matplotlib.pyplot as plt
2021-05-28 18:31:43 296
原创 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 477
原创 python_1_输出语句
print('我在学习:{}'.format('python'))print('i am studying :{} of {}'.format('basic word','python course'))print("{} is {:.2f} thousand".format("2021年中国单身人数",2))
2021-05-28 17:16:03 70
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人