Comma-Separated Values are a list of plain text values delimited by commas, or a file containing one or more lists in that format.

learn more… | top users | synonyms

0
votes
0answers
9 views

Tools for big CSV files manipulations [migrated]

I'm working with a huge CSV dataset and I'm now make some pre-processing on it. The pre-processing consists of removing lines with "not a numbers", change columns positions or remove lines. Is there ...
3
votes
2answers
85 views

Visualize a lot of words

I have a CSV file with a set of words occurrences in several documents. The first column is the document it. The second column states the text topic (there are 5 different topics). The other columns ...
30
votes
7answers
6k views

Why is a comma a bad record separator/delimiter?

I was reading this article and I'm curious for the proper answer to this question. The only thing that comes to my mind it's perhaps that in some countries the decimal separator is a comma, and it ...
1
vote
1answer
249 views

How to convert the text columns to libsvm format using feature hasher from scikit learn

This answer links to a code which only works for numeric data , but I have CSV file for machine learning which has mostly text data and most columns have a large cardinality , eg: a column with name ...
0
votes
0answers
131 views

Naming convention for column names

I have a general question. Is there any rule or convention about how to name columns in general (CSV, R, relational databases and so on)?. If I need to be more specific, I would like to know for R. I ...
8
votes
5answers
625 views

What is a good general purpose plain text data format like that used for Bibtex?

Context I'm writing a few multiple choice practice questions and I'd like to store them in a simple plain text data format. I've previously used tab delimited, but that makes editing in a text editor ...
3
votes
1answer
4k views

How to choose a data subset in RapidMiner?

I'm working with a CSV which contains approximately 220,000 entries. My aim is to predict one of the attributes (ATT1) using the other 3 (ATT2, ATT3, ATT4). I've been able to do this using NaiveBayes,...
16
votes
5answers
577 views

Simple, reliable, open, and interoperable plain text format for storing data

In a previous question I asked about tools for editing CSV files. Gavin linked to a comment on R Help by Duncan Murdoch suggesting that Data Interchange Format is a more reliable way to store data ...
13
votes
7answers
8k views

Strategy for editing comma separated value (CSV) files

When I work on data analysis projects I often store data in comma or tab-delimited (CSV, TSV) data files. While data often belongs in a dedicated database management system. For many of my ...
16
votes
7answers
9k views

What is the easiest way to create publication-quality plots under Linux?

We may assume that we have CSV file and we want a very basic line plot with several lines on one plot and a simple legend.