R for Social Good
  • Blog
  • Projects
  • Notes
Categories
All (118)
-API, Plumber, Workflow (1)
-Chat-GPT (1)
-Chat-GPT, DPLYR (1)
-ChatGPT -GoogleSheets (1)
-CLI (1)
-Data Management (1)
-dplyr, -ChatGPT, -Google Colab (1)
-Git -Shiny -Usethis (1)
-Glue (1)
-Google App Script -Chat GPT (1)
-Google Drive (1)
-Google Sheets (2)
-Hack (1)
-html -img -freecodecamp (1)
-Life (1)
-Process Documentation (1)
-Quality, Checklists (1)
-Quartro (1)
-Sanity (1)
-Shiny -TIL (1)
-Stats (1)
-Text Analysis (1)
-TODO (1)
-YAML (1)
Akimbo (1)
Books (1)
Chat GPT (3)
CL (1)
Claude-AI (1)
Computer Literacy (1)
Data Equity (1)
Decision Making (1)
Docker (2)
Evaluation (2)
evaluation (1)
GHA (1)
Google App Script (1)
Google Colab (1)
Google Sheets (1)
Links (1)
Linux (3)
LLM (1)
maps (1)
OJS (1)
Process Culture (1)
Productivity (1)
Qualtrics (2)
R (28)
RSS (1)
Shiny (4)
skills (1)
SQL (1)
TLI (1)
Verison Control (1)

R for Social Good

Author

Kevin Gilds, MPA

 

Kevin Gilds, MPA
 

It’s a cycle

Productivity

Producivity System

2025-11-10
Kevin Gilds, MPA
 

Qualtrics Fun

Qualtrics

More Version Control with Qualtrics

2025-11-05
Kevin Gilds, MPA
 

An OJS Primer

OJS

Trying OJS

2025-01-22
Kevin Gilds, MPA, Kevin
 

Data Equity

Data Equity

Weekly drop in conversations regarding data equity

2025-01-21
Kevin Gilds, MPA, Kevin
 

Process Culture

Process Culture

Developing a Process Culture

2025-01-20
Kevin Gilds, MPA, Kevin
 

Google Sheets Tables

Google Sheets

Working with Google Sheets Tables

2025-01-19
Kevin Gilds, MPA, Kevin
 

Knowledge Work

Decision Making

Decision Making

2025-01-12
Kevin Gilds, MPA, Kevin
 

Customize Shiny Manger Log In Screen

Shiny
Claude-AI

Steps to customize Shiny Manger log in page

2025-01-05
Kevin Gilds, MPA, Kevin Gilds
 

Saved by Qualtrics Version Control

Qualtrics
Verison Control

Revert Qualtrics Survey to earlier point

2024-12-08
Kevin Gilds, MPA, Kevin Gilds
 

Elmer

LLM
Shiny

Article on LLMs and Elmer Package

2024-11-30
Kevin Gilds, MPA, Kevin Gilds
 

RSS Feeds

RSS

Setting Up an RSS feed for this site

2024-11-26
Kevin Gilds, MPA
 

Shiny Fun

Shiny
TLI

Styling a Shiny App

2024-11-17
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.
2024-11-11
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.
2024-11-10
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.
2024-11-10
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.
2024-11-04
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…
2024-11-03
Kevin Gilds, MPA
 

Links

Links

Resources

2024-09-22
Kevin Gilds, MPA
 

Flywheels

skills

Making Skills look easy

2024-07-25
Kevin Gilds, MPA
 

Playing with Mapboxer Pkg

maps

Playing with the Mapboxer Pkg

2024-07-20
Kevin Gilds, MPA, Kevn Gilds, MPA
 

CL Shortcuts

CL

Playing with the Command Line

2024-07-07
Kevin Gilds, MPA, Kevn Gilds, MPA
 

VIM

Computer Literacy

Playing with VIM

2024-07-07
Kevin Gilds, MPA, Kevn Gilds, MPA
 

Apologies

-Life

Thinking about apologies

2024-06-15
Kevin Gilds, MPA, Kevn Gilds, MPA
 

Markdown Code to R script

-Chat-GPT

Used Chat GPT to help me with this

2024-05-27
Kevin Gilds, MPA, Kevn Gilds, MPA
 

Plumber Fun

-API, Plumber, Workflow

Troubleshooting API End Points

2024-05-18
Kevin Gilds, MPA, Kevn Gilds, MPA
 

Purpose of this data?

-Data Management

Data Request Forms

2024-03-30
Kevin Gilds, MPA, Kevn Gilds, MPA
 

Hotel Internet

-Hack

Work around for captive web portals

2024-03-17
Kevin Gilds, MPA, Kevn Gilds, MPA
 

Calendar & To Do List

-Sanity

A Blog Post Pairing Calendar & To Do List

2024-03-02
Kevin Gilds, MPA, Kevn Gilds, MPA
 

