Questions tagged [csv]
The CSV tag concerns text-based files containing tabular material using commas as a separator.
1
vote
1answer
37 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
34 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 ...
3
votes
2answers
47 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
143 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
56 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
59 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
54 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
34 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
69 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
136 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
30 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
38 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
28 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
180 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
84 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
131 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
29 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
77 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 ...
0
votes
0answers
23 views
Importing a csv Tablehead into latex, with too many columns
I tried importing a csv table, using the package csv simple:
\documentclass[11pt,a4paper]{scrartcl}
\usepackage{csvsimple}
\begin{filecontents*}{xxx.csv}
\end{filecontents*}
\begin{document}
\...
4
votes
2answers
220 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
376 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
61 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
68 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
59 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
178 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
0answers
29 views
How to fill in a tex template using csv file (datatool and subfile packages?) [duplicate]
I would like to create several index cards from information stored in a csv file, such that for a csv file such
CSV.csv{
name,letter,LETTER,number
Name1,a,A,1
Name2,b,B,1
Name3,c,C,1}
I get single ...
0
votes
1answer
56 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
66 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
152 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
97 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
207 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
144 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):
\...
3
votes
3answers
45 views
Unexpected Results from \dolistloop
Given \def\CSVList{a,b,c}, using \dolistloop{\CSVList} does not seem to process the \CSVList as expected:
Perhaps I am not understanding how \dolistloop is supposed to work, but this example is ...
2
votes
0answers
48 views
Is there an alternative package for loading the CSV, while still using pgfplotstables/pfgplots to display it?
There are several of issues with the CSV parser that is included in PGFPlots.
This isn't surprising, writing a CSV parser is well-known to be unexpectedly difficult.
A big one for me being that it ...
0
votes
1answer
122 views
Graph from csv table (col sep=comma) with pgfplotsinvokeforeach
I have many huge csv files and need a easy way to plot all of them without defining headers etc. every time.
Therefore I found this: https://tex.stackexchange.com/a/24023/95657
That is exactly what ...
1
vote
1answer
157 views
Highlight maximum values for each row in large csv
I am loading a rather large .csv file (>100 rows) that I need to print in longtable format and highlight the maximum value in each row. I found this thread Highlighting Extremal Values in Table which ...
2
votes
1answer
110 views
raster plot with tikz in latex from csv file
I am trying to plot neuron's spikes which are stored in a csv file the following way:
time, neuron1, neuron2, neuron3,...
1,1,0,1,...
2,1,0,0,...
3,0,0,1,...
and so on...
Therefore the data ...
1
vote
0answers
60 views
Extract one specific value from table/csv to draw an horizontal line
I need to add horizontal lines (asymptotes) to a plot made from a csv file, with the y-axis value taken from this last. I found an example to draw the horizontal lines
\addplot [thick,black]
table[x=...
2
votes
1answer
227 views
How can I generate a big tabular out of a csv File?
I have a csv File with 400 lines and 3 columns and I want to generate one Table over more site (I guess there will be 3 pages).
In addition there should be 4 columns of table at one site like this:
...
2
votes
1answer
79 views
Expansion of siunitx glossary entrys using a csv file
I'm try to create a custom latex class based on scrbook. I make heavy use of glossaries for my math symbols, for which pdftool tips are created showing the description and units when a mouse pointer ...
2
votes
2answers
136 views
insert table generated by csvsimple package into another tex document not using that package
I'm not sure if the title describes the question clearly.
I have a latex document that uses the csvsimple package to read some columns from a large datafile and make a nice table. It works fine, but ...
0
votes
1answer
40 views
cite inside a csv file
I am trying to create a table from a csv file that has a citation column. Here is a sample from the csv file:
id, ref
1, \cite{ref1}
2, \cite{ref2}
when I use:
\csvreader[
respect all,
...
1
vote
1answer
48 views
Last column does not show information when using csvreader
I am trying to show a table with two rows and 13 columns, through CSV and csvreader.
As you can see on the contents, there are two X's in the last column of the two rows. However, they are not shown ...
0
votes
0answers
51 views
URL wrapping (line breaking) in csvreader tables
I am trying to create a table by reading a CSV file with 'csvreader'. The CSV file contains one URL per row, some of the URLs are too long, so the aspect is awful, since some of the URLs invades the ...
2
votes
1answer
54 views
How to add symbols from csv file
Is there any way to read symbols from a CSV file using pgfplotstable.
\documentclass[8pt]{article}
\usepackage[english]{babel}
\usepackage{pgfplots, pgfplotstable}
\usepackage{filecontents}
\begin{...
1
vote
1answer
119 views
How to use a semicolon separator with csvsimple together with babel (french language)?
1) Semicolon ; separator and babel
Using the package csvsimple, I found that I can use a semicolon ; separator only if the babel package is not loaded:
\documentclass[varwidth,margin=0.5cm]{...
3
votes
2answers
112 views
CSV file and QR codes
I have a .csv file with some URLs.
First I want to store each URL in a variable.
Second I want to print the variables in QR codes.
What's the easiest way to do this?
MWE
\documentclass{article}
\...
1
vote
1answer
430 views
csvreader longtable caption repeated on every page
I am using csvreader with longtable and I added a caption in table head below is my code:
\csvreader[
longtable=ccc,
table head=\caption{Caption goes here.
}\label{tab:sometab} \\
\toprule\...
1
vote
1answer
25 views
Glossaries always gives last entry of csv-list when processed with datatool
Ok, I am clearly missing something but I cannot figure out what is wrong.
All is fine concerning the \gls{}-entries, but in \printglossary I only get the last entry of the .csv-list.
\documentclass{...
0
votes
0answers
44 views
longtable from csv how to bold specific rows?
I am creating long table from csv file. I want specific rows to be in bold font. how to do it ? Csv file is huge.
I have tried \textbf{} as it works in normal table from csv file.
My code is ..
\...
