Change \includegraphics to a TikZ \pic in \pgfplotstabletypeset

Question

I would like to change the content of my pgf table column "Image" from using an included graphic to a predefined TikZ \pic based on the information in column "Type". The \pic should be centered horizontally and vertically inside of the table.

Here is my working MWE

\documentclass{article}
\usepackage[a4paper, margin=10mm]{geometry}
\usepackage{pgfplotstable}
\usepackage{mwe}
\pgfplotsset{compat=newest}
\begin{filecontents}{data.csv}
Image,       ID,    Description,  Type,        X-Pos,   Y-Pos,   rotation
powerSupply, A1F5F, PowerSupply1, PowerSupply, 3590,    2000,    270 
powerSupply, 7ZF3I, PowerSupply2, PowerSupply, 3590,    2500,    270
powerSupply, O7PYQ, PowerSupply3, PowerSupply, 4250,    6070,    180
powerSupply, A7HAZ, Switch1,      singleSwitch,5700,    6070,    180
\end{filecontents}
\pgfplotstableread[col sep=comma]{data.csv}{\csvdata}
\pgfplotstablegetrowsof{\csvdata}
\pgfmathtruncatemacro\CSVDataRows{\pgfplotsretval-1}
\begin{document}
\begin{center}
\pgfplotstabletypeset[%
font=\ttfamily,%
col sep=comma,%
columns={Image, ID, Description, Type, X-Pos, Y-Pos},%
columns/Image/.style={%
column name=Image,%
assign cell content/.code={%
\pgfkeyssetvalue{/pgfplots/table/@cell content}{\includegraphics[scale=0.07]{example-image}}}  %==> This should be changed to add a TikZ \pic depending on the type column!
},%
columns/ID/.style={%
column name=ID,%
string type%
},%
columns/Description/.style={%
column name=Description,%
string type%
},%
columns/Type/.style={%
column name=Type,%
string type%
},%
columns/X-Pos/.style={%
column name=X-Pos%
},%
columns/Y-Pos/.style={%
column name=Y-Pos,%
column type/.add={}{|}%
},%
column type/.add={|}{},%
after row={\hline},%
every head row/.style={before row=\hline},
]{\csvdata}%
\end{center}
\end{document}

For Example we could use these two mini TikZ

%PowerOutlet
\tikzset{
 pics/stove/.style={
  code={
   \begin{scope}[scale=\resultImageScale]
     \draw[red,line width=\resultLineScaleMetric](0,0)--(0,1);
     \draw[red,line width=\resultLineScaleMetric](-1,1)--(1,1);
     \draw[red,line width=\resultLineScaleMetric,line cap=round](-1,2) arc[start angle=180,end angle=360,radius=1] node[midway,above,sloped,font=\bfseries] {\scalebox{\scaleRatio}{1}};
  \end{scope}
  }
 }
}
%Button
\tikzset{
 pics/stove/.style={
  code={
   \begin{scope}[scale=\resultImageScale]
     \drawred,line width=\resultLineScaleMetric circle[radius=1];
     \drawred,line width=\resultLineScaleMetric circle[radius=0.6];
   \end{scope}
  }
 }
}

Answer 1

You can just replace \includegraphics[scale=0.07]{example-image} in your code by \tikz{ \pic{<pic name>}; }.

The second part in the key pics/stove/.style (that is stove) is the name of the pic. So, if you define different pics, you should name them differently. If you define a pic named stove this way, you can call it via \pic{stove}; in a tikzpicture.

Note that there are some commands in the defintions of the pics you show, that are not defined, so I needed to define them in the below MWE:

\documentclass{article}
\usepackage[a4paper, margin=10mm]{geometry}
\usepackage{pgfplotstable}
\usepackage{mwe}
\pgfplotsset{compat=newest}
\def\resultImageScale{1}
\def\resultLineScaleMetric{0.4pt}
\def\scaleRatio{1}
%PowerOutlet
\tikzset{
 pics/PowerOutlet/.style={
  code={
   \begin{scope}[scale=\resultImageScale]
     \drawred,line width=\resultLineScaleMetric--(0,1);
     \drawred,line width=\resultLineScaleMetric--(1,1);
     \drawred,line width=\resultLineScaleMetric,line cap=round arc[start angle=180,end angle=360,radius=1] node[midway,above,sloped,font=\bfseries] {\scalebox{\scaleRatio}{1}};
  \end{scope}
  }
 }
}
%Button
\tikzset{
 pics/button/.style={
  code={
   \begin{scope}[scale=\resultImageScale]
     \drawred,line width=\resultLineScaleMetric circle[radius=1];
     \drawred,line width=\resultLineScaleMetric circle[radius=0.6];
   \end{scope}
  }
 }
}
\begin{filecontents}{data.csv}
Image,       ID,    Description,  Type,        X-Pos,   Y-Pos,   rotation
PowerOutlet, A1F5F, PowerSupply1, PowerSupply, 3590,    2000,    270 
PowerOutlet, 7ZF3I, PowerSupply2, PowerSupply, 3590,    2500,    270
button,      O7PYQ, PowerSupply3, PowerSupply, 4250,    6070,    180
button,      A7HAZ, Switch1,      singleSwitch,5700,    6070,    180
\end{filecontents}
\pgfplotstableread[col sep=comma]{data.csv}{\csvdata}
\pgfplotstablegetrowsof{\csvdata}
\pgfmathtruncatemacro\CSVDataRows{\pgfplotsretval-1}
\begin{document}
\begin{center}
\pgfplotstabletypeset[%
font=\ttfamily,%
col sep=comma,%
columns={Image, ID, Description, Type, X-Pos, Y-Pos},%
columns/Image/.style={%
column name=Image,%
assign cell content/.code={%
\pgfkeyssetvalue{/pgfplots/table/@cell content}{\tikz{\pic{##1};}}
}
},%
columns/ID/.style={%
column name=ID,%
string type%
},%
columns/Description/.style={%
column name=Description,%
string type%
},%
columns/Type/.style={%
column name=Type,%
string type%
},%
columns/X-Pos/.style={%
column name=X-Pos%
},%
columns/Y-Pos/.style={%
column name=Y-Pos,%
column type/.add={}{|}%
},%
column type/.add={|}{},%
after row={\hline},%
every head row/.style={before row=\hline},
]{\csvdata}%
\end{center}
\end{document}

---

If the Type in your table data is identical to the name of the relevant \pic (that is, the Image and the Type columns are identical copies), you can delete the Image column from your table and create this column as copy of the Type column automatically:

\documentclass{article}
\usepackage[a4paper, margin=10mm]{geometry}
\usepackage{pgfplotstable}
\pgfplotsset{compat=newest}
\def\resultImageScale{1}
\def\resultLineScaleMetric{0.4pt}
\def\scaleRatio{1}
%PowerOutlet
\tikzset{
 pics/PowerSupply/.style={
  code={
   \begin{scope}[scale=\resultImageScale]
     \drawred,line width=\resultLineScaleMetric--(0,1);
     \drawred,line width=\resultLineScaleMetric--(1,1);
     \drawred,line width=\resultLineScaleMetric,line cap=round arc[start angle=180,end angle=360,radius=1] node[midway,above,sloped,font=\bfseries] {\scalebox{\scaleRatio}{1}};
  \end{scope}
  }
 }
}
%Button
\tikzset{
 pics/singleSwitch/.style={
  code={
   \begin{scope}[scale=\resultImageScale]
     \drawred,line width=\resultLineScaleMetric circle[radius=1];
     \drawred,line width=\resultLineScaleMetric circle[radius=0.6];
   \end{scope}
  }
 }
}
\begin{filecontents}{data.csv}
ID,    Description,  Type,        X-Pos,   Y-Pos,   rotation
A1F5F, PowerSupply1, PowerSupply, 3590,    2000,    270 
7ZF3I, PowerSupply2, PowerSupply, 3590,    2500,    270
O7PYQ, PowerSupply3, PowerSupply, 4250,    6070,    180
A7HAZ, Switch1,      singleSwitch,5700,    6070,    180
\end{filecontents}
\pgfplotstableread[col sep=comma]{data.csv}{\csvdata}
\pgfplotstablegetrowsof{\csvdata}
\pgfmathtruncatemacro\CSVDataRows{\pgfplotsretval-1}
\pgfplotstablecreatecol[
    create col/copy={Type}
]{Image}{\csvdata}
\begin{document}
\begin{center}
\pgfplotstabletypeset[%
    font=\ttfamily,%
    col sep=comma,%
    columns={Image, ID, Description, Type, X-Pos, Y-Pos},%
    columns/Image/.style={
        column name=Image,%
        assign cell content/.code={%
            \pgfkeyssetvalue{/pgfplots/table/@cell content}{\tikz{\pic{##1};}}
        }
    },
    columns/ID/.style={%
        column name=ID,%
        string type%
    },%
    columns/Description/.style={%
        column name=Description,%
        string type%
    },%
    columns/Type/.style={%
        column name=Type,%
        string type%
    },%
    columns/X-Pos/.style={%
        column name=X-Pos%
    },%
    columns/Y-Pos/.style={%
        column name=Y-Pos,%
        column type/.add={}{|}%
    },%
    column type/.add={|}{},%
    after row={\hline},%
    every head row/.style={before row=\hline},
]{\csvdata}%
\end{center}
\end{document}