Questions tagged [csv]
The CSV tag concerns text-based files containing tabular material using commas as a separator.
2
votes
1answer
12 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
20 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
18 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
51 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
55 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
82 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
21 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
36 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
13 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
153 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
102 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
38 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
62 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
34 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
69 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
28 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
41 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
52 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
81 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
70 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
135 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
134 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
43 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
46 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
51 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
106 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
90 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
58 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
148 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
72 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
109 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
33 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
38 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
39 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
47 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
78 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
96 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}
\...
0
votes
1answer
270 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
22 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
42 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 ..
\...
3
votes
1answer
73 views
csvreader creates empty table, despite no compile error
I have a CSV file composed as shown below (I reported only a small part of it as it is very long). The actual separator I chose to use is '|' (pipe), as the file content might also include comma. Each ...
4
votes
5answers
454 views
\newcommand and CSV file
I have a CSV file which looks like this
testa, 123
testb, 456
testc, 789
How can process the CSV file to get the following result?
\newcommand{\testa}{123}
\newcommand{\testb}{456}
\newcommand{\...
1
vote
2answers
248 views
Cannot import csv file data to table in latex using csvsimple
I don't know why the data rows not shows up. Only the header, here is my csv file:
method,name,error,occurences
socket,socket,"ConnectionResetError(54, 'Connection reset by peer')",12
socket,socket,"...
5
votes
2answers
385 views
Rendering CSV data in tables which do not fit in paper width
I have to generate a number of tables from CSV data which span a
couple of hundred pages or more. So, I need some kind of
automation for this.
Please note the following salient points:
The data has ...
1
vote
1answer
45 views
How to get related information from a database?
Hello friends I am not able to get or link the content of Core-1 to look up table content of Core-1 is ENGL when i used \coreOne i am getting output as ENGL, so what will happen if i use \coreOne (i....
2
votes
1answer
118 views
csvsimple row counter processing
I am trying to list data from a csv file using csvsimple and to add automatic hyperlinks to related sections.
Issue
When working with a file with a header (but using the no head option to define a ...
3
votes
1answer
403 views
Can't colour my scatter plot according to values of a csv file
I am having issues trying to build a very simple scatter plot. The csv is organized as follows:
0.09298303885566861,1976.677756339018,1.360252917788105
0.05630059591218889,3608.903320218602,-12....
1
vote
1answer
184 views
Import CSV file generated from Excel To LaTeX with Datatool with accent
I'm trying to import a .CSV file generated with excel that contais special characters as á, é, í, ó, ú.
I'm using \DTLloadrawdb, but these characters still don't show.
What is the magic trick to do ...
1
vote
0answers
194 views
Package datatool Error: Can't assign \company : there is no key `*' in data base `*'
Hy, i'm having problem with the \DTLforeach in my table. LaTeX returns the following error:
Package datatool Error: Can't assign \company : there is no key Company' in data baseprodutosAloe'. ...\...
2
votes
1answer
243 views
Labeling points imported from csv
I have a csv file consisting of two columns corresponding to the x and y coordinates of a point cloud. Since it is possible to label a point in a tikzpicture environment by
\coordinate (1) at (0,0); #...
