Set X and Y axis labels in Bokeh
p = figure(width=300, height=300, x_axis_label='Initial xlabel') p.xaxis.axis_label = 'New xlabel'
References
https://stackoverflow.com/questions/24131501/x-and-y-axis-labels-for-bokeh-figure
Run Flask on Windows
set FLASK_APP=app.py set FLASK_ENV=development REM set FLASK_ENV=production set FLASK_DEBUG=TRUE venv\Scripts\python.exe -m flask run --host=0.0.0.0 --port=14002
References
https://flask.palletsprojects.com/en/1.1.x/quickstart/
https://flask.palletsprojects.com/en/1.0.x/cli/
https://flask.palletsprojects.com/en/1.1.x/config/
https://stackoverflow.com/questions/29882642/how-to-run-a-flask-application
Configure bokeh plot to have responsive size
p.sizing_mode = "scale_both"
References
https://docs.bokeh.org/en/latest/docs/user_guide/layout.html#sizing-mode
Embedding Bokeh plots using iframe
Embedding a single plot at a time with output_file()
<iframe src="/assets/img/Bokeh/flowers.html"
sandbox="allow-same-origin allow-scripts"
width="100%"
height="500"
scrolling="no"
seamless="seamless"
frameborder="0">
</iframe>
References
https://p-mckenzie.github.io/2017/12/01/embedding-bokeh-with-github-pages/
Using iframe in Angular
import { Pipe, PipeTransform } from '@angular/core';
import { DomSanitizer} from '@angular/platform-browser';
@Pipe({ name: 'safe' })
export class SafePipe implements PipeTransform {
constructor(private sanitizer: DomSanitizer) {}
transform(url) {
return this.sanitizer.bypassSecurityTrustResourceUrl(url);
}
}
<iframe width="100%" height="300" [src]="url | safe"></iframe>
Enable CORS in flask
from flask import Flask
from flask_cors import CORS, cross_origin
app = Flask(__name__)
cors = CORS(app)
app.config['CORS_HEADERS'] = 'Content-Type'
@app.route("/")
@cross_origin()
def helloWorld():
return "Hello, cross-origin-world!"
References
https://stackoverflow.com/questions/25594893/how-to-enable-cors-in-flask
Extract unique items from a list in Excel
Array distinct formula (requires pressing Ctrl + Shift + Enter):
{=INDEX(list,MATCH(0,COUNTIF($D$4:D4,list),0))}
=IFERROR(INDEX($A$2:$A$10, MATCH(0, COUNTIF($B$1:B1, $A$2:$A$10), 0)), "")
References
https://exceljet.net/formula/extract-unique-items-from-a-list
Use INDEX and MATCH Formula in Excel
=INDEX(C3:E11,MATCH("Frantz",B3:B11,0),2)
References
https://exceljet.net/index-and-match
Excel MATCH Function
MATCH is an Excel function used to locate the position of a lookup value in a row, column, or table. MATCH supports approximate and exact matching, and wildcards (* ?) for partial matches. Often, the INDEX function is combined with MATCH to retrieve the value at the position returned by MATCH.
=MATCH(E2,B3:B11,0)
=MATCH("pq*",B3:B11,0)
=MATCH("peach",B3:B9,0)
References
https://exceljet.net/excel-functions/excel-match-function
Excel INDEX Function
The Excel INDEX function returns the value at a given position in a range or array. You can use index to retrieve individual values or entire rows and columns. INDEX is often used with the MATCH function, where MATCH locates and feeds a position to INDEX.
=INDEX(A1:B5,2,2) // returns value in B2 =INDEX(A1:B5,3,1) // returns value in A3
References
https://exceljet.net/excel-functions/excel-index-function