Quality Control

-Quality, Checklists

Post about Quality Control

2024-02-25
Kevin Gilds, MPA, Kevn Gilds, MPA
 

Mermaid Diagrams

-Process Documentation

Playing with Mermaid Diagrams

2024-02-12
Kevin Gilds, MPA, Kevn Gilds, MPA

Text Analysis

-Text Analysis
How often do you formally analyze all the comments you receive. Below I will show you some ways to process text data for additional analysis.
2024-01-07
Kevin Gilds, MPA, Kevn Gilds, MPA
 

Weather and RSS on the Command Line

-CLI

Fun at the command line

2024-01-07
Kevin Gilds, MPA, Kevn Gilds, MPA
 

Top_frac Inverse

-Chat-GPT, DPLYR

Getting to the bottom half

2023-12-30
Kevin Gilds, MPA, Kevn Gilds, MPA
 

Pivot Longer

-dplyr, -ChatGPT, -Google Colab

Iterating Pivot Longer with ChatGPT

2023-11-22
Kevin Gilds, MPA, Kevn Gilds, MPA
 

All about the YAML

-YAML

Quartro Sites

2023-11-21
Kevin Gilds, MPA, Kevn Gilds, MPA

Synthetic data

-Stats

Simulation

2023-11-04
Kevin Gilds, MPA, Kevn Gilds, MPA
 

TODOs

-TODO

Did I find it?

2023-09-07
Kevin Gilds, MPA, Kevn Gilds, MPA
 

More Google Colab

Google Colab

Using R with Google Colab

2023-07-20
Kevin Gilds, MPA, Kevn Gilds, MPA
 

Style for Gmail

-Google App Script -Chat GPT

The sage of styling an html table for Gmail

2023-07-17
Kevin Gilds, MPA, Kevn Gilds, MPA
 

Colab

-Google Drive

Use Python or R with Google Drive

2023-07-04
Kevin Gilds, MPA, Kevn Gilds, MPA
 

Today I learned

-Google Sheets

No Query for you with xls

2023-06-23
Kevin Gilds, MPA, Kevn Gilds, MPA
 

UNPIVOT

-ChatGPT -GoogleSheets

UNPIVOT IN GOOGLE SHEETS

2023-06-22
Kevin Gilds, MPA, Kevn Gilds, MPA
 

Web Stuff

-Quartro

Adding a footer to blog posts

2023-06-03
Kevin Gilds, MPA, Kevn Gilds, MPA
 

Branches

-Git -Shiny -Usethis

Why we branch

2023-05-29
Kevin Gilds, MPA, Kevn Gilds, MPA
 

Glue

-Glue

Glue

2023-05-29
Kevin Gilds, MPA, Kevn Gilds, MPA
 

Mutating for Good

-Google Sheets

Create Extra Data to make it work

2023-05-29
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

2023-05-28
Kevin Gilds, MPA, Kevn Gilds, MPA
 

The Img Tag

-html -img -freecodecamp

The img tag

2023-05-25
Kevin Gilds, MPA, Kevn Gilds, MPA
 

i, Robot

Books
Chat GPT

More than Science Fiction

2023-05-12
Kevin Gilds, MPA, Kevn Gilds, MPA
 

Impact of AI

Chat GPT

Good reminders

2023-05-08
Kevin Gilds, MPA, Kevn Gilds, MPA
 

Chat GPT

Chat GPT

Html tables

2023-05-05
Kevin Gilds, MPA, Kevn Gilds, MPA
 

Data Dictionary

Artilce on Pointblank Package

2023-04-28
Kevin Gilds, MPA, Kevn Gilds, MPA
 

Interactive Documents

Sketching out ideas

2023-04-05
Kevin Gilds, MPA, Kevn Gilds, MPA
 

What to write

Getting the grove back

2023-04-03
Kevin Gilds, MPA, Kevn Gilds, MPA
 

Email on edit

This video gave me an idea

2023-02-21
Kevin Gilds, MPA, Kevn Gilds, MPA
 

Checklists

Love and Hate them

2023-02-20
Kevin Gilds, MPA, Kevn Gilds, MPA
 

One down

Finished the Learn HTML Section

2023-02-19
Kevin Gilds, MPA, Kevn Gilds, MPA
 

Goals

Inputs and Outpus

2023-02-18
Kevin Gilds, MPA
 

R & Linux

Rember this post

2023-01-15
Kevin Gilds, MPA, Kevn Gilds, MPA
 

Wilcox-signed-rank-test

A good article on this topic

2023-01-10
Kevin Gilds, MPA, Kevn Gilds, MPA
 

This week I learned

Pancakes

2023-01-03
Kevin Gilds, MPA, Kevn Gilds, MPA
 

Today I learned

Making dates more difficult

2023-01-02
Kevin Gilds, MPA, Kevn Gilds, MPA
 

Streaks

