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....
