Categories

All (110)

-API, Plumber, Workflow (1)

-CLI (1)

-Census, ACS pyramid-plots (1)

-Chat-GPT (1)

-Chat-GPT, DPLYR (1)

-ChatGPT -GoogleSheets (1)

-Data Management (1)

-Git -Shiny -Usethis (1)

-Glue (1)

-Google App Script -Chat GPT (1)

-Google Drive (1)

-Google Sheets (2)

-Hack (1)

-Life (1)

-Process Documentation (1)

-Quality, Checklists (1)

-Quartro (1)

-SQL -MS Access (1)

-Sanity (1)

-Shiny -TIL (1)

-Stats (1)

-TODO (1)

-Text Analysis (1)

-YAML (1)

-dplyr, -ChatGPT, -Google Colab (1)

-html -img -freecodecamp (1)

Akimbo (1)

Books (1)

CL (1)

Chat GPT (3)

Computer Literacy (1)

Docker (2)

Evaluation (2)

GHA (1)

Google App Script (1)

Google Colab (1)

Links (1)

Linux (3)

R (28)

SQL (1)

Shiny (2)

TLI (1)

TidyCensus (1)

evaluation (1)

maps (1)

skills (1)

R for Social Good

Kevin Gilds, MPA

Shiny Fun

Shiny

TLI

Styling a Shiny App

Kevin Gilds, MPA

All Equal()

Today I need to find a difference between two data frames. Actually, I had to split the data frame and find the difference between two survey entries.

Kevin Gilds, MPA

Cron-Jobs-GHA

I scheduled my first GHA with a cron job. The idea was to set it for 5:00 am every Sunday.

Kevin Gilds, MPA

Stylying a Shiny App

-Shiny -TIL

I was running into a issue of formatting a shiny application. In a tab panel, the content was running into the left margin. I asked Claude A.I and it gave me 3 options.

Kevin Gilds, MPA

Test Your SQL

SQL

SQL is on my mind and this looks like an interesting resource to test those SQL skills. I struggle with new data sets so this may be a good challenge.

Kevin Gilds, MPA

Github Actions

GHA

I spent the weekend revisiting how to build a GitHub Action to automatically pull data from Clockify. It was a challenging experience that felt like my first time coding due…

Kevin Gilds, MPA

Links

Links

Kevin Gilds, MPA

Flywheels

skills

Making Skills look easy

Kevin Gilds, MPA

Playing with Mapboxer Pkg

maps

Playing with the Mapboxer Pkg

Kevin Gilds, MPA, Kevn Gilds, MPA

CL Shortcuts

CL

Playing with the Command Line

Kevin Gilds, MPA, Kevn Gilds, MPA

VIM

Computer Literacy

Playing with VIM

Kevin Gilds, MPA, Kevn Gilds, MPA

Apologies

-Life

Thinking about apologies

Kevin Gilds, MPA, Kevn Gilds, MPA

Markdown Code to R script

-Chat-GPT

Used Chat GPT to help me with this

Kevin Gilds, MPA, Kevn Gilds, MPA

Plumber Fun

-API, Plumber, Workflow

Troubleshooting API End Points

Kevin Gilds, MPA, Kevn Gilds, MPA

Purpose of this data?

-Data Management

Data Request Forms

Kevin Gilds, MPA, Kevn Gilds, MPA

Hotel Internet

-Hack

Work around for captive web portals

Kevin Gilds, MPA, Kevn Gilds, MPA

Calendar & To Do List

-Sanity

A Blog Post Pairing Calendar & To Do List

Kevin Gilds, MPA, Kevn Gilds, MPA

Quality Control

-Quality, Checklists

Post about Quality Control

Kevin Gilds, MPA, Kevn Gilds, MPA

Mermaid Diagrams

-Process Documentation

Playing with Mermaid Diagrams

Kevin Gilds, MPA, Kevn Gilds, MPA

Text Analysis

-Text Analysis

