# \datavisualization and csv data

I'm quite new using tikz and pgf. I use Texmaker.

I get this error: PGF Math Error: Sorry, an internal routine of the floating point unit got an ill-formatted floating point number '. The unreadable part was near ''

when I try to run the following code

\documentclass{article}
\usepackage{pgfplotstable}
\usepackage{tikz}
\usetikzlibrary{datavisualization}

\begin{document}
\pgfkeys{/pgf/number format/.cd,
read comma as period,
set thousands separator={}}
\pgfplotstableset{col sep = &}

\begin{tikzpicture}[scale=1.6]
\datavisualization[scientific axes, visualize as scatter] %
data [separator=&, read from file = EMR_VA.csv];
\end{tikzpicture}
\end{document}


The csv file has 3 columns, delimited by &, and some values have decimals, separated by comma.
• What does EMR_VA.csv look like? – Henri Menke Nov 11 '15 at 14:57
• I am pretty sure, that you have to escape & in col sep = & and separator=&. Try replacing both instances with \&. – Henri Menke Nov 11 '15 at 15:17
• No unfortunately this doesnt help.. from the manual /pgfplots/table/col sep=space|tab|comma|semicolon|colon|braces|&|ampersand – Mino Nov 11 '15 at 15:23
• @Giacomo That's col sep not separator. – Manuel Nov 11 '15 at 15:28
• Do you want a 3D scatter plot, since there are three columns? If not, which two columns do you want? Is there a header line in your .csv file? For convenience, a sample file would be nice (just need a few lines). Finally, is using pgfplots an option, or do you require the datavisualization` library? – Torbjørn T. Nov 11 '15 at 21:36