[Tex/LaTex] Pgfplots plotting data from a csv file

csvpgfplotstikz-pgf

I'm trying to create a diagram with three x-axes at the bottom. I found a code which creates 3 axes but when I try to plot the data from a csv file I get an error stating:

! Package pgfkeys Error: I do not know the key '/tikz/col sep', to which you passed 'comma', and I am going to ignore it. Perhaps you misspelled it.

I have no problem plotting csv files in other settings but somehow I can't get this to work. What am I doing wrong?
Here is the file:
test.csv

Here is my code:

\begin{document}
\usepackage{pgfplots}

    \begin{tikzpicture}
        \pgfplotsset{    
        every axis x label/.style={
        at={(ticklabel* cs:1.05)},
        yshift = -7.5pt,
        anchor=west,},
        width=14cm,
        height=7cm,
        every axis y label/.style={at={(current axis.above origin)},
        anchor=north east,
        yshift = 1cm,} }
        \begin{axis}[
        scaled y ticks = false,
          y tick label style={/pgf/number format/fixed,
          /pgf/number format/1000 sep = \thinspace},
          xmin=0,xmax=3,
          xlabel={$Re$},
          ylabel={$\delta ~\text{[mm]}$},
          ymin=0, ymax=2,
          ymajorgrids=true, xmajorgrids=true,
          axis y line*=left, axis x line*=bottom]
          \addplot[color=red,smooth,thick, col sep=comma] {test.csv};
        \end{axis}
        \begin{axis}[
            xmin=0,xmax=70,%--- CF,
            hide y axis,
             axis x line*=none,
            ymin=0, ymax=2,
            xlabel={$\dot{V} ~[\text{L} / \text{h}]$},
            x label style={yshift=-0.8cm},
            x tick label style={yshift=-0.8cm}
            ]
        \addplot[color=blue,smooth,thick] coordinates { 
                  (2.28,1.09068)
            (1.67,0.97372)
            (1.11,0.832298376)
            (0.55,0.634618222)
            (0.27,0.46422) };
        \end{axis} 
          \begin{axis}[
            xmin=0,xmax=35,
            hide y axis,
            axis x line*=none,
            ymin=0, ymax=2,
            xlabel={$\dot{V}/A ~[\text{m}^3 / \text{h} \text{m}^2]$},
            x label style={yshift=-1.6cm},
            x tick label style={yshift=-1.6cm}
            ]
        \addplot[color=black,thick] coordinates { 
                  (2.28,1.09068)
            (1.67,0.97372)
            (1.11,0.832298376)
            (0.55,0.634618222)
            (0.27,0.46422) };
        \end{axis}   
    \end{tikzpicture}
\end{document}

Best Answer

This contains an answer to your question, I think, and an MWE. The answer to your question is that you should try

\addplot[color=red,smooth,thick] table[col sep=comma,header=false,x index=0,y index=1] {test.csv};

which works if your test.csv data has a format in which there is a comma separator. This is because col sep=comma is a valid option for a table, but not for a plot. Notice that I also increased xmax for that plot since with your setting the full plot gets clipped away.

To make it an MWE, I

added a document class,
loaded amsmath (since you are using \text),
moved \usepacage{pgfplots} above \begin{document},
added test.csv to the MWE via filecontents to make it easier to test.

I did not change any of the details, also because I do not really now what Re stands for. If it stands for real part, I wouldn't set it in math mode.

\documentclass[tikz,border=3.14mm]{standalone}
\usepackage{filecontents}
\begin{filecontents*}{test.csv}
70.4,1.012015504
52.8,0.919477106
35.2,0.803237238
17.6,0.637529818
8.8,0.506007752
\end{filecontents*}
\usepackage{amsmath}
\usepackage{pgfplots}
\pgfplotsset{compat=1.16}
\begin{document}
\begin{tikzpicture}
    \pgfplotsset{    
    every axis x label/.style={
    at={(ticklabel* cs:1.05)},
    yshift = -7.5pt,
    anchor=west,},
    width=14cm,
    height=7cm,
    every axis y label/.style={at={(current axis.above origin)},
    anchor=north east,
    yshift = 1cm,} }
    \begin{axis}[
    scaled y ticks = false,
      y tick label style={/pgf/number format/fixed,
      /pgf/number format/1000 sep = \thinspace},
      xmin=0,xmax=75,
      xlabel={$Re$},
      ylabel={$\delta ~\text{[mm]}$},
      ymin=0, ymax=2,
      ymajorgrids=true, xmajorgrids=true,
      axis y line*=left, axis x line*=bottom]
      \addplot[color=red,smooth,thick] table[col sep=comma,header=false,
      x index=0,y index=1] {test.csv};
    \end{axis}
    \begin{axis}[
        xmin=0,xmax=70,%--- CF,
        hide y axis,
         axis x line*=none,
        ymin=0, ymax=2,
        xlabel={$\dot{V} ~[\text{L} / \text{h}]$},
        x label style={yshift=-0.8cm},
        x tick label style={yshift=-0.8cm}
        ]
    \addplot[color=blue,smooth,thick] coordinates { 
              (2.28,1.09068)
        (1.67,0.97372)
        (1.11,0.832298376)
        (0.55,0.634618222)
        (0.27,0.46422) };
    \end{axis} 
      \begin{axis}[
        xmin=0,xmax=35,
        hide y axis,
        axis x line*=none,
        ymin=0, ymax=2,
        xlabel={$\dot{V}/A ~[\text{m}^3 / \text{h} \text{m}^2]$},
        x label style={yshift=-1.6cm},
        x tick label style={yshift=-1.6cm}
        ]
    \addplot[color=black,thick] coordinates { 
              (2.28,1.09068)
        (1.67,0.97372)
        (1.11,0.832298376)
        (0.55,0.634618222)
        (0.27,0.46422) };
    \end{axis}   
\end{tikzpicture}
\end{document}

Related Solutions

[Tex/LaTex] How to hide empty (value 0) ybars with pgfplots

You can use

 y filter/.expression={y==0 ? nan : y}

in the options of \addplot.

\documentclass{article}

% ---------------------------------- tikz
\usepackage{pgfplots}          % to print charts
\pgfplotsset{compat=1.12}

\begin{document}

\begin{figure}
  \centering
  \begin{tikzpicture}
    \begin{axis} [
      % general
      ybar,
      scale only axis,
      height=0.5\textwidth,
      width=1.2\textwidth,
      ylabel={\# Dots},
      nodes near coords,
      xlabel={Variation},
      xticklabel style={
        rotate=90,
        anchor=east,
      },
      %enlarge x limits={abs value={3}},
      ]
      \addplot+[y filter/.expression={y==0 ? nan : y}] table [
        x=grade,
        y=value,
      ] {
grade   value
-11 0
-10 0
-9  0
-8  0
-7  0
-6  0
-5  3
-4  1
-3  2
-2  15
-1  11
0   179
1   8
2   1
3   0
4   1
5   2
6   0
7   0
8   0
9   0
10  0
11  0
      };
    \end{axis}
  \end{tikzpicture}
\end{figure}
\end{document}

[Tex/LaTex] pgfplots: percentage in matrix plot

It does not work in your MWE because you are overwriting it by also giving the option nodes near coors to the \addplot command. Remove the latter one (or specify format here), and it will print. I added a thinspace before the percentage sign, although it can also be recommended to load the siunitx package and let that format and typeset the values for you.

Anyway, here's the quickfixed version:

\documentclass[border=3pt]{standalone}
\usepackage{pgfplots}
\pgfplotsset{%
  width=5cm,
  height=18cm,
  compat=1.13,
  colormap={blackwhite}{gray(0cm)=(1); gray(1cm)=(0.5)},
  xticklabels={LPIBG, ALL, HPIBG},
  xtick={0,...,2},
  ytick=\empty
}

\begin{document}
\begin{tikzpicture}
\begin{axis}[%
  enlargelimits=false,
  xlabel style={font=\footnotesize},
  ylabel style={font=\footnotesize},
  legend style={font=\footnotesize},
  xticklabel style={font=\footnotesize},
  yticklabel style={font=\footnotesize},
  colorbar,
  colorbar style={%
    ytick={0,20,40,60,80,100},
    yticklabels={0,20,40,60,80,100},
    yticklabel={\pgfmathprintnumber\tick\,\%},
    yticklabel style={font=\footnotesize}
  },
  point meta min=0,
  point meta max=100,
  nodes near coords={\pgfmathprintnumber\pgfplotspointmeta\,\%},
  every node near coord/.append style={xshift=0pt,yshift=-7pt, black, font=\footnotesize},
]

\addplot[
matrix plot,
mesh/cols=3,
point meta=explicit]
table[meta=C]{
  x y C
  0 0 80
  1 0 36
  2 0 40
  0 1 64
  1 1 80
  2 1 60
  0 2 52
  1 2 84
  2 2 72
  0 3 72
  1 3 28
  2 3 32
  0 4 56
  1 4 84
  2 4 80
  0 5 72
  1 5 52
  2 5 44
  0 6 4
  1 6 84
  2 6 41
  0 7 37
  1 7 69
  2 7 84
  0 8 63
  1 8 53
  2 8 82
  0 9 78
  1 9 74
  2 9 39
  0 10 39
  1 10 63
  2 10 88
  0 11 76
  1 11 74
  2 11 49
  0 12 39
  1 12 6
  2 12 88
  0 13 46
  1 13 33
  2 13 75
  0 14 88
  1 14 67
  2 14 54
  0 15 79
  1 15 83
  2 15 75
  0 16 50
  1 16 46
  2 16 71
  0 17 92
  1 17 71
  2 17 75
  0 18 46
  1 18 33
  2 18 8
};
\end{axis}
\end{tikzpicture}
\end{document}

Best Answer

Related Solutions

[Tex/LaTex] How to hide empty (value 0) ybars with pgfplots

[Tex/LaTex] pgfplots: percentage in matrix plot

Related Question