• Home
• io.nosqlbench
• virtdata-realdata
• 4.15.87
• source code
• prep_surnames.sh

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

data..prep_census.prep_surnames.sh Maven / Gradle / Ivy

#!/bin/bash
curl -O https://www2.census.gov/topics/genealogy/2010surnames/names.zip
unzip names.zip
xsv select 'name,rank,count,prop100k,cum_prop100k' Names_2010Census.csv > surnames.csv
perl -pi -e 'if (/^(.+?),(.+)$/) { $_=uc(substr($1,0,1)).lc(substr($1,1)).",".$2."\n"; }' surnames.csv
perl -pi -e 'if (/All other names/) { $_=""; }' surnames.csv
#zip -9 surnames.csv.zip surnames.csv
rm Names_2010Census.xlsx
rm Names_2010Census.csv
rm names.zip
mv surnames.csv ../surnames.csv