title: freelance-posts author: kevin date: ‘2020-06-19’

Kevin Gilds, MPA, Kevn Gilds, MPA

Weather and RSS on the Command Line

-CLI

Fun at the command line

Kevin Gilds, MPA, Kevn Gilds, MPA

Top_frac Inverse

-Chat-GPT, DPLYR

Getting to the bottom half

Kevin Gilds, MPA, Kevn Gilds, MPA

Is Not Null

-SQL -MS Access

Is Not Null Explanation

Kevin Gilds, MPA, Kevn Gilds, MPA

Pivot Longer

-dplyr, -ChatGPT, -Google Colab

Iterating Pivot Longer with ChatGPT

Kevin Gilds, MPA, Kevn Gilds, MPA

All about the YAML

-YAML

Kevin Gilds, MPA, Kevn Gilds, MPA

Synthetic data

-Stats

Kevin Gilds, MPA, Kevn Gilds, MPA

Household Income: Polk County

TidyCensus

Map Polk County Household Income

Kevin Gilds, MPA, Kevn Gilds, MPA

Population Pyramids

-Census, ACS pyramid-plots

Working with Tidy Census Data

Kevin Gilds, MPA, Kevn Gilds, MPA

TODOs

-TODO

Kevin Gilds, MPA, Kevn Gilds, MPA

More Google Colab

Google Colab

Using R with Google Colab

Kevin Gilds, MPA, Kevn Gilds, MPA

Style for Gmail

-Google App Script -Chat GPT

The sage of styling an html table for Gmail

Kevin Gilds, MPA, Kevn Gilds, MPA

Colab

-Google Drive

Use Python or R with Google Drive

Kevin Gilds, MPA, Kevn Gilds, MPA

Today I learned

-Google Sheets

No Query for you with xls

Kevin Gilds, MPA, Kevn Gilds, MPA

UNPIVOT

-ChatGPT -GoogleSheets

UNPIVOT IN GOOGLE SHEETS

Kevin Gilds, MPA, Kevn Gilds, MPA

Web Stuff

-Quartro

Adding a footer to blog posts

Kevin Gilds, MPA, Kevn Gilds, MPA

Branches

-Git -Shiny -Usethis

Kevin Gilds, MPA, Kevn Gilds, MPA

Glue

-Glue

Kevin Gilds, MPA, Kevn Gilds, MPA

Mutating for Good

-Google Sheets

Create Extra Data to make it work

Kevin Gilds, MPA, Kevn Gilds, MPA

Spreadsheet Data to Google Calendar

Google App Script

Google App Script to add Events from spreadsheet to Google Calandar

Kevin Gilds, MPA, Kevn Gilds, MPA

The Img Tag

-html -img -freecodecamp

Kevin Gilds, MPA, Kevn Gilds, MPA

i, Robot

Books

Chat GPT

More than Science Fiction

Kevin Gilds, MPA, Kevn Gilds, MPA

Impact of AI

Chat GPT

Kevin Gilds, MPA, Kevn Gilds, MPA

Chat GPT

Chat GPT

Kevin Gilds, MPA, Kevn Gilds, MPA

Data Dictionary

Artilce on Pointblank Package

Kevin Gilds, MPA, Kevn Gilds, MPA

Interactive Documents

Sketching out ideas

Kevin Gilds, MPA, Kevn Gilds, MPA

What to write

Getting the grove back

Kevin Gilds, MPA, Kevn Gilds, MPA

Email on edit

This video gave me an idea

Kevin Gilds, MPA, Kevn Gilds, MPA

Checklists

Love and Hate them

Kevin Gilds, MPA, Kevn Gilds, MPA

One down

Finished the Learn HTML Section

Kevin Gilds, MPA, Kevn Gilds, MPA

Goals

Inputs and Outpus

Kevin Gilds, MPA

R & Linux

Rember this post

Kevin Gilds, MPA, Kevn Gilds, MPA

