{pgfplotstable} is a package that can read, parse, modify or generate tables. Data is provided via either external files or inline code. It also serves as the data handler of the graphics package {pgfplots}.

learn more… | top users | synonyms

1
vote
0answers
7 views

Drawing multiple box plots from a file

I've got data in the following format n lw lq m uq uw 50 200 209 237 327 569 100 376 379 386 390 391 150 ... ... Where lw = lower whisker, lq = lower quartile, etc. I want to plot each box against ...
2
votes
1answer
19 views

pgfplotstable and longtable with caption is shown multiple times in tableslist

I'm visualizing a csv file using pgfplotstable and longtable as followed: \newcommand{\powerTable}[3]{ \pgfplotstabletypeset[ string type, col sep = comma, skip rows ...
5
votes
0answers
19 views

pgfplotstable show subset of rows?

I'm visualizing a csv with pgfplotstable as following: \pgfplotstabletypeset[ string type, col sep = comma, begin table=\begin{longtable}, end table=\end{longtable}, ...
1
vote
0answers
32 views

PGPlots xtick label from a table

I am trying to load data from a table which looks like below and use the 'label' column for xticklabels. idx,label,value 1,20040101_20050108.rotation.summary, 19.470949839091155 ...
4
votes
1answer
44 views

Graph shifts position when adding plot

If I compile this code without the Gaussian function at the end everything is allright, but if I try with it the whole figure shifts to the right. In this example it is not a very big problem, but ...
2
votes
1answer
26 views

How to change the color background of a single cell in the last row

Using pgfplotstable, I want to color singular cells in the last row of an automatically created table based on csv-input. Since the length of the table differs, I need to color the last cell ...
0
votes
0answers
28 views

Longtabu in pgfplotstable from csv input with additional tikz lines

My question is based on this thread: Faulty table lines I have lots of csv-separated data e.g. in this format 11,22 33,44 55,66 ... and so on I'm creating tables automatically using the ...
0
votes
0answers
13 views

Multiple row in heading for tables

I have a problem formulating two rows in my heading of my table using pdfplotstable exporting csv file from excel. This is what i have: \usepackage{pgfplotstable} \documentclass[a4paper, 12pt]{book} ...
2
votes
1answer
20 views

pgfplotstable with .tsv file where the headers have underscores: How to avoid “Missing $ inserted”?

The file I want to show is a .tsv file that I cannot edit. It looks like this: up_gene up_chr up_strand up_Genome_pos APLP2 chr11 + 129991686 BACE2 chr21 + 42617990 BRDT chr1 + ...
3
votes
1answer
24 views

Adapted table width to text using pgfplotstable and csv excel

I have a problem with forcing my table to the same width as the text. I export the csv (Excel) file to Latex using this approach, see code. Changing text-size in Excel works to a curtain "level", but ...
3
votes
1answer
579 views

Conditional formatting, rounding and postprocessing of a column in pgfplotstable

I want to round p-values in a table to two decimals (for example 0.05), have values less than 0.05 in bold font and have values less than 0.01 to come out as '<0.01' in bold font. Like this (the ...
6
votes
1answer
79 views

Getting certain data out of .txt file

I'd like to use an external .txt file to provide a table in my LaTeX document with data. To achieve this I've taken into consideration the pgfplotstable package and the filecontents package. Both of ...
4
votes
1answer
89 views

newenvironment using pgfplotstable

I want to have a newenvironment body as an inline input argument for pgfplotstable. Is it possible to do this without using braces in the body itself? \documentclass{article} ...
3
votes
1answer
43 views

pgfplots - insufficient precision

I am having the following problem: Using pgfplots to plot some convergence graphs, I have to load a text file and do some computations. Most of the time everythings works just fine. But in some ...
0
votes
1answer
33 views

pgfplots: percentage in matrix plot

I'm trying to draw a matrix plot with the shown values in percentage. I already tried: nodes near coords = {\pgfmathprintnumber\pgfplotspointmeta\%} Unfortunately this didn't work out. Here is my ...
4
votes
1answer
39 views

pgfplotstableread{mydata.csv} VS table {mydata.csv} efficiency and capability for csv files pgfplots

I am trying to plot a very large .csv file with multiple columns using pgfplots. I want to use the first column for all my plots. My usual routine is to do something like: \addplot [solid] table ...
0
votes
1answer
28 views

Change Default row separator in pgfplotstable / order of commands for each line

I edited the question and added a MWE. Please feel free to change tags or the title of the topic since I'm not sure how to categorize my problem. I'm using the tabu package and pgfplotstable for ...
2
votes
1answer
25 views

Accessing Files with Spaces In Parent Directory Path

I'm having problems getting the pgfplotstable to compile because of issues with file path names containing spaces. I have read a bunch of other posts that say to just put quotes around things but none ...
1
vote
1answer
71 views

How to fill the parameters of `boxplot prepared` with data from table using PGFPlots?

I want to draw a boxplot using boxplot prepared@ Page 469 of pgfplots-manual; v1.13, with the values of lower whisker, lower quartile, median, higher quartile, and higher whisker from a data file. ...
13
votes
1answer
2k views

Multiple Files input to one pgfplotstable

I have several data files that I would like to combine into one table using pgfplots table. Specifically, I would like to use one file to set the first three columns and then have each data file fill ...
0
votes
0answers
16 views

Longtable in pgfplotstable

I'm trying to get pgfplotstable in combination with a longtable to work. The data is read from a file "Errordata.dat". The file is saved as ANSI-formatted. 1,2,3,4,5,6,7,8,9 1,2,3,4,5,6,7,8,9 ...
2
votes
0answers
54 views

longtable with pgfplotstable - adding predefined rows and breaking manually

Based on this link pgfplotstable; longtable with caption and repeating header I wrote this MWE: \documentclass{article} \usepackage{longtable} \usepackage{booktabs} \usepackage{multirow} ...
2
votes
1answer
62 views

Plotting data series with pgfplots [duplicate]

I have a csv file index.dat with data Year,0-19 years,20-39 years,40-59 years,60-79 years,80-99 years,100 years+ 2000,100,100,100,100,100,100 2001,101,102,101,102,101,102 ... I am trying to plot ...
1
vote
1answer
26 views

pgfplots filter table with float content and conditions

I want to filter some data for a plot, and so far the best thing I found is this here. This is the relevant code from the mentioned question: \pgfplotsset{ discard if not and smaller/.style n ...
1
vote
0answers
32 views

Highlight first rows and first columns of a pgfplotstable

I'm trying to change the background color of the cells FOO and BAR and also the ones with the values (1 and 2) in the following MWE: \documentclass[12pt]{article} ...
5
votes
0answers
41 views

pgfplotstable longtabu repeating header and other options

I want to print a long table with pgfplotstable and long tabu. For some reason, with the following code, I do not get the header repeated on every page. I also want a \bottomrule and a caption on ...
2
votes
1answer
80 views

Why the `.tex` file is running indefinitely in PdfLaTeX?

I am using the following code to plot a set of graphs from the experimental data given in book1.txt. This .txt file is also kept in the same folder along with .tex. My book1.txt file is A B ...
1
vote
0answers
11 views

Current file relative paths and pgfplotstableread

For my latex documents I employ a structure like this: pictures doc1 doc2 ... To allow quick editing my picture folder contains a testfile. While I successfully use the import package to allow my ...
3
votes
1answer
51 views

Tikz pgf plot: cyclic shift of alphabetic labels on x axis

I have the following code to produce a plot \documentclass{standalone} \usepackage{tikz} \usepackage{pgfplots} \pgfplotstableread[row sep=\\,col sep=&]{ letter & freq \\ a & 11 ...
0
votes
0answers
13 views

pgfplotstable use cyclelist to color columns/header

Jake shows a beautiful example of presenting the same data in a table and a plot in this answer. However he manually sets the color for the bar graph(s) and the first table fields. I am wondering if ...
3
votes
1answer
52 views

! Missing # inserted in alignment preamble

I have a problem in compiling my tex file using nle.cls document class. The problem seems to be with package pgfplotstable. If I comment it our every thing works fine. The package disrupts the working ...
2
votes
1answer
38 views

Define and use column styles in pgfplotstable

Is it possible to define custom styles and use them to display columns? I have 10 columns, 3 of which are strings and the rest are floating point numbers with a series of options I've defined. I'd ...
3
votes
1answer
101 views

pgfplotstable: read and manipulate multiple data files into one tabular

When trying to typeset a datatable I can't insert \pgfplotstabletypeset in a tabular environment. What am I missing? mwe: \documentclass[a4paper]{article} ...
6
votes
2answers
133 views

How to plot anomaly using two colors in a single plot with pgfplot?

I want to create a line plot using a table data included in the MWE. The thing is that, using this data, I want that the plot looks like the next figure: i.e., with different color areas for one ...
2
votes
0answers
55 views

How to get rid of the following error with pgfplots?

When I am running the following code with data.txt file... \documentclass{standalone} \usepackage{tikz,pgfplots} \begin{document} \pgfplotstableread{data.txt}\Rtable ...
4
votes
1answer
58 views

pgfplotstable: how to change the color/font/background of a single cell?

Let's look at this MWE, where I am trying to change the formatting/background of a cell in the table. I think I have just copied the example in the manual, but I have the nasty effect that the content ...
1
vote
1answer
62 views

Pgfplots line style

I don't know why, but when I type commands such as: thick, dotted, red, blue etc. it doesn't recognize the commands or it just compiles and nothing changes. For example if I type thick, it gives me ...
1
vote
0answers
21 views

`string replace` before plotting

The package pgfplotstable defines a key string replace* that can be used to replace strings inside a typeset table (in \pgfplotstabletypeset); for instance (quoting from the manual) ...
6
votes
1answer
78 views

pgfplots: correct rounding problems

I had a problem with disappearing marker as the data sum up to more than 100 while xmax was set to 100. See pgfplots: node near coords missing due to rounding problems. As written in the answer to ...
12
votes
2answers
355 views

Plot one function per row of table

I want to plot a polynomial that is parametrized by an additional parameter d. I took samples of the domain of d and stored the coefficients of the polynomial for each of these samples in a table: d ...
3
votes
1answer
64 views

How to have unconnected points on a plot? [duplicate]

I'm trying to create a graph which has all of the datapoints from an inline table plotted, without a line connecting them, but still having the points on the graph. The issue with the MWE is the line ...
0
votes
0answers
73 views

How to import data file in pgfplots? How to enlarge Tex Memory?

\documentclass[paper=a4, fontsize=11pt]{article} %\usepackage{tikzpicture} \usepackage{pgfplots} \usepackage{tikz} \newcommand{\horrule}[1]{\rule{\linewidth}{#1}} % Horizontal rule \title{ ...
1
vote
1answer
43 views

Some issues with a stacked area plot - pgfplot

I have three issues with a stacked area plot. 1: I want to make the plot more width to fit it in my presentation. But if I scale in x-direction it also scales the fonts (labels). How to avoid that? ...
1
vote
1answer
39 views

How to parse and print the characters {} with pgf and \thisrow?

I have a data table with "{}" I would like to keep these characters. Results: I would like to uningore this character from parsing to be printed on the image. I know that I could to change: nodes ...
4
votes
0answers
687 views

pgfplots: howto read touchstone files (s1p, s2p, s3p,…)

With pgfplots you can simply create nice plots that seamlessly integrate into your TikZ figure. As a high frequency engineer you will inevitably use a network analyzer to measure S-parameters. The de ...
2
votes
1answer
53 views

How to modify the layout of a longtable using pgfplotstable

In order to prepare a long series of industrial reports containing complicated long tables, I am combining samples of code I have found on the site, and this looks promising. In my field, cells need ...
0
votes
1answer
12 views

multicolumn doesn't count columns property in pgfplotstable

Consider the following MWE where I would expect the multicolumn to span the number of columns in the pgfplotstable/longtable combination. \multicolumn{\pgfplotstablecols}{r}{{\small\tablename\ ...
3
votes
1answer
76 views

pfgplotstable and siunitx, unit column from .csv file

I have some data in a .csv file that I would like to typeset with a combination of pgfplotstable and siunitx. Consider the following (not so extremely minimal) MWE who throws the error Undefined ...
1
vote
1answer
57 views

Reading xticklabels from a csv

I need to display the labels in AgentTypesS column in my barchart. This is an excerpt from my .csv file (Yes, it is an uneven file) AgentTypesL, OriginalL, MergedL, DifferenceL, ...
0
votes
2answers
30 views

pgfplotstable and longtable table counter problem/caption positioning [duplicate]

Consider the following MWE which uses pgfplotstable and longtable to output some csv file content. The table counter are incrementet twice for each table added. Why? ...