The CSV tag concerns text-based files containing tabular material using commas as a separator.

learn more… | top users | synonyms

3
votes
1answer
42 views

Adapted table width to text using pgfplotstable and csv excel

I have a problem with forcing my table to the same width as the text. I export the csv (Excel) file to Latex using this approach, see code. Changing text-size in Excel works to a curtain "level", but ...
0
votes
0answers
14 views

Load CSV file + landscape

I hope someone is able to help me. I'm trying to create landscape pages, that are holding my survey items. After several tries with CSV files, I wrote everything by hand, but it's just too inflexible, ...
1
vote
0answers
28 views

PGF Plot: Different Graphs/Plots in one file

I want to plot my benchmark results from Celero (C++ benchmarking library) in latex, via PGF Plot: I get a csv file with all data in the form of (here with example data): Now I want to plot the ...
1
vote
1answer
11 views

datatool package: Looking for sth like \xDTLassignfirstmatch, but w/ partial (not exact) match

Problem statement I use the datatool package's \xDTLassignfirstmatch macro to determine the due date of a given assignment (which is identified by a short code such as ex1 or rd2) from a .csv file ...
1
vote
0answers
23 views

Load CSV file with numbers and get maximum and average value

I have several CSV files and I need to get their maximum and average values. I prefer to do this in TeX file, if possible. Example: source1.csv: 1100000, 25.5 1200000, 58.3 1300000, 21.2 ...
1
vote
1answer
57 views

latex table to continue on the same page

I need to generate a latex table using data from a csv file. The table has only two columns with about 500 rows. I would like to make best use of the space and continue the table on the same page, ...
0
votes
0answers
22 views

pgfplotstable: How to change font for the minimum/maximum value in a column?

I am trying to automatically change the font for a cell if the value is the minimum/maximum in that column. In the manual of pgfplotstable there is a post-processing step that can change the font if ...
2
votes
1answer
66 views

Skip to long lines in pgfplots