Wilcox-signed-rank-test

A good article on this topic

Kevin Gilds, MPA, Kevn Gilds, MPA

This week I learned

Kevin Gilds, MPA, Kevn Gilds, MPA

Today I learned

Making dates more difficult

Kevin Gilds, MPA, Kevn Gilds, MPA

Streaks

Kevin Gilds, MPA, Kevn Gilds, MPA

Today I learned

A script to filter multiple values

Kevin Gilds, MPA, Kevn Gilds, MPA

Data Types

When something is not working as expected; check the data type

Kevin Gilds, MPA, Kevn Gilds, MPA

Lazy & Automation

Thanksgiving weekend

Kevin Gilds, MPA, Kevn Gilds, MPA

App Script

Kevin Gilds, MPA, Kevn Gilds, MPA

Codebooks and More

Kevin Gilds, MPA, Kevn Gilds, MPA

Likert Scales

Kevin Gilds, MPA, Kevn Gilds, MPA

Reprex

Reprex and other items I learned today

Kevin Gilds, MPA, Kevn Gilds, MPA

Import Packages

Kevin Gilds, MPA, Kevn Gilds, MPA

Make terrible gadgets

To make good gadgets you have to make some stinkers

Kevin Gilds, MPA, Kevn Gilds, MPA

playing

Playing with addins

Kevin Gilds, MPA, Kevn Gilds, MPA

move

I moved to Quarto and not sure how I feel about it. I know how Blogdown and Hugo can be burdensome. I just kept waiting for things to break on me. I miss my add new post…

Kevin Gilds, MPA

joins

Here is the basic form of a join.

Kevin Gilds, MPA

R-packages

The QualtRics pakcage is a key r package I utilize. The package provides an API access from Qualtrics to a R environment. If you manage separate Qualtrics accounts, set your…

Kevin Gilds, MPA

addins

I downloaded the remedy package today.

Kevin Gilds, MPA

sql cert

I have enjoyed taking the courses from this learning track.https://www.freecodecamp.org/learn/relational-database/

Kevin Gilds, MPA

bash

Using a bash script with Postgres database.

Kevin Gilds, MPA

foreign keys

I have been working on a SQL certification course from Freecode Camp. The most important thing that I learned today was adding a Foreign Key to a table in Postgres.

Kevin Gilds, MPA

SQL Form

ALTER TABLE <table_name> ADD COLUMN <column_name> <DATA_TYPE> <CONSTRAINTS>;

Kevin Gilds, MPA

Nano

Linux

I was testing my luck/skill with this post and curious if I messed anything up editing a bash file in Nano.

Kevin Gilds, MPA, Kevin

Git Hooks

R

I came here for an article on a .gitlab-ci.yml example and came away with an article on githooks. I think the githook is what I need!

Kevin Gilds, MPA, Kevin

commit to the static

R

Kevin Gilds, MPA, Kevin

Column Names

R

Designed Data Management 🧐

Kevin Gilds, MPA, Kevin

A README Tale

R

This tweet led me in many directions.

Kevin Gilds, MPA, Kevin

data-types

R

Common errors emerge from mix matched data types but the error ouput rarely tell you this-if ever.

Kevin Gilds, MPA, Kevin

flextable

R

I am preparing to complete a report using officedown due at the end of the month. I was checking out the package out today and was happy to see I could at least open the…

Kevin Gilds, MPA, Kevin

Docker Tutorial

Docker

I went through this tutorial today and concepts are starting to sink in and the power of it.

Kevin Gilds, MPA, Kevin

Docker

Docker

Docker Deep Dive was recommended to me yesterday. I start using Docker and then I stop and lose the momentum. Kind of like programming, I suspect you have to do Docker in…

Kevin Gilds, MPA, Kevin

Submodules

Shiny

R

Don’t forget the ns!

Kevin Gilds, MPA, Kevin

Shiny Proxy Fun

R

This article got me thinking about other hosting possibilities such as html files and bookdown reports.

