{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

3
votes
2answers
46 views

row index of first non-zero element in pgfplotstable

I am using the "functions" \findmin and findmax from here quite much to dynamical format and set plots from CSV data I read in. In the same vein, I want a function \findFirstNonZeroIndex, which ...
2
votes
1answer
24 views

How can I “force” pgfplotstable to be under a heading

Due to a recommendation on this board, I have decided to use pgfplotstable in my lab reports to import data from a CSV and print it out as a table in LaTeX. However, in a section such as my ...
1
vote
2answers
56 views

Text halfway a line using coordinates in an axis environment

I want to denote text halfway a line in an axis environment. Here's a minimum working example: \documentclass{article} \usepackage{currfile} \usepackage{filecontents} \usepackage{pgfplots} ...
7
votes
2answers
111 views

Printing an array of numbers into multiple columns

I have 100 numbers and I want to print the numbers in multiple columns in one page like: 1 11 21........91 2 12 22........92 3 13 23........93 4 14 24........94 5 15 25........95 6 16 26........96 7 ...
2
votes
0answers
31 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 ...
6
votes
1answer
91 views

Ignore commas in fields in TSV file

I'm importing data from a tab-separated values file. Unfortunately, there's a comma in one of the fields: between the surname and firstname. How can I ignore the comma when the file is imported so I ...
1
vote
1answer
85 views

2D histogram from a single row of a table, with discrete axis

I am trying to make an animation from a table that contains a row for every frame (year) where the rows are a 9x7 matrix unzipped: Date, Row1Col1, Row1Col2, ..., Row9Col7 1864, 0.65, 0.01, ...
2
votes
1answer
42 views

\pgfplotstableread dynamically create loaded table macro from \pgfplotsinvokeforeach key

I am trying to load a whole lot of CSV's using \pgfplotstableread and dynamically assign them a macro name from a \pgfplotsinvokeforeach loop. I tried \csname but suspect this is totally the wrong ...
2
votes
0answers
27 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 ...
1
vote
0answers
32 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 ...
2
votes
1answer
29 views

manually inserting row lines when inputting csv to latex

I am making a long table for a paper appendix that spans multiple pages. I would like there to be no lines marking each row, except to designate sections. The only way I have figured out how to do it ...
0
votes
0answers
42 views

pgfplots error: could not read table file

I can not read tables using pgfplotstableread. A mwe is \documentclass{article} \usepackage{pgfplots} \begin{document} \pgfplotstableread{ a b 0 1 }\datatable \end{document} I get the error ...
4
votes
2answers
103 views

Don't display the leading mantissa 1 in power of tens (with pgfplotstable)

In pgfplotstable, how can I display “1e-7” as “10⁻⁷” instead of “1⋅10⁻⁷” ?
13
votes
5answers
451 views

Coloring negative and positive numbers automatically

I believe numprint.sty is not working. at least the manual states that Printing negative numbers in red does not work. Only the minus sign is printed in red. When was this bug introduced? Some ...
0
votes
0answers
30 views

how to do a very Front page with Special Tables? using cropmarks? help!

how to do a very Front page with Special Tables? using cropmarks? help! Is there a better way insted use word? and how to insert a footnote with a special format? Could you guide me? Thanks in ...
2
votes
1answer
32 views

How to grant consistency of number formatting with pgfplotstable?

I am trying to format a series of tables, containing texts and numbers, using pgfplotstalble, for a technical document targeting a european audience, therefore I need the comma as decimal delimiter ...
2
votes
1answer
51 views

“skip coords” and “xticklabels from file” cause wrong labels

When filtering data from a file (with skip coords between index for example) and loading the x tick labels from the same file, the x tick labels are not skipped, leading to wrong labels. As an ...
0
votes
1answer
44 views

Extra spacing in cell using \pbox in \pgfplotstabletypeset

I am using a straight-forward \pgfplotstabletypeset. Because I wanted to insert a manual break in one of the cells to decrease the width of that cell, I added a \pbox as suggested in ...
3
votes
0answers
26 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 ...
4
votes
1answer
83 views

Defining a variable in Tikz and using it in a table

I read the page Define a variable in TikZ about how to define a variable in tikz, but I am trying to then put these values in a table and getting errors. It seems latex is not remembering the white ...
2
votes
0answers
56 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 ...
3
votes
1answer
32 views

Using siunitx and pgfplotstable removes header when used as a style

I'm following the solution presented here. However, for some reason when I used the code as a style defined in pgfplotstableset the header disappears. How can I fix it? \documentclass{article} ...
1
vote
0answers
80 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
37 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 ...
3
votes
1answer
25 views

pgfplotstable with multirow

How can I use pgfplotstable with multirow to create a table with a column in which every cell spans 3 rows. \documentclass{article} \usepackage{pgfplotstable} \usepackage{multirow} ...
2
votes
1answer
80 views

Linear Regression with symbolic x-coordinates

I have been having difficulty with this problem for a few days now so I'm hoping you can come to my aid. I am trying to create a line of linear regression for a very small chart using pgfplots. ...
2
votes
1answer
20 views

Perform column operations on pgfplotstable

Can you use pgfplotstable to perform operations on columns? For example, I have \documentclass{article} \usepackage{pgfplotstable} \pgfplotstableread{ x y 4 2.50000000e-01 16 6.25000000e-02 64 ...
3
votes
1answer
48 views

`pgfplotstable`, table overlapping graphic

I have a pgfplots graphic in a pgfplotstable, and a part of the graphic is overlapped by the table like you can see in this picture: The 800 at the top is cut by the tabular border. Here is a MWE: ...
1
vote
1answer
130 views

Use specific “col sep=&” with \pgfplotstableread{⟨file name⟩}{⟨\macro⟩}

I would like to make one table that consist of data (Columns) from multiple (7) input files. I know for a pgfplot this can be done by simply loading data from different sources into one graph. I have ...
3
votes
1answer
82 views

How to change \pgfplotstableset for different parts of a document?

In the documentation for the pgfplotstable package you can find the following in the introduction: Key-value pairs can be set in two ways: As default settings for the complete document (or ...
1
vote
0answers
82 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
59 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 ...
4
votes
1answer
101 views

trend line in pgf plot

I have been trying to fit a trend line using pgf plot for my data and unfortunately can't seem to hit the right spot with the code. I have looked in the manual for examples of linear regression and ...
6
votes
1answer
117 views

pgfplotstable: postprocessing cell with math formula

I have the following csv file: 0.000000000000000000e+00 -2.485778083899142232e-01 -6.775462378935208640e-01 1.687203134856525066e+00 2.019105909655298348e+00 1.000000000000000000e+00 ...
1
vote
0answers
76 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 ...
0
votes
0answers
87 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 ...
2
votes
1answer
64 views

Create a new pgfplotstable that is a subset of another pgfplotstable

I'm using pgfplots to plot a data set, and I want to add a local regression line for a subset of the data. I'm able to calculate the regression line and plot if for the subset, but pgfplots is still ...
4
votes
1answer
76 views

Name pgfplotstable Column within foreach loop

I recently stumbled over pgfplotstable and its ability to process table information and create new columns. To hone my skills, I tried to create a script that would calculate an exponential smoothing ...
1
vote
0answers
41 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 ...
6
votes
1answer
111 views

How to recreate this graph?

I'm quite new to drawing graphs. I have the following table: \begin{tabular}{rrrr} \firstrow Frequency/[Hz] & $V_{pp}$/[V] & $V_{rms}$ DMM/[V] & $V_{rms}$ scope/[V] \\ 50 & ...
0
votes
0answers
31 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. ...
4
votes
1answer
75 views

pgfplotstable - How can I stack the columns from a data file under one another?

I'd like the columns ColHead6--ColHead10 to be put under the first set of five columns (of course with the first column on the left once again). How can I do that? And could I use ...
3
votes
0answers
102 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
1answer
85 views

Conditionally use bold font for table cell with pgfplotstable

I am trying to conditionally use bold font for table cells with values according to a condition. It works nicely with changing the text color as illustrated in the example below, but I am not able to ...
1
vote
0answers
94 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
1answer
47 views

Avoid multiple entries of caption in list of tables using pgfplotstable with longtable

I'm using pgfplotstable to display data from .csv files and it happens that displayed tables break over three pages. The problem is, that for every page an entry is placed into the list of tables. ...
2
votes
0answers
23 views

pgfplots: plot data table until n-th line [duplicate]

Is there a way to plot only the first n-th lines of a data file using pgfplots? Currently I'm plotting the whole csv-file using (MWE): \documentclass{article} \usepackage{pgfplots} ...
3
votes
0answers
26 views

Use data from other multiple data files with calculations [duplicate]

This answer shows nicely how to use data from another file while plotting data using \addplot table. However, when trying to access the create on use column using \thisrow{}, an error occurs. For ...
2
votes
0answers
103 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: -- ...
6
votes
2answers
150 views

How to create a column that depends on another created column in pgfplotstable?

In the following MWE, I'm trying to create one on use column based on the definition of another on use column. PGF generates an error in this case: PGFPlots: reading {test1.dat} PGFPlots: reading ...