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.

0
votes
1answer
44 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
42 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
27 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 ...
2
votes
1answer
57 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
116 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
19 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
25 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
25 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
111 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
76 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
95 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
25 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
58 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
16 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
176 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
235 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
53 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
64 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
44 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
113 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
49 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
63 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
106 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
85 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
158 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
140 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
47 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
80 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
127 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
100 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
59 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
179 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
74 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
120 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
36 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
46 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
46 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
50 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
94 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
101 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
341 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
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
81 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
464 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
279 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
409 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
46 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....