{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
0answers
149 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 ...
9
votes
1answer
575 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} ...
2
votes
0answers
180 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) ...
4
votes
1answer
182 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
575 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 ...
5
votes
1answer
631 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 ...
8
votes
1answer
285 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
26 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
221 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 ...
4
votes
1answer
691 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 ...
0
votes
1answer
269 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
240 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. ...
3
votes
1answer
356 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) ...
6
votes
1answer
274 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
152 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 ...
12
votes
2answers
2k views

Stacked bar plots with several descriptive nodes

I have a stacked bar plot where I would like to display additional information for each bar—besides their cumulative values. This information should include the non-cumulative values and the ...
2
votes
2answers
272 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 ...
8
votes
2answers
212 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
155 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 ...
8
votes
3answers
610 views

Is it possible to make a pgfplotstable smaller? Reduce spaces and maybe draw vertical lines between columns?

My table is too big and won't fit a page, so I wanted it to be a little smaller. Maybe reduce spaces between each column and draw a line instead. Adding column type/.add={|}{}% results in '|c' ...
2
votes
1answer
942 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
106 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
543 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 ...
7
votes
2answers
252 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 ...
4
votes
1answer
169 views

Pgfplotstable converting zeros to — in a knitr inline table

how do I change each 0.0 to -- without having to reference each as string type or making the whole table string type? The actual table is quite long and it would take too long to do it manually. For ...
5
votes
2answers
301 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 ...
12
votes
2answers
285 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} ...
3
votes
2answers
838 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 <- ...
8
votes
2answers
401 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
85 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 ...
6
votes
1answer
233 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 ...
3
votes
1answer
300 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
144 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 ...
3
votes
1answer
259 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 ...
4
votes
1answer
207 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 ...
5
votes
1answer
148 views

How to display every 4th row in a large data file using pgfplotstable?

Question: I am trying to select certain rows, similar to this question Selecting rows to be displayed with pgfplotstable, however I am not sure how I would go about doing it. I want to display only ...
2
votes
0answers
268 views

pgfplotstable an caption below data [closed]

I'd like to have a pgfplotstable with the caption below the data, just like with a regular table: \begin{table}[h] \centering \begin{tabular}{lccc} A & 3 & 4 & 6 \\ B & 4 & ...
2
votes
1answer
326 views

Adding a knitr table from R into a \pgfplotstableread statement

I'm trying to get a table from R into a pgfplotstable to edit for printing. the r code is \documentclass{article} \usepackage{pgfplotstable} \begin{document} \pgfplotstableread[format=inline,row ...
8
votes
2answers
202 views

What is wrong with this TeX macro

Still soldiering on with trying to learn these macros. Can someone tell me why this isn't working? The macro \mycline{n-n} is supposed to expand to \cmidrule{1-1} ... \cmidrule{n-n}, but in my code ...
4
votes
1answer
305 views

How to align \vrule partial vertical lines in a pgfplotstable

I had a look at this post on Misaligned multicolumn but it doesn't really solve my problem. I have the code below which is supposed to produce a table with a blue line for the first row and red lines ...
6
votes
1answer
228 views

pgfplotstable: Two columns into one with numeric data, but can't round

Question: Relates to the question posed here. I have made one column from two, but I would like to round the numbers off from a precision of 4 to 2. How do I do that? Here is the MWE: ...
4
votes
1answer
126 views

Using #1 literally in a macro

In this post I found some working code that I am now using quite frequently: \documentclass{article} \usepackage{pgfplotstable} \begin{document} \pgfplotstableread{ num value 1 2 ...
1
vote
0answers
2k views

Creating .dat files and reading a .dat file in pgfplots [closed]

The first question I have, is about creatinga .dat file in Mac. How can I create a file containing columns of data with .dat format in Mac OS Lion? What I did was to create the file using TextEdit, ...
3
votes
1answer
157 views

Macro to outline a cell in pgfplotstable

Still struggling with the \expandafter and \noexpand tex macros. I'm trying to put a table together using pgfplotstable. In this case the code is something like \documentclass{article} ...
10
votes
2answers
1k views

pgfplotstable: How to access column name?

I have used \pgfplotstableset to assign column names in the preamble. However, I don't know how to access them. \documentclass{article} \usepackage{amsmath} \usepackage{pgfplots, pgfplotstable, ...
3
votes
1answer
379 views

pgfplotstable selecting numeric columns or multiple columns by index

Hi two questions in one: I haven't been able to figure out the answer from the manual: I have a table of data with strings in the first column: I'd like to apply some key-values (e.g. fonts by ...
4
votes
2answers
346 views

How to rotate head row cell entries of pgfplotstable

How am I able to rotate the first entries of a table with pgfplotstable? I have the following table and want to rotate the descN labels in the first row. \documentclass{article} ...
3
votes
2answers
261 views

adding row numbers to a pgfplotstable

I've had a look at the attached answer Automatic table row numbers but I'm not sure how to apply it to pgfplotstable. I'd like to get automatic rownumbers on my table so I can apply formatting by row ...
4
votes
1answer
136 views

How to use pgfplotstable's iflessthan key

pgfplotstable offers the iflessthan key to define a custom comparison function: /pgfplots/iflessthan/.code args={##1##2##3##4}{<...>} I just don't know how to use it, there's no example in the ...
3
votes
1answer
223 views

A macro for looping through a pgfplotstable set by cell

Hi following on from the following question on multi-line headers with pgfplotstable, the solution was to set each affected cell individually. I decided to throw together a command to do that but keep ...