Questions tagged [csv]

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

Filter by
Sorted by
Tagged with
0
votes
1answer
738 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 ...
3
votes
1answer
583 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
273 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
87 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
471 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
134 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
225 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
147 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
81 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
96 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
103 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
337 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
176 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
1k 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
32 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
75 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 .. \...
4
votes
1answer
194 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
568 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
973 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
738 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
56 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
321 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
902 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....
2
votes
1answer
408 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
396 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
380 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); #...
2
votes
1answer
372 views

Reading quoted csv

I would like to read in data from a CSV file into a plot. Unfortunately, the data contains commas itself: Name, Description, Data hello, "hello, world", 1 Note that the data is quoted using ...
1
vote
0answers
438 views

Plot directly from .csv file [closed]

\begin{tikzpicture} \begin{axis}[ title=Stress vs. Strain, xlabel={Strain $\Delta$ (\si{\milli\meter})}, ylabel={Load $F$ (\si{\newton})}, xmin=-0.30, ymin=0, %grid=major, ...
1
vote
0answers
674 views

Python array to txt or csv to latex [closed]

I'm new at Latex and I have a problem, I have an array in Python and I want to paste that array as a matrix in Latex in a simple way. In Python I have: np.savetxt("matrix.csv", matrizfake, delimiter='...
4
votes
1answer
301 views

DTLgetvalueforkey works, but DTLfetch doesn't

In the following example \DTLgetvalueforkey retrieves the information without problem, while \DTLfetch fails: \documentclass{article} \usepackage{filecontents} \begin{filecontents*}{data.csv} ...
2
votes
1answer
146 views

PGFPlots - messed up data from csv file

I'm trying to plot some data that I aquired form a sensor. However, the plot looks very messed up an I'm not sure why. It appears as if the data on the x axis is not read correctly. MWE: \...
3
votes
1answer
221 views

loop for table generation with pgfplotstable

I am using pgfplotstable to enter my CSV tables into LaTeX. The issue is that I am using two lines as the header, in the first line introducing my variables and second line their units. The following ...
3
votes
2answers
277 views

How do I get datatool to play nicely with utf8 inputenc and non-ASCII in the incoming CSV?

If I try to compile the following LaTeX file: \documentclass{article} \usepackage[utf8]{inputenc} \usepackage{datatool} \begin{document} \tableofcontents \appendix \section{Bill of Materials} \...
1
vote
0answers
251 views

CSV Reader does not compile special characters

I am creating tables from a csv file by using "csvsimple" package. The "autotabular" option is included, so that I don't have to manually count the number of cells and manually set the cell alignment. ...
0
votes
1answer
438 views

Table from csv file with two header rows [duplicate]

I have multiple csv files to read and create a table with one or two headerlines. (parameters/units) I would like to use two header lines from this files using \pgfplotstabletypeset. Can anyone help ...
4
votes
1answer
233 views

How to call specific lines of data in a CSV in ConTeXt?

I have a CSV file, using "@" as the delimiter, containing data such as this: Code @ Title @ Page @ Tags @ File 001 @ Buying Tips @ 1 @ seafood, fish, ...
0
votes
1answer
948 views

display a csv file in LaTeX [closed]

How can I link a csv file, and display the data in separate columns ? \documentclass{article} \usepackage{makeidx} \usepackage{datatool} \DTUoaddb[keys=c1,c2,c3]{ctext}{csvtext.csv} \begin{document} \...
5
votes
3answers
261 views

How to generate key value macro from csv file?

I have a CSV file with key-value pairs, and I want to be able to read the file into latex, and generate macros to access the values. Here is my current attempt with datatool: \documentclass{article} ...
6
votes
1answer
403 views

Tikz Wheelchart - How do I link a CSV to this graph?

I am trying to connect a CSV file to a wheelchart of the tikzpicture package. The image below looks fine, the only issue is that currently the data entries are hard coded. In the code below you can ...
2
votes
1answer
73 views

Help with longtable renders extra field

So I have a problem because my longtable seems always render one extra field in my table. Depending on where I put my \ it renders after it goes through the csv or before. My code is: \documentclass{...
3
votes
1answer
55 views

csvloop bug with the word “long”?

I'm experimenting some issues with the csvloop using the package csvsimple. I need help determining if it's a bug with the package, or something I can fix myself. The word "long" is showing up in my ...
1
vote
2answers
327 views

CSV groupplot expansion within foreach loop

I want to make a groupplot of a number of columns from a CSV file. The CSV file looks like this: a,b,x,y 1,2,3,4 5,6,8,1 9,2,4,5 5,5,1,9 Therefore I made a package that uses the code below to plot ...
1
vote
1answer
194 views

3D Surf/Mesh Plot from a Single Line in csv File? Pgfplots preferably

I have done a range of experiments, each using 9 sensors. The sensors are physically aligned in 3 by 3, and I would like to also show the data in a mesh or surface plot like this. However, I get the ...
2
votes
1answer
98 views

PGFplot plot y over x where z=bar (comparable to SQL WHERE clause)

I am using TexLive XuaLatex with PGFplots 1.13 to plot data. I have a table like this: x , y , z 0 , 0 , 0 0 , 0 , 1 1 , 1 , 0 1 , 1 , 1 2 , 2 , 0 2 , 4 , 1 3 , 3 , 0 3 , 9 , ...
4
votes
3answers
847 views

Creating string array from csv file

I would like to create some name badges using a loop. I have a spreadsheet with names and affiliations that I save in names.csv file as follows "Name1","Surname1","Affiliation1", "Name2","Surname2","...
1
vote
1answer
365 views

Missing \endgroup in csv longtable

I am trying to read in a very long csv file to a longtable, but I am getting a missing \endgroup inserted error when compiling. I cannot figure out what is missing. \documentclass{standalone} \...
6
votes
1answer
1k views

Adjust decimals on table from csv

My problem is that I'm importing some data from a csv and generating a table. The table is good, but I need the numbers with 4 decimals. I've generated the table with this code (probably it is not ...
2
votes
0answers
398 views

Error when importing UTF-8 encoded csv file containing “æ,ø,å” with datatool [duplicate]

I am trying to import a UTF-8 encoded csv file into a tabularx environment to sort the table in ascending order with respect to the first column. When compiling I get the error: Package inputenc Error:...
1
vote
2answers
2k views

how to import CSV table with header containing spaces

The header column names in my CSV contain spaces. Is there a way to still import it using csvsimple or maybe some other package? That way I would be able to specify data in CSV, import it and render ...
1
vote
0answers
331 views

xticklabels from table not working [duplicate]

The content \documentclass[margin=1cm]{standalone} \usepackage{filecontents} \usepackage{pgfplots} \begin{filecontents}{dummy.txt} category,amountTotal excellent,0 good,8 neutral,2 ...