Begin again

2023-01-01
Kevin Gilds, MPA, Kevn Gilds, MPA
 

Today I learned

A script to filter multiple values

2022-12-29
Kevin Gilds, MPA, Kevn Gilds, MPA
 

Data Types

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

2022-12-16
Kevin Gilds, MPA, Kevn Gilds, MPA
 

Lazy & Automation

Thanksgiving weekend

2022-11-26
Kevin Gilds, MPA, Kevn Gilds, MPA
 

App Script

Google Sheets

2022-11-23
Kevin Gilds, MPA, Kevn Gilds, MPA
 

Codebooks and More

Codebooks

2022-11-16
Kevin Gilds, MPA, Kevn Gilds, MPA
 

Likert Scales

The saga

2022-11-15
Kevin Gilds, MPA, Kevn Gilds, MPA
 

Reprex

Reprex and other items I learned today

2022-11-12
Kevin Gilds, MPA, Kevn Gilds, MPA
 

Import Packages

Be nice

2022-11-11
Kevin Gilds, MPA, Kevn Gilds, MPA
 

Make terrible gadgets

To make good gadgets you have to make some stinkers

2022-11-10
Kevin Gilds, MPA, Kevn Gilds, MPA
 

playing

Playing with addins

2022-11-10
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…
2022-11-07
Kevin Gilds, MPA
 

joins

Here is the basic form of a join.
2022-10-23
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…
2022-10-21
Kevin Gilds, MPA
 

addins

I downloaded the remedy package today.
2022-10-12
Kevin Gilds, MPA
 

sql cert

I have enjoyed taking the courses from this learning track.https://www.freecodecamp.org/learn/relational-database/
2022-09-27
Kevin Gilds, MPA
 

bash

Using a bash script with Postgres database.
2022-09-25
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.
2022-09-23
Kevin Gilds, MPA
 

SQL Form

ALTER TABLE <table_name> ADD COLUMN <column_name> <DATA_TYPE> <CONSTRAINTS>;
2022-09-23
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.
2022-01-09
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!
2022-01-08
Kevin Gilds, MPA, Kevin
 

commit to the static

R
Note to self
2022-01-07
Kevin Gilds, MPA, Kevin
 

Column Names

R
Designed Data Management 🧐
2022-01-05
Kevin Gilds, MPA, Kevin
 

A README Tale

R
This tweet led me in many directions.
2022-01-04
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.
2022-01-03
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…
2022-01-02
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.
2022-01-01
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…
2021-12-30
Kevin Gilds, MPA, Kevin
 

Submodules

Shiny
R
Don’t forget the ns!
2021-12-29
Kevin Gilds, MPA, Kevin
 

Shiny Proxy Fun

R
This article got me thinking about other hosting possibilities such as html files and bookdown reports.
2021-12-28
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.
2021-12-27
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…
2021-12-23
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.
2021-12-22
Kevin Gilds, MPA, Kevin
 

Maps!

R
Here is a tutorial on using the mapview package. I hope I get to use it soon.
2021-12-21
Kevin Gilds, MPA, Kevin
 

Back to Gitlab

Full stop, I prefer Gitlab!
2021-12-20
Kevin Gilds, MPA, Kevin
 

TIL

R
I wrote some functions and scripts had to complete troubleshooting to make them work
2021-12-19
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…
2021-12-18
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 =…
2021-12-17
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…
2021-12-14
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…
2021-12-11
Kevin Gilds, MPA, Kevin
 

Linux-Twitter

Linux
2021-12-08
Kevin Gilds, MPA, Kevin
 

2021-12-Eval-Twitter-Threads

Evaluation
2021-12-08
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.
2021-11-15
Kevin Gilds, MPA, Kevin
 

Issue-Templates

R
Can I make an issue template in Gitlab!
2021-11-01
Kevin Gilds, MPA, Kevin
 

File-Paths

R
Not that file paths come up in polite conversations.
2021-10-30
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
2021-10-24
Kevin Gilds, MPA, kevin
 

Domain Expertise

R
It is very cool when someone articulates a sense you have brewing beneath the surface.
2021-10-04
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…
2021-09-24
Kevin Gilds, MPA, Kevin
 

Shaking up Mental Models

R
Once you see it; you can’t unsee it.🤔
2021-09-14
Kevin Gilds, MPA, Kevin
 

Lessons

R
There were warnings!🤕
2021-08-31
Kevin Gilds, MPA, Kevin
 

Where are my keys

R
Today, I had to relearn how to reset a git remote.
2021-07-23
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…
2021-06-16
Kevin Gilds, MPA, Kevin
 

Across

R
I made that more difficult than it had to be.
2021-06-13
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…
2019-03-27
Kevin Gilds, MPA, Kevin

Maps

R
My issue list includes a task to map the Fl Absences data set.
2018-05-09
Kevin Gilds, MPA, kevin
No matching items