The CSV tag concerns text-based files containing tabular material using commas as a separator.

learn more… | top users | synonyms

22
votes
2answers
21k views

How to plot data from a CSV file using tikz and csvsimple?

Here is a minimal example : \begin{filecontents*}{data.csv} a,b,c,d 1,4,5,1 2,3,1,5 3,5,6,1 4,1,4,9 5,3,4,7 \end{filecontents*} \documentclass{article} \usepackage[utf8]{inputenc} ...
18
votes
3answers
30k views

Importing csv file into latex as a table

I am using the \csvautotabular function to import data from a csv file. It has worked beautifully; however, I only want to import certain columns from the file. How can I exclude certain columns? ...
13
votes
2answers
673 views

Combine columns of a csv

I'm attempting to use \pgfplotstabletypeset but with no luck. I have a CSV file like the following: Name, Age, stDev Adam, 15, 3 When I output in this into my PDF, I would like the last two columns ...
12
votes
1answer
383 views

Render rfc4180 compilant CSV as table

Is there a LaTeX package, which would import data from csv and honour the quotation escaping? To be exact I mean one using the rules 1. - 7. of http://tools.ietf.org/html/rfc4180#section-2 Neither ...
9
votes
2answers
3k views

Importing CSV file as a table in Latex but file too long

I am trying to import a CSV file but the data in the table is too long it goes down till the end of the page and disappears without continuing on the next page. Here's the file: ...
9
votes
3answers
1k views

How can CSV files be put into LaTeX without having to adjust much?

I would like to have a TeX-Snippet that takes a filename as an argument and outputs a table with toprule and bottomrule: \begin{tabular}{lrr} \toprule Fach & Dauer & Einkommen\\ ...
8
votes
1answer
527 views

Huge table/matrix with colored boxes

I have a huge CSV file with about 25.5k records that (structurally) looks like the sample below. In essence, I want to display the values of the columns U,V,W,X,Y,Z of each row as a colored box. The ...
7
votes
3answers
4k views

Are there tools for importing from CSV to BibTeX?

I'm seeking a way to get my books database, stored on Goodreads, into BibTeX form. As near as I can tell, Goodreads provides no support for this directly, but does provide for CSV export (on the ...
7
votes
1answer
119 views

Multiple instances of xelatex in parallel without overwriting generated PDF's

I've one TeX file abc.tex which is executed using xelatex abc.tex to generate the PDF file abc.pdf Inside abc.tex I'm using the datatool package to read data from an external CSV file (say pqr.csv). ...
7
votes
1answer
301 views

Macro for pgfplots/gnuplot exponential regression line

I am trying to create a series of plots with exponential regression that are automatically generated from comma/tab separated .csv files and pgfplots with help from gnuplot. When not using macros I ...
7
votes
1answer
651 views

Plotting graphs from csv with pgfplots?

I am trying to plot a graph using pgfplots in which the data is read from a CSV file. My points show up fine, but when I try to add a regression line, it appears as a vertical line at x=0. Can anyone ...
6
votes
4answers
7k views

How to compute an histogram (plot bars) binning the values from a .csv using TeX?

I've a .csv with a column of acquired measures. I would like to make the histogram bins using TeX from the measures distribution so I have to create the bins first. I haven't found any reference to ...
6
votes
4answers
1k views

Sending Same Letter to multiple addresses

I'm sending the same letter to multiple addresses. The addresses are stored in a csv document. I've so far created a loop to create multiple letters, but I have not been successful in finding a ...
6
votes
2answers
894 views

How to annotate TikZ plotted function using axis values?

I would like to annotate local max of a .csv spectrum. My goal is to have a latex plot analogous of the matplotlib script I use, which give me this result: I've plotted the same spectrum from this ...
6
votes
1answer
149 views

Why is this CSV form letter code incompatible with the table of contents in ConTeXt?

Using the code in the answer to How to create form letters from spreadsheet data in ConTeXt?, I am building a document from data in a CSV file. I found that some part of the code is incompatible with ...
6
votes
1answer
134 views

Plot Gantt-like plot from csv

I am trying to plot a Gantt-like chart with pgfplot from a CSV-File. The aim is to display the behavoir of a task scheduler. In my CSV-File I have tupel of timestamp(x) and task ID(y). ...
5
votes
2answers
2k views

