Skip to content

Instantly share code, notes, and snippets.

@l0gicpath

l0gicpath/all_users.csv

Last active November 11, 2017 13:59
Show Gist options
  • Save l0gicpath/9185572 to your computer and use it in GitHub Desktop.
Save l0gicpath/9185572 to your computer and use it in GitHub Desktop.
Download ZIP
Subtract data of one CSV file from another using fast grep. Dummy data generated by http://dummydata.me/
Raw
all_users.csv
[email protected] Stefanie House
[email protected] Dinah Erickson
[email protected] Melisa Reynolds
[email protected] Lily Carson
[email protected] Millard Rubio
[email protected] Octavia Santana
[email protected] Royal Bender
[email protected] Laverne Hutchins
[email protected] Sherman Wilder
[email protected] Thelma Burris
[email protected] Wilma Rosado
[email protected] Benito Fowler
[email protected] Harrison Hernandez
[email protected] Janette Benson
[email protected] Judi Palmer
[email protected] Angelo Compton
[email protected] Wilbur Coffey
[email protected] Salvatore Coleman
[email protected] Bradley Maldonado
[email protected] Abel Rasmussen
Raw
bad_users.csv
[email protected] Thelma Burris
[email protected] Wilma Rosado
[email protected] Benito Fowler
[email protected] Harrison Hernandez
[email protected] Janette Benson
[email protected] Judi Palmer
Raw
terminal
grep -Fvf bad_users.csv all_users.csv > users_final.csv
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment