{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
234 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
91 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 ...
5
votes
0answers
447 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
64 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
462 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 ...
3
votes
0answers
38 views

Pgfplots: Transpose headrow as first column in: confusion matrix with colormaps / heatmaps

My question builds on code from this question: original question/answer What I am trying to achieve: I want to use pgfplots to build a table, where the header row is automatically added as first ...
3
votes
0answers
106 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{}{}{} ...
3
votes
0answers
223 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
83 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 ...
3
votes
0answers
41 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
154 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
161 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
175 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
145 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
182 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
390 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
30 views

import a long tab delimited data file with first row as the header

Here's a very simple task that I don't seem to be able to get the format right. In short, I am trying to import and format a long tab-delimited txt file, with the first row as the header. I tried the ...
2
votes
0answers
52 views

How to correct a PGFPLOT plot with minimal data that does not follow global options?

I have incomplete test data, as shown in the MWE. I would like to use all (few) available data points in the plot, ie (55.16, 0.08) for copper, but the plot does not take it into account. Also the ...
2
votes
0answers
97 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
88 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
103 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
121 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
128 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
230 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
160 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
161 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
47 views

print empty cell in Latex

I have an array stored in csv file from Python program as : W = [ 1, 2, , 4, , 5] I want to print the array in Latex as : W 1 2 4 5 I have ...
1
vote
0answers
48 views

Calculate pearson correlation, r in pgfplots

Is it possible to calculate the pearson correlation, r or r^2 value from a linear regression using pgfplots? I already have the curve and would like to display the r value in the legend. I couldn't ...
1
vote
0answers
80 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
23 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
52 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
39 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
58 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
216 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
73 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
124 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
87 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
109 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
177 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
50 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
48 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
122 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
125 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
138 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
97 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
119 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
128 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
141 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
251 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 ...
0
votes
0answers
39 views

Auto label points read from file

My question is the following, I read data from txt file where the data are stored as: North,East 1,5 4,7 a file with code \pgfplotstableread[col sep=comma, header=true {data.csv}\table; \addplot ...