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
15 views

pgfplots macros: x filter/.code={\pgfmathparse{#1/1000000}\pgfmathresult} doesn't work for csv file

I would like, to have x-axes in MHz range, therefore I would like to use command: x filter/.code={\pgfmathparse{#1/1000000}\pgfmathresult} but nothing is happen. I am using lualatex for image ...
4
votes
3answers
65 views

Defining new commands from csv-file?

I would like to define new commands and be able to change the output from a csv-file. Let's say the csv-file is semicolon seperated: Name; Score Max; 12 Peter; 32 Anna; 27 Now I would like to have ...
1
vote
1answer
36 views

csvsimple repeats head elements instead of CSV row elements

I try to format a CSV file as a table and ran into the issue that the csvsimple package repeats the head elements after a % sign appears in the file. Consider the following MWE (strongly reduced from ...
2
votes
2answers
114 views

Use LaTeX to produce parts lists?

I have a document where I describe how to renovate my house. Now someone wants an additional document (in the appendix and/or as extra CSV file) with parts lists of all windows and doors and so on. ...
0
votes
0answers
53 views

pgfplots errors when reading in data in standalone file

I'd appreciate any help with this. I've had a read of some similar problems, but not the same as mine. I'm trying to create an image using pgfplots, in a standalone .tex file. I have a CSV file, with ...
0
votes
0answers
17 views

Latex to pdf pandoc conversion where a table is fetched from file

I am trying to run a simple pandoc tex-to-pdf conversion. The command is: pandoc -s -o tmp.pdf tmp.tex For some reason it generates an empty pdf with just a page number but no table in there. It ...
1
vote
1answer
33 views

pgfplotstable - siunitx error with data from csv with values in scientific notation

I want to create table using pgfplotstable with data from csv file with values in scientific notation, but when i try to compile the file to pdf I end up with following siunitx errors Package siunitx: ...
1
vote
1answer
21 views

How to read csv into table with custom header?

I want to read a csv into a table that I defined like follows: \begin{table}[bp] \centering \caption{Reading csv.} \label{table:csv} \begin{tabular}{cccc} \toprule \multirow{2}{...
0
votes
1answer
67 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
27 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
21 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
58 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
31 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
12 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
50 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
36 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
62 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
133 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
126 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
71 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
100 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
72 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
11 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
64 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
47 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
47 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
23 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
29 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
37 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
24 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
91 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
73 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
18 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
68 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
38 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
54 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
53 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
29 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
46 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
63 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
57 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
15 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
75 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
59 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
80 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
135 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
20 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/...

1
2 3 4 5 6