All Questions
8 questions
-1
votes
3
answers
250
views
Issues related to grep command looping for multiple csv files
I made a for loop script as shown below,
for file in *.csv
do
grep raxA $file > new_${file}
done &&
mkdir raxA && mv new_* raxA &&
for file in *.csv
do
grep raxB $file > ...
- 129
1
vote
1
answer
1k
views
Export command output specific lines and put it into CSV file
Could you assist me how to retrieve specific lines and put it into CSV file?
How to process the output via Bash and Python3?
Remark:
"objectID" represents each found server
"An instance of Path" ...
- 53
3
votes
3
answers
257
views
Text Manipulation - Transpose column into rows depending on the value
I want to write a code to be able to manipulate text on my CSV file which contains the following:
71w - Rus,51200
71w - Phi,307200
71w - Ukr,307200
71w - Ukr,51200
71w - Mic,102400
71w - Mic,51200
...
1
vote
0
answers
388
views
Large file processing performance
I did a simple performance test of csv processing a while ago, and want to share results with community, maybe you can point out, what test could be more precise and fair.
Firstly i took out 42 MB ...
2
votes
3
answers
1k
views
Customized Sort and remove double quotes join by underscore of multiple columns from tab delimited file
Custom Sort based on subject column order should be Maths, English, Science
when I use this below command
awk -F',' '{if (NR!=1) {print $2,$3,$5,$4}}' myfile.csv
on my myfile.csv I am getting like ...
- 53
3
votes
4
answers
812
views
Selecting lines in a file that do not contain the value in the other file
I have two files. One is a CSV of data with 60490 lines. Each line is a set of values such as a customer name, service dates, etc.
One of these values in the first file is a VIN value.
I have a ...
- 103
41
votes
17
answers
38k
views
Converting CSV to TSV
I have a number of large CSV files and would like them in TSV (tab separated format). The complication is that there are commas in the fields of the CSV file, eg:
A,,C,"D,E,F","G",I,"K,L,M",Z
...
user14755
1
vote
5
answers
192
views
Replicate a column in a one-line CSV file
I have a file that consists of a single line:
a,x,b,c,d,e
I want to convert this into
a,x,b,x,c,x,d,x,e,x
Which is the easiest way to achieve this? A solution based on Python will be most helpful
...
- 3,086