Kevin Gilds, MPA, Kevin

Automated Testing Links

R

I stumbled upon these resources over the weekend and they gave me some ideas on how to automate some tests.

Kevin Gilds, MPA, Kevin

Writing in Community

Akimbo

I signed up for this workshop. I believe this will help me develop the habit of writing everyday whether I want to or not. I participated in the Freelance workshop and found…

Kevin Gilds, MPA, Kevin

Command Line

Linux

R

Here is a fun video/content on using the command line. Command Line. Good stuff with ls command and navigation.

Kevin Gilds, MPA, Kevin

Maps!

R

Here is a tutorial on using the mapview package. I hope I get to use it soon.

Kevin Gilds, MPA, Kevin

Back to Gitlab

Full stop, I prefer Gitlab!

Kevin Gilds, MPA, Kevin

TIL

R

I wrote some functions and scripts had to complete troubleshooting to make them work

Kevin Gilds, MPA, Kevin

Abstraction

R

I am preparing for a presentation on shiny modules I am giving in the coming week and it got me thinking. The comparison between the use of modules and functions is on point…

Kevin Gilds, MPA, Kevin

To make upper case

R

I needed to make the values in a column consistent and was struggling to add in the base R function of toupper in a dplyr pipeline. I found the str_to_upper(string, locale =…

Kevin Gilds, MPA, Kevin

Fun with Readme & Github Actions

R

I have been focused on github actions and gitlab pipelines for about two weeks, and I stumbled upon this cool post. Not only is there good content on Github Actions, but…

Kevin Gilds, MPA, Kevin

Dashboards

Evaluation

R

I started a project thinking I wanted to get away from a dashboard and present the information within the context of a website. Once the building process started, I realized…

Kevin Gilds, MPA, Kevin

Linux-Twitter

Linux

Kevin Gilds, MPA, Kevin

2021-12-Eval-Twitter-Threads

Evaluation

Kevin Gilds, MPA, Kevin

Testing Shiny Applications

R

At some point last year, I jumped into unit testing with the help of the pointblank package. Since then, I have improved my ability to work with the testthat package.

Kevin Gilds, MPA, Kevin

Issue-Templates

R

Can I make an issue template in Gitlab!

Kevin Gilds, MPA, Kevin

File-Paths

R

Not that file paths come up in polite conversations.

Kevin Gilds, MPA, kevin

Data Management

evaluation

I discovered two great resources for data management in the past couple of weeks: Data Cleaning Plan and Data Audits

Kevin Gilds, MPA, kevin

Domain Expertise

R

It is very cool when someone articulates a sense you have brewing beneath the surface.

Kevin Gilds, MPA, Kevin

Communication Toolbox with Shiny

R

Last Wednesday, I presented the User Feedback chapter from Mastering Shiny for Cohort 2 of the book club from r4ds. My goal was to emphasize that a shiny application is a…

Kevin Gilds, MPA, Kevin

Shaking up Mental Models

R

Once you see it; you can’t unsee it.🤔

Kevin Gilds, MPA, Kevin

Lessons

R

There were warnings!🤕

Kevin Gilds, MPA, Kevin

Where are my keys

R

Today, I had to relearn how to reset a git remote.

Kevin Gilds, MPA, Kevin

Side Benefits of Learning R

R

If you take the time to learn ggplot2 you are going to learn a lot more than plotting. Depending on your purpose for learning ggplot2, that could be great or perhaps…

Kevin Gilds, MPA, Kevin

Across

R

I made that more difficult than it had to be.

Kevin Gilds, MPA, Kevin

Pets

R

The TidyTuesday project for March 27, 2019 consisted of Pet Registrations from Seattle. I had the good fortune to work with this data set prior on a Chromebook Data Science…

Kevin Gilds, MPA, Kevin

Maps

R

My issue list includes a task to map the Fl Absences data set.

Kevin Gilds, MPA, kevin