{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

8
votes
3answers
192 views

How can CSV files be put into LaTeX without having to adjust much?

I would like to have a TeX-Snippet that takes a filename as an argument and outputs a table with toprule and bottomrule: \begin{tabular}{lrr} \toprule Fach & Dauer & Einkommen\\ ...
1
vote
0answers
64 views

pgfplotstable manually declare row data

I'm trying to load data into somes tables using pgfplotstable. My problem is that the data in the files is in a bit of a different format than the way I want to present it in the table, and after I ...
1
vote
1answer
146 views

PGFplotstable: using a csv file with 4 columns

Suppose I have a csv file with no titles in it just data. The first column is time (x axis) and the next 3 columns each construct a different set; that is, plot(t, col1) is one set of data, plot(t, ...
3
votes
1answer
150 views

Linear regression in a loglog-plot with fixed slope

Goal: create a plot to compare the empirical convergence rate of a numerical method with the one expected from the theory. Accordingly, given a loglog-plot, I would like to add the line which has a ...
1
vote
0answers
73 views

Pgfplots working as standalone but not in main document

Update 1 The data file can be downloaded here> 11855-4_RT.dat Original: In my main document I have been including a pgftable as: \SSTeTableTypeT %contains \pgfplotstableset - included in the end of ...
8
votes
2answers
160 views

How to do linear regression in pgfplots for data with nan?

I am trying to use pgfplots to plot a linear regression to my data. If there is a nan in my data set, no fit is generated, with the warning: NOTE: coordinate (1,nan) has been dropped because it is ...
2
votes
1answer
73 views

How to change font family LaTeX plot?

I want to change the font family of the bar plot to Helvetica fonts. I have tried using the following code but it only changes axis fonts and not the data labels inside the plot: ...
1
vote
0answers
72 views

pgfplotstabletypeset verticle alignment of cell contents, plus horizontal lines

I am using pgfplotstabletypeset to read contents of a csv file and typeset (In the MWE below instead I copy/pasted the contents of csv file, to make it easier to test the MWE). I have some content ...
3
votes
0answers
72 views

PgfPlots bar with missing data causes columns to be “misplaced” [closed]

I looked for a similar problem here in SE but I couldn't find it. It's just driving me crazy :| Here is a MWE: \documentclass[xcolor=dvipsnames, 10pt, pdflatex]{beamer} \usepackage[utf8x]{inputenc} ...
3
votes
0answers
64 views

Redefinition of pgfplotstableread and inline tables

I had to redefine pgfplotstableread because I use it in standalone files in an extra img/ folder that loads data from a different data/ folder as follows. \begin{filecontents}{plot.tikz} ...
2
votes
1answer
86 views

How to add font commands to a pgfplotstable header cell?

I'm trying to change the cell color and text color of the header of a pgfplotstable. Changing the cell color is not that much of a problem because I can just prefix the row with \rowcolor: ...
1
vote
0answers
93 views

PGFPLOT Externalization not working [closed]

I am trying to externalize PGF Plot to be saved as EPS file using latex and enabled shell-escape. \documentclass[a4paper]{article} \usepackage{lipsum} \usepackage{tikz} ...
13
votes
2answers
160 views

'e+08' (don't suppress 0) notation in columns with S-specifier

for symmetry reasons in a large table I want the scientific format with 2 digits (i.e. e+08). By default it suppresses the 0. Here is what I do: \documentclass[]{article} \usepackage{siunitx} ...
5
votes
3answers
320 views

Fill the area under minimum of two functions using tikz and pgfplots

I am loading two curves from a file and plot them with \addplot table [...] {the table.txt}; I have managed to fill the area under a single curve, but I want the minimum of the two curves filled. What ...
4
votes
2answers
97 views

How to eliminate a annoying amount of white space between bars in bar plot?

I have removed one row of data from a file, but I cannot find way to get rid of the white space in the center of the plot. Reducing the width moves the bars outside of the graph, and the only way to ...
3
votes
1answer
138 views

Unable to read in text labels for pgfplots bar chart

I've started using pgfplots and can plot scatter plots where all data is numeric, but I'm having no luck at all with bar charts where the xlabel is text. I've tried to find a solution in the manual ...
3
votes
1answer
122 views

Making a stacked bar chart

I want to transform a set of barcharts (such as in the subset in the MWE below) to a stacked bar chart which is more legible, as in this example: \documentclass{article} \usepackage{tikz} ...
4
votes
1answer
135 views

read table from file , each row different number of columns

I have a data file where each row has a different number of columns, like this: x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x ...
7
votes
0answers
192 views

Automatically add discontinuities in some plots

I have multiple plots (about 15 different figures) that have the same axes (i.e., same ymin and ymax values and same xticks). One of the plots has very large values. I don't want to either increase ...
10
votes
1answer
273 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
112 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
136 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
63 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
252 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
165 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
87 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
209 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
114 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
115 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
125 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
161 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
97 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
45 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
68 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
244 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
115 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
93 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
108 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
56 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
94 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
71 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
119 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
127 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
71 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
393 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
76 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
117 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
55 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
55 views

Controlling pgftable numeric output

Please consider the following \documentclass{article} \usepackage{filecontents} % For tables \usepackage{pgfplotstable} \usepackage{booktabs} \usepackage{array} \usepackage{etoolbox} ...