Questions tagged [csv]

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

Filter by
Sorted by
Tagged with
11
votes
3answers
2k 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\\ ...
9
votes
1answer
16k views

PGFplotstable: using a csv file with 4 columns

Suppose I have a csv file with no titles in it just data. The first column is time (x axis) and the next 3 columns each construct a different set; that is, plot(t, col1) is one set of data, plot(t, ...
1
vote
0answers
474 views

Create a bar chart from CSV [closed]

I have a .csv file that looks like this: gender.csv GENDER,NUMBER,PERCENT MALE,20,20 FEMALE,80,80 TOTAL,100,100 I want to create a bar chart using MALE and FEMALE. GENDER can be the chart name or ...
1
vote
1answer
2k views

Plotting Multiple Time Series plots in LaTeX using PGFplots and txt files - Relativity Issues

I have a problem with plotting multiple time series plots in a single graph in Latex. Background: I have three products - Potatoes, Apples, and Oranges. Each products' historical price and ...
7
votes
2answers
10k views

How to transform Google docs tables into Latex Tables?

I usually do all of my tables using Google Docs spreadsheet. This is a good and quick way to organize information and create quick tables. Now I am writing a document in Latex and I would like to ...
2
votes
1answer
772 views

csvsimple erros building csv table

I want to use the csv package to insert tables into my document. I am importing csv by using the \usepackage{csvsimple} command. Then, in the code, I use \csvautotabular{Tables/test} to create the ...
4
votes
1answer
68 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: Here'...
4
votes
2answers
409 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 \multirow{n}{*}...
3
votes
1answer
2k 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 ...
10
votes
4answers
17k 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 ...
1
vote
1answer
424 views

How to display a number with many decimals and year correctly

I have a table in "import_csv_2.csv" as follows: No. Year W(G) 1 2010 0.02110333 2 2008 0.02082747 3 2006 0.02037291 ... \pgfplotstabletypeset[ col sep=comma, columns/Subject/....
9
votes
1answer
984 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 ...
2
votes
2answers
2k 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 ...
6
votes
1answer
233 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). ...
3
votes
1answer
171 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, ...
3
votes
0answers
85 views

How to maintain data to be both implemented and documented (in a personal package)

I'm looking for the best strategy for maintaining, in a personal package, a (long) list of data that has to be defined in the implementation and to be documented in the documentation. Let me be more ...
1
vote
2answers
1k views

csvsimple filtering problem

The following code works as I would expect. \documentclass{scrartcl} \usepackage{csvsimple,filecontents} \begin{document} \begin{filecontents*}{chunk.csv} AAAA,aaaaa BBBB,bbbbb CCCC,ccccc DDDD,...
9
votes
2answers
2k 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 ....
3
votes
2answers
2k 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*} \documentclass{...
44
votes
5answers
102k 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? ...
3
votes
1answer
870 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 ...
12
votes
1answer
489 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 ...
12
votes
2answers
1k 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 ...
7
votes
1answer
180 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 ...
5
votes
2answers
3k 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 ...
0
votes
1answer
1k views

How do I create a visually pleasing tree hierarchy from a difficult to read CSV File (MySQL Export)?

Ok here is the deal: I am working on an endangered language project. The data is contained in a MySQL database. I can run a query to produce a hierarchy, but the hierarchy is difficult for humans to ...
4
votes
1answer
1k 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 ...
2
votes
1answer
767 views

read strings from csv file for usage as figure meta data

I got the following problem, I use pgfplots(table) to generate plots and tables in my latex document from generated data. I would like to read additional information from a metadata file. The reason ...
2
votes
2answers
56 views

verbatim within… a package delivers a string from a file and that string needs to be printed without interpretation

The csvtools package warns in its documentation from interpretable inputs but offers no solution as far as I can see. This Code generates a table \documentclass{article} \usepackage{csvtools} \...
2
votes
1answer
359 views

How to get the last element of a specific column from a CSV file?

I have CSV files of different lengths. For example a,b,c,d,e 0,0, 5, 5, 1 0,5, 5, 11, 2 0,11, 5, 16, 1 5,0, 10, 6, 1 5,6, 10, 11, 2 I want to get the value of the last element of the c and d columns,...
46
votes
3answers
63k 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} \usepackage{...
3
votes
2answers
1k 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 ms),...
4
votes
2answers
926 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 ...
8
votes
5answers
8k 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 right)...