[Tex/LaTex] PGFPLOTS: How to merge 2 tables for histogram

pgfplotspgfplotstable

I have a data set that I will plot across two pages. My initial strategy is to split the table in half. Read in the first table and plot, and so with the second. My problem with this is I do a summary histogram and I need the full file, that is now split. How can I merge the tables into 1 table, actually the first column from each? Everything I've seen in the pgfplotstable/pgfplots manuals show adding columns. Can "addplot hist" take multiple tables?

If I have:

\begin{filecontents}{dataA.csv}
Miles,   Bike,    rdate,   desc
12.5,    Yel-11,  {$\stackrel{\hbox{Yel-11}}{\hbox{\tiny 03-30-14}}$},   {12.5 miles:\ Mohawk}
16.5,    Fuji,    {$\stackrel{\hbox{Fuji}}{\hbox{\tiny 04-23-14}}$},     {16.5 miles:\ Snow}
21.0,    8000SHX, {$\stackrel{\hbox{8000SHX}}{\hbox{\tiny 05-18-14}}$},  {21.0 miles:\ Ojibway Road}
24.2,    Yel-11,  {$\stackrel{\hbox{Yel-11}}{\hbox{\tiny 05-24-14}}$},   {24.2 miles:\ Ojibway Road}
23.4,    YFoil,   {$\stackrel{\hbox{YFoil 77}}{\hbox{\tiny 05-29-14}}$}, {23.4 miles:\ Snow}
21.1,    Y-22,    {$\stackrel{\hbox{Y-22}}{\hbox{\tiny 05-30-14}}$},     {21.1 miles:\ Ojibway Road}
\end{filecontents}
\begin{filecontents}{dataB.csv}
Miles,   Bike,    rdate,   desc
23.9,    YFoil,   {$\stackrel{\hbox{YFoil 77}}{\hbox{\tiny 06-01-14}}$}, {23.9 miles:\ Snow}
32.5,    Fuji,    {$\stackrel{\hbox{Fuji}}{\hbox{\tiny 06-05-14}}$},     {32.5 miles:\ Phoenix Church}
23.8,    YFoil,   {$\stackrel{\hbox{YFoil 77}}{\hbox{\tiny 06-17-14}}$}, {23.8 miles:\ Snow}
27.0,    YFoil,   {$\stackrel{\hbox{YFoil 77}}{\hbox{\tiny 06-22-14}}$}, {27.0 miles:\ Snow}
34.0,    Y-22,    {$\stackrel{\hbox{Y-22}}{\hbox{\tiny 06-27-14}}$},     {34.0 miles:\ Central Mine}
20.0,    Fuji,    {$\stackrel{\hbox{Fuji}}{\hbox{\tiny 06-29-14}}$},     {20.0 miles:\ Snow}
\end{filecontents}

Results in:

\begin{filecontents}{merged.dat}
Miles
12.5
16.5
21.0
24.2
23.4
21.1
23.9
32.5
23.8
27.0
34.0
20.0
\end{filecontents}

Any help here is greatly appreciated. Dave.

Best Answer

pgfplotstable comes with a method named \pgfplotstablevertcat which concatenates tables vertically. "Concatenate vertically" means: append rows.

Here is a minimal example which concatenates the tables along with a very minimal visualization:

\documentclass{standalone}

\usepackage{pgfplots}
\pgfplotsset{compat=1.9}

\usepackage{pgfplotstable}

\begin{filecontents}{dataA.csv}
Miles,   Bike,    rdate,   desc
12.5,    Yel-11,  {$\stackrel{\hbox{Yel-11}}{\hbox{\tiny 03-30-14}}$},   {12.5 miles:\ Mohawk}
16.5,    Fuji,    {$\stackrel{\hbox{Fuji}}{\hbox{\tiny 04-23-14}}$},     {16.5 miles:\ Snow}
21.0,    8000SHX, {$\stackrel{\hbox{8000SHX}}{\hbox{\tiny 05-18-14}}$},  {21.0 miles:\ Ojibway Road}
24.2,    Yel-11,  {$\stackrel{\hbox{Yel-11}}{\hbox{\tiny 05-24-14}}$},   {24.2 miles:\ Ojibway Road}
23.4,    YFoil,   {$\stackrel{\hbox{YFoil 77}}{\hbox{\tiny 05-29-14}}$}, {23.4 miles:\ Snow}
21.1,    Y-22,    {$\stackrel{\hbox{Y-22}}{\hbox{\tiny 05-30-14}}$},     {21.1 miles:\ Ojibway Road}
\end{filecontents}
\begin{filecontents}{dataB.csv}
Miles,   Bike,    rdate,   desc
23.9,    YFoil,   {$\stackrel{\hbox{YFoil 77}}{\hbox{\tiny 06-01-14}}$}, {23.9 miles:\ Snow}
32.5,    Fuji,    {$\stackrel{\hbox{Fuji}}{\hbox{\tiny 06-05-14}}$},     {32.5 miles:\ Phoenix Church}
23.8,    YFoil,   {$\stackrel{\hbox{YFoil 77}}{\hbox{\tiny 06-17-14}}$}, {23.8 miles:\ Snow}
27.0,    YFoil,   {$\stackrel{\hbox{YFoil 77}}{\hbox{\tiny 06-22-14}}$}, {27.0 miles:\ Snow}
34.0,    Y-22,    {$\stackrel{\hbox{Y-22}}{\hbox{\tiny 06-27-14}}$},     {34.0 miles:\ Central Mine}
20.0,    Fuji,    {$\stackrel{\hbox{Fuji}}{\hbox{\tiny 06-29-14}}$},     {20.0 miles:\ Snow}
\end{filecontents}

