0
votes
1answer
19 views

How to add a prefix to every row of a particular column in a csv file via command line on linux

So basically i am trying to achieve the following.    File before editing.  column-1,   column-2,  column-3,  column-4,  column-5 Row-1-c1, ...
0
votes
2answers
169 views

Delete empty column from csv file with bash script

Looking for some way to look at a csv file and delete columns including the header that have no values in the subsequent lines that follow. Perhaps if I wanted to delete column Test03 from below ...
3
votes
1answer
613 views

Unix command to get number of lines in a CSV file

I have to get the count of lines from incoming CSV files. I have used the following command to get the count. wc -l filename.csv Consider files coming with 1 record I am getting some files with * ...
2
votes
0answers
158 views

Open only the first 10 lines of large CSV file in LibreOffice Calc

I will start receiving many large CSV files, of which only the first few lines are of interest to me. I was hoping to open them by piping only the first few lines to Calc, but this doesn't work: $ ...
1
vote
4answers
402 views

How to split CSV files as per number of rows specified?

I've CSV file (around 10,000 rows ; each row having 300 columns) stored on LINUX server. I want to break this CSV file into 500 CSV files of 20 records each. (Each having same CSV header as present in ...
0
votes
3answers
81 views

Pre-pending to an output line of `tail -f file` if its contents match another file

Trying to cram all of the following into the title was hard, so this is what I really mean: I am doing a tail -F access.log to watch an Apache2 log in realtime. The first thing on each line is an IP ...
1
vote
1answer
120 views

Regex to join fields in a CSV

I have a CSV with over 2 million records in it with the following format. path;name;extension;size;date;user /foo/;difacs;cgi;3,795;18-07-2011;Unix User\pads ...
1
vote
3answers
773 views

csv averages on linux command line

Hey I have a big file full of records like this 1, 2, 4, 5, 6 1, 3, 5, 6, 3 1, 4, 5, 6, 6 2, 4, 5, 5, 5 2, 3, 4, 5, 2 anyway i need to take the average of all rows with the same 1st number(key). ...
2
votes
1answer
239 views

What's a good linux program to make a depth map or 3d plane from a csv file of coordinates?

The title just about says it all...I have a list of evenly-spaced points in a csv file like this: x,y,z 5,3,3.2 5,6,4.3 5,9,5.4 10,3,4 10,6,3.8 10,9,3.6 15,3,4.8 15,6,4 15,9,3.5 And I need a depth ...
11
votes
4answers
6k views

How to join two CSV files?

Suppose you have one CSV file with 2 fields: ID and email. You have another file with 2 fields: email and name. How can you produce a file with all three fields joined on email?