Posts, Publications & More

Additional projects further underscoring my personal interests in data science, public health, and creating functional narratives.

Posts

Ideas and analyses aren't much without effective communication. Below you can find my work as published on Medium for a deeper look into how data often translates into applied storylines.

A Systematic Approach to Bad Data"

Towards Data Science article providing a step by step guide of what to do with architecturally unsound data.

Learn more

A Complete Guide to Database Normalization in SQL"

Towards Data Science article detailing the first three steps of database normalization in PostgreSQL.

Learn more

"Data Cleaning in R Made Simple"

Towards Data Science article outlining best data cleaning practices and how to execute them in R.

Learn more

"Adapting Social Science to a Data-Driven World"

Medium article underscoring the necessity of interdisciplinary methodology within the social sciences.

Learn more

Publications

Scientific writing is an entirely separate yet equally as valuable skillset. Within my time at the UCSF Late Life Depression Program, I have participated in several academic paper pipelines, one of which was recently published in the peer-reviewed Aging and Mental Health journal.

"The relationship of frailty and disability with suicidal ideation in late life depression"

Bickford et al., 2019. Original publication Aging and Mental Health Dec 2019 Issue

Learn more

More

Capitalizing on both data science related coursework and academic research has provided several opportunities to broaden my knowledge of statistics, programming and study design. Below are examples of just that.

"Differential Predictors of Self and Study Partner-Assessed Subjective Cognition in Late Life Depression"

R-based academic project utilizing linear regression analysis results in poster accepted and presented at 2021 American Psychiatric Association Conference.

Learn more

"The Double-Edged Sword of Neurobiological Association: Mental Illness Trends & Implications"

Small, Python-based academic project utilizing principal component analysis to determine underlying mechanisms driving mental illness stigma

Learn more

"Learning: Data Science" Repo

Github repository of programming projects and related materials completed throughout my personally-customized data science training.

Learn more