luisDVA’s gists

luisDVA / common-issues-10_aoe-demo.R

Last active January 12, 2021 22:37

Putting everything together

	## %######################################################%##
	# #
	#### Putting everything together ####
	#### Chained data cleaning demonstration ####
	# #
	## %######################################################%##


	# Load the raw Age of Empires units dataset from csv (aoe_raw.csv)
	# Identify and fix common issues that make these data unusable

luisDVA / common-issues-09_parsing-numbers.R

Last active January 12, 2021 22:37

Parsing numbers

	## %######################################################%##
	# #
	#### Parsing numbers - your turn ####
	# #
	## %######################################################%##

	# Import the Marine Protected Areas dataset (MPAS-mine.csv)
	# Subset to keep only the MPA names and columns with extent data
	# Make the columns that hold the MPA extent into usable numeric variables
	# Watch out for decimals

luisDVA / common-issues-08_empty-rows-columns.R

Last active January 12, 2021 22:38

Empty rows and colums

	## %######################################################%##
	# #
	#### Empty rows and columns - your turn ####
	# #
	## %######################################################%##


	# Import the Marine Protected Areas dataset (MPAS-your.csv)
	# Identify the empty rows and columns, and create a new object with only the empty rows and columns
	# Remove the empty rows and columns

luisDVA / common-issues-07_broken-values.R

Last active January 12, 2021 22:38

Broken values

	## %######################################################%##
	# #
	#### Broken values - your turn ####
	# #
	## %######################################################%##

	# Load the raw Age of Empires units dataset from csv (aoe_raw.csv)
	# Identify the broken values in both the 'Type' and 'Name' columns and unbreak them
	# Clean up any separator-related issues arising from the 'unbreaking'

luisDVA / common-issues-06_duplicates.R

Created November 26, 2020 01:08

Duplicates

	## %######################################################%##
	# #
	#### Duplicates - your turn ####
	# #
	## %######################################################%##

	# Load the messy Age of Empires units dataset bundled with `unheadr` (AOEunits_raw)
	# Keep only units of Type "Cavalry"
	# Identify duplicated records across all variables
	# Remove duplicated records across all variables

luisDVA / common-issues-05_compound-values.R

Last active January 27, 2021 22:33

Compound values

	## %######################################################%##
	# #
	#### Compound values - your turn ####
	# #
	## %######################################################%##

	# Import the Marine Protected Areas dataset (MPAS-your.csv)
	# Separate the country codes variable (ISO3 and UN scheme)
	# Unnest the Reference variable
	# > Keep an eye on the separators

luisDVA / common-issues-04_emb-subheaders.R

Created November 25, 2020 20:10

Missing, implicit, or misplaced grouping variables

	## %######################################################%##
	# #
	#### Missing, implicit, or misplaced ####
	#### grouping variables - your turn ####
	# #
	## %######################################################%##

	# Load the `primates2017` dataset bundled with 📦 `unheadr`
	# Create a new column that groups the different species by taxonomic family.
	# In biology, taxonomic families all end in the suffix "_DAE_"

luisDVA / common-issues-03_lettercase.R

Last active June 28, 2021 19:57

Letter case

	## %######################################################%##
	# #
	#### Letter case - your turn ####
	# #
	## %######################################################%##


	# Import the Marine Protected Areas dataset (MPAS-your.csv)
	# Summarize the number of Marine Protected Areas by country (Country full).

luisDVA / common-issues-02_whitespace.R

Last active January 12, 2021 22:40

Whitespace

	## %######################################################%##
	# #
	#### Whitespace - your turn ####
	# #
	## %######################################################%##

	# - Import the Marine Protected Areas data (MPAS-your.csv) from the previous lesson
	# - check the Country variable for leading or trailing whitespace
	# - Remove it if necessary.

luisDVA / common-issues-01_unusable-headers.R

Last active January 12, 2021 22:41

Unusable headers

	## %######################################################%##
	# #
	#### Unusable variable names - your turn ####
	# #
	## %######################################################%##

	# - Import the Marine Protected Areas data (MPAS-your.csv)
	# - Make the variable names usable by placing all header fragments in a single
	# header row
	# - Clean the names for consistency

Luis Verde Arregoitia luisDVA