Skip to content

Instantly share code, notes, and snippets.

@swann44

swann44/index.txt

Last active March 8, 2020 09:44
Show Gist options
  • Save swann44/3974b1b154b4738d9f47728b3ae9d208 to your computer and use it in GitHub Desktop.
Save swann44/3974b1b154b4738d9f47728b3ae9d208 to your computer and use it in GitHub Desktop.
Download ZIP
linux 3
Raw
index.txt
wilder@wilder-ThinkPad-T440p:~/Documents$ history | tail -20
484 grep PHP wilders.csv > PHP.csv
485 grep 2019 PHP.csv > 2019.csv
486 grep France 2019.csv > php_france_2019.csv
487 grep JavaScript wilders.csv > Javascript.csv
488 grep Toulouse Javascript.csv
489 grep Toulouse Javascript.csv > toulouse.csv
490 rm -r toulouse.csv
491 grep Toulouse Javascript.csv > javascript_biarritz_toulouse.csv
492 rm -r javascript_biarritz_toulouse.csv
493 grep Biarritz Javascript.csv >javascript_biarritz_toulouse.csv
494 grep Toulouse Javascript.csv >javascript_biarritz_toulouse.csv
495 rm -r javascript_biarritz_toulouse.csv
496 grep Toulouse Javascript.csv > Toulouse.csv
497 grep Biarritz Javascript.csv > Biarritz.csv
498 cat Biarritz.csv Toulouse.csv | sort -u
499 cat Biarritz.csv Toulouse.csv | sort -u > javascript_biarritz_toulouse.csv
Raw
javascript_biarritz_toulouse.csv
We can make this file beautiful and searchable if this error is corrected: It looks like row 2 should actually have 1 column, instead of 6 in line 1.
cat Biarritz.csv Toulouse.csv | sort -u
Agathe,Bazin,Toulouse,France,2017,JavaScript
Alexandre,"Da Silva",Toulouse,France,2019,JavaScript
Alfred,"Da Silva",Biarritz,France,2018,JavaScript
Alphonse,Leleu,Biarritz,France,2019,JavaScript
Andrée,Berthelot,Biarritz,France,2019,JavaScript
Arthur,Bruneau,Biarritz,France,2018,JavaScript
Aurélie,Becker,Toulouse,France,2018,JavaScript
Benjamin,Tanguy,Biarritz,France,2018,JavaScript
Céline,Fabre,Toulouse,France,2019,JavaScript
Chantal,Caron,Biarritz,France,2017,JavaScript
Charlotte,Roche,Biarritz,France,2018,JavaScript
Christelle,Vallet,Biarritz,France,2017,JavaScript
Claude,Samson,Toulouse,France,2019,JavaScript
Colette,Bouvier,Biarritz,France,2018,JavaScript
Danielle,Lecomte,Toulouse,France,2019,JavaScript
Danielle,Perrin,Toulouse,France,2019,JavaScript
Daniel,Roy,Biarritz,France,2017,JavaScript
Édith,Turpin,Biarritz,France,2017,JavaScript
Emmanuelle,Mercier,Biarritz,France,2017,JavaScript
Éric,Meunier,Toulouse,France,2019,JavaScript
Henri,Guilbert,Toulouse,France,2018,JavaScript
Laetitia,Schneider,Biarritz,France,2019,JavaScript
Laurence,Lemaire,Biarritz,France,2019,JavaScript
Léon,Jacquet,Biarritz,France,2019,JavaScript
Marcel,Olivier,Biarritz,France,2019,JavaScript
Maryse,Allain,Toulouse,France,2018,JavaScript
Mathilde,Descamps,Toulouse,France,2019,JavaScript
Maurice,Munoz,Toulouse,France,2017,JavaScript
Michel,David,Biarritz,France,2019,JavaScript
Michèle,Traore,Toulouse,France,2017,JavaScript
Noël,Noel,Toulouse,France,2019,JavaScript
Olivier,Dufour,Toulouse,France,2018,JavaScript
Pénélope,Paris,Biarritz,France,2017,JavaScript
Philippe,Paris,Toulouse,France,2018,JavaScript
Raymond,Bouvet,Toulouse,France,2019,JavaScript
Sébastien,Ferreira,Biarritz,France,2018,JavaScript
Théodore,Bousquet,Biarritz,France,2019,JavaScript
Théodore,Gerard,Toulouse,France,2018,JavaScript
Théodore,Regnier,Biarritz,France,2018,JavaScript
Thérèse,Guyot,Biarritz,France,2019,JavaScript
Thierry,Alexandre,Biarritz,France,2017,JavaScript
Timothée,Henry,Toulouse,France,2018,JavaScript
Victor,Lopez,Biarritz,France,2019,JavaScript
Vincent,Sanchez,Biarritz,France,2019,JavaScript
Yves,Marie,Biarritz,France,2019,JavaScript
Raw
php_france_2019.csv
We can make this file beautiful and searchable if this error is corrected: No commas found in this CSV file in line 0.
wc -l php_france_2019.csv
97
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment