{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

6
votes
0answers
202 views

colour cells in a table according to the value

I have seen the following code in response to another similar question that works when the numbers in the table are between 0 and 100. How do I have to modify this code so that it works for numbers ...
5
votes
0answers
382 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 ...
4
votes
0answers
60 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} ...
4
votes
0answers
411 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 ...
4
votes
0answers
80 views

Subtract first row from each row and compute the relative differences

I am trying to create a new column from another one by subtracting from each row the first one. Then I want to create another column with the relative difference. \documentclass{article} ...
3
votes
0answers
115 views

PGFPLOTSTABLE configuration, bold style for headers, specific row, and specific formatting from CSV

I am starting to use the package pgfplotstable as it seems to be a powerful tool and is able to do what I'd like to do. I am importing custom CSVs, and as these will change over time, I need to plot ...
3
votes
0answers
37 views

post-process cell content in one column based on another column

I am trying to do something quite similar to this post: pgfplotstable: Conditional post-processing of cell content on a per-column basis However, I'd like to post-process the column based on the ...
3
votes
0answers
132 views

Importing Data from CSV file to Latex Table

I am running WinEdt 9.0, MikTex 2.9 on windows 7 pro. I am constructing a standard format PDF report and must follow that format (ie the table is in a particular format with colors and fonts etc ...
3
votes
0answers
124 views

Conversion of big “amount” of seconds into HH:MM:SS when plotting timeseries with pgfplots

My aim is to plot a timeseries (experimental data) using pgfplots in LaTeX (pdfLaTeX, TexLive on Mac). The data I'm using is seperated with semicolons (columnwise) and has the following structure: -- ...
3
votes
0answers
149 views

One tabular with column input from multiple data files with pgfplotstable

I have a question which sort of extends the page Multiple Files input to one pgfplotstable. In the answer to this question, data is read from dataB.dat and subsequently appended to the data as ...
3
votes
0answers
137 views

Barchart, Boxplot Data Table PGF Math Errors from mixed format inline data

My code for a horizontal bar chart with a summarizing boxplot is coming together, but I still have a nagging PGF Math problem if I try to plot the boxplot values, which are commented out at the bottom ...
3
votes
0answers
72 views

Add rows for sum/mean/std at end of pgfplotstable

How do you add a one or multiple rows at the bottom of a table in pgfplotstable that is a summation/average/variance or other function of the above data in that particular column? How can this be ...
3
votes
0answers
152 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} ...
3
votes
0answers
325 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 ...
2
votes
0answers
33 views

Legend entry for each point in scatter plot with matching color

I have a file with multiple columns, of which I create scatter plots where positions are given from column 1 vs column 2, while the mark color is based on column 3. I now wish to automatically create ...
2
votes
0answers
62 views

pgfplotstable: typset csv with 2 or more header lines (eg. name, unit, comment)

I am exporting from Origin and get a Data.csv like this: Short_Name1; Short_Name2 Long_Name1; Long_Name2 Unit1; Unit2 Comment1; Comment2 1,1; 2,0 3,5; 4,3 When I try to ...
2
votes
0answers
59 views

How can I use \multicolumn in a \pgfplotstable table?

In my experiments with pgfplotstable, I've run into some bumps: merging multiple columns adding formatting commands to text within cells Problem I cannot seem to properly add a \multicolumn{}{}{} ...
2
votes
0answers
54 views

Percentage character in header of pgfplotstable

I am trying to create a table with data from a .xslx file exported to .csv with pgfplotstable but I have trouble with the percentage sign. One of the columns in the header includes the percentage ...
2
votes
0answers
60 views

problems inserting commas in tables - pgfplotstable

I have a table I want to import into an appendix. The last column is a source key, and there are several sources in each cell I want to list as a, b, c; d, f, m; etc. However, the problem is the are ...
2
votes
0answers
96 views

PGFPlotstable with data from csv file : character µ and _ in column header

I have searched for a long time on the internet (here and other LaTeX resources on the web) but I could not find the answer to my (simple) question: how could I draw a table with Pgfplots, with data ...
2
votes
0answers
95 views

Possible to create \pgfplotstablenew without header?

I'd like to create a (pgfplots)table from scratch, however, one without a header. So I'm trying to modify one of the examples in the pgfplotstable documentation: \documentclass{article} ...
2
votes
0answers
183 views

Getting the (variable) number of columns per row with pgfplotstable?

I've already seen PGFplots and table with different number of elements in columns; but this is a slightly different question... Consider the following MWE: \documentclass{article} ...
2
votes
0answers
138 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 ...
2
votes
0answers
148 views

How can I manipulate data in a PGFPlots Table using l3int?

I need to provide statistical functionality to some of my TeX-trainees and I'd like to leverage the intuitiveness of l3int and the expressiveness of pgfplots and its table helper package. So, as a ...
1
vote
0answers
44 views

Generate Tikz tree from filecontents

Is there an easy way to create tree nodes from data in a file? I need the tree to have nodes in the format 1,2,3,4 rather than 1,2,4,8 etc. I can't create the nodes in a loop as there would be two ...
1
vote
0answers
36 views

Bar plot with y-error and nodes near coords

I have to plot some data as a bar plot. These data is processed with pgfplotstable, so I can plot the mean and the error for my data. Now I want to print the nodes near coords for each of the bars; ...
1
vote
0answers
13 views

How to concatenate expr into the pgfplotstabletypeset?

I have a file with time in seconds and I want to make a expression inside the pgfplotstabletypeset to convert the seconds into 2h35m40s. I only get how to convert to hours, minutes and seconds but ...
1
vote
0answers
41 views

How can I create a new table environment wrapper for pgfplotstable?

A similar question has been asked here: - newenvironment using pgfplotstable At first glance, I thought it was the same question, because the question is not clearly stated. That person is asking for ...
1
vote
0answers
34 views

pgfplots(table) protect ##1 when in a `\newcommand` with optional arguments

I am using the excellent answer from @percusse to the question How to rotate head row cell entries of pgfplotstable which works great if you always want rotated headers. I am calling ...
1
vote
0answers
46 views

Import data with pgfplotstable and generic horizontal lines

I have a dataset which is in the following form: # timeIt newtonIt globalIt time_0 time_1 # ---------------------------------------------------------------- 1 1 1 0.01247044 0.01111968 1 2 2 ...
1
vote
0answers
161 views

Pgfplotstable multicolumn table with dec sep align and Tabularx

I would like to implement a multicolumn table with Pgfplotstable that aligns on one side the number of the columns by dec sep align and secondly aligns the whole table by Tabularx. A version without ...
1
vote
0answers
63 views

pgfplots table read handle non-numerical entries

In a previous question, I asked how to create a Root Locus plot and got a pretty good answer thanks to @percusse using \pgfplotstableread that gets me 90% of the way there. However, the one thing I ...
1
vote
0answers
97 views

Spaces are not formatted correctly in url paths when using sphinx package and reStructuredText

I have a problem similar to the one in: Obey spaces with URL package (path command). The obeyspaces option is not working within the pgfplots table column. However, my problem is slightly different ...
1
vote
0answers
74 views

Pgfplotstable: column math is wrong!

I am using the following code with pgfplotstable to generate a new column that represents the difference of two other columns. \pgfplotstableset{create on use/iqr/.style={ create ...
1
vote
0answers
99 views

PGFPLOTS defintion inside macro inside table or insert boxplots inside table

I am trying to take a plot of a series of boxplots and include/insert these into a table. The code came from a posting of using a data table to define a series of boxplots. The code for the table ...
1
vote
0answers
127 views

Table of ybar plots with specific colors

I am trying to use specific coloring in an table of ybar plots. Maybe someone can help me out here. I have read other threads concerning the coloration of ybars but none of them really worked. This ...
1
vote
0answers
44 views

How to use pgfplotstabletypeset in combination with sweave

I am trying to make a table in LateX in which the background colour of my cells depend on the size of a number. I found some answers on Parametrize shading in table through TikZ but I cannot get them ...
1
vote
0answers
42 views

pgfplotstable - How can I stack the columns from a data file under one another without the headings but with additional vspace?

I'd like to typeset data in multiple columns below one another. The problem is, if I were to typeset lots of data for relatively few parameters, I'd like to typeset the content on a upright a4 page. ...
1
vote
0answers
109 views

Unequal bin widths in pgfplots density histogram

In the pgfplots manual, it talks about density histograms with equal bin widths/ranges. Is it possible to make a density histogram with specified unequal bin widths/ranges? For example, if I set ...
1
vote
0answers
105 views

\draw via \pgfplotstableforeachcolumnelement fails outside {axis} environment, but works inside?

Consider this MWE: \documentclass{article} \usepackage{pgfplots} \usepackage{pgfplotstable} \usetikzlibrary{calc} \pgfplotstableread[col sep=space,row sep=newline,header=true]{ ts val 0.0 0.0 1.0 ...
1
vote
0answers
111 views

Make a large heatmap with gaps and tables between

I am trying to make a large heatmap which looks like this with gaps and row or column names written in some of the cells. Empty cells are also present in the heat map. Can i make this using pgfplots? ...
1
vote
0answers
92 views

Large number of plots from external csv file

I'm looking to draw a large number of lines/datasets (around 150~200, 50 points each) on a single window using pgfplot. The data is imported from a csv file created with matlab. I've seen several ...
1
vote
0answers
103 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
0answers
120 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 ...
1
vote
0answers
134 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 ...
1
vote
0answers
224 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 ...