{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

6
votes
1answer
114 views

Macro expanding to comma separated list

I'm trying to use a macro for pgfplotstable labels but the macro is treated as a single entry of a csl rather than a csl. The Question asked in Using a macro as value of addtotoc in \includepdf ...
6
votes
1answer
185 views

How to access rows through naming or similar

I want to create a style for tables similar to \documentclass{article} \begin{document} \begin{table} \begin{tabular}{cc} A & B \\ a & b \\ c & d \\ \multicolumn{2}{l}{\emph{C}} \\ e ...
6
votes
1answer
415 views

Filter table rows for regression

I have a table containing a flag and x and y values. I'd like to have a regression for all rows with 1 in the first column. How can I do this? \documentclass{article} \usepackage{array} ...
6
votes
1answer
297 views

How to change format of xticklabel when loaded from table

I have the following code \documentclass[tikz]{standalone} \usepackage{pgfplots} \usepackage{pgfplotstable} \usepackage{filecontents} \begin{filecontents}{testdata.dat} 6.3e-05 0.8767984145412976 ...
5
votes
3answers
319 views

Fill the area under minimum of two functions using tikz and pgfplots

I am loading two curves from a file and plot them with \addplot table [...] {the table.txt}; I have managed to fill the area under a single curve, but I want the minimum of the two curves filled. What ...
5
votes
2answers
2k views

Fill area of curve above a line using pgfplots

This question is related to Fill between two curves in pgfplots. which started me of. However, I need to have just the area above the reference line filled. \begin{tikzpicture} ...
5
votes
2answers
171 views

Changing the rules of line breaks

I used pgfplotstable to read the data from a file. The columns have fixed widths. The third column contains usual text and the lines are broken nicely. The second column contains mathematical ...
5
votes
2answers
153 views

Color Management with a Family of Curves

I am struggling with following fairly simple looking problem of plotting a family of curves. \documentclass[border=1mm]{standalone} \usepackage{pgfplotstable} \pgfplotsset{compat=1.8} ...
5
votes
1answer
629 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 ...
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 ...
5
votes
1answer
76 views

plotting data from rows instead of columns in latex

How can I use the addplot table command to select data from rows to be plotted instead of columns? Thank you.. I tried that but still I got errors.. here is my script: \documentclass{article} ...
5
votes
1answer
80 views

Precision for one row only

I have an array with three rows and I would like that the last row has a specific format. There is a command every row no/.style, but it wouldn't work in our context because the processing is applied ...
5
votes
1answer
1k views

How can multiple pgfplotstable columns be used in a legend?

I'd like to plot a few sets of data using the groupplots library of pgfplots. On each plot, I'd like to add a few other pieces of data that do not change from plot to plot. So I put the plot ...
5
votes
2answers
521 views

skipping the first line of a data file for pgfplotstable

I need to skip the first row of a csv file, which is auto-generated by some magic measurement apparatus. It contains its own filename as the first line. The second line contains the column names (no ...
5
votes
1answer
50 views

pgfplotstable will not generate table

I have some data from a table that I would like to tableize with pgfplotstable. After many hours of going through the pgfplotstable 1.10 manual and basicly copying the example code with my data. Are ...
5
votes
1answer
347 views

Problems with \pgfplotstableread and relative paths

I have this folder structure in my project: main.tex mystyle.sty tex mytex.tex img myimg.tex dat mydat.dat And the following files: main.tex: \documentclass{scrartcl} \usepackage{mystyle} ...
5
votes
1answer
227 views

Create Table for a Family of Curves

Following the issue Color Management with a Family of Curves I couldn't find a proper way of creating the associated table for a family of curves. I tried to create new columns with respect to the ...
5
votes
2answers
731 views

pgfplots: Displaying a bar graph and a table from the same input file

I try to display on one Beamer slide a bar graph and a table with numbers taken from the same input file (to avoid repetition when copying the data). For now, I am stuck on this error message: ...
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
2answers
545 views

Rearrange data in pgfplotstable

I have a \pgfplotstable with data (loaded from a file) like this one: \pgfplotstableread{ s f 0.0 95.9638 0.2380665 160.565 0.511 190.435 0.705 270.435 1.0 ...
5
votes
1answer
222 views

How to make pgfplotstable read tables with macros

I want to migrate my tables to pgfplotstables. I used to have a macro for the rows of my tables, partly, because Kile used to. So currently, my tables more or less look like: oldtable: ...
5
votes
1answer
176 views

String annotations to scatter plot coming from a different file

I am trying to adapt the setup to be found in this question. to the case where the names are in a different file. The main motivation is to have the same names for several plots and to be able to ...
5
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 ...
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 ...
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 ...
5
votes
1answer
899 views

Using value of a table as color indicator for \addplot like a colormap

I am trying to use a relative value (percentage) extracted of a table to define the color of several 2D plots like this: At the moment I'm using addplot[mesh] together with a self defined colormap ...
5
votes
1answer
552 views

Horizontal table with pgfplotstable

How can I make table in pgfplotstable table form input file A B 1.0 20 1.1 21 1.2 22 1.3 23 1.4 24 looks like this one: I trying to use \pgfplotstabletranspose\loadedtable{input.dat} ...
5
votes
1answer
123 views

Table with percentage sign for a specific line

I am importing a table from a file and I would like to add a percentage sign for all figures on the third row. The code works well for a specific cell in the table using the command every row 2 ...
5
votes
1answer
175 views

Sorting a table according to values in another table

I have two tables (A and B), both with a string valued column and an integer valued column. What i would like to actually have is a sorted table B sorted by the values of table A. The crucial point is ...
5
votes
1answer
129 views

How to implement the macros style with mixed chars and floats in a csv file?

I would like to implement macros to generate multiple tables in a document. Some inspiration comes from here: usage-of-longtable-or-equivalent-and-pgfplotstabletypeset The input csv file and ...
5
votes
1answer
83 views

Assign initial value to \pgfmathaccuma

I cannot assign zero initially to \pgfmathaccuma and \pgfmathaccumb. It gives this error: ! Missing number, treated as zero. Then I press s to skip. However, \pgfmathaccumb is always empty! I want ...
5
votes
1answer
389 views

Pgfplotstable and multirow

In the following example, I'm trying to typeset a table using pgfplotstable with an every even row rule. Is there a way to deactivate it for some given columns ? Or alternatively, is there a way to ...
5
votes
1answer
108 views

Plot using pgfplots from a text file in long form (vs wide form)?

In the statistical programming language R, there are two different forms to represent data. The wide form looks like the following: subject time age weight height 1 John Smith 1 33 90 ...
5
votes
1answer
169 views

IfDecimal in pgfplotstable

I try to calculate the values of a new column errorxin a pgfplotstable on the fly with \pgfplotstableset{create on use... based on the colums error1 and error2 as error1 - error2. This works fine, if ...
5
votes
2answers
77 views

a table with cell \pm another cell using pgfplotstable

Say, i have a text file 10.0123235 5.0234324 11.2342345 6.02343256 where the first column is value and the second is a standard deviation. I am trying to figure out how to automatically put it ...
5
votes
1answer
405 views

TikZ graph not aligning

I am having two issues with TikZ pictures. I have three graphs side by side, and I am having issues, but only with some of them, which is very odd. First the x-axis is going out of alignment (some ...
5
votes
0answers
90 views

colour cells in a table according to the value

I have seen the following code in response to another similar question that works when the numbers in the table are between 0 and 100. How do I have to modify this code so that it works for numbers ...
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 ...
4
votes
1answer
331 views

Pgfplotstable one row in bold

Considering this MWE, I am looking to obtain bold style on a row. The highlight's style works on columns but not on row. \documentclass{standalone} \usepackage{pgfplotstable} \begin{document} ...
4
votes
1answer
215 views

Using dashes with siunitx with pgfplotstable

I have a table setup that is mostly numerical columns. However, there are occasionally some cells that have a blank entry, currently the in the excel csv file output as "---". Everything worked ...
4
votes
1answer
516 views

reading and processing data in pgfplots

I have a standard text file, two columns, space separated, containing x and y data to be plotted. I want to plot x vs -y, i.e. plot(x,-y). In general, how do you read your data and plot a function ...
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 ...
4
votes
2answers
345 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} ...
4
votes
1answer
562 views

Show last N rows from input datafile only in \pgfplotstabletypeset

I would like to limit the rows in \pgfplotstabletypeset to the last N rows. I can skip rows by doing this: \pgfplotstabletypeset[skip rows between index={0}{4}]{file.data} But this only works if I ...
4
votes
3answers
165 views

Pgfplots - How to deal with special characters in data files?

I have a file which contains column headings such as AAA-BBB or something to the effect of CC_DD_8734-20°. How should I deal with this if I just want to use such a file? Or should I prepare each set ...
4
votes
1answer
135 views

read table from file , each row different number of columns

I have a data file where each row has a different number of columns, like this: x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x ...
4
votes
1answer
63 views

Expanding a macro into a long list for use with pgfplotstable

Failing again to get macros to work. I have the following M(n)WE \documentclass[10pt]{article} \usepackage{pgfplotstable} \begin{document} \xdef\mydef{ \foreach \a/\b in ...
4
votes
1answer
187 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, ...
4
votes
1answer
460 views

Putting multiple columns from csv file into single column while printing the table using pgfplotstable

Reference: My question which was answered by Dr. Christian Feuersänger Link to the question.. This is a follow-up question. The MWE (Provided by Dr. Christian Feuersänger in his answer) ...
4
votes
1answer
697 views

Long table and pgfplotstable with multiple data files

I have two csv files: namespgf.csv Sl. No., Reg. No.,Name,Category,Group,Gate,Sponsored,Department 1,MS001,Ajay-D-Vimal Raj P,PY,OBC,--,No,Physics 2,MS002,Harish Kumar,PY,GE,GATE,Yes,Physics ...