Coronavirus Positive Tests in Hawaii

Today I decided to look at the tests for coronavirus that are being done in Hawaii. It looks like the number of positive tests are slowing down. I had a sense that the population is also probably healthier from social distancing, so I wanted to look at the trend in tests and positive tests. library(dplyr) ## ## Attaching package: 'dplyr' ## The following objects are masked from 'package:stats': ## ## filter, lag ## The following objects are masked from 'package:base': ## ## intersect, setdiff, setequal, union library(ggplot2) library(lubridate) ## ## Attaching package: 'lubridate' ## The following object is masked from 'package:base': ## ## date library(scales) library(tidyr) library(zoo) ## ## Attaching package: 'zoo' ## The following objects are masked from 'package:base': ## ## as. [Read More]

Hawaii Coronavirus Update 2020-04-19

Here’s some more of my efforts to look at the local coronavirus data. I also thought it would be helpful to update the numbers this weekend since they look to have plateaued a bit this past week. In this post I look at the released cases versus the total to see how many active cases are still being tracked. I also look at the new cases by island since there were a couple of clusters on the Big Island and Maui. [Read More]

Hawaii Coronavirus Update 2020-04-14

In my last post I used data from the New York Times Github repository. The authors update it within a day or two but I found a new crowdsourced data source from the local tech community that is typically updated within minutes of the Department of Health data posting. Data Loading The Google Sheet is very nice to look at but I’ve had issues recently with loading data directly from Google sheets. [Read More]

Coronavirus in Hawaii

Coronavirus is all anyone can think about these days, and the New York Times has become a repository for USA case data for some reason. They have been publishing the data on Github for now. Data Loading I loaded the data directly from the NY Times repository. The repository has county and state lists but because I was interested in the different counties in Hawaii, I used the county file. [Read More]

Password Strength and Tidy Tuesday

I just found out about Tidy Tuesday, an educational exercise from the R for Data Science folks. The idea is that they publish a dataset every Tuesday for people to play around with. If you make something you’re proud of you can publish it on Twitter and use the hashtag #tidytuesday. I haven’t tried it before, but today’s one was a topic that was of interest to me–computer security and passwords. [Read More]

Restarting with California Health Interview Survey

Lately this blog has had a lot of descriptive posts about my life but not much that stretches my R abilities. Later this year my organization is holding its research day, so I decided to start practicing on a dataset that I last used about 7 years ago. The California Health Interview Survey is a survey of households that is weighted to be representative of the non-institutionalized population of California. [Read More]
health 

How Much Water Garbanzo Beans Absorb in an Overnight Soak

I made a recipe for falafel today that involved soaking dry garbanzo beans/chickpeas. I happened to have weighed the dry garbanzo beans before soaking to see how much I had. Before soaking I had 403 g beans. After soaking in tap water at 77 degrees F the weight was 795 g. The beans gained 392 g of water or 97.3% of their dry weight. That’s close enough to call it double! [Read More]

Running Mileage in 2019

After a great 2019 of running, I wanted to look back to see how far I had run. I regularly use a Garmin GPS watch to track my runs. The Garmin app and website let me look back at 12 months but after January 1, the 12 months was updated to February 2019 to January 2020 so I couldn’t see my 2019 totals anymore. I also sync to Strava but the Strava 2019 Year in Review mileage total (1216 miles) was off of the Garmin calculation that I saw at the end of December (~1300 miles). [Read More]

Prime Rib Temperature

We started a new family Christmas Eve tradition with roast prime rib. This year was a 6.61 lb bone on prime rib. library(dplyr) ## ## Attaching package: 'dplyr' ## The following objects are masked from 'package:stats': ## ## filter, lag ## The following objects are masked from 'package:base': ## ## intersect, setdiff, setequal, union library(ggplot2) dat <- tbl_df(read.csv("../datasets/Prime_rib_temp.csv")) I followed the Serious Eats recipe. I cut off the bone then salted and let the bones and meat dry brine overnight. [Read More]

Iolani Football 1945-2019

This week the local paper released a season recap of my alma mater’s football team. Included in the article was a link to game results dating back to 1945. It looked like there was an opportunity for a little data analysis on things like home and away records, records versus specific schools, etc. I downloaded the data and cleaned it for analysis in Google Sheets. library(dplyr) ## ## Attaching package: 'dplyr' ## The following objects are masked from 'package:stats': ## ## filter, lag ## The following objects are masked from 'package:base': ## ## intersect, setdiff, setequal, union library(lubridate) ## ## Attaching package: 'lubridate' ## The following object is masked from 'package:base': ## ## date library(ggplot2) iolani <- tbl_df(read. [Read More]