{pgfplotstable} is a package that can read, parse, modify or generate tables from data that is either provided via 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
193 views

Dec sep align & string type cell incompatibility?

I would like to use the dec sep align feature of pgfplotstable while having certain cells containing text. I tried this: \documentclass{article} \usepackage{pgfplotstable} \usepackage{booktabs} ...
3
votes
2answers
87 views

pgfplotstable, round-off error

I'd like to do some simple computation in my table and it looks like I'm seeing some round-off errors. Does anybody know the precision that pgfplotstable uses internally? Is there any work around ...
8
votes
1answer
120 views

Can I use | as column separator in pgfplotstable?

I want to use | as column separator in the CSV file. Because it looks clean, so I won't feel headache to edit the CSV file directly. I have checked the manual, it seems the option col sep accepts ...
8
votes
2answers
1k views

pgfplot: plotting a large dataset

I try to plot a dataset which is large using pgfplots. Since I'm aware of problems with large files, I used the external mode. I additionally increased main_memory from 3000000 to 6000000. It crashes ...
0
votes
0answers
258 views

Tikz graph layout algorithms and loading file using pgfplotstable [closed]

I am trying to enable layout algorithms in CVS-version of PGF. Following code can be compiled by LaTeX. \documentclass{article} \usepackage{tikz,pgfplotstable} \usetikzlibrary{graphs} ...
0
votes
0answers
46 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
98 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 ...
2
votes
1answer
334 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 ...
0
votes
0answers
123 views

Change Table header cells formatting [closed]

How can I make header cells italic using pgfplotstable? I load several csv files and add their content to an object using \pgfplotstablecreatecol. Then I use the following code to generate the table ...
5
votes
1answer
251 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
122 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
169 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
151 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
131 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} ...
4
votes
2answers
494 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
333 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
291 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
206 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
282 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 ...
7
votes
1answer
452 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 ...
6
votes
1answer
603 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 ...
8
votes
1answer
195 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
210 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 ...
6
votes
2answers
328 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
162 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, ...
6
votes
3answers
667 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
555 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
291 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
398 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
281 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
490 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 ...
7
votes
1answer
539 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
382 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
124 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 ...
9
votes
1answer
396 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 ...
2
votes
1answer
115 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
212 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} ...
10
votes
1answer
820 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
470 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
232 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 ...
5
votes
2answers
384 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
153 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
273 views

PGFPlots staggered axis

Why in this plot the axis are all staggered ? \documentclass[12pt,% % corpo del font principale a4paper,% % carta A4 % ...
1
vote
1answer
566 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
241 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
410 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 ...
9
votes
3answers
2k 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
309 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
852 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
128 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 ...