{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

0
votes
0answers
52 views

Pgfplot with two ordinates y tick base position [duplicate]

Possible Duplicate: position of axis multiplier and one other I have a plot with two ordinates. The tick base for the "right" y-axis is "10^-3". However, the "*10^-3" is placed on the left ...
3
votes
1answer
126 views

Replace Column in PGFPlotstable with lookup values

I have a table that has a column of integer values representing atomic numbers. I know of the command: string replace={---}{\textemdash} However this is table-wide. I want to match the values in a ...
6
votes
1answer
676 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
370 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} ...
4
votes
1answer
184 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 ...
2
votes
1answer
274 views

Manually add a literal column to a table loaded from a file

I would like to use pgfplotstable to typeset some numbers stored in a text file. I have used \pgfplotstableread to achieve that and it worked all right. Now I want to add a column to the said table ...
3
votes
1answer
284 views

column separator in header line in column with dec sep align

I'd like to have a column with vertical bar separators. When I set the number format to 'dec sep align' the vertical separators disappear. Here is a MWE: \documentclass{article} \usepackage{array} ...
3
votes
2answers
174 views

Adding a x tick but not the corresponding y tick

I'm generating pgf plots on the fly and I would like to avoid adding non integer y ticks on my plots, while keeping all the x ticks. Here is a MWE: \documentclass[10pt]{article} \usepackage{tikz} ...
6
votes
2answers
1k views

Compiling a document with PGFplots processing only every x-th data point? [duplicate]

Possible Duplicate: How to select a finite number of samples from the file when plotting using pgfplot Compiling my document with many PGF Plots, each containing thousands of data points ...
3
votes
1answer
541 views

How to plot coordinate between two xticks?

I want to plot some data using pgfplot. Here is a code I have written: \documentclass{article} \usepackage{pgfplots} \pgfplotsset{compat = 1.3} \begin{document} \begin{tikzpicture} \begin{axis}[ ...
6
votes
1answer
541 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} ...
2
votes
1answer
288 views

pgfplots: how to check if addplot filters all data

is there an easy way to check if a \addplot(+) table [...] command in PGFPLOTS has any drawn any points? The reason is that I want to process the data dynamically, and if the plot is empty, the legend ...
3
votes
1answer
722 views

edit x-y data from different files/tables

I've two one column data files (A.txt and B.txt). To plot them together first I load dataA with \pgfplotstableset{ create on use/dataA/.style={create col/copy column from table={A.txt}{0}} } Then I ...
9
votes
1answer
886 views

How can I filter/select data (float, text) from a table and plot it?

Note I post this question in addition to a recent question (see below) with a more detailed description of the problem: This was the original question: How can I filter/select data from a table and ...
7
votes
1answer
2k views

How can I filter/select data from a table and plot it?

I have a table with data from a file and before anything, I sort the data. Then I would like to filter only the rows that have a specific value. There has been a similar question which almost contains ...
9
votes
1answer
361 views

Pgfplotstable: how can I add percent signs (and respect dec sep align)?