\begin{document}
\pgfplotstableset{col sep=comma}
\pgfplotstablevertcat{\output}{dataA.csv} % loads `dataA.csv' -> `\output'
\pgfplotstablevertcat{\output}{dataB.csv} % appends rows of dataB.csv

\pgfplotstabletypeset[columns=Miles,fixed zerofill]{\output}

\begin{tikzpicture}[baseline]
    \begin{axis}[anchor=center]
    \addplot table[x expr=\coordindex,y index=0] {\output}; 
    \end{axis}
\end{tikzpicture}
\end{document}

enter image description here

Note that [baseline] and anchor=center are merely here for alignment with the table.

Related Solutions

[Tex/LaTex] how to create an histogram with a string label using pgfplots

To use a string as the label for a bar plot, you can use point meta=explicit symbolic and specify which column to use as the label for each plot by setting meta=<column name> in the table options of the plots.

In this case, I would reorganise the data table to group the organisms and hit counts by the overlap:

\documentclass{article}

\usepackage{pgfplots, xstring}

\pgfplotsset{compat=newest}
\usepackage{filecontents}

\begin{filecontents}{dataedited.csv}
overlap,hit1,organism1,hit2,organism2,hit3,organism3
100,274,Unknowns,228,Coccomyxa subellipsoidea,11,Eukaryota
-500,153,Unknowns,145,Coccomyxa subellipsoidea,7,Eukaryota
-1000,118,Unknowns,108,Coccomyxa subellipsoidea,4,cellular organisms
-2000,74,Coccomyxa subellipsoide,72,Unknowns,4,Viridiplantae
-4000,51,Unknowns,42,Coccomyxa subellipsoidea,2,Eukaryota
-8000,26,Coccomyxa subellipsoidea,25,Unknowns,1,Eukaryota
-16000,14,Coccomyxa subellipsoidea,13,Unknowns,1,cellular organisms
\end{filecontents}

\begin{document}
\begin{tikzpicture}
        \pgfplotstableread[col sep=comma]{dataedited.csv}\table
        \centering
        \begin{axis}[
            xbar, bar width=7pt,
            height                = 11cm,
            width                 = 10cm,
            enlarge x limits      = false,
            axis lines*           = left,
            legend style          = {
              at              = {(0.5,-0.2)},
              anchor          = north,
              legend columns  = -1
            },
            xmin = 0,
            ytick                 = data,
            scaled x ticks        = false,
            yticklabels from table= \table{overlap},
            point meta=explicit symbolic,
            nodes near coords={
                \IfStrEq{\pgfplotspointmeta}{Coccomyxa subellipsoidea}{\textcolor{red}{\pgfplotspointmeta}}{\pgfplotspointmeta}
            },
            every node near coord/.append style={anchor=mid west, yshift=-0.5ex, black!75}
        ]
          \addplot [fill=gray] table [col sep=comma, y expr=-\coordindex, x=hit3, meta=organism3] {dataedited.csv};
          \addplot [fill=gray!75] table [col sep=comma, y expr=-\coordindex, x=hit2, meta=organism2] {dataedited.csv};
          \addplot [fill=gray!50] table [col sep=comma, y expr=-\coordindex, x=hit1, meta=organism1] {dataedited.csv};
      \end{axis}
  \end{tikzpicture}
\end{document}

[Tex/LaTex] PGFPLOTS: Drawing a Histogram

Something like this?

Above picture is produced by:

\documentclass[border=3mm,
               tikz,
               preview
               ]{standalone}
\usepackage{pgfplots}

    \begin{document}
%---------------------------------------------------------------%
\begin{tikzpicture}
\begin{axis}[
    ymin=0, ymax=55,
    minor y tick num = 3,
    area style,
    ]
\addplot+[ybar interval,mark=no] plot coordinates { (0, 5) (5, 35) (10, 50) (15, 30) (20, 15) (25, 0) };
\end{axis}
\end{tikzpicture}
    \end{document}

Best Answer

Related Solutions

[Tex/LaTex] how to create an histogram with a string label using pgfplots

[Tex/LaTex] PGFPLOTS: Drawing a Histogram

Related Question