Questions tagged [csv]
The CSV tag concerns text-based files containing tabular material using commas as a separator.
286
questions
0
votes
1answer
53 views
plotting 4 variables graph from csv file
I have a csv file with 4 columns like this:
P Q R cost
6, 3, 1, SC
6, 2, 2, SC
6, 1, 3, SC
5, 4, 1,
5, 3, 2,
5, 2, 3, DR
5, 1, 4, DR
4, 5, 1,...
0
votes
0answers
26 views
Creating a heatmap from CSV data [duplicate]
This questions solves the same problem I have, but in the example the data comes from filecontents and the solution involves changing the data, in my case the data comes from a CSV which I cannot ...
1
vote
0answers
17 views
LaTeX commands in pgfplots legend entries from csv import
I am trying to import data from a csv file, where legend entries are automatically taken from the csv file's header. Those legend entries contain LaTeX math code.
% used PGFPlots v1.16
\documentclass[...
0
votes
2answers
51 views
Can't fit table from csv in page
I'm very unexperienced in Latex but I need to write a document that uses table from a csv file and I'm having a really hard time knowing how to do it. The main problems:
If I include the header from ...
1
vote
1answer
26 views
Write CSV in document with dynamic filename
I'm super new to Latex and I'm trying to do automatic documents that present information regarding each project. Every folder and project has a different name/code and I'd like the document to add a ...
1
vote
0answers
11 views
create bib files from csv [duplicate]
I have bibliographical references ordered in a spreadsheet and I want to create a .bib file to use then in latex documents. I have found the way to transforma a .bib file into a csv, but not the ...
1
vote
1answer
44 views
Create a sorted, three-column table from a single column in a CSV file
I have a CSV file that has various columns. One of the columns is called summits. This column contains multiple summits in the following form:
Summit name (elevation m)
For example
Mount Everest (...
2
votes
1answer
25 views
Create a nested comma-separated-list from a CSV file
In my Latex document I define a nested list that looks like this:
\def\recipes{
{
test1@
test2@
test3@
test4@
test5a*test5b@
test6a*test6b
},
{
test1@
test2@
test3@
test4@
test5a*test5b@
test6a*test6b
...
1
vote
1answer
61 views
How to create a Telephone Directory using a CSV data base [duplicate]
I have created a excel file with Name,Title,Designation,Department,Faculty,Institute,TelNo,Email id columns
I want section wise telephone directory, i.e., We have 16 Faculties. So I want to create a ...
1
vote
3answers
101 views
Create table from .csv file, Header line to long
I have a big table that I want to put into my latex Document. The problem that I have is that the header line(the top line) for the column names is too long. This is my state.csv file
game id,start,...
1
vote
1answer
59 views
A row of CSV data is not saved after checking for its emptiness and existence
Following up this answer and the ensuing discussion, \getRow is expected to check the existence and emptiness of the target row of a CSV data, then save that row columns to another macro.
In other ...
2
votes
1answer
124 views
xparse: How to conditionally get a warning or error when retrieving empty or non-existent CSV data?
Following up this great answer of reading a CSV file and saving it, I need to have the following:
A compilation-halting error is required when I try to index into a non-existent row or column since ...
1
vote
1answer
70 views
Storing a CSV row columns in a list/array and indexing into it
Following up this answer, how to extend the code of its second method to store each row value columns in a list or array and be able to index into it?
In other words, I need another macro (along with \...
0
votes
1answer
65 views
csvsimple wrap table cells
I am using csvsimple package to embed csv files as tables into my latex document.
It looks like long cell contents break the rendering:
tokens.csv:
method,corpus,tokens
MI,Quran,"allah, thou, thi,...
2
votes
2answers
61 views
Using \DTLfetch inside a \href
I'm trying to create a new command in LaTeX that creates a Google Map URL pointing to the coordinates associated with the place specified as a parameter in the called command (a sort of "table ...
0
votes
0answers
10 views
export csv to latex margins error
Export a csv to latex but I could not correct the margins
here is the link to download it
https://www.google.com/url?hl=es&q=https://www.stats.govt.nz/assets/Uploads/Tatauranga-umanga-Maori-...
0
votes
1answer
50 views
Multiple 'discard if not' in pgfplots [duplicate]
Context: I want to plot some data from a CSV file with pgfplots. This file contains more information than needed, so I want to filter it. Filters (with discard if not from here or there) work well on ...
0
votes
1answer
39 views
Undefined control sequence help required for plotting a graph
When trying to insert a graph plotting a DC transfer curve from Multisim I have been having a minor issue and I'm not sure why. If anyone could explain how to fix this I would be greatly appreciative. ...
0
votes
0answers
42 views
Tikz/pgfplots include .csv file in pgfplotstableread
I'm trying to make a 3D-histogram based on the example shown here.
However, there are two things I can't figure out on my own, as I'm still learning to use the Tikz/pgf packages.
When I try to ...
0
votes
0answers
18 views
How do i get multipe csvautolongtables side by side in LaTeX?
I am trying to place two vscautolongtable side by side in latex:
\begin{minipage}{15cm}
\begin{tabular}{c|c|c|c}
d & K & h & score \\
\csvautolongtable[head to column names]{...
1
vote
2answers
22 views
Using pgfplotstable and longtable with a .csv
I'm trying to import a .csv while using longtable and pdfplotstabletypeset. I can't get the longtable command to work.
\documentclass[12pt,a4paper,oneside]{report}
\usepackage{booktabs}
\usepackage{...
0
votes
0answers
29 views
Percentage sign in .csv with \pgfplotstabletypeset
I'm trying to enter a percentage sign (%) into a table. The table is in a .csv format. Using \% does not work. The problem might be in the document class, but I can't change the document class. The ...
1
vote
2answers
22 views
Set filedirectory in LaTex individually for each data type(csvsimple)
I am new to LaTex coding; so if this question has already been asked just let me know and post the link :)
I try to put a lot of small csv tables into a LaTeX file and found this solution online (...
3
votes
2answers
87 views
How to look up a cell value of a multi-column csv file?
Following up this answer, how can I have an optional argument of the command \getValue that specifies the column in which I look up the cell value so that it has the following syntax?
\getValue\<...
2
votes
0answers
59 views
Generate wedding Invitations using tex
I am looking at creating a bunch of PDFs that I can send out as wedding invitations. I tried using Python and Latex to create the invitations and then send them, but I have hit a brick wall. I have ...
0
votes
1answer
16 views
Store previous element of loop in intermediate variable for dynamic command creation
I am dynamically creating commands and would like to define them based on the current value in an iteration list. The problem is that the current value appears as the last value of the iterated ...
0
votes
1answer
54 views
3D surface plot from csv data
I am trying to plot velocity data from a probe measured across a channel.
The goal is a surface spanned over the measured points and colored according to the velocity value (v) and viewed from the top ...
0
votes
1answer
35 views
Iterating through CSV file - command viewed as one item
I'm trying to iterate through a CSV file, but am running into trouble. The file is multiple lines and I want to go through the CSV items one-by-item. When using the etoolbox docsvlist, it inerprets ...
0
votes
0answers
40 views
CSVREADER in creating a fancy table
I'm really struggling to create the following table in LaTeX where only the data comes from a csv file (the numbers in the file is in exactly the same format as it is in this table). The challenge is ...
2
votes
2answers
50 views
How do I sum CSV-values in to cells?
I am both new here on stackexchange and fairly new to TeX.
I have tried searching for similar questions but found none.
I am working on a document where I need to pppulate a table from a csv file. The ...
0
votes
0answers
22 views
csvsimple inside tabular environment, but csv data includes LaTeX arrays/tables/aligned etc
I am trying to import a csv using csvsimple, and I have already overcome the challenge of the csv delimiter (by adding curly braces around every field), but I am now stuck with a admittedly weird ...
1
vote
1answer
36 views
tikz: load data range from csv file
With this code, I can plot from .csv file
\documentclass[12pt]{article}
\usepackage{pgfplots}
\pgfplotsset{compat=newest}
\begin{document}
\begin{tikzpicture}
\begin{axis}[xmin=0]
\addplot +[] table[...
0
votes
0answers
25 views
Iterate over comma separated values and optional argument [duplicate]
I would like to adapt this answer of another post for one optional argument but my MWE is just a M(not)WE.
\documentclass{article}
\usepackage{xparse}
\newcommand\test[2]{#1+#2\par}
\ExplSyntaxOn
...
0
votes
1answer
58 views
How to create a tabular of hyperref from a csv file in LaTeX?
I am working on the auto-creation of a report after running a parametric study. In order to summarize all the results, I put the the important data as well as the case name in a table. For convenience ...
0
votes
0answers
45 views
pgfplots Error when trying to read a copy of a .csv file that works if not renamed
I'm writing my thesis and this is the first time, I've ever encountered this kind of problem. So, I'm constantly working with csv files, with no problem. Yesterday, this started to happen:
This block ...
0
votes
0answers
14 views
Sorting one csv file and get data from the second one placed in the right place in pgfplots
I have 2 csv files that looks like this :
First one :
class,met
ABDOMINAL,341
ADVANCED-CAD,556
ALCOHOL-ABUSE,31
Second one :
class,met
ABDOMINAL,136
ADVANCED-CAD,100
ALCOHOL-ABUSE,13
I currently use ...
0
votes
0answers
19 views
Why are only the column headers being formed in the latex document when I import the CSV file
This is a very basic version of what I am trying to do
\documentclass(article}
\usepackage(csvsimple}
\begin{document}
\csvautotabular{example.csv}
\end{document}
I have also attached a small portion ...
4
votes
1answer
71 views
Build glossaries from csv with datatool using with longnewglossaryentry
I'm trying to build a glossary from a csv using datatool and \longnewglossaryentry. I haven't been able to get this to work.
Let's start with something that does compile:
\documentclass[10pt, a4paper]{...
0
votes
0answers
43 views
How do include a csv hyperlink, so that a csv file is downloaded when the hyperlink is clicked in the pdf?
I want to have a hyperlink in my pdf which downloads a csv file to the users computer when clicked. How do I go about achieving this?
Please note, I would prefer it if the csv file was able to be ...
1
vote
1answer
63 views
How to escape the # character in csvreader
I'm following this csvsimple documentation and I've come across an issue with my csv file having a reserved character: # and I've tried escaping it with a blackslash(\) and I've tried appending [...
0
votes
0answers
95 views
How to allow non-unique column names in PgfPlotsTable?
I have been struggling with PgfPlotsTable for a while. Problem is that I cannot get rid of '-indexNum' appended at the end of my column names. Does anyone know if there's an option to have non-unique ...
0
votes
0answers
19 views
\longtable with imported csv data
I am trying to spread an imported csv table on two pages. Somehow this doesn't work. Does anyone have advice for me?
\begin{landscape}
\begin{document}
\begin{longtable}
\csvautotabular[]{Tables/...
2
votes
2answers
327 views
How do I plot time series graphs?
I want to display time on the y axis. I have developed this code, but it is not showing any output.
\usepackage{filecontents}
\begin{filecontents}{mwe.csv}
Time,a,b
00:00,0,10
10:30,6,4
11:30,5,5
...
2
votes
1answer
179 views
ConTeXt: List -> Table
I have a list (not a table) that I want to typeset as a grid for filing labels. The list is in CSV-ish format with comments where similar entries are grouped into a single line.
\startseparatedlist[...
1
vote
1answer
114 views
Import csv file: How can I merge information from different lines?
I am trying to compile a bilingual dictionary from a spreadsheet file that was exported as csv. The file contains columns with the kinds of information that one would expect from a dictionary: lexeme, ...
2
votes
1answer
69 views
Use data in .csv file as arguments for macro in TiKZ
I have a .csv file with numbers I'd like to use as arguments in a TiKZ macro I've created. I've tried several different approaches but seem to be running into problems with expanding arguments (really ...
1
vote
1answer
128 views
Serial letter from csv with table with multiple lines in one cell
I'm struggeling with creating a "serial letter" (not really a letter, but a document wich I will need different versions of for different people). I have all the data I need to insert in a csv file. ...
2
votes
3answers
314 views
Read csv values as key-value pairs [duplicate]
I have a csv file that contains the following:
"N","n","M"
200,100,50
How can I read it with LaTeX such that \N, \n_trees and \M then returns respectively 200, 100 and 50 ? Or some other internal ...
1
vote
1answer
54 views
LaTeX: Get Variables out of a cvs row
I want to quickly swap out different values in a tex file - like for a batch print so far I'm using multiple .tex files and swap out the \input examplefile.tex in my header.
examplefile.tex:
\...
1
vote
1answer
191 views
CSV reader leaves a blank line at bottom of table
I am using csvsimple to read a CSV file into my document. Here is the document:
\documentclass[12pt]{article}
\usepackage{csvsimple}
\begin{document}
\begin{tabular}{|c|c|c|}
\hline
Col1 & ...
