{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

5
votes
1answer
85 views
+100

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 ...
0
votes
1answer
20 views

pgfplotstabletypeset with the use of multirow and the vertical line problem

Please bear with my clumsy codes here. I am using multicolumn and multirow to custom-made a header but are having trouble. I will use an example csv file to illustrate what I am trying to do. My csv ...
3
votes
2answers
49 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
1answer
87 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, ...
1
vote
2answers
59 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
112 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
32 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
93 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 ...
4
votes
2answers
104 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⁻⁷” ?
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
29 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
30 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
46 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 ...
2
votes
1answer
82 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. ...
13
votes
5answers
452 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 ...
2
votes
3answers
173 views

Wrong placement (and/or size) of picture / plot with groupplot of table (… and discontinuity)?

Consider this MWE: \documentclass{article} % \documentclass{standalone} \usepackage{pgfplots} \pgfplotsset{compat=1.5.1} \usetikzlibrary{pgfplots.groupplots} \usepackage{pgfplotstable} ...
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
45 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 ...
1
vote
1answer
45 views

Pgfplotstable and etoc don't recompile

My document compiled normally, but it seems that there is an incompatibility between the packages etoc and pgfplots. The latex compiles, but not to recompile to get the references and the table of ...
3
votes
0answers
27 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 ...
2
votes
0answers
61 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 ...
4
votes
1answer
84 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 ...
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
83 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
38 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
27 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
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
131 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
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 ...
1
vote
0answers
84 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 ...
6
votes
1answer
118 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 ...
5
votes
2answers
1k 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 ...
4
votes
1answer
102 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 ...
1
vote
0answers
77 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 ...
5
votes
2answers
367 views

How to plot the graph below?

May I know how to draw the graph as shown below? below is a code I have try but with look and feel that is quite far away from the example: \begin{tikzpicture} \begin{axis}[ legend pos=north ...
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
81 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
112 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
76 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
104 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 ...