Instantly share code, notes, and snippets.

@aborruso Andrea Borruso aborruso

@aborruso aborruso / 00xlsTask.md
Last active Oct 17, 2018
Estrarre da tutti i fogli di un file XLS le stesse colonne e righe e produrre un file di output
View 00xlsTask.md 
pyexcel transcode input.xls out_.csv
for i in out_*.csv;do mlr --csv put '$foglio = "'"$i"'"' then cut -f "campoUno,campoTre,foglio" then filter '(NR == 3 || NR == 7)' "$i" >tmp_"$i"; done
mlr  --csv cat tmp_* >./output.csv
  • con pyexcel trasformo tutti i fogli in file CSV;
  • poi con miller estraggo soltanto le celle dei campi campoUno e campoTre di riga 3 e 7. Aggiungo pure una colonna con il nome del foglio;
  • e infine creo con miller un unico file di output.
@aborruso aborruso / gist:610d7e08a6ae02ef4f6c5f3306b57c8e
Created Oct 16, 2018
rapQueryOutput.html
View gist:610d7e08a6ae02ef4f6c5f3306b57c8e
<html>
<head>
<meta name="generator" content="HTML Tidy for HTML5 for Linux version 5.2.0">
<title>
</title>
</head>
<body>
<div style="border:1px solid #990000;padding-left:20px;margin:0 0 10px 0;">
<h4>
A PHP Error was encountered
@aborruso aborruso / gist:4f395483929c7c6c2547bdf226ef34fd
Last active Oct 15, 2018
pubblicazioniDettagli.csv
View gist:4f395483929c7c6c2547bdf226ef34fd
BENEFICIARIO;DATI_FISCALI;IMPORTO;NORMA;UFFICIO;RESPONSABILE;INDIVIDUAZIONE;DOCUMENTI;DATA;NUMPROVVEDIMENTO;FOLDER;DATA_PUBBLICAZIONE;ID;anno
"1° CIRCOLO DIDATTICO ""N SPEDALIERI""";80013070877;€ 931,18;Art. 6 L.R. 09/08/1988 n°15;Servizio 8 Scuole Statali;Picone Giuseppa;ripartizione per funzione delegata;allegati_vari_2156.zip;28/05/2018;2156;dip_istr_form;29/05/2018;1008686;2018
"1° CIRCOLO DIDATTICO ""N SPEDALIERI""";80013070877;€ 14.925,00;Art. 7 L.R. 24/02/2000 n 6;Servizio 8 Scuole Statali;Picone Giuseppa;ripartizione per funzione delegata;allegato_vari_4821.zip;28/09/2018;4821;dip_istr_form;28/09/2018;1012405;2018
@aborruso aborruso / gist:15c629c8d814c8bb7ae434d509a189f5
Last active Oct 15, 2018
pubblicazioni.csv
View gist:15c629c8d814c8bb7ae434d509a189f5
BENEFICIARIO;IMPORTO_CORRISPOSTO;NUM_PROVVEDIMENTI
"1° CIRCOLO DIDATTICO "N SPEDALIERI"";15.856,00;2
"1° IC " V VENETO "";22.412,00;2
"1° IC "G M COLUMBA"";26.112,00;2
@aborruso aborruso / README.md
Last active Oct 3, 2018
View README.md
@aborruso aborruso / 00README.md
Last active Oct 7, 2018
Un albero di tweet su licenze per dati aperti e piattaforme come Wikidata, Wikipedia e OpenStreetMap https://hackmd.io/s/SkKq6eaFX
View 00README.md 
statusid,user,id
1044561432141058050,synapta,01
1045273277256671232,GiorgiaLodi,02
1046660399108689920,openantani,03
@aborruso aborruso / bo.geojson
Created Jul 10, 2018
View bo.geojson
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@aborruso aborruso / index.html
Created Jul 4, 2018
View index.html
<!DOCTYPE html>
<html>
<head>
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="ie=edge">
<meta http-equiv="Content-type" content="text/html;charset=UTF-8">
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/katex@0.10.0-alpha/dist/katex.min.css" integrity="sha384-BTL0nVi8DnMrNdMQZG1Ww6yasK9ZGnUxL1ZWukXQ7fygA1py52yPp9W4wrR00VML" crossorigin="anonymous">
<style>
/*--------------------------------------------------------------------------------------------- * Copyright (c) Microsoft Corporation. All rights reserved. * Licensed under the MIT License. See License.txt in the project root for license information. *--------------------------------------------------------------------------------------------*/ body { font-family: "Segoe WPC", "Segoe UI", "SFUIText-Light", "HelveticaNeue-Light", sans-serif, "Droid Sans Fallback"; font-size: 14px; padding: 0 26px; line-height: 22px; word-wrap: break-word; } #code-csp
@aborruso aborruso / index.html
Created Jul 4, 2018
View index.html
<!DOCTYPE html>
<html>
<head>
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="ie=edge">
<meta http-equiv="Content-type" content="text/html;charset=UTF-8">
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/katex@0.10.0-alpha/dist/katex.min.css" integrity="sha384-BTL0nVi8DnMrNdMQZG1Ww6yasK9ZGnUxL1ZWukXQ7fygA1py52yPp9W4wrR00VML" crossorigin="anonymous">
<style>
/*--------------------------------------------------------------------------------------------- * Copyright (c) Microsoft Corporation. All rights reserved. * Licensed under the MIT License. See License.txt in the project root for license information. *--------------------------------------------------------------------------------------------*/ body { font-family: "Segoe WPC", "Segoe UI", "SFUIText-Light", "HelveticaNeue-Light", sans-serif, "Droid Sans Fallback"; font-size: 14px; padding: 0 26px; line-height: 22px; word-wrap: break-word; } #code-csp
@aborruso aborruso / index.html
Created Jul 4, 2018
View index.html
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-type" content="text/html;charset=UTF-8">
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/katex@0.10.0-alpha/dist/katex.min.css" integrity="sha384-BTL0nVi8DnMrNdMQZG1Ww6yasK9ZGnUxL1ZWukXQ7fygA1py52yPp9W4wrR00VML" crossorigin="anonymous">
<style>
/*--------------------------------------------------------------------------------------------- * Copyright (c) Microsoft Corporation. All rights reserved. * Licensed under the MIT License. See License.txt in the project root for license information. *--------------------------------------------------------------------------------------------*/ body { font-family: "Segoe WPC", "Segoe UI", "SFUIText-Light", "HelveticaNeue-Light", sans-serif, "Droid Sans Fallback"; font-size: 14px; padding: 0 26px; line-height: 22px; word-wrap: break-word; } #code-csp-warning { position: fixed; top: 0; right: 0; color: white; margin: 16px; text-align: center; font-size: 12px; font-family: sa