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

learn more… | top users | synonyms

1
vote
1answer
52 views

Simple import of data with special characters for table

I'm currently trying to import a set of data from a file (comma or tabbed delimited, doesn't matter) for creating a table. Below is an example of this data (DH parameters in case you're curious): ...
3
votes
1answer
38 views

How to deal with csv file whoese fields are enclosed by quote?

I have a csv file whose fields contain text. As fields can contains newlines, they are enclosed by double quotes. Editing these file works well with my favourite spreadsheet (libreoffice). I want to ...
7
votes
1answer
94 views

Macro for pgfplots/gnuplot exponential regression line

I am trying to create a series of plots with exponential regression that are automatically generated from comma/tab separated .csv files and pgfplots with help from gnuplot. When not using macros I ...
4
votes
1answer
82 views

Recreating formatting of an Excel table using simplecsv

I'm trying to recreate a wholesale price list in LaTeX so that the data can be updated automatically from CSV files. I'm able to import data using \csvautolongtable but I'm struggling with the ...
5
votes
1answer
96 views

Appending Graphic from Optional CSV Column to PGFPlotsTable Column Content

I have a CSV file containing a list of names, numbers and optionally pictures. This file is to be displayed in a multi-column table, with the name (and optionally appended picture as icon) in one ...
2
votes
2answers
73 views

Creating a multi-column table with dynamically wide columns from a CSV file

I'm trying to make a multi-column table take dynamic values, read from a CSV file. The current table looks like this and has been formatted manually with tabularx, without any multicolumn package ...
1
vote
1answer
72 views

pfgplots groupplot with more than one \addplot per \nextgroupplot?

I'm having trouble making a group plot in pgfplots. I want to have 2 separate graphs, each with two regression lines and two sets of dots, but groupplot lumps everything onto 1 set of axes. I can't an ...
7
votes
1answer
100 views

Plotting graphs from csv with pgfplots?

I am trying to plot a graph using pgfplots in which the data is read from a CSV file. My points show up fine, but when I try to add a regression line, it appears as a vertical line at x=0. Can anyone ...
0
votes
2answers
112 views

How to import CSV files into my own style of tables?

I've been using LaTeX to write lab reports for a year now, which includes manually entering data into tables. However, now I am performing experiments that have way more datapoints that manually ...
3
votes
0answers
84 views

csvautotabular with macro code headers

The manual states that macro code is allowed and will be processed accordingly using csvautotabular (section 4.3, page 31). The header allows some math mode macros such as underlines (X_{1}) and ...
2
votes
0answers
43 views

problems inserting commas in tables - pgfplotstable

I have a table I want to import into an appendix. The last column is a source key, and there are several sources in each cell I want to list as a, b, c; d, f, m; etc. However, the problem is the are ...
2
votes
1answer
57 views

manually inserting row lines when inputting csv to latex

I am making a long table for a paper appendix that spans multiple pages. I would like there to be no lines marking each row, except to designate sections. The only way I have figured out how to do it ...
1
vote
1answer
38 views

csvsimple creating multiple lines out of one entry

Data looks like this: name,job,age John,student,21 Frederik,student,18 Johnson,professor,49 I'd like to generate a table, that when for the first time a new job show up (the list is sorted by job), ...
4
votes
1answer
50 views

problematic extra cell when importing CSV to latex

I have a table that spans several pages I will be including in an appendix that I would like to import into my LaTex document from a csv. I found the long table answer post very helpful: Importing CSV ...
2
votes
2answers
85 views

Build PGF/TikZ matrix from CSV file

I want to automatically build a PGF/TikZ based drawing based on some external data that is read using csvsimple. My main issue at the moment is that most of the nodes are part of a matrix, mainly to ...
2
votes
0answers
43 views

manual generated toc page with wraps an tab stops [closed]

My last deeper contact with TeX was many years ago. Since then I use it only from time to time to assemble PDF pages with bookmarks etc. Now I need to manually create TOC pages for a collection of ...
1
vote
1answer
55 views

You can't use a prefix with `\char"FB': error when importing csv into latex

I'm trying to use the package csvsimple to create a table from a csv file. This worked so far, but when I try to add new figures/tables afterwards I get multiple errors. It looks like the \end ...
3
votes
1answer
120 views

How to make convert csv to fancy tables?

I want convert csv to fancy tables like this : First, I make a basic table with my MWE like this : \documentclass{article} %\usepackage{csvsimple} \usepackage{pgfplotstable,filecontents} ...
3
votes
1answer
73 views

Nested CSV with csvsimple

I have two csv files. I want to use the first (countries.csv) to generate sections, and then filter the second (bottles.csv) by the name of the section. Below is an MWE - you can see that the nested ...
1
vote
1answer
55 views

Speed up CSV loading with datatools package?

I am using the datatool package to read some CSV files. I've used the csvsimple package before, which I finally managed to break by adding more and more requirements to the mix. Now I'd like to switch ...
2
votes
0answers
88 views

PGFPlotstable with data from csv file : character µ and _ in column header

I have searched for a long time on the internet (here and other LaTeX resources on the web) but I could not find the answer to my (simple) question: how could I draw a table with Pgfplots, with data ...
6
votes
4answers
214 views

Sending Same Letter to multiple addresses

I'm sending the same letter to multiple addresses. The addresses are stored in a csv document. I've so far created a loop to create multiple letters, but I have not been successful in finding a ...
2
votes
1answer
60 views

pgfplots is skipping first ytickslabel from file

Rendering the MWE below pgfplots skips the first 'Adiff' label of the CSV. I'm sure this is a no-brainer and easy karma points for experienced pgfplots users, but I am stomped. ...
1
vote
1answer
85 views

How to create a large table with Pgfplots and string entries?

I tried to hack this here for a larger case but it is firing errors. What is causing the too many columns error and is Pgfplots ideal for this kind of table generation? Goal: table that I am trying ...
2
votes
2answers
202 views

Creating a table from CSV file with strings?

I want to create a table from a CSV file in LaTex. I am able to do it with numbers here but creating table for strings such as abbrevions does not work. What is the problem? MVE This example ...
1
vote
1answer
159 views

Custom table from csv file (multiple header rows)

I would like to create custom tables from .csv files. By custom I mean, that I only want LaTex to read in the body of the table, i.e. "a & b & ... \ ..." but I want to write my own header and ...
0
votes
1answer
76 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 ...
4
votes
1answer
839 views

Scatterplot with data from CSV file and trendline

I have created a scatterplot with code from this previous asked question. \documentclass[varwidth=true, border=2pt]{standalone} \usepackage[utf8]{inputenc} % this is needed for umlauts ...
3
votes
1answer
158 views

csvsimple handles underscores wrong

I try to print a .csv file with the help of the csvsimple package. My csv file contains underscores since it is generated out of a database which uses underscores in column names as convention. ...
1
vote
0answers
49 views

csv string to table without external files

I'm trying to create a Latex table from a CSV string. I saw a similar question , after which I started playing around with the csvsimple package (manual). What I don't understand is the need for ...
2
votes
1answer
219 views

Reading and (custom) formatting a CSV (not \csvautotabular)

Suppose I have a really long, really boring list of data in - let's say CSV, but converting to other formats is an option, when this can be done automatically - and I want to prepare a section in my ...
9
votes
2answers
1k views

Importing CSV file as a table in Latex but file too long

I am trying to import a CSV file but the data in the table is too long it goes down till the end of the page and disappears without continuing on the next page. Here's the file: ...
1
vote
0answers
153 views

How to read csv file with semicolon as delimiter [closed]

Suppose I have the following scientists.csv file: name,surname;age Albert,Einstein;133 Marie,Curie;145 Thomas,Edison;165 Now I want to use ; as the only delimiter: How can I do that? MWE ...
2
votes
1answer
384 views

How to read a csv file having #

I want to read from a csv file: \documentclass{article} \usepackage{csvsimple} \begin{document} \csvautotabular{initial.csv} \end{document} Now my initial.csv file looks like this: a, # b 1, 3 ...
4
votes
1answer
97 views

CSV Table Overflow with CSV Simple?

I have a large CSV data set (240 rows - 4 columns ). When I try to embed the data using csvsimple the table overflows instead of flowing to the next page. How can I get the table to flow onto the next ...
1
vote
1answer
243 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, ...
2
votes
0answers
68 views

Change unit from a read in data table [closed]

I use pgfplots to create a graph from a csv file. The column that I use for the x-axis contains time values measured in ms. As my timelapse is a bit more as a min I therefor have values between 1000 ...
8
votes
3answers
474 views

How can CSV files be put into LaTeX without having to adjust much?

I would like to have a TeX-Snippet that takes a filename as an argument and outputs a table with toprule and bottomrule: \begin{tabular}{lrr} \toprule Fach & Dauer & Einkommen\\ ...
1
vote
1answer
877 views

PGFplotstable: using a csv file with 4 columns

Suppose I have a csv file with no titles in it just data. The first column is time (x axis) and the next 3 columns each construct a different set; that is, plot(t, col1) is one set of data, plot(t, ...
1
vote
0answers
113 views

Create a bar char 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 ...
1
vote
1answer
683 views

Plotting Multiple Time Series plots in LaTeX using PGFplots and txt files - Relativity Issues

I have a problem with plotting multiple time series plots in a single graph in Latex. Background: I have three products - Potatoes, Apples, and Oranges. Each products' historical price and ...
1
vote
0answers
696 views

How to transform Google docs tables into Latex Tables?

I usually do all of my tables using Google Docs spreadsheet. This is a good and quick way to organize information and create quick tables. Now I am writing a document in Latex and I would like to ...
1
vote
1answer
236 views

csvsimple erros building csv table

I want to use the csv package to insert tables into my document. I am importing csv by using the \usepackage{csvsimple} command. Then, in the code, I use \csvautotabular{Tables/test} to create the ...
4
votes
1answer
59 views

\useplot with Text in CSV

Is there a way to import & auto-plot a graph containing text in one column? Eg. Here's my table Period,Unit Sales (in thousands) Q1 '07,24943 Q2 '07,27855 Q3 '07,32752 Q4 '07,36766 Edit: ...
5
votes
2answers
126 views

Auto-coalesce same values into \multirow

I am generating a pgfplotstable from a data file. In that file, within the Class column, subsequent rows with the same value should automatically be coalesced/collapsed/joined to form a ...
3
votes
1answer
549 views

pgfplots: how to load distinct symbolic ticks/labels from file?

I want to plot a matrix of color-values from a csv file. Inspired by this website, I set out to write my MWE below, to which I added this way of dynamically loading symbolic ticks/labels from my data ...
5
votes
4answers
3k views

How to compute an histogram (plot bars) binning the values from a .csv using TeX?

I've a .csv with a column of acquired measures. I would like to make the histogram bins using TeX from the measures distribution so I have to create the bins first. I haven't found any reference to ...
1
vote
1answer
125 views

How to display a number with many decimals and year correctly

I have a table in "import_csv_2.csv" as follows: No. Year W(G) 1 2010 0.02110333 2 2008 0.02082747 3 2006 0.02037291 ... \pgfplotstabletypeset[ col sep=comma, ...
8
votes
1answer
393 views

Huge table/matrix with colored boxes

I have a huge CSV file with about 25.5k records that (structurally) looks like the sample below. In essence, I want to display the values of the columns U,V,W,X,Y,Z of each row as a colored box. The ...
3
votes
2answers
571 views

Bar chart from CSV file with adjustable bar width

I have a CSV file with approximately 1500 records that I would like to plot using something like a bar chart, but I don't know where to start at all. Each record contains a width and a height, which ...