How can I plot bigger amounts of data?

I am currently playing around with hailstone sequences (collatz numbers). I would like to create a plot like this (from Wikipedia): But I don't know how this kind of plot is called (it's neither a ...
5
votes
1answer
65 views

How to iterate over a comma separated list passed through the datatool interface

I'm trying to iterate over a comma separated list that is itself inside a cell in a .csv file, which I'm reading and iterating over with datatool. As per, How do I process a comma separated list ...
5
votes
1answer
172 views

problematic extra cell when importing CSV to latex

I have a table that spans several pages I will be including in an appendix that I would like to import into my LaTex document from a csv. I found the long table answer post very helpful: Importing CSV ...
5
votes
2answers
192 views

Auto-coalesce same values into \multirow

I am generating a pgfplotstable from a data file. In that file, within the Class column, subsequent rows with the same value should automatically be coalesced/collapsed/joined to form a ...
5
votes
1answer
152 views

Appending Graphic from Optional CSV Column to PGFPlotsTable Column Content

I have a CSV file containing a list of names, numbers and optionally pictures. This file is to be displayed in a multi-column table, with the name (and optionally appended picture as icon) in one ...
5
votes
0answers
22 views

pgfplotstable show subset of rows?

I'm visualizing a csv with pgfplotstable as following: \pgfplotstabletypeset[ string type, col sep = comma, begin table=\begin{longtable}, end table=\end{longtable}, ...
4
votes
2answers
579 views

Automatically formatting a table from a file with a list of words

I have a list of ~1000 words in a text file. The words are listed in a text file "my_words.txt" with no breaklines as follows: word1, word2, word3, etc. I would like to display these words in a ...
4
votes
1answer
3k views

Scatterplot with data from CSV file and trendline

I have created a scatterplot with code from this previous asked question. \documentclass[varwidth=true, border=2pt]{standalone} \usepackage[utf8]{inputenc} % this is needed for umlauts ...
4
votes
1answer
126 views

Eso-pic and data-tool

Csv files can be easier to prepare for the person who is not used to LaTeX syntax. I would like to use a csv file containing Id, myauthor, mydate, myaddress Sebastian, 12.12.2012, XYZ road, ...
4
votes
2answers
113 views

ConTeXt xtable split to multiple pages

