{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

11
votes
1answer
582 views

PGFPLOTS: Show x labels for every second tick

How can I show xaxis labels for every second data in this dataset. I want a bar for each tick, but not a label. \documentclass{article} \usepackage{pgfplots} \pgfplotsset{compat=newest} ...
1
vote
1answer
154 views

Number of rows in loaded table

Is it possible to determine the number of rows in a table read by pgfplotstableread{values.dat}\val ? My setup is the following. I make experiments to see how a parameter affects a convergence ...
8
votes
1answer
140 views

Help with a simple bar plot

I have some data in a table; the first column has some names; the second column associates a "category" to each name, and the third column associates a "section" to each name. All entries are ...
1
vote
0answers
23 views

How to draw a bar chart from multiple measurements with mean and variance [duplicate]

I have a few hundred measurements in a simple CSV file. I want a bar chart which indicates mean and variance pretty much like this: I've browsed various archives, such as the PFG plot gallery, but ...
2
votes
1answer
76 views

Trouble including graphics from csv file into Pgftable, commands are dissapearing (local maybe?)

I've been trying to add eps graphics with the filename in a csv file. Take a look at the CSV to get an idea of what I mean: ...
3
votes
2answers
358 views

pgfplotstable column width & row height

I am drawing a large heatmap containing only colors using \pgfplotstabletypeset. The table contains 103 columns, and 111 rows, which I am trying to squeeze in the area of 13cm * 16cm. In order to save ...
3
votes
2answers
178 views

Custom axis line location for PGFplots table with tikzpicture

I am trying to change the axis y line location from 0 to 100 from these questions (1, 2). Say that the error bars represent confidence intervals on percentage scale, so 100% is no difference. Here is ...
2
votes
0answers
107 views

Pgfplots: date range and integers as input data

I have a data table that looks something like: Week,value 2010-01-03 - 2010-01-09,0 2010-01-10 - 2010-01-16,0 2010-01-17 - 2010-01-23,0 2010-01-24 - 2010-01-30,0 2010-01-31 - 2010-02-06,0 2010-02-07 ...
3
votes
1answer
251 views

\pgfplotstabletypeset heatmap: logarithmic scale

I am trying to create my own rendition of this heatmap. My values range anywhere from 1 to 783764. I want to plot them as colors on a logarithmically (base10) scaled colormap. So the values' ...
2
votes
1answer
158 views

Pgftables: How to automatically add row headers?

Here is a MWE: \documentclass{article} \usepackage{pgfplotstable} \begin{document} Here is the multiplication table in roman numeral. \pgfplotstabletypeset[string type]{ i ii iii ii iv ...
1
vote
1answer
191 views

Align table side by side with graph

I'm trying to get my csv table aligned to the left of my graph. The graph is appearing below (and indented) the table. Any ideas? \begin{minipage}{0.5\textwidth} \pgfplotstabletypeset[col sep=comma, ...
6
votes
1answer
145 views

How to align two PgfplotsTable objects with graphs?

This is a follow-up for the fantastic question and answer here. I have been struggling with this so long that I would really appreciate help. Say that I have two datasets that are related, but on ...
3
votes
0answers
242 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 ...
3
votes
1answer
142 views

pgfplotstable: using one column to control style of another

I want to print a pgfplotstable where one column (which is not printed) used to change the style of another column. In my MWE below, I want to change the font= style of select values in the Item ...
1
vote
0answers
63 views

Auto-coalesce same values into \multirow

I am generating a pgfplotstable from a data file. In that file, within the Class column, subsequent rows with the same value should automatically be coalesced/collapsed/joined to form a ...
2
votes
1answer
104 views

pgfplotstable: not printing string type values

I have some data in a csv file I wanted to turn into a table, but pgfplotstable does not print any string type values. All I'm getting is the numbers, but I also need those string values. The example ...
2
votes
1answer
301 views

pgfplots: marker size relative to interval size

I am trying to create a ybar interval pgf plot with horizontal lines as markers on top of each interval/bar. Intervals widths are specified by my external CSV data file. I defined my own plotmark ...
6
votes
1answer
136 views

Macro expanding to comma separated list

I'm trying to use a macro for pgfplotstable labels but the macro is treated as a single entry of a csl rather than a csl. The Question asked in Using a macro as value of addtotoc in \includepdf ...
1
vote
1answer
114 views

How to display a number with many decimals and year correctly

I have a table in "import_csv_2.csv" as follows: No. Year W(G) 1 2010 0.02110333 2 2008 0.02082747 3 2006 0.02037291 ... \pgfplotstabletypeset[ col sep=comma, ...
5
votes
1answer
120 views

Plot using pgfplots from a text file in long form (vs wide form)?

In the statistical programming language R, there are two different forms to represent data. The wide form looks like the following: subject time age weight height 1 John Smith 1 33 90 ...
0
votes
1answer
67 views

How to encapsulate row predicates in `pgfplots`

I'm trying to encapsulate some pgfplotstable code that involves setting up a row predicate. If you are checking table values amongst the predicate code you need access to the table and the only thing ...
2
votes
1answer
126 views

How to have pgfplotstable ignore rows with no entries in certain columns?

I have data from a large .csv file. Simplified, it looks like this: TypeI, TypeII, Data A, , 3 B, , 1 , C, 4 , D, 1 I've made symbolic ...
2
votes
1answer
79 views

Repeated pgfplotstable calls causing errors

I've been working with pgplotstable for some time now and initially I was reading in data from .csv files. I'm writing a couple of packages that print tables and so I've written various \defs to ...
2
votes
1answer
154 views

Pgfplotstable: format all cells but header row and header column

I found some code to asign colors to table values with PGFplotstable, but unfortunately it is only designed for tables where the topmost row is a head row (which is ignored by postproc). I also need ...
13
votes
2answers
135 views

Making a table independent of pgf

I use pgfplotstable to generate tables to be included in online submission to journals. I would like to make my paper independant of pgfplotsable because compilation of the document is made online ...
8
votes
1answer
74 views

Pgfplotstable ignores chars in filename

I am using the ignore chars key from the pgfplotstable to ignore some characters in a table. However, I have noticed that it also removes characters from the file name and I am wondering if this is ...
8
votes
1answer
479 views

Pgfplots linear regression (mean square error)

Pgfplots offers the possibility to compute a linear regression, as in the following post Linear regression - trend line with pgfplots . However, is it possible to compute the mean square error ? My ...
3
votes
0answers
93 views

Pgfplots fails to generate boxplots for some data set

I use pgfplots to generate boxplots, however with some small data sets as the following, I get an error message. speed 2 3 1 2 2 11 Here is the error message : Sorry, an ...
4
votes
1answer
128 views

Use column header as labels for x ticks

With pgfplots, it is possible to let the xticklabels be given by one column of a table. However, is it possible to import it from the table header ? In my concrete case, I have a table with two ...
3
votes
0answers
56 views

Searchbox for a table [closed]

I'm new to LaTeX. I was wondering if it is possible to create a searchbox for a table (in LaTeX) which would then work in the pdf. I don't want to just display the word as in the find function. I'd ...
3
votes
1answer
69 views

Controlling pgftable numeric output

Please consider the following \documentclass{article} \usepackage{filecontents} % For tables \usepackage{pgfplotstable} \usepackage{booktabs} \usepackage{array} \usepackage{etoolbox} ...
1
vote
0answers
191 views

Clash between knitr, tikzDevice and pgfplotstable

I use knitr to compile a document composed of two .Rnw. Please considered the following examples from this answer main.Rnw % !Rnw weave = knitr % !TeX program = pdfLaTeX ...
6
votes
1answer
187 views

How to access rows through naming or similar

I want to create a style for tables similar to \documentclass{article} \begin{document} \begin{table} \begin{tabular}{cc} A & B \\ a & b \\ c & d \\ \multicolumn{2}{l}{\emph{C}} \\ e ...
6
votes
1answer
190 views

pgfplotstable multiple columns same heading name

I have some x y data that I wish to typeset using pgfplotstable, rather than having say 9 rows of 2 columns, I would like to have 3 rows, with 3 sets of xy pairs. Consider the following: ...
1
vote
0answers
61 views

pgfplotstable: how to repeat row entries and combine it with external data [closed]

I want to combine the table data (in a file A.txt) -0.13336 -0.13634 -0.13336 -0.11589 -0.136 0.76158 0.63087 0.76158 0.95729 0.63 0.9543 0.59712 0.9543 0.90589 0.59712 0.17172 0.13013 0.17172 ...
4
votes
0answers
281 views

How to add marks to all graphs at certain y level

I'd like to add markers to my plots only at certain y levels. How to do this for certain x levels is obvious, I didn't manage to do it inversley though. What I have (equi-x): What I want is ...
8
votes
1answer
276 views

Formatting an array of complex numbers with pgfplotstable

Say I have two csv files representing the real and imaginary part of a complex matrix. I would like to nicely display this matrix in LaTeX. The difficulty is to correctly round numbers and not ...
2
votes
1answer
96 views

Iconography to summarize a table

I am building up a table summarizing several methodologies for a presentation. And I would like to place some coloring iconography to grasp some information at a glance. Here is the problem ...
3
votes
1answer
368 views

pgfplotstable read data from file and create new columns

I made this file parameters.dat: parameter, value $K_1$, 0.00034 $K_2$, 0.0053 $K_3$, 0.07 $K_4$, 0.0027 Now I would like to generate a table in my .tex file with 4 columns: ...
6
votes
1answer
123 views

pgfplotstable: fixed precision, switch-case?

I tried using pgfplotstable to format an external txt file, but some problems arrived. My goal is to show the numbers with fixed, fixed zerofill, precision two and with the presign, which should ...
3
votes
1answer
111 views

Remove row in table (pgfplotstable)

I am using pgfplotstable, I read a data file and I want to create a table without several rows. To do this, I am trying to use every row no XX/.style={output empty row} (where XX is the number of the ...
3
votes
1answer
99 views

Inclusion of pgfplotstable in tikzpicture

Is there any way to include a table generated by pgfplotstable in the tikzpicture environment, where other figures generated by pgfplots exist, in order to save them together as one figure with ...
5
votes
1answer
80 views

Precision for one row only

I have an array with three rows and I would like that the last row has a specific format. There is a command every row no/.style, but it wouldn't work in our context because the processing is applied ...
5
votes
1answer
148 views

Table with percentage sign for a specific line

I am importing a table from a file and I would like to add a percentage sign for all figures on the third row. The code works well for a specific cell in the table using the command every row 2 ...
3
votes
0answers
37 views

Read single value from a table [duplicate]

I will use in many places in my LaTeX document a specific value given in, say, the row 2 and column 1 from a table. Is it possible to make a macro for it, such as \read{2}{1} ? Here is an simple ...
7
votes
1answer
110 views

Import a table with a specified format

Basically, I have a table (from a file) containing only numeric values. I would like to import in latex but it has to be formatted in a specific way, as illustrated by the picture. The ... should be ...
4
votes
1answer
107 views

Keeping first and last rows of a pgfplotstable with longtable on a page

I am using pgfplotstable along with longtable. Everything works good, but sometimes a single row can be on one page, which is kind of ugly. How can i keep the first 3 and last 3 rows of the table on ...
6
votes
1answer
469 views

TikZ graph not aligning

I am having two issues with TikZ pictures. I have three graphs side by side, and I am having issues, but only with some of them, which is very odd. First the x-axis is going out of alignment (some ...
11
votes
1answer
307 views

Setting table width with pgfplotstable

I am using pgfplotstable to create a table for the following data: Species Moles (1) Moles (2) Moles (3) Ca++ 1.8887e-4 1.9476e-4 3.4462e-2 CaCl+ 3.7537e-5 ...
0
votes
1answer
107 views

Insert Sweave into LaTeX

I have already done most of my final paper using normal LaTeX and inserted a table using pgfsplotstable. However, I find it particularly difficult to edit/ style the table using this packages syntax. ...