def table_base(data) -> Table: table = Table() level = ['较低:0~3k', '一般:3k~5k', '中等:5k~8k', '较高:8k~12k', '优秀:12k以上'] city = ['beijing', "shanghai", 'guang', 'shen', 'cheng'] table.add(level, data[1]).set_global_opts( title_opts=opts.ComponentTitleOpts(title="表格", subtitle="城市")) return table
def take_snapshot(self, file_html=None, width="1400px", height="580px"): """获取快照 :param file_html: str 交易快照保存的 html 文件名 :param width: str 图表宽度 :param height: str 图表高度 :return: """ tab = Tab(page_title="{}@{}".format(self.symbol, self.end_dt.strftime("%Y-%m-%d %H:%M"))) for freq in self.freqs: chart = self.kas[freq].to_echarts(width, height) tab.add(chart, freq) t1 = Table() t1.add(["名称", "数据"], [[k, v] for k, v in self.s.items() if "_" in k and isinstance(v, str) and v not in ["Other~其他", "向下", 'Y~是', 'N~否', '向上']]) t1.set_global_opts(title_opts=ComponentTitleOpts(title="缠中说禅信号表", subtitle="")) tab.add(t1, "信号表") t2 = Table() ths_ = [["同花顺F10", "http://basic.10jqka.com.cn/{}".format(self.symbol[:6])]] t2.add(["名称", "数据"], [[k, v] for k, v in self.s.items() if "_" not in k and v != "Other~其他"] + ths_) t2.set_global_opts(title_opts=ComponentTitleOpts(title="缠中说禅因子表", subtitle="")) tab.add(t2, "因子表") if file_html: tab.render(file_html) else: return tab
def table_base(sql, titl) -> Table: table = Table() # engine = create_engine("mysql+pymysql://root:root@localhost:3306/mysql", encoding="utf-8") # session = sessionmaker(bind=engine) # df = pd.read_sql(sql, engine) # rows=df.values.tolist() # headers=df.columns.tolist() with SQLPoll() as db: students = db.fetch_all(sql, None) headers = [] for student in students: headers = list(student.keys()) break c = [] rows = [] for student in students: c = list(student.values()) rows += [c] if len(rows) == 0: headers = ['记录', '数量'] rows = [['无', 0]] table.add( headers, rows).set_global_opts(title_opts=opts.ComponentTitleOpts(title=titl)) return table
def take_snapshot(self, file_html=None, width="1400px", height="580px"): """获取快照 :param file_html: str 交易快照保存的 html 文件名 :param width: str 图表宽度 :param height: str 图表高度 :return: """ tab = Tab(page_title="{}@{}".format( self.symbol, self.end_dt.strftime("%Y-%m-%d %H:%M"))) for freq in self.freqs: chart = ka_to_echarts(self.kas[freq], width, height) tab.add(chart, freq) t1 = Table() t1.add(["名称", "数据"], [[k, v] for k, v in self.s.items() if "_" in k]) t1.set_global_opts( title_opts=ComponentTitleOpts(title="缠中说禅信号表", subtitle="")) tab.add(t1, "信号表") t2 = Table() t2.add(["名称", "数据"], [[k, v] for k, v in self.s.items() if "_" not in k]) t2.set_global_opts( title_opts=ComponentTitleOpts(title="缠中说禅因子表", subtitle="")) tab.add(t2, "因子表") if file_html: tab.render(file_html) else: return tab
def table_base() -> Table: table = Table() heardes = [ "课题名称", "课题编号", "年份", "负责人", "负责单位", "课题类型", "领域", "课题方向", "关键词", "URL" ] res_file = "..\\000LocalData\\caict_k\\research_subject_intergrate.csv" res_file_read = open(res_file, 'r', encoding='utf-8') res_list = [] temp_list = [] res_name_list = [] for line in res_file_read.readlines(): line = line.strip().split("|") if line[1] not in res_name_list: temp_list.append(line[0]) temp_list.append(line[1].replace("--", "-", 10)) temp_list.append(line[2]) temp_list.append(line[3]) temp_list.append(line[4]) temp_list.append(line[5]) temp_list.append(line[6]) temp_list.append(line[7]) temp_list.append(line[8]) temp_list.append(line[10]) # print(temp_list) res_list.append(temp_list) temp_list = [] res_name_list.append(line[1]) table.add(heardes, res_list).set_global_opts( title_opts=opts.ComponentTitleOpts(title="院软课题知识数据表(2010-2019)")) return table
def table_traces(rows) -> Table: table = Table() headers = ["设备名", "MonkeyError", "条数"] table.add( headers, rows).set_global_opts(title_opts=ComponentTitleOpts(title="错误日志收集")) return table
def get_eventtable(rows) -> Table: table = Table() headers = ["序号", "日期", "举报内容", "所属区域", "维度", "经度"] for r in rows: c = r[2] cl = list(c) n_w = len(cl) idx = int((n_w - 1) / 30) #每40个词分行 if (idx < 1): continue for i in range(idx): cl.insert((i + 1) * 30, "\n") r[2] = "".join(cl) ''' headers = ["City name", "Area", "Population", "Annual Rainfall"] rows = [ ["Brisbane", 5905, 1857594, 1146.4], ["Adelaide", 1295, 1158259, 600.5], ["Darwin", 112, 120900, 1714.7], ["Hobart", 1357, 205556, 619.5], ["Sydney", 2058, 4336374, 1214.8], ["Melbourne", 1566, 3806092, 646.9], ["Perth", 5386, 1554769, 869.4], ["Sydney", 2058, 4336374, 1214.8], ["Melbourne", 1566, 3806092, 646.9], ["Perth", 5386, 1554769, 869.4], ] ''' table.add(headers, rows).set_global_opts( title_opts=ComponentTitleOpts(title="详细举报数据"), ) return table
def getDeatils(self, num): if num <= 0: exit("[+] 所取条数必须大于0,默认为20!") YearRank = {} for i in range(1, self.month + 1): global MonthRank MonthRank = {} url = self.baseurl + "&month=%d" % i res = requests.get(url) maxPage = int(re.findall(re.compile(r'(?<=page=)\d*(?=\D)'), res.text)[-2]) if re.findall(re.compile(r'(?<=page=)\d*(?=\D)'), res.text) else 1 pagelist = [_ for _ in range(1,maxPage + 1)] threads = [GetList(pagelist[i:i+3], url) for i in range(0,maxPage + 1,3)] for t in threads: t.start() for t in threads: t.join() YearRank = dict(Counter(YearRank) + Counter(MonthRank)) YearRank = sorted(YearRank.items(), key = lambda x:x[1], reverse=True) if num > len(YearRank): num = len(YearRank) YearRank = dict(YearRank) else: YearRank = dict(YearRank[0:num]) table = Table(page_title = "edusrc%d 年度榜单 TOP %d" % (time.localtime().tm_year,num)) YearRankKeys= [_ for _ in YearRank.keys()] YearRankValues = [_ for _ in YearRank.values()] headers = ["排名", "用户名", "Rank"] rows = [] for i in range(len(YearRank)): row = [i + 1, YearRankKeys[i], YearRankValues[i]] rows.append(row) table.add(headers, rows) table.render("result.html") os.system("result.html")
def create_base_table(title, x_list, data_list): headers = [" "] + x_list rows = [] for key in data_list.keys(): #print(key) row = [] row.append(key) for x in data_list[key]: row.append(x) #print(row) rows.append(row) table = Table() table.add(headers, rows) table.set_global_opts( title_opts=opts.ComponentTitleOpts(title=title) ) src_path = "./test/" html_file_name = src_path + title + ".html" img_file_name = src_path + title + ".png" table.render(html_file_name) path_wkimg = r'C:\Program Files\wkhtmltopdf\bin\wkhtmltoimage.exe' # 工具路径 cfg = imgkit.config(wkhtmltoimage=path_wkimg) imgkit.from_file(html_file_name, img_file_name, config=cfg) #make_snapshot(snapshot, table.render(html_file_name), img_file_name) print(img_file_name+"生成完毕...")
def statistics(model, jupyter=True, path='Model Summary.html', title="Model Summary", subtitle=""): t = pd.DataFrame([[ i.name, i.__class__.__name__, i.trainable, i.dtype, i.input_shape, i.output_shape, i.count_params() ] for i in model.layers], columns=[ 'layer_custom_name', 'layer_object_name', 'trainable', 'dtype', 'input_shape', 'output_shape', 'params' ]) # t['output_memory(MB)'] = (t.output_shape.map(lambda x:sum([reduce(lambda y,z:y*z, i[1:]) for i in x]) if isinstance(x, list) else reduce(lambda y,z:y*z, x[1:])) # *t.dtype.map(lambda x:int(re.sub("\D", "", x))))/32#/1024/1024) t.loc['total'] = ['', '', '', '', '', '', t.params.sum()] t['input_shape'] = t.input_shape.map( lambda x: str(x).replace("),(", "),\n(") if isinstance(x, list) else x) t = t.reset_index().rename(columns={'index': ''}) for i in t.columns: t[i] = t[i].astype(str) table = Table() headers = t.columns.tolist() rows = t.values.tolist() table.add(headers, rows).set_global_opts( title_opts=ComponentTitleOpts(title=title, subtitle=subtitle)) return table.render_notebook() if jupyter else table.render(path)
def table_base(header,row) -> Table: table = Table(page_title='未完成项',js_host=r"D:\JGY\600-Data\004-auxiliary辅助文件\\") headers = header rows = row table.add(headers, rows).set_global_opts( title_opts=opts.ComponentTitleOpts(title="Table") ) return table
def _gen_table() -> Table: table = Table() headers = ["City name", "Area", "Population", "Annual Rainfall"] rows = [["Brisbane", 5905, 1857594, 1146.4], ["Perth", 5386, 1554769, 869.4]] table.add(headers, rows) return table
def table_base(header,row) -> Table: table = Table() headers = header rows = row table.add(headers, rows).set_global_opts( title_opts=opts.ComponentTitleOpts(title="Table") ) return table
def createtable(data): # 生成pyecharts表格 table = Table() headers = ["提交日期","仪器编号","板号","样品数量","结果均值","ISD"] # rows = [[localtime(d.upload_time).strftime("%Y-%m-%d %X"), d.instrument, d.platenum, d.num, d.mean, d.sd] for d in data] rows = [[d.upload_time.strftime("%Y-%m-%d %X"), d.instrument, d.platenum, d.num, d.mean, d.sd] for d in data] table.add(headers, rows).set_global_opts(title_opts=ComponentTitleOpts(title="结果分布表")) return table
def test_table_base(fake_writer): table = Table() headers = ["City name", "Area", "Population", "Annual Rainfall"] rows = [["Brisbane", 5905, 1857594, 1146.4], ["Perth", 5386, 1554769, 869.4]] table.add(headers, rows).render() _, content = fake_writer.call_args[0] assert_in("fl-table", content)
def table_base(rows) -> Table: table = Table() headers = [ "设备名", "设备号", "CPU", "总内存", "分辨率", "网络", "耗时(s)", "CPU峰值", "CPU均值", "内存峰值", "内存均值", "fps峰值", "fps均值", "开始电量", "结束电量", "上行流量峰值", "上行流量均值", "下行流量峰值", "下行流量均值" ] table.add(headers, rows).set_global_opts( title_opts=ComponentTitleOpts(title="手机汇总信息", subtitle="")) return table
def _create_table() -> Table: table = Table() headers = ["City name", "Area", "Population", "Annual Rainfall"] rows = [ ["Brisbane", 5905, 1857594, 1146.4], ["Adelaide", 1295, 1158259, 600.5], ["Darwin", 112, 120900, 1714.7], ] table.add(headers, rows) return table
def table_base() -> Table: table = Table() headers = ["国家", "2012", "2013", "2014", "2015", "2016", "2017", "2018"] rows = [ ["中国", 3.867, 4.158, 4.301, 3.953, 3.685, 4.107, 4.622], ] table.add(headers, rows).set_global_opts( title_opts=opts.ComponentTitleOpts(title="近年中国贸易总额/万亿美元")) return table
def table_base(): table = Table() headers = ["地区", "现有确诊", "累计死亡", "累计治愈"] rows = [] table.add(headers, rows).set_global_opts( title_opts=ComponentTitleOpts(title="Table", subtitle="副标题")) # table.render("table_base.html") return rows
def table_base(feeds: typing.List) -> Table: table = Table() headers = ['user', 'action', 'time', 'question', 'vote'] rows = [] for f in feeds: info = [f.user, f.action, f.time, f.question, f.vote] rows.append(info) table.add(headers, rows).set_global_opts(title_opts=ComponentTitleOpts( title='爬取一天的关注动态', subtitle='利用无头浏览器爬取异步加载页面')) table.render('zhihu.html') return table
def table_base(): table = Table() headers = ["地区", "确诊", "死亡", "治愈"] rows = [["湖北", 13522, 414, 397], ["浙江", 829, 0, 60], ["广东", 813, 0, 24], ["河南", 675, 2, 20], ["湖南", 593, 0, 29], ["安徽", 480, 0, 20], ["江西", 476, 2, 19], ["重庆", 344, 2, 9]] table.add(headers, rows).set_global_opts( title_opts=ComponentTitleOpts(title="Table", subtitle="副标题")) # table.render("table_base.html") return rows
def draw_Table(Time_List, Score_List, Comment_List, Update_List): #绘制评论表格 table = Table() headers = ["评论时间", "情绪值", "评论内容"] rows = [] for index in range(0,1800,30): temp = [Time_List[index], Score_List[index], Comment_List[index]] rows.append(temp) table.add(headers, rows).set_global_opts( title_opts=ComponentTitleOpts(title="时间-情绪-评论文本 抽样数据") ) return table
def get_table_base(self, _data): ''' plot geo-detail :param _data: gps对应的城市分布(dataframe) :return: 数据示例 ''' table = Table() headers = ["City name", "Number"] rows = _data table.add(headers, rows).set_global_opts( title_opts=opts.ComponentTitleOpts(title="Table-Details")) return table
def table(self): print('正在生成表格...') table = Table() headers = ['商品详情', '商品价格', '商品销量', '店铺名称', '店铺地址', '商品图片', '商品主页'] rows = [ list(item.values()) for item in self.collection.find({}, {'_id': 0}) ] table.add(headers, rows) table.set_global_opts(title_opts=ComponentTitleOpts(title="数据源表格汇总")) table.render("表格汇总.html") print('生成完成')
def table(self): table = Table() if self.obj.type == 0: headers = ["用户名", "Rank", "平均Rank", "通过率"] rows = [[self.obj.sid, self.obj.rank, self.obj.averageRank, self.obj.passingRate]] title = self.obj.sid + "个人信息" else: headers = ["单位", "Rank", "平均Rank"] rows = [[self.obj.sid, self.obj.rank, self.obj.averageRank]] title = self.obj.sid + "信息" table.add(headers, rows) table.set_global_opts(title_opts = ComponentTitleOpts(title = title, title_style = {"style": "text-align:center;font-weight:800;"})) self.page.add(table)
def table_base(): table = Table() headers = ["City name", "Area", "Population", "Annual Rainfall"] rows = [ ["Brisbane", 5905, 1857594, 1146.4], ["Adelaide", 1295, 1158259, 600.5], ["Darwin", 112, 120900, 1714.7], ["Hobart", 1357, 205556, 619.5], ["Sydney", 2058, 4336374, 1214.8], ["Melbourne", 1566, 3806092, 646.9], ["Perth", 5386, 1554769, 869.4], ] table.add(headers, rows)
def table_base() -> Table: table = Table() headers = ["年份", "华南理工大学", "深圳大学", "广州工业大学", "五邑大学"] rows = [ ["2019", 55, 169, 377, 745], ["2018", 58, 167, 452, 792], ["2017", 87, 432, 406, 768], ["2016", 58, 470, 350, 800], ] table.add(headers, rows).set_global_opts( title_opts=ComponentTitleOpts(title="江门一中最低录取排名(不包含自主招生)") ) return table
def table_base(Movies) -> Table: table = Table() headers = ['name', 'score', 'quote', 'cover_url', 'ranking', 'country'] rows = [] for movie in Movies: info = [ movie.name, movie.score, movie.quote, movie.cover_url, movie.ranking, movie.country ] rows.append(info) table.add(headers, rows).set_global_opts(title_opts=ComponentTitleOpts( title='多页爬虫', subtitle='利用URL自动爬取下一页')) table.render('douban.html') return table
def totable(self,arrayAttr,arrayValue,name) -> Table: table = Table() headers =arrayAttr rows = [ arrayValue ] table.add(headers, rows).set_global_opts( title_opts=ComponentTitleOpts(title="Table-Details", subtitle=name) ) hname = str(time.time()) + '.html' table.render('./front-end/table/'+hname) return hname
def take_snapshot(self, file_html, width="950px", height="480px"): tab = Tab(page_title="{}的交易快照@{}".format( self.symbol, self.end_dt.strftime("%Y-%m-%d %H:%M"))) for freq in self.freqs: chart = ka_to_echarts(self.kas[freq], width, height) tab.add(chart, freq) headers = ["名称", "数据"] rows = [[k, v] for k, v in self.signals.items()] table = Table() table.add(headers, rows) table.set_global_opts( title_opts=ComponentTitleOpts(title="缠论信号", subtitle="")) tab.add(table, "信号表") tab.render(file_html)