How to make xtable or TABLE [split=repeat] option to work with comma-separated list? \usemodule[database] \defineseparatedlist [MyTable] [separator=comma, left=\bTD,right=\eTD, ...
4
votes
1answer
572 views

Combining invoice and datatool to create serial invoices

I want to generate invoices based on a CSV table. My approach looks like this: \documentclass{letter} \usepackage{invoice} \usepackage{datatool} \address{ABC AG \\ Nonamestreet 4 \\ 1100 ...
4
votes
1answer
988 views

Getting specific row/column values from a csv file to use in text, figures or table cells

I am trying to do the following: read a csv (or other similar format) external file with numerical and string data into an object; reference/get an specific value from such object to use into an ...
4
votes
1answer
187 views

CSV Table Overflow with CSV Simple?

I have a large CSV data set (240 rows - 4 columns ). When I try to embed the data using csvsimple the table overflows instead of flowing to the next page. How can I get the table to flow onto the next ...
4
votes
2answers
1k views

Use CSV data in table caption?

I want to use some data, imported with csvsimple, in a table caption. \begin{filecontents*}{data.csv} column1,column2,column3 name1,val1a,val1b name2,val2a,val2b \end{filecontents*} ...
4
votes
1answer
242 views

Recreating formatting of an Excel table using simplecsv

I'm trying to recreate a wholesale price list in LaTeX so that the data can be updated automatically from CSV files. I'm able to import data using \csvautolongtable but I'm struggling with the ...
4
votes
1answer
901 views

PGFPlots error “Dimension too large” when plotting .csv data

I did search on here for a solution and I did read the manual, but i couldn't find an answer (or at least one that I understood). I am plotting some data in a .csv file and for some reason when the x ...
4
votes
1answer
63 views

\useplot with Text in CSV

Is there a way to import & auto-plot a graph containing text in one column? Eg. Here's my table Period,Unit Sales (in thousands) Q1 '07,24943 Q2 '07,27855 Q3 '07,32752 Q4 '07,36766 Edit: ...
3
votes
1answer
326 views

How to draw a graph from CSV with TeX?

I am a complete beginner with TeX, I would like to draw JMH benchmark graph using TeX. Since I have output results in CSV format. This is my actual code: \documentclass{article} \usepackage{pgfplots} ...
3
votes
1answer
315 views

How to deal with csv file whoese fields are enclosed by quote?

I have a csv file whose fields contain text. As fields can contains newlines, they are enclosed by double quotes. Editing these file works well with my favourite spreadsheet (libreoffice). I want to ...
3
votes
1answer
490 views

csvsimple handles underscores wrong

I try to print a .csv file with the help of the csvsimple package. My csv file contains underscores since it is generated out of a database which uses underscores in column names as convention. ...
3
votes
2answers
700 views

How to import data from a CSV file in a figure caption using csvsimple?

I have made a pretty report that gets all the data from CSV files data.csv like this : Images,Infos,Bayer,BilineaireA,BilineaireB,TeinteA,TeinteB,ContourA,ContourB,Forme img1(illusion),Temps (en ...
3
votes
1answer
91 views

Problem defining a string column with PGFPlotsTable

First, I am fresh new with the PGFPlotTable package! I have the following CSV file that I would like to plot in a LaTeX table: ...
3
votes
1answer
261 views

How to make convert csv to fancy tables?

I want convert csv to fancy tables like this : First, I make a basic table with my MWE like this : \documentclass{article} %\usepackage{csvsimple} \usepackage{pgfplotstable,filecontents} ...
3
votes
1answer
245 views

Nested CSV with csvsimple

I have two csv files. I want to use the first (countries.csv) to generate sections, and then filter the second (bottles.csv) by the name of the section. Below is an MWE - you can see that the nested ...
3
votes
2answers
187 views

Create a caption for table using the \csvautolongtable command from the csvsimple package

I successfully included a .csv table using the \csvautolongtable command from the csvsimple package (the table is more than one page, this is why I am using this command). Now I want to add a caption ...
3
votes
1answer
35 views

Adding code (pagebreak) after value change in csvsimple

Background I want to create a document with the user data of our network at school, which should be handed out to the user. This should be done class by class. Approach The user data are given in a ...
3
votes
1answer
26 views

Creating csv files from .dtx: blank line at top

I'm working on a .dtx project in which I might embed data in the .dtx to be written to a couple of .csv files. The problem I'm encountering is that a line feed character is inserted before the first ...
3
votes
1answer
77 views

Omitt some xticklabels

I am currently reading some data from a CSV-file together with the xticklabels as one column from that file: \pgfplotstableread[col sep=comma]{data/test1_d4.csv}\dataTestOneFour \begin{figure}[ht] ...
3
votes
1answer
564 views

PGFplot multiple histograms using CSV file

I have tried to draw a comparative graph using histogram and taking data from different CSV source files. I can draw the two histograms but the resulting graph is not what I want: I don't want the two ...
3
votes
1answer
978 views

pgfplots: how to load distinct symbolic ticks/labels from file?

I want to plot a matrix of color-values from a csv file. Inspired by this website, I set out to write my MWE below, to which I added this way of dynamically loading symbolic ticks/labels from my data ...
3
votes
2answers
1k views

Bar chart from CSV file with adjustable bar width

I have a CSV file with approximately 1500 records that I would like to plot using something like a bar chart, but I don't know where to start at all. Each record contains a width and a height, which ...
3
votes
1answer
330 views

Plot multiple histograms from csv file using pgfplot

I have the following data.csv file: subject,f1,f2,f3 F11,0.019,0.04165,0.00016547 F14,0.03034,0.02161,0.000267 M22,0.05128,0.0648,0.000327 M22_1,0.052,0.0328,0.000206 M23,0.0364,0.06355,0.000379 ...
3
votes
1answer
28 views

Adapted table width to text using pgfplotstable and csv excel

I have a problem with forcing my table to the same width as the text. I export the csv (Excel) file to Latex using this approach, see code. Changing text-size in Excel works to a curtain "level", but ...
3
votes
2answers
57 views

Possible conflict between dcolumn and csvsimple

Ok, so I'm trying to add a table to a document using a .csv file. After tinkering with it I've got this for the table: \usepackage{makeidx} % allows for indexgeneration \usepackage[utf8]{inputenc} ...