Skip to main content
Share Your Experience: Take the 2024 Developer Survey

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
1 answer
36 views

Problems with currfiledir, pgfplotsstable and compilation from a section file

My project File tree - section - mysection.tex - tools - mystandalone_data.csv - mystandalone.tex main.tex MWE main.tex \documentclass{article} \usepackage[mode=buildmissing]{standalone} \...
Enevevet's user avatar
  • 772
0 votes
0 answers
37 views

Insert table in Overleaf from .csv file [duplicate]

I'm writing my first paper in Overleaf instead of Markdown and struggling with how to insert data programmatically. I have a table of data that gets frequently updated that I want to display in the ...
AFH's user avatar
  • 103
0 votes
0 answers
40 views

Creating quarterly report from excel/csv file in latex

I am trying to create a quarterly report in latex from a database in excel/csv. for the report I only need certain attributes and their corresponding values. So far Ive managed to create a suitable ...
Deibel's user avatar
  • 9
1 vote
1 answer
47 views

Color points scatter from .csv in order according to colormap

I want to color these 10 points from the .csv the same colors as the corresponding colormap, in the order that they appear (i.e. completely independent of their x,y value). How do I achieve this? ...
Bart Wolleswinkel's user avatar
1 vote
1 answer
35 views

csvsimple csvreader doesn't use option separator

My csv is separated by tabs. When loading it with \csvautotabular the option separator=tab works fine. But when loading it with with \csvreader just like in the example of the documentation it only ...
stef9998's user avatar
1 vote
1 answer
45 views

The table header and each row of the input CSV file make one table

I want to get more tables from one CSV file so that the tables have a header and only one row from the input CSV file. The first table has the header and the first row of the CSV file, the second will ...
Zeljko Hrcek's user avatar
2 votes
1 answer
101 views

CSV data with a variable number of table columns using csvsimple-l3

I have two CSV files. One has 5 columns and the other has 6 columns. It is necessary to check the CSV file and determine the number of columns, which I managed to do. I saved the number of columns in \...
Zeljko Hrcek's user avatar
0 votes
1 answer
30 views

Make a zero order hold plot from a .csv file with pgfplot

I want to make a zero-order hold plot from a .csv file using the pgfplots package. My idea is to use the \addplot+[const plot] option. The documentation mentions {<list of coordinates>} as ...
Daniel's user avatar
  • 1
2 votes
0 answers
260 views

Best way to create a table for data in R?

Main question: What is the best way to create a table in a LaTeX document for data from R? At first glance, two possibilities seem conceivable: Let R create the table and "paste" it into ...
user1's user avatar
  • 2,206
0 votes
1 answer
14 views

Set specific values on x axis on a logarithmic plot [closed]

I made the following plot And it comes from data that I stored on a .csv, now the x axis is on a logarithmic scale and I only want ticks right below the points that are plotted. Fortunately, all of ...
Leonardo Lovera's user avatar
0 votes
1 answer
33 views

Cannot plot CSV with PGFPlotTable, Missing \endcsname inserted

Let's say I have this pretty standard CSV file: id,x0,y,sy,yhat,yerr,yrelerr,ychi2 0,-1,-1.083108355,0.075,-1.013608377,-0.069499978,0.068566894,0.85871057 1,-0.857142857,-0.625857469,0.075,-0....
jlandercy's user avatar
  • 195
0 votes
0 answers
29 views

csv data and multido

