{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
280 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
303 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
155 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
152 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
594 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
138 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
66 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
504 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
331 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
226 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
699 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
564 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
538 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
217 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
169 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
993 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
296 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
879 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
530 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
121 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
166 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
126 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
81 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
373 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
106 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
168 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
72 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
393 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
1answer
404 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} ...
5
votes
0answers
83 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
157 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 ...
5
votes
0answers
148 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
314 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
208 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
469 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
125 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
338 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
550 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
145 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
133 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
62 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
181 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
455 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
683 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 ...
4
votes
2answers
92 views

How to eliminate a annoying amount of white space between bars in bar plot?

I have removed one row of data from a file, but I cannot find way to get rid of the white space in the center of the plot. Reducing the width moves the bars outside of the graph, and the only way to ...
4
votes
1answer
108 views

pgfplotstable: Why does `postproc cell content` not work properly when used within a style?

I use pgfplotstable and want to post-format a specific column. Among other things I need to duplicate its content. My problem is that postproc cell content works fine as a direct parameter to ...