full_data
Type Table, then Shift-Enter. Ctrl-space for more options.
complaints@1.db
full_data = db.query(`
WITH tmp as (
SELECT review_id, airline, country, ratings, lang, translated_text, title, date_pub
FROM reviews
)
SELECT embedding_x, embedding_y, doc_top, text, airline, country, tmp.review_id, ratings, lang, translated_text, title, date_pub
FROM ${form.select_m} m
LEFT JOIN tmp
ON m.review_id = tmp.review_id
`)
db = DuckDBClient.of({
reviews: FileAttachment("tripadvisor_reviews_multi_country_downsampled_trans.parquet"),
country_paraphrase_multilingual_MiniLM_L12_v2_True_False: FileAttachment("country_paraphrase_multilingual_MiniLM_L12_v2_True_False.parquet"),
country_paraphrase_multilingual_MiniLM_L12_v2_False_False: FileAttachment("country_paraphrase_multilingual_MiniLM_L12_v2_False_False.parquet"),
country_paraphrase_multilingual_MiniLM_L12_v2_False_True: FileAttachment("country_paraphrase_multilingual_MiniLM_L12_v2_False_True.parquet"),
country_paraphrase_multilingual_MiniLM_L12_v2_True_True: FileAttachment("country_paraphrase_multilingual_MiniLM_L12_v2_True_True.parquet"),
country_sentence_transformersLaBSE_False_False: FileAttachment("country_sentence_transformersLaBSE_False_False.parquet"),
country_sentence_transformersLaBSE_False_True: FileAttachment("country_sentence_transformersLaBSE_False_True.parquet"),
country_sentence_transformersLaBSE_True_False: FileAttachment("country_sentence_transformersLaBSE_True_False.parquet"),
country_sentence_transformersLaBSE_True_True: FileAttachment("country_sentence_transformersLaBSE_True_True.parquet")
})
Purpose-built for displays of data
Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.
