Questions tagged [csv]
The CSV tag concerns text-based files containing tabular material using commas as a separator.
244
questions
2
votes
1answer
103 views
ConTeXt: List -> Table
I have a list (not a table) that I want to typeset as a grid for filing labels. The list is in CSV-ish format with comments where similar entries are grouped into a single line.
\startseparatedlist[...
1
vote
1answer
35 views
Import csv file: How can I merge information from different lines?
I am trying to compile a bilingual dictionary from a spreadsheet file that was exported as csv. The file contains columns with the kinds of information that one would expect from a dictionary: lexeme, ...
2
votes
1answer
45 views
Use data in .csv file as arguments for macro in TiKZ
I have a .csv file with numbers I'd like to use as arguments in a TiKZ macro I've created. I've tried several different approaches but seem to be running into problems with expanding arguments (really ...
0
votes
1answer
29 views
Serial letter from csv with table with multiple lines in one cell
I'm struggeling with creating a "serial letter" (not really a letter, but a document wich I will need different versions of for different people). I have all the data I need to insert in a csv file. ...
2
votes
3answers
106 views
Read csv values as key-value pairs [duplicate]
I have a csv file that contains the following:
"N","n","M"
200,100,50
How can I read it with LaTeX such that \N, \n_trees and \M then returns respectively 200, 100 and 50 ? Or some other internal ...
0
votes
1answer
22 views
LaTeX: Get Variables out of a cvs row
I want to quickly swap out different values in a tex file - like for a batch print so far I'm using multiple .tex files and swap out the \input examplefile.tex in my header.
examplefile.tex:
\...
1
vote
1answer
26 views
CSV reader leaves a blank line at bottom of table
I am using csvsimple to read a CSV file into my document. Here is the document:
\documentclass[12pt]{article}
\usepackage{csvsimple}
\begin{document}
\begin{tabular}{|c|c|c|}
\hline
Col1 & ...
1
vote
1answer
18 views
Importing a csv column with numbers and characters to latex using siunitx
When I try to import a csv table from an external file that has both numbers and characters in the same column, siunitx package gives the following error.
Package siunitx Error: Invalid token 'n' ...
0
votes
1answer
81 views
Plotting graph (tikz, pgf) from .csv. Error: Missing \endcsname inserted
I'm getting following error trying to plot .csv table (link to the table: https://github.com/JKhay/LaTeX) to an article:
Missing \endcsname inserted.
<to be read again>
\...
1
vote
0answers
42 views
How to generate personalized PDF documents from a LaTeX file linked to a text file or database with the names
Say you need to generate certificates of assitance to a course. You compose a LaTeX document and want to link it to a CSV or a database file, where the names of the assistants are stored. Is Latexdb ...
0
votes
0answers
33 views
CSV File reading slash (“/”) in latex table
I have csv file having 6 columns where first column have "/" in it. I am using below code:
\documentclass{article}
\usepackage{csvsimple}
\usepackage{datatool}
\begin{document}
\DTLloadrawdb[keys={...
1
vote
1answer
21 views
Boldface CSV headings
(question updated from 1 to 3 columns)
I am trying to do something supremely simple: typeset a table such as
what.csv
First,Last,Style
Bob,Marley,Reggae
Fritz,Wunderlich,Lieder
with boldface ...
0
votes
0answers
14 views
How to add new line/enter in csv s.t. automatic table generation contains the enter?
Given this code that automatically generates a table from a csv file, how can I ensure that an enter or new line is put into a cell in the table?
\documentclass{standalone}
\usepackage{csvsimple}
\...
1
vote
1answer
57 views
Import CSV to Latex
Have tried all of the prior responses questions but just can not seem to get any of them to work. I have tried all the various csvreader but can't seem to figure it out.
I am trying to import the ...
2
votes
1answer
98 views
shape C not found in the files.csv (tikz-network package)
Following the first example on page 33 of https://github.com/hackl/tikz-network/blob/master/manual.pdf I have been getting the following error below.
! Package pgf Error: No shape named C is known.
...
2
votes
1answer
95 views
Error at compiling example from the Manual tikz-network
As per example on page 26 of the manual https://github.com/hackl/tikz-network/ when doing latexmk -pdflua -pvc or latexmk -pdfxe -pvc I get the following error below. Note: already tried https://...
1
vote
0answers
124 views
Using external (delimited) data files for Asymptote contour plots
I need to plot two-dimensional data, which I would like to do in a contour plot. From my personal experience in trying to get nice contour plots using pgf/tikz and what I read in Fill a contour-plot, ...
4
votes
1answer
50 views
Print range of many group rows in datatools
I use this code from this answer:
\documentclass{article}
\usepackage{filecontents}
\begin{filecontents*}{product.tex}
%Type =1,2...10
No,Type,Name,Description
1,1,A1,D1
2,1,A1,D2
3,1,A1,D3
30,1,A1,...
1
vote
1answer
62 views
PGFPlots - Missing number, treated as zero error - when loading data from file
I am drawing a heatmap/scatter plot with the mark colour determined based on a score. I have mapped scores to Red, Green and Blue values, and trying to colour the marks based on the RGB values. The ...
2
votes
1answer
39 views
How to update the generated .csv file in csvsimple package
I just started using csvsimple which looks like a great package. I wonder if it was possible to do the following
Let's say that I have a .csv file that I copy into the .tex file as follows:
\...
1
vote
1answer
689 views
Color table with data from csv file with colors from csv file
I am trying to create a table (which is from a csv file) which cells are colored (from another csv file (this way I can do preprocessing externally)). I have looked briefly at tools such as datatool, ...
2
votes
1answer
72 views
How do you put two CSV Tables next to each other?
How do you put two CSV files as a table next to each other? I have the sample effort:
\begin{table}[!htb]
\begin{minipage}{2 in}
\begin{tabular}{1|c}
\bfseries Terahertz (THz) & \bfseries ...
2
votes
2answers
64 views
Drawing two curves from a csv file
Hello fellows and folks!
I am working with python and I need to draw the following picture in latex by using the values from the variables. They are a ton, so it is not like the usual stuff where I ...
4
votes
3answers
148 views
Find the locations of blank lines in .csv file
This is related to a previous question I asked - Plotting data blocks of varying length using PGFPlots and gnuplot.
Here is a minimum working example:
% !TeX TXS-program:compile = txs:///pdflatex/[--...
2
votes
2answers
188 views
Converting CSV file into PDF dynamically [duplicate]
I have a simple CSV file that looks similar to:
pens, 23
bottles, 5
spoons, 6
chairs, 5
books, 12
I want to convert this into a PDF document. I have no clue on how could I do this. I have installed ...
0
votes
1answer
121 views
Removing quotes in csvsimple
Before someone marks this as a duplicate question, I have read this answer, and it has not helped.
I have a csv file:
"headline","similarity"
"Tesco directors in scandal",""
"Tesco suspends three ...
3
votes
1answer
71 views
Possible Bug in passing variables from CSV
I think there's a bug in calling decimal numbers from CSV files. Have a look.
Create a Folder.
Add a CSV file called texDemo.CSV with the following in it.
UniqueID,Name,DecimalPercentageComplete,...
0
votes
1answer
72 views
pgfplots to build a contour from csv
I want to plot the contour lines from some simulation I did.
Therefore, I have a csv file with my computed data, and I would like to use pgfplots to plots these contour lines.
I look on the ...
3
votes
1answer
165 views
mistake when exporting numpy data to csv to pgfplots
I have to plot data from a numerical simulation. I perform my simulations with python and numpy. But now I want to plot the result in a LaTeX file. Since I want to be able to modify the layout without ...
1
vote
0answers
195 views
Generating small business cards based on a csv file
Based on
https://www.overleaf.com/latex/examples/mailmerged-business-cards/gnnhcjvkvcfd
I'm trying to implement a project that would generate small business cards based on a csv file.
I created a ...
2
votes
1answer
63 views
Adding/subtracting to the /thecsvrow number in csvsimple
Assume a simple example centered on the csvsimple package.
\documentclass{standalone}
\usepackage{csvsimple}
\usepackage{fp}
\usepackage[table]{xcolor}
\begin{filecontents*}{input.csv}
Foo,...
2
votes
1answer
52 views
Color background for title row in csvsimple
Assume a simple example centered on the csvsimple package.
\documentclass{standalone}
\usepackage{csvsimple}
\usepackage{fp}
\usepackage{xcolor}
\begin{filecontents*}{input.csv}
Foo,Bar,Baz,...
2
votes
1answer
49 views
Strange csvsimple output when the line starts with an accented character
The code example below produces an undesirable result, where an Omega appears on the 5th line and all data from the 6th line appears glued to the last cell in the 5th line.
Does anyone knows what ...
2
votes
1answer
346 views
Change Column Name and Cell Value Pgfplotstable
I have this csv file:
,Accuracy
1,0.982
2,0.982
3,0.982
4,0.988
5,0.916
6,0.976
7,0.958
8,0.97
9,0.945
10,0.988
11,0.969
This is the screenshot when I imported it into Latex file:
This is the ...
1
vote
1answer
101 views
Using Slashbox/Diagbox in Pgfplotstable
I have a csv file in this form
,0.01,0.1,1.0,10.0,100.0
0,0.3837,0.8259,0.9386,0.9386,0.9386
1,0.3837,0.9464,0.9386,0.9386,0.9386
2,0.3976,0.95,0.9386,0.9386,0.9386
3,0.8259,0.9386,0.9386,0.9386,0....
5
votes
4answers
283 views
use foreach to read columns from a csv file?
How can I read columns from a external csv file using a foreach statement? e.g. if the content of the csv file is as follows:
{0,0,0},black,
{1,1,0},yellow,
{1,0,1},pink
And I would like to use it ...
2
votes
1answer
43 views
LaTex Skipping Figure Counting
I'm having trouble with the \label feature in figure environments. Initially, the code I was working with would label Figure 1 in Section 4 as Figure 41. I found this solution: https://stackoverflow....
1
vote
1answer
170 views
csvsimple - process column names with digits correctly
I have a csv that contains column names with digits. Somehow this seems to be a problem for csvsimple, but I can't quite figure out why and how to deal with it correctly.
Here's what I want to ...
4
votes
2answers
348 views
csvsimple vs. conditional row coloring
I've a CSV file what I want process with csvsimple. My desire is to color some rows based on a conditional (one specified column has bigger value). Here is an MWE:
\documentclass[12pt]{article}
\...
2
votes
1answer
742 views
Pgfplots plotting data from a csv file
I'm trying to create a diagram with three x-axes at the bottom. I found a code which creates 3 axes but when I try to plot the data from a csv file I get an error stating:
! Package pgfkeys Error: I ...
1
vote
1answer
94 views
How to Label y-axis properly when plot from CSV file? [duplicate]
I would like labeling as follows:
It does not get proper labeling on y-axis when I am plotting data from CSV file in Latex. Here is the code :
\documentclass{standalone}
\usepackage{tikz,pgfplots}
...
6
votes
1answer
110 views
How to add title at custom position in Latex pgfplot?
I tried to add title at custom position of a pgfplot from a CSV (https://drive.google.com/file/d/1xnF8rG9J50ZIxl9K04k6nksvjWoWrfHe/view?usp=sharing) file, but nothing came out. I tried several ways, ...
1
vote
1answer
138 views
How to plot histogram from a tab separated csv file containing tabular list of ordered tuples?
I would like to plot a histogram in which x-axis will contains ordered tuple data and y-axis will contains its frequencies. A CSV file containing data as follows :
x_values y_frequency
(2,102,100)...
1
vote
2answers
363 views
Importing CSV as Long Table Not Working
I tried implementing the solution found here with multiple columns, but it is not working for me. It is just replicating the third column three times. What am I doing wrong? I know I wouldn't need a ...
0
votes
1answer
79 views
Converting a date from a csv file to a number
I try to only display items from the csv file for which the date lies in the futere
\begin{tabular}{rlll} % Date&&&\\\
\csvreader[
filter test=\ifnumgreater{\datum}{\today},]%
{test.csv}{...
1
vote
0answers
97 views
Rainbow CSV\TSV Style with pgfplotstable
I am trying to generate something similar to this Rainbow Style.
I would like to use the listings package for that (easy import through \lstinputlisting). Any Ideas? Or are there other solutions for ...
6
votes
1answer
335 views
Plot bar chart from csv with different styles depending on row in csv
I try to plot the content of a csv file in a bar chart, where depending on the row the bar should have a different style. This is what I came up with so far:
\documentclass{article}
\usepackage{tikz}
...
5
votes
1answer
168 views
Load data into custom tikZ timeline plot from a .csv file
I have created a custom timeline plot in tikz, and am aware of other options for timelines but I need mine to be more customizable. A mwe is shown below. I would like to modify this tex file to read ...
3
votes
1answer
363 views
How to import data from excel and format it as text in LaTeX?
I have a big database spreadsheet on Excel which is a list of products and I want to use its data to write formatted text in LaTeX.
The table looks like this:
Year / Name product / Details
2000 / ...
4
votes
2answers
166 views
TikZ: colors stored in matrix with coordinates inferred
I'd like to use data stored in an external CSV file to fill nodes inside a tikzpicture matrix. If my data is stored as x/y/z, I can write the following loop (put together from this and this):
\...
