{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

2
votes
0answers
651 views

pgfplotstable error: missing \endcsname inserted [closed]

I'm getting strange errors with pgfplotstable: \documentclass{article} \usepackage[utf8]{inputenc} \usepackage[T1]{fontenc} \usepackage{pgfplots} \pgfplotsset{compat=1.7} ...
8
votes
2answers
156 views

The index of head row doesn't begin with 1

This seems a very simple question, but I cannot find an answer. I have a very simple CSV file and I want to make a LaTeX table from it. tiny.csv -1, 1, -1, 1 2, 4, 6, 8 3, 9, 27, 81 LaTeX file ...
3
votes
1answer
113 views

Sorting according to more than one key in pgfplotstable

Is it possible to sort rows of a pgfplotstable according to multiple keys? For example, input file is as follows: Mtx Kind P Sp A LP 16 4.2 C OPT 16 72.5 A LP 64 20.3 B OPT 16 ...
0
votes
1answer
185 views

Stacked chart in TeX (added up line loads)

I've got a problem with finding the correct way or commands to make a nice plot in TeX, even with some basic experience in pgf/TikZ. Imagine a weight distribution with start- and stop values and a ...
3
votes
2answers
227 views

line-breaking inside multirow environment in a pgfplotstable

I want to combine two string columns into one column. The contents of the columns should be in two lines, i.e., first column's content must be in the first row of the combined column and second ...
11
votes
2answers
438 views

pgfplots: get color setting from table

I want to plot multiple lines using pgfplots. Each of the lines should have a color, depending on the group it belongs to. In the example attached, a table is provided, containing all the ...
3
votes
1answer
477 views

Double row heading in pgfplotstable

Good day all! I store tables on CSV files and use pgfplotstable package to call the files. This works fine but I have a challenge. I need to bring the units in bracket (i.e (MeV) and (mb/MeV/sr) ...
4
votes
1answer
119 views

Parametrized Column Names for Pgfplotstable inside a Macro

I use same table format for several data files, so I have written a macro named \tableMacro. The problem is: I need to include different columns in different tables. I want to parametrize columns={} ...
1
vote
1answer
106 views

using data column as “axis” in table with pgfplotstable

I'm new to pgfplots/pgfplotstable and got the following problem. I got a datafile like the following I use for plotting with pgfplots: P1 P2 Value 1 1 0.00000000000e+00 1 2 1.00000000000e-02 1 3 ...
5
votes
1answer
746 views

Plotting functions with parameters from an external file using gnuplot/pgfplots/pgfplotstable

If I have a table, how can I get the table values and use them as parameters for plotting in pgfplots in gnuplot? In particular, how can multiple curves be plotted with the same functional form from ...
4
votes
1answer
366 views

PGFPLOTS coordinate filtering as a style?

I am using pgfplots to make plots for my thesis, and I have many scatter plots that I want to have consistent formatting. I am controlling the shape and color of the scatter plot marks with two ...
6
votes
1answer
570 views

pgfplotstable: Conditional post-processing of cell content on a per-column basis

I am trying to add an asterisk to the content of certain cells depending on the cell's content (essentially, adding a marker for significant p-values) but I am having trouble trying to do so on a ...
4
votes
1answer
215 views

Using Hashtag in macro

I had a problem putting the column headers in bold (in a table of course) using pgfplotstable. You can see the problem here I found a way to work arround that. It isn't generic as I wanted it to be, ...
10
votes
1answer
184 views

Is there an easy way to change the column order of a pgfplotstable?

I am aware of Rearrange data in pgfplotstable but I was hoping for a kind of one-pass solution that doesn't spread the table over so many commands but is rather self-contained within ...
6
votes
1answer
1k views

Filter rows from a table

I have a large table that contains results for many instances, and I want to make separate tables and plots grouped by one (or more) field. In this minimal working example, I want to make a table and ...
2
votes
2answers
1k views

Can't load file for bar plot

I have the following: \documentclass{article} \usepackage{pgfplots} \usepackage{pgfplotstable} \usepackage{filecontents} \begin{filecontents}{testdata.csv} Probe Mittelwert ...
2
votes
0answers
445 views

How to use tikzexternal? [closed]

I use some huge file to plot and for this I changed the tex conf file to increase memory that works. But I would like use instead external memory for this I try to use tikzexternal. But I fail. MWE ...
5
votes
0answers
153 views

How can I create a 3D Manhattan bar chart? [duplicate]

I have some data which I would like to visualize. This data are 3-tuples of integers: (Threads,Sum,# of occurences) (1,2,20) (1,7,18) (1,100,25) (2,7,15) (4,103,24) I would like to visualize this ...
2
votes
0answers
181 views

elementwise division of two columns loaded from different files [duplicate]

My next question follows on Sum up rows from different data files where I asked how to sum up the data from different files. In this case I have e.g. two data files, consisting of m (here e.g. m=3) ...
9
votes
1answer
679 views

Heatmap of a triangular matrix (or a sparse matrix)

So let me first of all shamelessly steal heatmap code from this answer to Drawing heatmaps using TikZ \documentclass{standalone} \usepackage{colortbl} \usepackage{pgfplots} \usepackage{pgfplotstable} ...
7
votes
3answers
998 views

Write a column selectively to the appropriate row using pgfplotstable?

Description: I have a .csv file named namespgf.csv Reg.No.,Name 5501,Kathirvelu A 5502,Gugan K 5503,Kalaitchelvi S 5504,Suresh S 5505,Mahesh K and another .csv file named markspgf.csv number,marks ...
4
votes
1answer
204 views

Aligning Tuples of Decimals with PgfplotsTable

In this question, Jake gave an awesome answer that shows how PgfplotsTable can be used to read tab-delimited data from a file, and typeset the parsed decimals in scientific notation such that all of ...
5
votes
1answer
705 views

how to create an histogram with a string label using pgfplots?

Dear i try to generate an histogram / barplot result.csv: overlap,hit,organism 100,274,Unknowns 100,228,Coccomyxa subellipsoidea 100,11,Eukaryota -500,153,Unknowns -500,145,Coccomyxa subellipsoidea ...
6
votes
1answer
921 views

How to expand linear regression fit to the full x-axis range while using semilogyaxis

Since I was asked in another post: Trend line or line of best fit in pgfplots to ask this question explicitly, I'm now doing so: How can I expand the linear regression fit, generated with for ...
5
votes
1answer
962 views

Log axis in pgfplots

When I add the log ticks with fixed point option, pgfplots ignores the x-axis range instead of just affecting the y-axis. without log ticks with fixed point with log ticks with fixed point ...
4
votes
1answer
808 views

Trend line with pgfplots and dateplots

Is there an easy way to avoid the following pretty straightforward error message at compile time: Could not parse input '2010-01-01' as a floating point number, sorry. The unreadable part was near ...
9
votes
1answer
330 views

Sum up rows from different data files

I've a certain amount of inputfiles (.txt) for the final definition of the y-data of my axis environment. The x-data come from a different file. The goal is to sum up each row of the input files ...
2
votes
0answers
27 views

Problem printing some symbols accurately from a pgf plot table [duplicate]

Possible Duplicate: Why do the less than symbol (<) and the greater than symbol (>) appear wrong as upside down exclamation or question mark? I'm trying to print symbols from my pgf ...
1
vote
0answers
249 views

scaled y ticks=false don´t work together with loglogaxis? [closed]

I´ll like to remove the multiplier on the y axis. My wish is to get somethings like, 0.001, not 1.10^-3. Can somebody help me please ...
0
votes
1answer
419 views

How to Reference a pgfplotstable

I am still generating a table from a cvs file with the pgfplotstable package. In my text I will reference to the generated table but I did not know how to do this. Normal your make a \label{tab:foo} ...
1
vote
1answer
285 views

How to vertically align text in the headers of a PgfplotsTable?

I am stacking one header by using this macro: \newcommand*{\textstackrel}[2]{\ensuremath{\stackrel{\hbox{#1}}{\hbox{#2}}}}. This makes the other single line headers bottom aligned, which looks bad. ...
2
votes
2answers
337 views

pgfplotstable line usage and wrapping

pgfplotstable seems ideal for incorporating CSV data into a table automatically. I'm however having trouble with lines (they won't merge with headers, and I can't seem to get them to work at the ...
6
votes
1answer
334 views

Create square and custom size cells in a table using pgfplotstable

I'm trying to create something like a confusion matrix of several classes. Thus, I want to display only the shades of the values. I manage to do it using this: \documentclass{article} ...
3
votes
1answer
175 views

Float pgfplotstable to right of text

I want to float a smaller table to the right of my text. Here is an example of the code: % Example Table \documentclass{minimal} \begin{filecontents*}{scientists.csv} name,surname,age ...
8
votes
2answers
260 views

Reference table value in text

I want to be able to reference a table value in my text (this is because I often update my tables, and then list the specific values in the text). Here is an example table I would use: % Example ...
0
votes
1answer
179 views

Align right in table if no expression

I am using pgfplotstabletypset to read in a table -- I want all cells in the first column with the expression Factor in them to be aligned to the left and bolded, and I want all cells without that ...
4
votes
1answer
1k views

Caption with longtable and pgfplotstabletypeset

The 'longtable' documentation says to use \caption{Your caption here} for captions, but I can't see where to specify the 'longtable' options in the example where pgfplotstabletypeset and longtable ...
3
votes
1answer
115 views

Multiple multicolums table making the first row of data disappear. Also need tips on making it better looking

Following this question: Multiple Multi columns with pgfplotstable The first row of my data gets messed up somehow, here's the code: \documentclass{article} \usepackage{booktabs} ...
3
votes
1answer
695 views

Multiple Multi columns with pgfplotstable

I've already seen these two questions: Create a contingency table using pgfplotstable and Dec sep align & \multicolumn incompatibility? and I'm still not able to do what I want. I rarely use ...
4
votes
2answers
1k views

Undesired quotes around values in table (pgfplot)

I am saving tables using write.table in R using the following code: x <- rnorm(100) y <- rnorm(100) z <- rnorm(100) model <- z ~ x + y results <- glm(model) pe <- ...
7
votes
2answers
280 views

How to keep hue from going beyond 300° in xcolor/pgf? (Doing math in pgfplotstable)

Ok, this is probably an incredibly trivial question for anyone who knows more about xcolor or pgf or TikZ or whatever really. I tried to use a hue scale for a heat map/color matrix with values ...
3
votes
1answer
284 views

Pgfplotstable adding a growth column without column names and then offsetting it

I'm trying to create a new column in a pgfsplotstable which shows the compound growth over the preceding columns. The columns don't have names, and I want to shift the column a little to the right to ...
6
votes
1answer
251 views

Plots only logarithmicly spaced samples

I have a data file with many entries, order of 10000. I want to plot them all with lines, and a small subset of them with points and error bars (can not plot error bars on 10000 samples). Plotting ...
12
votes
2answers
306 views

A macro to typeset a difficult table

The following table was created with the following LaTeX-code (mwe): \documentclass{article} \usepackage{tabu} \usepackage{multirow} \begin{document} \newtabulinestyle{stip=on 1.5pt off 2pt} ...
6
votes
1answer
805 views

Pgfplotstable without headings row

I would like to typeset a table with a multicolumn heading only. Here is my current attempt \documentclass{article} \usepackage{pgfplotstable} \usepackage{booktabs} \usepackage{array} ...
8
votes
2answers
454 views

How to draw multiple Rectangles from input data file

I want to draw set of rectangles on axis based on input file. My .tex file should be some thing like that \documentclass{article} \usepackage{tikz,pgf} \usetikzlibrary{plotmarks} ...
5
votes
1answer
88 views

Extracting source from pgfplotstable

I like using pgfplotstable because I can feed data in tables directly to it and generate a latex table. However, not all of my coauthors have the right packages to compile pgf-enabled latex. Since ...
3
votes
1answer
368 views

Filter by value when reading and calculating data using pgfplotstable

I am trying to plot data from a file, using pgfplots for the plot and pgfplotstable to read in the data and calculate a new column (cummulative values from another row), which is plotted as well. My ...
2
votes
1answer
154 views

Formatting a custom column in pgfplotstable

Following up on my question on PGF custom columns I've successfully created a column but now I'm struggling to format it to fixed, two digit precision. This seems a little hair trigger in terms of ...
4
votes
1answer
242 views

pgfplotstable: two columns into one but removing text (keeping numbers) from new column

Question: This is a followup up to pgfplotstable: Two columns into one with numeric data, but can't round. Except this time, I have some text throughout the mean and sd column and would like to ...