From eb16cb6d4d1335c0764c0b59fd1a4ca1f78558e4 Mon Sep 17 00:00:00 2001
From: Mischa POSLAWSKY <perl@shiar.org>
Date: Fri, 6 Sep 2019 23:26:39 +0200
Subject: [PATCH] examples with csv, xml, and json data

Practical usage with most common file types.
---
 graph | 17 +++++++++++++++++
 1 file changed, 17 insertions(+)

diff --git a/graph b/graph
index 0e07a6e..373bbfd 100755
--- a/graph
+++ b/graph
@@ -237,6 +237,23 @@ Any kind of database query with leading counts:
     echo 'SELECT count(*),schemaname FROM pg_tables GROUP BY 2' |
     psql -t | graph -u
 
+Exchange rate USD/EUR history from CSV download provided by ECB:
+
+    curl https://sdw.ecb.europa.eu/export.do \
+         -Gd 'node=SEARCHRESULTS&q=EXR.D.USD.EUR.SP00.A&exportType=csv' |
+    awk -F, '{RS="\r\n"} /^[12]/{print $2,$1}' | graph
+
+Total population history from the World Bank dataset (XML):
+
+    curl http://api.worldbank.org/v2/country/1W/indicator/SP.POP.TOTL |
+    xmllint --xpath '//*[local-name()="date" or local-name()="value"]' - |
+    awk -F'<[^>]+>' 'BEGIN {RS="</wb:value>"} {print $4,$2}' | graph
+
+Movies per year from prepared JSON data:
+
+    curl https://github.com/prust/wikipedia-movie-data/raw/master/movies.json |
+    jq '.[].year' | uniq -c | graph
+
 Git statistics, such commit count by year:
 
     git log --pretty=%ci | cut -b-4 | uniq -c | graph
-- 
2.30.0