3f:null 40:["$","title",null,{"children":"Utils | Bright | Observable"}] 46:T512,style = html``47:[] 44:{"id":"6e3d8776f076c1d6","slug":"utils","title":"Utils","thumbnail":"c34ef02ffcb28db5c0f1723260bc2954cae616713673bf7c54ed1e05482c4ce7","access_level":"public","create_time":"$D2022-08-10T01:41:15.467Z","update_time":"$D2023-03-12T07:19:40.137Z","view_time":null,"first_public_time":"$D2023-02-14T04:18:40.425Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"af1f5d50c28a0daa","login":"cottonsh","name":"Bright","avatar_url":"https://avatars-next.observableusercontent.com/9d3d644ab76cea5630482ceb616150b3cf74fa61e6e445e7b2033dae2406ebf8","tier":"starter_2024","bio":"","following":false},"version":349,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"eae7b817ce208d2d","login":"cottonsh","name":"Bright","avatar_url":"https://avatars-next.observableusercontent.com/9d3d644ab76cea5630482ceb616150b3cf74fa61e6e445e7b2033dae2406ebf8","tier":null,"bio":"","following":false}],"members":[{"type":"individual","id":"eae7b817ce208d2d","login":"cottonsh","name":"Bright","avatar_url":"https://avatars-next.observableusercontent.com/9d3d644ab76cea5630482ceb616150b3cf74fa61e6e445e7b2033dae2406ebf8","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Utils","cells":[{"id":0,"value":"# Utils\n 1、Terminal\n \n get a place to print message altogether,messages are innerhtml of <div> element\n - Terminal: return a terminal with default style\n - title:title display at top of Terminal\n - print(...args):print text messages, every message is displayed in one line,eg. print(1,2,3), print('text'),print()\n - cls():clear all outputs\n\n2、Notebook Visulizer\n\ngenerate a notebook Visulizer @observablehq/notebook-visualizer\n\nusage:\nimport {notebookNB} from \"cottonsh/utils\"\nid='@observablehq/notebook-visualizer'\nnotebookNB(id)\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":98,"value":"## 1、Terminal","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":57,"value":"title=\"【Terminal】
\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":7,"value":"Terminal=html`

${title}

`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":14,"value":"function print(...args){\n Terminal.innerHTML+=\" \"\n for(let arg of args){\n Terminal.innerHTML=arg+\"\\t\"\n }\n Terminal.innerHTML+=\"
\"\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":47,"value":"function cls(){\n Terminal.innerHTML=`${title}`\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":103,"value":"cls()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":101,"value":"print()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":110,"value":"# 2、Notebook Visulizer","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":112,"value":"mutable id=\"@observablehq/notebook-visualizer\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":114,"value":"import {chart} with {id as id} from \"@observablehq/notebook-visualizer\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":119,"value":"function visulizeNB(id){\n mutable id=id;\n return chart\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":123,"value":"visulizeNB(\"@cottonsh/echarts-runner\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":128,"value":"# 3、Akshare tookit\n\n```javascript\nimport {akshare} from '@cottonsh/utils'\n//return json data\ndata=akshare(api_name,{arg1:value,arg2:value})\n//show data\nInputs.table(data)\n```","pinned":true,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":133,"value":"function akshare(api,args){ \n \n var s=''\n for(var arg in args){\n s+=arg+'='+args[arg]+'&'\n }\n let url=`http://127.0.0.1:5000/api/public/${api}?${s}`\n let data=$.ajax({\n url:url\n });\n console.log(api,url)\n return data\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":149,"value":"## 处理json中的null值\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":158,"value":"function handleNullInJson(data,fill=0){\n /*\n []\n */\n data.forEach(d=>{\n for(var key in d){\n if (d[key]===null){\n d[key]=fill\n }\n }\n })\n return data\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":233,"value":"### py-server\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":235,"value":"function Py2(codes,objBack=null){\n var msg\n $.ajax({\n type: \"get\",\n url: \"http://127.0.0.1:5000\",\n dataType : 'json',\n crossDomain:true,\n contentType:'application/json',\n data:{code:codes,objBack:objBack},\n async:false,\n success: function(res){\n \n msg={\n out:res.out,\n value:JSON.parse(res.objBack)\n }\n }\n }); \n \n return msg\n \n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":222,"value":"### 打印table\nhttps://observablehq.com/@visnup/hello-danfo-js","pinned":true,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":226,"value":"function printdf(data_as_array) {\n \n const table = html`

`;\n \n let tableObject = d3.select(table);\n \n tableObject.append(\"tr\")\n .selectAll()\n .data(data_as_array[0])\n .enter()\n .append(\"th\")\n .text(d => d);\n \n tableObject.selectAll(\"tr\")\n .data(data_as_array.slice(1, 15))\n .enter()\n .append(\"tr\")\n .selectAll()\n .data(d => d)\n .enter()\n .append(\"td\")\n .text(d => d)\n ;\n \n \n return table;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":344,"value":"# 使用attrs属性","pinned":true,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":348,"value":"//使用 d3.select('div').call(attrs({width:600,height:800}))\nfunction attrs(o,arg) { \n Object.keys(arg).forEach(k=>{\n console.log(typeof k,arg[k])\n o.attr(k,arg[k])\n \n }) \n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":143,"value":"# 引入其他库 ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":147,"value":"import {EchartsRunner} from '@cottonsh/echarts-runner'","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":166,"value":"moment=require(\"https://cdn.jsdelivr.net/npm/moment@2.29.4/moment.min.js\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":176,"value":"import {dfd} from '@visnup/hello-danfo-js'","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":135,"value":"$$=require(\"https://cdn.jsdelivr.net/npm/jquery@3.6.0/dist/jquery.min.js\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":163,"value":"sz=akshare('stock_szse_summary',{\"date\":''+getDate(new Date())})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":205,"value":"function handle_null_json(data){\n data.forEach(d=>{\n for(var key in d){\n if (d[key]===null){\n d[key]=0\n }\n }\n })\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":213,"value":"import {style} from \"@sandraviz/d3image\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":260,"value":"htl.html`

test

\n`\n","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":274,"value":"faker=import('https://cdn.skypack.dev/@faker-js/faker')","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":294,"value":"faker.faker.name.fullName()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":311,"value":"Faker = (await import('https://cdn.skypack.dev/faker@5.5.3?min')).default","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":313,"value":"# Python","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":316,"value":"function toArray(df) {\n return df.to_dict(\"records\").toJs().map(Object.fromEntries)\n \n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":322,"value":"pd = {\n await pyodide.loadPackage(\"pandas\");\n return pyodide.runPython(`import pandas\npandas`);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":324,"value":"import { py, pyodide } from \"@gnestor/pyodide\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":338,"value":"pd.date_range('2013-1-1',periods=6)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":328,"value":"function loadFile(file){\n return pyodide.pyodide_py.open_url(file)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":334,"value":"# Other","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":336,"value":"$46","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"}],"files":"$W47","stdlib":"1"}} 45:"$44:body"