Loading

12 2021 档案

摘要:计算分组平均数 from pandas import Series,DataFrame import pandas as pd import numpy as np df = pd.read_excel('F:/Jupyter/6.xlsx') df = df.pivot_table(index=[ 阅读全文
posted @ 2021-12-07 14:19 ZhouSpeaks 阅读(131) 评论(0) 推荐(0)
摘要:transform方法 transform会讲一个函数运用到各个分组。 文件6.xlsx的内容如下: 假设我们想为DataFrame添加一个用于存放各索引分组平均值的列。我们可以先聚合再合并: from pandas import Series,DataFrame import pandas as 阅读全文
posted @ 2021-12-07 13:45 ZhouSpeaks 阅读(135) 评论(0) 推荐(0)
摘要:GroupBy 按发行人汇总2021年截至目前债券实际发行规模的统计 from pandas import Series,DataFrame import pandas as pd import pymysql db = pymysql.connect(host='127.0.0.1', port 阅读全文
posted @ 2021-12-06 12:30 ZhouSpeaks 阅读(156) 评论(0) 推荐(0)
摘要:线形图 DataFrame.plot() import pandas as pd from pandas import DataFrame,Series df = DataFrame([12,22,53,14,25,36,27,58,69,10],columns = ['A'],index = np 阅读全文
posted @ 2021-12-03 15:57 ZhouSpeaks 阅读(237) 评论(0) 推荐(0)
摘要:app.py from flask import Flask, render_template, redirect, session from flask import request app = Flask(__name__) app.secret_key = '\xc9ixnRb\xe40\xd 阅读全文
posted @ 2021-12-01 16:12 ZhouSpeaks 阅读(242) 评论(0) 推荐(0)