Reporting mal anders, Markdown sei Dank

Ein Open Source Kochrezept
Ottmar Gobrecht
DOAG Konferenz 2016, Nürnberg

Ein Gruß aus der Küche

Appetithäppchen

Beispieldaten

Einwohnerentwicklung New York, Rio, Tokio
1940 - 2010

Population Development,New York,Rio,Tokio
1940,7454995,1759277,6778804
1950,7891957,2375280,5385071
1960,7781984,3300431,8310027
1970,7895563,4251918,8840942
1980,7071639,5090723,8351893
1990,7322564,5480768,8163573
2000,8008278,5857904,8134688
2010,8175133,6320446,8980768

Zutatenliste

Selber Kochen

Markdown

Vereinfachte Auszeichnungsprache zur HTML Erstellung
Definition: 2004, John Gruber, Aaron Swartz
Ziel: Ohne Konvertierung leicht les- und schreibbar

# Eine Überschrift

Ein kurzer Absatz.

* Ein Aufzählungspunkt
* Noch einer mit *kursivem* und **fettem** Text

Markdown Reporter - Demo Chart

SELECT markdown_reporter.convert_document(
           p_format   => 'pdf' -- html, pdf, docx (with png's only)
         , p_markdown => markdown_reporter.preprocess_data(p_markdown => q'[
``` { .sql .chart .line caption="Demo Chart"}
SELECT 1940 "Population Development", 7454995 "New York", 1759277 "Rio"
     , 6778804 "Tokio"              FROM dual UNION ALL
SELECT 1950,7891957,2375280,5385071 FROM dual UNION ALL
SELECT 1960,7781984,3300431,8310027 FROM dual UNION ALL
SELECT 1970,7895563,4251918,8840942 FROM dual UNION ALL
SELECT 1980,7071639,5090723,8351893 FROM dual UNION ALL
SELECT 1990,7322564,5480768,8163573 FROM dual UNION ALL
SELECT 2000,8008278,5857904,8134688 FROM dual UNION ALL
SELECT 2010,8175133,6320446,8980768 FROM dual;
```
]'))
  FROM dual;

Das Ergebnis dieser Query

Eingangsdaten Pandoc

SELECT markdown_reporter.preprocess_data(p_markdown => '...')
  FROM dual;

``` { .sql .chart .line caption="Demo Chart"}
"Population Development","New York","Rio","Tokio"
"1940","7454995","1759277","6778804"
"1950","7891957","2375280","5385071"
"1960","7781984","3300431","8310027"
"1970","7895563","4251918","8840942"
"1980","7071639","5090723","8351893"
"1990","7322564","5480768","8163573"
"2000","8008278","5857904","8134688"
"2010","8175133","6320446","8980768"
```

Pandoc Filter - Beispiel Line Chart

# read csv data from code block
df = pd.read_csv(StringIO( code ), index_col=0, parse_dates=True)
# create chart
if charttype == 'line':
    ax = df.plot.line(subplots=False, figsize=(width/96, height/96), \
    legend=legend) # size must be given in inches, default is 96 dpi
#---<snip>-----------------------------------------------------------
# set title and axis labels
if title != '':
    ax.set_title(title)
#---<snip>-----------------------------------------------------------
# clean up chart with seaborn despine method
sns.despine()
# save chart
plt.savefig(filename)

Der komplette Filter

Chartentwicklung mit Jupyter

Jupyter Start mit Shellaufruf:

jupyter notebook

Chartentwicklung mit Jupyter

Jupyter-Docs, Das Notizbuch aus dem Markdown Reporter Projekt