My data contains a column with numbers like 0.01 or 0.9412 which I want to display as 1.00% and 94.12% . I would like to declare the column by means of dec sep align. How can I do that? [This ...
3
votes
1answer
286 views

Pgfplotstable. How to exclude one row from sorting scope?

I am a beginner in LaTeX, experimenting with industrial documents. I cannot find the suitable code to solve some of the problems below: I would like to be able to sort the table, but excluding the ...
11
votes
2answers
599 views

PGFplotstable: Is it possible to set a number format for a *row* instead of a column?

Using pgfplotstable, it's straightforward to set a column number format using columns/(columnname)/.style={(format)} What I would like to do is change the number format of a particular row. In my ...
4
votes
1answer
227 views

indent some first-column words in a table using PGFplots

I'm trying to indent some of the words in the first column of a table using PGFplotstable. I can't figure out any other way to do this other than to put 4 spaces in front of the word. Unfortunately, ...
7
votes
3answers
857 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 ...
8
votes
1answer
757 views

pgfplots need help with complicated stacked bar chart using selected rows from data table

I'm trying to recreate this bar chart from the data table found in the MWE below. It involves doing a couple things that I can't figure out: stack positive and negative bars on the same axis, ...
4
votes
1answer
429 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
640 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 ...
2
votes
1answer
397 views

Create a ybar interval from given bar widths

I am collecting data using the NASA Task Load Index, which gives 6 scales and has a weight associated with each scale. I am trying to plot the mean value for each scale using a ybar interval graph, ...
7
votes
1answer
658 views

Calculate and draw difference of two plots automatically

I'm trying to automatically generate a plot, which visualizes the difference of two other plots. The input source is a single(!) file. The data is filtered by one column with /tr/rowfilter. Here is an ...
8
votes
1answer
1k views

Create a contingency table using pgfplotstable

I'm trying to create a general pgfplotstable style for displaying contingency tables (the below example being taken from Wikipedia) of any sort but I am having trouble computing the totals for each ...
7
votes
1answer
552 views

Aligned pgfplots in beamer frames

I would like to reproduce the design represented in the following picture with Beamer an Pgfplots. Namely, I want the size of plotting area to be always the same size and have the same position ...
5
votes
1answer
160 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 ...
12
votes
1answer
853 views

Plot x y data from different files/tables

I have two data files (xxxx.txt and yyyy.txt), each only containing one column of x and y data respectively. Now I want to plot these two data together in a simple 2D diagram. Has anybody an idea how ...
3
votes
1answer
174 views

PGFPlot two \pgfplotstableregressiona

Hi i have two plot with two linear regression but the legend show the same equation for the straight line... i have not made a MWE because I thought that does not serve. Is needed? ...
2
votes
1answer
304 views

How can I add another plot to the \addplot command in PGFPlots?

My goal is to add another plot to the \addplot command and this small example hopefully shows what I'm trying to do: \documentclass{standalone} \usepackage{pgfplotstable} \begin{document} ...
11
votes
1answer
2k views

How to use a string column with pgfplotstable to label datapoints in a pgfplot?

I have a comma-separated list of data points. They should be plotted as a scatter plot, and should be labeled using data from the .csv file. Having specified the first column of my file as string ...
5
votes
1answer
781 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
419 views

Pgfplots remove darker borders on marks

Hi is possible remove the darker borders on marks indicated from the arrow ? Thanks \documentclass[a4paper,12pt]{article} \usepackage{pgfplots,pgfplotstable} % Grafici ...
6
votes
2answers
471 views

PGFPlots colored regression legend

how can i have this legend? in this plot: \documentclass[a4paper,12pt]{article} \usepackage{pgfplots,pgfplotstable} % Grafici \pgfplotsset{/pgf/number format/use comma,compat=newest,% ...
1
vote
1answer
172 views

PGFPlots: strange behaviour

Look at the differences between the following two plots. I would like to have in plot "1" the same distances between the colorbar, axis labels and the ticks labels that I get in plot "2". How can ...
3
votes
1answer
344 views

PGFPlots staggered axis

Why in this plot the axis are all staggered ? \documentclass[12pt,% % corpo del font principale a4paper,% % carta A4 % ...
2
votes
1answer
1k views

Distance of the axis labels Pgfplots

Why this options change the distance of the axis labels in this plot ? \pgfplotsset{/pgf/number format/use comma,compat=newest,% width=12cm,% height=9cm% ...
2
votes
1answer
345 views

Pgfplots two datatable in the same document

\documentclass[a4paper,12pt]{article} \usepackage{pgfplots,pgfplotstable} % Grafici \pgfplotsset{/pgf/number format/use comma,compat=newest} ...
4
votes
1answer
870 views

Dates as xticklabels ; number formated dates provided

I would like to plot temporal data and have dates as tick labels. I have seen chapter 4.20 Symbolic Coordinates and User Transformations from pgfplots manual but it does not correspond to my situation ...
10
votes
3answers
4k views

Convert numpy array into tabular

I am doing some data analysis in python, putting the results in form of a matrix stored into a numpy array. I would like to put this results into a report and the best way would be to put a table with ...
5
votes
1answer
463 views

How can LaTeX code in a data file be read by pgfplotstable?

I would like to place some LaTeX math code in the columns of a file to be read by pgfplotstable. Unlike How to use underscores with pgfplotstable?, I would like the columns to be formatted so LaTeX ...
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 ...
1
vote
1answer
168 views

How to use underscores with pgfplotstable?

I have an input file like this: some_entry 123 another_entry 456 yet_another_entry 789 and I want to typeset it as a table with: \pgfplotstabletypeset[col sep=space]{FILENAME} Problem is that ...
7
votes
1answer
1k views

Is it possible to create a table and bar chart on the fly?

I am a beginner in Latex, using it tentatively for industrial documents. I have reached a point where the anticipated benefits from using it in a Corporate environment appear to me very significant. I ...
3
votes
1answer
388 views

PgfplotsTable: How to merge cell contents of two tables to one table?

I have two tables (sorry, inline tables are not working with pgfplotstable 2011/12/19 on my system, even with the option format=inline): Data table (data.csv): X,A,B U,1.1,1.2 V,2.1,2.2 ...
7
votes
1answer
886 views

Usage of longtable (or equivalent) and pgfplotstabletypeset

I'm a new user of TikZ pgfplots and pgfplotstable and have been stoked to discover how easy it is to go between Matlab (via matlab2tikz and writing to CSV) and LaTeX. I'm getting a little more ...
29
votes
2answers
2k views

Drawing heatmaps using TikZ

Introduction I want to create a heatmap using TikZ. You can see the basic idea in the picture below: I basically have a table of values and each value is assigned a color. The picture is the result ...
3
votes
2answers
467 views

Pgfplots \closedcycle introduces unwanted slope

I'm trying to plot two graphs with the area between them filled. This works fine, except for the fact that the \closedcycle does not go down vertically, but rather at some (arbitrary?) slope, circled ...
1
vote
0answers
93 views

Scope issues with pgfplotstable [closed]

I created a command that creates a table and do some computations on it. And I would like to use this command several times. \documentclass{minimal} \usepackage{pgfplotstable} \pgfplotstableset{% ...