Posts

Some temperature data

using ffmpeg to stitch together some images into a slide show

Switched from Jekyll to Hugo

How to download your Noom data Per this note, you can apparently download your Noom data here I used this because I completely forgot what a serving was for one of my custom recipes On Noom all I can see is that my “KetoGranola20210326” , 1 serving is 187 Cal. But if I have a trusty food scale and I want to log 149g I need to know what that is for a serving. ...

link

Reference started reading [[February 2nd, 2021]] finished [[April 3rd, 2021]] Author [[Sonke Ahrens]] These are my [[literature notes]] I suppose. Book in three sentences When (not if) you take notes, less is more and you achieve this by writing like the git diff building on what you already know; you write what you have learned You write in your own words, distilling the gist, to make retention more likely. The [[slip box]] can make writing easier by replacing planning with the execution of small incremental well defined tasks, “Read with a pen and make fleeting notes”, “write literature notes from fleeting notes”, “create permanent notes around topics that tug at your interests as you go along”, “have interactive discussions with your slip box, making connections between your permanent notes as you go along”, “dump your permanent notes as outlines for manuscripts you can work on and edit until you are satisfied.” Impact ...

Quick reference for that keto pie Almond flour crust 350 F 2 (1/2) cup almond flour 3 tbspn erithrytol 1/4 tsp sea salt 1/4 cup melted butter Mix dry ingredients with butter first Then add 1 large egg 1/2 tsp vanilla extract Mix again Bake 10-12 min Coconut flour crust 400 F oven 1/2 cup coconut oil (melted) 3/4 cup coconut flour 1/4 tsp sea salt 2 tbspn erithrytol Combine those dry ingredients with oil using a mixer first Then add 2 eggs And mix again Bake around 10 min Filling 325 F oven One 15oz can pumpkin puree 1/2 cup heavy cream or coconut cream 2 large eggs, room temperature 1 (1/2) tsp cinnamon 1/2 tsp ginger 1/4 tsp nutmeg 1/8 tsp cloves 3 tbsp erithrytol 1/4 tsp sea salt 1 tspn vanilla extract Bake for about 50-60 min or until jiggly (jello like) Cool using a fan . Refrigerate

2021-04-10 Tust trawling image search for some inspiration Clamped From here, like the clamp since it doesn’t take over your entire desk. But I’m only seeing enough space for a laptop and hmm not a whole monitor. Bracket for big screens This one though , wow looks like an extension for your screen too nice. Hmm permanant tall desk Actually, reading that home Edit site more, I like the concept of just having a tall desk to begin with. And a nice soft mat to stand on. And then you can bring in a nice stool to sit on whenever you want to sit. Brilliant ...

2021-03-28 Tried uploading around 2021-03-13 oops.. Asked Vimeo support and answering some questions What version of the app am I running? Version 8.4.1 Any error messages after starting the upload? An error I see when I go to look my videos on https://vimeo.com/manage/videos “Optimization pending…” , “This is taking a while. Try refreshing the page, or come back later.” when I click on any of the videos there. How much free space is available on my mobile device and how large is the file? 61.9 GB of 64 GB Used Videos ranging from 100MB to 500MB Was the video being uploaded shot on the same device? Or imported from elsewhere? Yes ...

https://databricks.com/try-databricks 2021-03-21 Running A quick start notebook Based on the notes here, it is pretty easy to create an auto-scaling cluster. Not sure yet what events prompt the cluster to get more workers. But I would be curious to try a job that uses fewer workers and more workers, to see how the outcomes compare. I also like ethat this notebook supports SQL and also python , using what looks like first line as %python to indicate the language. Is this spark sql or sql ? From the quick start notebook… CREATE TABLE diamonds USING csv OPTIONS (path "/databricks-datasets/Rdatasets/data-001/csv/ggplot2/diamonds.csv", header "true") 2021-04-03 Revisit my earlier problem Last time , I found this CDC dataset called “COVID-19_Case_Surveillance_Public_Use_Data.csv” My basic initial question I would like to answer is “how do the symptomatic rates compare by age bin”, since this dataset has an onset_dt column, which is eithr blank if no symptoms and has a date if symptoms. More dataset metadata.. 22.5 M rows each row is a de-identified patient created: 2020-05-15 updated 2021-03-31 (not sure what was being updated though) Temporal Applicability: 2020-01-01/2021-03-16 Update Frequency: Monthly columns Column Name Description Type cdc_case_earliest_dt Calculated date–the earliest available date for the record, taken from either the available set of clinical dates (date related to the illness or specimen collection) or the calculated date representing initial date case was received by CDC. This variable is optimized for completeness and may change for a given record from time to time as new information is submitted about a case. Date & Time cdc_report_dt Calculated date representing initial date case was reported to CDC. Depreciated; CDC recommends researchers use cdc_case_earliest_dt in time series and other time-based analyses. Date & Time pos_spec_dt Date of first positive specimen collection Date & Time onset_dt Symptom onset date, if symptomatic Date & Time current_status Case Status: Laboratory-confirmed case; Probable case Plain Text sex Sex: Male; Female; Unknown; Other Plain Text age_group Age Group: 0 - 9 Years; 10 - 19 Years; 20 - 39 Years; 40 - 49 Years; 50 - 59 Years; 60 - 69 Years; 70 - 79 Years; 80 + Years Plain Text race_ethnicity_combined Race and ethnicity (combined): Hispanic/Latino; American Indian / Alaska Native, Non-Hispanic; Asian, Non-Hispanic; Black, Non-Hispanic; Native Hawaiian / Other Pacific Islander, Non-Hispanic; White, Non-Hispanic; Multiple/Other, Non-Hispanic Plain Text hosp_yn Hospitalization status Plain Text icu_yn ICU admission status Plain Text death_yn Death status Plain Text medcond_yn Presence of underlying comorbidity or disease Plain Text Get data in there Per the Databricks web console I can specify an S3 bucket and create a table from my file like that And they refer to “DBFS” as “Databricks File System” from the example you can load from the File Store like sparkDF = spark.read.csv('/FileStore/tables/state_income-9f7c5.csv', header="true", inferSchema="true") # then you can create a temp table from that df sparkDF.createOrReplaceTempView("temp_table_name") THere was also an interesting note in the help notebook about permanent tables available across cluster restarts… # Since this table is registered as a temp view, it will only be available to this notebook. If you'd like other users to be able to query this table, you can also create a table from the DataFrame. # Once saved, this table will persist across cluster restarts as well as allow various users across different notebooks to query this data. # To do so, choose your table name and uncomment the bottom line. permanent_table_name = "{{table_name}}" # df.write.format("{{table_import_type}}").saveAsTable(permanent_table_name) I am looking for how to do this w/ s3… Ah according to docs you mount s3 files as regular files then proceed as usual ok will try that … aws_bucket_name = "my-databricks-assets-alpha" s3fn = "s3://my-databricks-assets-alpha/cdc-dataset/COVID-19_Case_Surveillance_Public_Use_Data.csv" s3fn = "s3://my-databricks-assets-alpha/cdc-dataset/COVID-19_Case_Surveillance_Public_Use_Data.head1000.csv" mount_name = "blah" dbutils.fs.mount("s3a://%s" % aws_bucket_name, "/mnt/%s" % mount_name) display(dbutils.fs.ls("/mnt/%s" % mount_name)) Funny thing I was trying to run this cell in the databricks notebook but it would not run and no error was given. But the reason I am pretty sure is that no cluster was attached to the notebook. ...