Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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); #...