How do I skip lines, that are to long, when using \addplot command and data read from csv file? My database has around 500k points describing position in x-y space. Position can be wrapped around (...
8
votes
4answers
4k views

Are there tools for importing from CSV to BibTeX?

I'm seeking a way to get my books database, stored on Goodreads, into BibTeX form. As near as I can tell, Goodreads provides no support for this directly, but does provide for CSV export (on the right)...
3
votes
1answer
34 views

“escape underscore” environment with csvreader

I want to put the content of a csv file in a tabular environment. However, this includes text with underscores "_". Because this triggers the math environment, it gives the error: Missing $ inserted. ...
3
votes
2answers
147 views

Error while trying to read csv file to create table

I have a csv like the following: CategoryName,Pageviews Restaurants,37951 Shopping,22002 Things to do,20067 Nightlife,10612 Gifts,9194 Food Shopping,8655 Useful Stuff,8536 Parenting ,8353 Home,7654 ...
1
vote
0answers
40 views

Add spacing between every second bar tikzpicture

So I've created this chart below from a .csv file with the code at the bottom. However I would like to add some spacing between the 2&3 bars and 4&5 bars. Is this possible or do I need to ...
1
vote
0answers
41 views

import cvs file with special characters as table in latex

I am trying to import a cvs file with special characters to my latex file using scvsimple however, I am getting some errors. I tried many suggestions from the forum and net but non worked for me. ...
1
vote
0answers
11 views

surface plot — end points get connect connected (tikzpicture) [duplicate]

It's the first time I'm asking a question here, but I've been using this side a lot on my way to get my head around Latex. I am currently working on something which I can't seem to figure out: I am ...
5
votes
0answers
25 views

pgfplotstable show subset of rows?

I'm visualizing a csv with pgfplotstable as following: \pgfplotstabletypeset[ string type, col sep = comma, begin table=\begin{longtable}, end table=\end{longtable}, columns={{...
1
vote
1answer
45 views

Create table for each CSV file in a directory

Assume I have a directory which has a dynamic number of files match a certain pattern (e.g. tabledata0.csv, tabledata1.csv). Now I want to create automatically create tables out of it. Sometimes it is ...
0
votes
0answers
22 views

Multiple row in heading for tables

I have a problem formulating two rows in my heading of my table using pdfplotstable exporting csv file from excel. This is what i have: \usepackage{pgfplotstable} \documentclass[a4paper, 12pt]{book} ...
1
vote
0answers
68 views

Using /csname in

I want to use a smarter solution for a big CSV file with many LocalX columns \documentclass[a4paper,12pt,hidelinks]{article} \usepackage[utf8]{inputenc} %\usepackage[utf8x]{inputenc} \usepackage[...
1
vote
1answer
62 views

Underfull \hbox warning about alignement in a csvsimple table

The following csvsimple table keeps returning warnings of the type: Underfull \hbox (badness 10000) in paragraph at lines: \csvreader[no head, longtable=|p{\dimexpr 0.2\linewidth-2\tabcolsep}|p{\...
1
vote
2answers
759 views

Custom separator for CSV import via csvsimple

I have successfully used csvsimple to import .csv files. But I would like to have commas as number separators, so I modified the .csv file to use semicolons as separators and as csvsimple manual says, ...
1
vote
1answer
49 views

CSV table header alignment

I have a simple two-lines csv file, which I've imported to latex with csvsimple like this: \begin{filecontents*}{data.csv} 1,2,3,4,5 101,102,104,105,106 -1,-2,-3,-4,-5 \end{filecontents*} ......
0
votes
0answers
9 views

Automatic linebreaks in table created with csvautoimport [duplicate]

I'm using csvautolongtable to import a csv file. Now the text in some cells is running over the edge of the page. How can I prevent this? \documentclass{article} \usepackage[T1]{fontenc} \usepackage[...
0
votes
1answer
371 views

Table does not display in List of Tables

I'm including a table: \begin{table}[htb!] \centering \csvautotabular{results.csv} \caption{Results} \end{table} And in the top of my document, I have: \listoffigures \listoftables However, all ...
1
vote
2answers
51 views

How can I input only certain columns using macros outside csvsimple?

I want to define a command, like \newcommand \Fruittype {Strawberries} and only input the data from the column that contains it. Can someone help me? \documentclass[a4paper,12pt,hidelinks]{article} \...
3
votes
1answer
197 views

Creating a LaTeX Table from a Microsoft Word Document

I have this multi page word document file which is consisted of a table with two columns. the left column is an English word in front of which in the left column the Persian translation is provided. I ...
1
vote
0answers
41 views

Parse a file and produce latex output [duplicate]

Here's my problem: I'm writing my thesis and I have a big list of items in a csv. I would love to parse it, obtain some fields and generate different outputs in latex code. How can I automate this ...
2
votes
0answers
149 views

How to convert csv file to bibtex? [closed]

I have a csv file of the database Springer as follows: Columns Item Title,Publication Title,Book Series Title,Journal Volume,Journal Issue,Item DOI,Authors,Publication Year,URL,Content Type Data ...
1
vote
1answer
94 views

csv long table in landscape

I want to import a csv table, but the table has too many columns i.e. too wide. So I put it in landscape environment and use the \csvautolongtable. The specific code is the following: \usepackage{...
4
votes
1answer
125 views

Problem defining a string column with PGFPlotsTable

First, I am fresh new with the PGFPlotTable package! I have the following CSV file that I would like to plot in a LaTeX table: truncatedtime;meanfinalfloatvalue;floatvaluedifference;datap2count;...
1
vote
1answer
200 views

Setting “col sep = semicolon”

I obtain this table: using this code: \pgfplotstabletypeset[ col sep = comma, string replace*={_}{\textsubscript}, every head row/.style={before row=\toprule,after row=\midrule}, every last row/....
1
vote
0answers
201 views

Create a bar chart from CSV

I have a .csv file that looks like this: gender.csv GENDER,NUMBER,PERCENT MALE,20,20 FEMALE,80,80 TOTAL,100,100 I want to create a bar chart using MALE and FEMALE. GENDER can be the chart name or ...
3
votes
2answers
257 views

Create a caption for table using the \csvautolongtable command from the csvsimple package

I successfully included a .csv table using the \csvautolongtable command from the csvsimple package (the table is more than one page, this is why I am using this command). Now I want to add a caption ...
1
vote
2answers
226 views

Plot multiple functions when data-columns are separated by comma pgfplots

I have a csv file with 2 "columns" separated by comma. So the .csv file looks something like 0.123,0.3232 1.244,1.325 The above numbers are the "y-values" at x=0 and x=1 respectively, i.e. the ...
3
votes
1answer
36 views

Adding code (pagebreak) after value change in csvsimple

Background I want to create a document with the user data of our network at school, which should be handed out to the user. This should be done class by class. Approach The user data are given in a ...
1
vote
2answers
133 views

Remove space between consecutive fbox commands

I type several fbox commands and for some reason the boxes are separated with small spaces: MWE: \documentclass{article} \usepackage{fullpage} \setlength{\oddsidemargin}{-15mm} \raggedright \...
5
votes
1answer
72 views

How to iterate over a comma separated list passed through the datatool interface

I'm trying to iterate over a comma separated list that is itself inside a cell in a .csv file, which I'm reading and iterating over with datatool. As per, How do I process a comma separated list ...
3
votes
2answers
60 views

Possible conflict between dcolumn and csvsimple

Ok, so I'm trying to add a table to a document using a .csv file. After tinkering with it I've got this for the table: \usepackage{makeidx} % allows for indexgeneration \usepackage[utf8]{inputenc} \...
0
votes
3answers
327 views

csvreader and respect all (special characters in the csv file)

I'm trying to use csvsimple to read in a file with elements that contain special characters (underscores in this example) and create a table that only has a some of the columns. I can read in the file ...
1
vote
1answer
116 views

Package csvsimple: How do I reject the last line of a csv file

Ultimately I want to read a csv (comma separated variable) file into LaTeX and display a table. I'm doing this within the beamer document class. I'm currently using the \csvautobooktabular command ...
1
vote
1answer
38 views

Using “datatool” to assign values to newly created commands ends filling all with the last value

I'm trying to create new commands by taking their values via a CSV file and datatool to load them into a DB. The problem is that every created command with this process ends with the values assigned ...
1
vote
1answer
419 views

XY plot from date/time data table using pgfplots

I have a dataset in the format shown below, which I have exported from R using export.table() function. I want to make an XY plot using pgfplots, where x=time, and y=value, and the points are ...
4
votes
2answers
130 views

ConTeXt xtable split to multiple pages

How to make xtable or TABLE [split=repeat] option to work with comma-separated list? \usemodule[database] \defineseparatedlist [MyTable] [separator=comma, left=\bTD,right=\eTD, first=\bTR,...
1
vote
0answers
35 views

Remove default formatting from pgfplotstable. [closed]

I have some tables created using pgfplottable loading data from a csv file. The issue I am encountering is that the values are getting reformatted, for example a "2.00" in the csv is resulting in "2" ...
6
votes
1answer
144 views

Plot Gantt-like plot from csv

I am trying to plot a Gantt-like chart with pgfplot from a CSV-File. The aim is to display the behavoir of a task scheduler. In my CSV-File I have tupel of timestamp(x) and task ID(y). \documentclass{...
3
votes
0answers
91 views

Grouping data in pgfplots

I have a file with measurement results for different settings (group) in a single csv file as shown below. I would like to plot a line in pgfplots for each group and provide an appropriate legend. Is ...
3
votes
1answer
26 views

Creating csv files from .dtx: blank line at top

I'm working on a .dtx project in which I might embed data in the .dtx to be written to a couple of .csv files. The problem I'm encountering is that a line feed character is inserted before the first ...
2
votes
1answer
457 views

Importing table from csv file

I have the following table in a avg_value.csv file: ,M23,F23_1,M36,F44,F63,M70 M23,1.00,0.81,0.88,0.83,0.41,0.82 F23_1,,1.00,0.52,0.56,0.25,0.94 M36,,,1.00,0.62,0.94,0.96 F44,,,,1.00,0.43,0.23 F63,,,,...
3
votes
1answer
387 views

Plot multiple histograms from csv file using pgfplot

I have the following data.csv file: subject,f1,f2,f3 F11,0.019,0.04165,0.00016547 F14,0.03034,0.02161,0.000267 M22,0.05128,0.0648,0.000327 M22_1,0.052,0.0328,0.000206 M23,0.0364,0.06355,0.000379 F37,...
1
vote
1answer
78 views

Combine multiple pgfplots from tex files

I have been using Sharelatex to write my thesis and I have accumulated many pgfplots. I can't include more than ~6 pgfplots produced by csv files before I get compile time out. I have been dividing my ...
0
votes
0answers
78 views

Creating a list from CSV files

I do have a CSV file containing a list of collaborators to a book. I'd like to know if theres is an automated way to import this file into Latex and generate a list of collaborators (in twocolumn ...