Jeremy Allen
@jeremy-data.bsky.social
5.1K followers
4.3K following
1.1K posts
I help @posit.co deliver the best R and Python data science solutions to the public sector in the US and elsewhere. Fan of cats coffee whiskey tea photography philosophy Atlanta - personal account. https://18chains.com/
Posts
Media
Videos
Starter Packs
Reposted by Jeremy Allen
![bee <- function(max_vowels = 2) {
vowels <- c("a", "e", "i", "o", "u")
seven <- sample(letters, 7, replace = FALSE)
num_vowels <- length(intersect(seven, vowels))
while (num_vowels == 0 || num_vowels > max_vowels) {
seven <- sample(letters, 7, replace = FALSE)
num_vowels <- length(intersect(seven, vowels))
}
pattern <- "\n\n %s\n%s %s\n %s\n%s %s\n %s\n\n"
cat(sprintf(pattern, seven[1], seven[2], seven[3], seven[4],
seven[5], seven[6], seven[7]))
}
bee()](https://cdn.bsky.app/img/feed_thumbnail/plain/did:plc:yktvw5fpe6j4rqy4vio7l3w3/bafkreihwvf2iiecuqqdkmmknvuh3dgvhb3ibcukqatubvjwstegyug3l54@jpeg)
![⏺ Task(Analyze case name patterns)
⎿ Done (15 tool uses · 48.9k tokens · 12m 58s)
⏺ I've completed a comprehensive analysis of case names across all three CSV files (8,707 total cases). Here's what I found:
Key Findings
151 unique issues identified across these categories:
Major Issues:
1. United States typos (22 cases): "United State", "United Staes", "United Sates", "United Statse", etc.
2. State name typos (55 cases): Virgina, Tennesse, Georiga, Conneticut, Illnois, Minneosta, Pennsylvannia, etc.
3. Concatenated "of[State]" (16 cases): "ofMassachusetts", "ofVirginia", "ofPennsylvania"
4. "American" instead of "America" (4 cases): "United States of American"
5. "vs" instead of "v." (13 cases): Mostly Oregon and North Carolina
6. Whitespace issues (23 cases): Leading/trailing spaces
7. Multiple consecutive spaces (4 cases)
8. Placeholder values (13 cases): "Unknown", "Data not available", "W"
Your Current Code Coverage:
✅ Already handles: Some "United States" typos, "Ofmassachusetts", Tennessee variations❌ Missing: Most state typos,
whitespace issues, "vs" patterns, "United States of American", placeholders
I've provided a complete updated cleaning code block that fixes all 151 issues. The code is ordered properly (whitespace →
concatenation → spelling → separators → standardization) and includes all the fixes your current code has plus the new ones
needed for the two additional datasets.](https://cdn.bsky.app/img/feed_thumbnail/plain/did:plc:yktvw5fpe6j4rqy4vio7l3w3/bafkreidct4memo7q2ntv3bjifokuzyyhkuawna4nv7ockcmn7mfmykeuzu@jpeg)