I am making a card with properties of Periodic Table of Elements. I wish had the mass number, like this using pstricks: \documentclass[12pt,a1paper]{article} \usepackage[a1paper,margin=0cm]{...
Darío's user avatar
  • 471
1 vote
1 answer
117 views

Testing if a string is a part of a csv list of strings

I use the xsim package with tags for my exercises. These tags are a CSV lists of strings. I have a tag called year (year={2020-2021,2017-2018}, for instance) which contains school years. I can ...
Didier's user avatar
  • 1,321
0 votes
1 answer
110 views

readcsv not working

I started learning LaTeX (on Overleaf) and I have to insert a table. Due to the size of the table, for convenience I want to import it as CSV. I replicated the same code from internet (as Importing ...
eugenio b's user avatar
1 vote
1 answer
39 views

Macros that directly reference spreadsheet/csv

I would really like is to get a row from a CSV, format it, and then put it in my text. Say for example I have a spreadsheet that has data about cities, for example "Montreal, 1000, Victoria, ...
Paul's user avatar
  • 11
0 votes
0 answers
45 views

TikZ pgfplots reverse x axis values

Yes, I know there are loads of examples on this site, but I haven't found anything that works for me. I tried to reverse the x axis values with x dir=reverse, but what i get is this How do I make the ...
user3713179's user avatar
1 vote
1 answer
102 views

Plotting eye diagram with pgfplots

I'm a student writing my master thesis and would like to be able to plot eye diagrams in LaTeX using pgfplots. I have a csv file that contains the data on the eye diagram in a "time, voltage"...
Siebe Arnout's user avatar
1 vote
0 answers
25 views

Loading csv file and accessing data by row and col using Latex3 [duplicate]

I want to load data from csv file and later access them. In C# I would have one Dictionary<string, int> for mapping column names to their indexes. And another Dictionary<string/*PK value*/, ...
Sergei Zinovyev's user avatar
0 votes
1 answer
46 views

Package hyperref Warning: Token not allowed in a PDF string. Using value from CSV in TOC

I am using datatool to read csv file and get values from it. I also want to use these values in a chapter names. I have no problems with TOC and pages. I can see values from my csv file. But bookmarks ...
Sergei Zinovyev's user avatar
0 votes
0 answers
119 views

csvsimple and tabularray - fit table to page

I have a code for creating a table from a CSV data file but the table size is very long. I would like to automate the code so any table coming from any CSV file I use will fit into one page. Here is ...
MathTeX's user avatar
  • 129
0 votes
0 answers
66 views

I saw answers on excel to LaTex but do not want a latex table... Need to use LaTex in Excel to make .csv with math symbols, subs & supers, etc

I am trying to make a csv file for flashcards that includes latex symbols, the file needs to be in csv format and I was editing it in excel to change the plain text such as d/dx f(x) or x^2 a_n etc to ...
Elaina Jeansonne's user avatar
1 vote
1 answer
38 views

Issue with rules when display csv file in a tabular

I'm trying to display values from a csv file inside a tabular. To do so, I'm using the macro \csvreader. I would like thr tabulat to like this way : with a toprule, the head of columns, a midrule, ...
Thomas's user avatar
  • 273
0 votes
0 answers
219 views

How can I read an excell csv file with colored cells into a tabular or table and display the color formatting?

This is my code for reading the csv files into a tabular, but it does not keep the color formatting: \csvreader[tabular={|c|c|r|c|c|c|c|c|c|}, before reading = \begin{adjustbox}{width=\columnwidth}, ...
Ghespenst's user avatar
1 vote
1 answer
139 views

Connecting points with coordinates from columns in a csv file

I have a csv file containing four columns x1, y1, x2 and y2. I need to draw line segments connecting the points (x1,y1) and (x2,y2) for each row of the table using \addplot. In the following code, ...
Don's user avatar
  • 11
0 votes
1 answer
179 views

How to auto replace string pattern in header CSV cells with pgfplotstable?

In the following csv file example, I want to automatically replace a string pattern in all headers cells when importing with pgfplotstable: \begin{filecontents*}{sample.csv} parameter,cubic ...
zetyty's user avatar
  • 777
0 votes
1 answer
148 views

How to randomly select and plot a csv file from a folder

I have data1.csv, data2.csv, and data3.csv in a folder. I use pythontex to randomly select a number from 1 to 3. \begin{pycode} list = random.sample(range(1, 3), 3) select = list[0] \end{pycode} Then ...
Hana Enna's user avatar
0 votes
1 answer
97 views

How to read values interms of milli(m), femto(f), micro(u) into float values

I have a .csv file, which contains values interms of milli(m), femto(f) and micro(u)etc. which I want to process it as float value inside pgfmathparse \begin{filecontents*}{mycsv.csv} Device, betaeff, ...
Raja's user avatar
  • 450
0 votes
1 answer
160 views

exporting a specific row from CSV using csvsimple

What is the best way to obtain a specific row (or a subset of row) when I use csvsimple? ⧵csvreader[head to column names]{filename.csv}{}{} For example, I would like to get only row three from the ...
user199's user avatar
  • 37
0 votes
0 answers
105 views

Export text from CSV or Excel to Latex document

Similar to this creating multiple generic letters from pulling info from an excel/csv file, how can I create multiple files from LaTeX without using r? I do not have any issues with running LaTeX code ...
user199's user avatar
  • 37
2 votes
2 answers
584 views

How to read a large .csv file as table with bookstyle?

I need to insert large tables in the appendix of my MSc thesis and I want to read the data from .csv files without fill the .tex file where I write. I produce the tables with the help of ...
g_don's user avatar
  • 799
0 votes
0 answers
44 views

Is there a way to make \DTLloaddb load not from external files? [duplicate]

The journal has a rule that forbids loading external files and the entire tex file must be self-contained in a single .tex file. Therefore all \DTLloaddb{aaa.csv} must be replaced. Is there a way to ...
he wei's user avatar
  • 23
2 votes
1 answer
70 views

Data from file when variable number of data

I am using the datatool package in order to get data from a csv to LaTeX pdf pages: \documentclass{article} \usepackage{datatool} \begin{document} \DTLloaddb{data}{students.csv} \DTLforeach{data} {\...
user1583209's user avatar
0 votes
1 answer
133 views

Read CSV as crosstab/pivot table

I've got a table that looks like this: (Note: This table was generated in winword by my predecessor, so I don't have a MWE of it. My attempts to do so have failed, as it's apparently not so simple to ...
Jakob Lovern's user avatar
0 votes
1 answer
45 views

howto obtain a striped table with csvloop?

Is this possible with csvloop command to change the row colors in order to obtain a striped longtable? Something equivalent to late after line=\csvifoddrow{\\\rowcolor{white}{\\\rowcolor{gray!20}}, ...
Certes's user avatar
  • 35
-2 votes
1 answer
76 views

using csvsimple inside a pgfgantt diagram?

Is there any possibility to use some data contained in a csv file to create milestone or bar inside a pgfgantt diagram ? And, if yes, how to do so ? Is this possible with csvsimple ? Is it possible to ...
Certes's user avatar
  • 35
0 votes
0 answers
21 views

Contents imported from csv file goes beyond the page below

I want to create a one-word Q&A document. I imported the contents from a .csv file which has 104 rows, the contents go below the page and not to the next page. How do I rectify it? \documentclass[...
Srini Vasan's user avatar
5 votes
1 answer
128 views

Using \def in csv range

I would like to use a predefined list of numbers in the csvsimple-l3 range option. The MWE will explain better: \documentclass[11pt]{article} \usepackage[utf8]{inputenc} \usepackage{csvsimple-l3} \...
user125198's user avatar
0 votes
2 answers
91 views

automating vector math problem creation using csv data source

I'm a teacher, and I'm looking to automate some homework problem creation with vector algebra. I would like to use a csv file (which I can pre-process for input to tex) with the format: "question....
randomlogic78's user avatar
1 vote
1 answer
89 views

Get vector from array .csv file

I hope you can help me. I want to create a variable with name 'x' with the values of the column with header 'x' of the array .csv file called 'data' (please see below). Could you help me do it? .csv ...
el_maxx's user avatar
  • 163
1 vote
1 answer
119 views

Using a CSV File to Drive Custom Macro

Background I am trying to figure out why the attached MWE is not working. My custom macro reqUser works correctly when using the xstring both inside and outside of the csvsimple environment. The expl3 ...
Nebabon's user avatar
  • 115
0 votes
1 answer
378 views

Pass tabular arguments from \newcommand

So I asked this question yesterday but I realized I didn't do a good job of explaining it. I basically need to read different csv files with different numbers of columns and I need to build a command ...
user270659's user avatar
0 votes
2 answers
83 views

Transpose and make table with small text in corner + big text

Ok, this is what I want to make: But I'm struggling with understanding how to make this from an external CSV file. I have this approach because the book will be driven by external files which is ...
Jimmy Westberg's user avatar
1 vote
1 answer
67 views

Draw a piecewise constant graph from csv

I have the following csv file: 1,36 2,22 3,13 4,8 5,7 6,2 7,1 8,7 9,12 10,5 11,6 12,2 13,7 14,4 15,4 16,1 17,2 18,1 19,1 20,2 21,2 22,1 23,1 24,1 25,1 26,1 27,2 28,0 29,0 30,0 31,0 32,1 33,0 34,0 35,0 ...
Mark's user avatar
  • 755
0 votes
0 answers
40 views

I can't seem to get anything to import a csv at all

I have a rather large .csv that I would rather not type by hand into LaTeX, and am trying to use the csvsimple package to import it. The csv is 51 rows long, with the first few looking like the ...
Mac McMahan's user avatar
4 votes
1 answer
489 views

How to read a csv file row by row and create a table?

I have a problem reading my rows from the .csv database. Separated by commas every key. So, here is my .csv: id,term,description 1,"system","name" 2,"syst2","...
Programmer1988's user avatar
0 votes
1 answer
416 views

How to correctly parse a CSV file row-by-row with different number of commas/columns from each row to another?

Following up this answer, with this csv file \begin{filecontents*}[overwrite]{mydata.csv} TeMaxPartLoad,163.0576,,,, MaxSpeedTR,1065.9,,,,, coeffs, 3, 5, 9 , 8, 6 , \end{filecontents*} I ...
Diaa's user avatar
  • 9,649
1 vote
1 answer
35 views

pgfplots generates extra x steps from csv

I try to load data from a csv and set the x ticks to years but for some reason, pfgplots creates intermediate 0.5 years with no corresponding y data points. \documentclass[12pt]{article} % use larger ...
Phönix 64's user avatar
1 vote
1 answer
56 views

How to filter case-insensitive in csvloop

I have a command like this: \newcommand{\contactdetails}[1]{% \csvloop{% file={authors.csv},% filter equal={#1}{\name},% command=\printcontact,% head=true,% ...
akichii's user avatar
  • 65
4 votes
1 answer
296 views

LaTeX 3D Plot from csv

I have a lot of csv-files with this format: -,x0,x1,x2,x3,x4 y0,z00,z10,z20,z30,z40 y1,z01,z11,z21,z31,z41 y2,z02,z12,z22,z32,z42 I want to make a 3D Plot with LaTeX. Unfortunately, I was not able to ...
sunrein's user avatar
  • 43
0 votes
1 answer
164 views

Plotting non nummerical data from csv file using pgfplots

so I'm trying to plot a csv file using pgfplots. The csv file looks like this but with more data: Here is the download link for the csv: https://datawrapper.dwcdn.net/NDCZf/4/ I tried using the code ...
AidenFive's user avatar

1
2 3 4 5
8