{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
1answer
28 views

How to reference a cell outside pgfplots-table?

I have written a dynamic LaTeX table which includes data from an external file and computes a new column out of the existing columns according to some criteria. Now I want to reference the computed ...
3
votes
1answer
28 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
17 views

pgfkeys - storing today's date with pgfplotstablenew, pgfplotstablesave

I'm working on making a simple tool to generate burn down reports/track task progress; this is my first foray into more complicated table manipulation so there's probably something pretty basic I'm ...
1
vote
0answers
17 views

pgfplotstable, multicolumn sp

I am trying to make a table (code below) that should contain three headings and five equally spaced sub columns but the one on the far right does not want to agree. If I make the really long heading ...
4
votes
1answer
109 views

“Logarithmic scale” for negative values

I have the following MWE: \documentclass{standalone} \usepackage{pgfplots} \usepackage{pgfplotstable} \usepackage{filecontents} \pgfplotsset{compat=1.12} \begin{filecontents}{data.dat} 4 -1e4 4 -1e3 ...
8
votes
3answers
2k views

pgfplotstable; longtable with caption and repeating header

I would like to use the pgfplotstable package in order to import data from a .csv file into a multi-page table. I would like for the table to have: a caption above it and its header to repeat at ...
6
votes
2answers
57 views

bold or higlight first row and column of tabe created from csv file

I'm using csvreader from csvsimple package to read csv data and create table from it. My goal is to bold or somehow highlight first row and first column. Here is my MWE: \documentclass{article} ...
2
votes
1answer
21 views

citations in pgfplotstable

So I'm calling data in to a pgfplotstable with \pgfplotstabletypeset[col sep=comma]{example.txt} which has been working fine, until I tried to include a citation in my example.txt file with ...
1
vote
0answers
33 views

Linear regression with fixed point

I have a data set to which I want to add a trend line. For my system, there will always be a fixed point on (2, 0). I have the line representing this system, but currently I do not account for the ...
1
vote
0answers
24 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
21 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
22 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
38 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
34 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
32 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
18 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
24 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
589 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
83 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
90 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
51 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
43 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
43 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
34 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
28 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
79 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
61 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
66 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
29 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 ...
2
votes
0answers
41 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
49 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
52 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
15 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
59 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
42 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
107 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
139 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
58 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
72 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
68 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
26 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
82 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
361 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
65 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
76 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{ ...