Skip to content

Instantly share code, notes, and snippets.

@lebowvsky
Last active March 3, 2020 16:10
Show Gist options
  • Save lebowvsky/2e08431b3871eac7ea42873b7ec96b11 to your computer and use it in GitHub Desktop.
Save lebowvsky/2e08431b3871eac7ea42873b7ec96b11 to your computer and use it in GitHub Desktop.
Terminal3
675 grep "France,2019,PHP" wilders.csv | wc -l > php_france_2019.csv
676 cat php_france_2019.csv
677 grep "Biarritz" wilders.csv | grep "JavaScript" > biarritz.csv
678 ls
679 cat biarritz.csv
680 grep "Toulouse" wilders.csv | grep "JavaScript" > toulouse.csv
681 cat toulouse.csv
682 cat biarritz.csv toulouse.csv > javascript_biarritz_toulouse.csv
683 ls
684 cat javascript_biarritz_toulouse.csv
685 history
686 tail -n 17 history > history.txt
687 history | tail -n 20 > history.txt
MBP-de-Brice:terminal3 bricelegallo$
We can make this file beautiful and searchable if this error is corrected: It looks like row 46 should actually have 6 columns, instead of 1. in line 45.
Emmanuelle,Mercier,Biarritz,France,2017,JavaScript
Thierry,Alexandre,Biarritz,France,2017,JavaScript
Édith,Turpin,Biarritz,France,2017,JavaScript
Chantal,Caron,Biarritz,France,2017,JavaScript
Pénélope,Paris,Biarritz,France,2017,JavaScript
Christelle,Vallet,Biarritz,France,2017,JavaScript
Daniel,Roy,Biarritz,France,2017,JavaScript
Théodore,Regnier,Biarritz,France,2018,JavaScript
Benjamin,Tanguy,Biarritz,France,2018,JavaScript
Arthur,Bruneau,Biarritz,France,2018,JavaScript
Sébastien,Ferreira,Biarritz,France,2018,JavaScript
Charlotte,Roche,Biarritz,France,2018,JavaScript
Colette,Bouvier,Biarritz,France,2018,JavaScript
Alfred,"Da Silva",Biarritz,France,2018,JavaScript
Vincent,Sanchez,Biarritz,France,2019,JavaScript
Yves,Marie,Biarritz,France,2019,JavaScript
Alphonse,Leleu,Biarritz,France,2019,JavaScript
Laurence,Lemaire,Biarritz,France,2019,JavaScript
Marcel,Olivier,Biarritz,France,2019,JavaScript
Victor,Lopez,Biarritz,France,2019,JavaScript
Michel,David,Biarritz,France,2019,JavaScript
Théodore,Bousquet,Biarritz,France,2019,JavaScript
Andrée,Berthelot,Biarritz,France,2019,JavaScript
Léon,Jacquet,Biarritz,France,2019,JavaScript
Laetitia,Schneider,Biarritz,France,2019,JavaScript
Thérèse,Guyot,Biarritz,France,2019,JavaScript
Agathe,Bazin,Toulouse,France,2017,JavaScript
Maurice,Munoz,Toulouse,France,2017,JavaScript
Michèle,Traore,Toulouse,France,2017,JavaScript
Aurélie,Becker,Toulouse,France,2018,JavaScript
Timothée,Henry,Toulouse,France,2018,JavaScript
Théodore,Gerard,Toulouse,France,2018,JavaScript
Maryse,Allain,Toulouse,France,2018,JavaScript
Philippe,Paris,Toulouse,France,2018,JavaScript
Henri,Guilbert,Toulouse,France,2018,JavaScript
Olivier,Dufour,Toulouse,France,2018,JavaScript
Alexandre,"Da Silva",Toulouse,France,2019,JavaScript
Mathilde,Descamps,Toulouse,France,2019,JavaScript
Céline,Fabre,Toulouse,France,2019,JavaScript
Raymond,Bouvet,Toulouse,France,2019,JavaScript
Danielle,Lecomte,Toulouse,France,2019,JavaScript
Noël,Noel,Toulouse,France,2019,JavaScript
Danielle,Perrin,Toulouse,France,2019,JavaScript
Éric,Meunier,Toulouse,France,2019,JavaScript
Claude,Samson,Toulouse,France,2019,JavaScript
MBP-de-Brice:terminal3 bricelegallo$
We can make this file beautiful and searchable if this error is corrected: No commas found in this CSV file in line 0.
97
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment