|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Compare 2 files of csv file and match column data and create a new csv file of them
Post 302938939 by RudiC on Friday 20th of March 2015 07:11:56 AM
03-20-2015
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi all,
Am new to scripting. So i just need your ideas to help me out. Here goes my requirement.
I have two csv files
1.csv 2.csv
abc,1.24 abc,1
def,2.13 def,1
I need to compare the first column of 1.csv with 2.csv and if matches then need to compare... (2 Replies)
Discussion started by: chinnahyd
2 Replies
2. Shell Programming and Scripting
I've got two large csv text table files with different number of columns each.
I have to compare them based on first two columns and create resulting file
that would in case of matched first two columns include all values from first one and all values (except first two colums) from second one. I... (5 Replies)
Discussion started by: agb2008
5 Replies
3. Shell Programming and Scripting
Hello everyone!!
I am not completely new to shell script but I havent been able to find the answer to my problem and I'm sure there are some smart brains here up for the challenge :D.
I have several CSV files that I need to combine into one, but I also need to know where each row came from.... (7 Replies)
Discussion started by: fransanchezoria
7 Replies
4. Shell Programming and Scripting
Hi Friends,
I'm a great fan of this forum... it has helped me tone my skills in shell scripting. I have a challenge here, which I'm sure you guys would help me in achieving...
File A has a list of job ids and I need to compare this with the File B (*.log) and File C (extend *.log) and copy... (6 Replies)
Discussion started by: asnandhakumar
6 Replies
5. Shell Programming and Scripting
(say) I have 2 csv files - file1.csv & file2.csv as mentioned below:
file1.csv
ID,version,cost
1000,1,30
2000,2,40
3000,3,50
4000,4,60
file2.csv
ID,version,cost
1000,1,30
2000,2,45
3000,4,55
6000,5,70
The... (7 Replies)
Discussion started by: Naresh101
7 Replies
6. Shell Programming and Scripting
Hi,
I have a file of csv data, which looks like this:
file1:
1AA,LGV_PONCEY_LES_ATHEE,1,\N,1,00020460E1,0,\N,\N,\N,\N,2,00.22335321,0.00466628
2BB,LES_POUGES_ASF,\N,200,200,00006298G1,0,\N,\N,\N,\N,1,00.30887539,0.00050312... (10 Replies)
Discussion started by: djoseph
10 Replies
7. Shell Programming and Scripting
I am running an ISQL command on Sybase DB and getting output of a query in an CSV file.
The issue is that all the data comes in to the same column, i want them to be separated in different columns.
SQL_COMMAND=command.sql
file=file.txt
formatFile=formatFile.txt
report=report.csv
echo... (1 Reply)
Discussion started by: Sharma331
1 Replies
8. Shell Programming and Scripting
I am trying to parse two csv files and make a match in one column then print the entire file to a new file and append an additional column that gives description from the match to the new file. If a match is not made, I would like to add "NA" to the end of the file
Command that Ive been using... (6 Replies)
Discussion started by: dis0wned
6 Replies
9. Shell Programming and Scripting
Need awk or Shell script to compare Column-1 of two different CSV files and print if column-1 matche
Example:
I have files in below format
file 1:
zxc,133,joe@example.com
cst,222,xyz@example1.com
File 2 Contains:
hxd
hcd
jws
zxc
cst
File 1 has 50000 lines and file 2 has around 30000 lines :
Expected Output has to be :
hxd
hcd
jws (5 Replies)
Discussion started by: TestPractice
5 Replies
10. UNIX for Beginners Questions & Answers
1.csv contains following column-
Empid code loc port
101 A xy 01
102 B zx 78
103 A cg 12
104 G xy 78
2.csv contains follwing data-
Empid code loc port
101 A gf 01
102 B zx 78
103 C cg 32
104 ... (1 Reply)
Discussion started by: rishabh
1 Replies
LEARN ABOUT DEBIAN
pymetrics
PYMETRICS(1) User Commands PYMETRICS(1) NAME
pymetrics - Python source code metrics SYNOPSIS
pymetrics [options] files... DESCRIPTION
This manual page documents briefly the pymetrics command pymetrics is a program that produces metrics for Python programs. Metrics include McCabe's Cyclomatic Complexity metric, LoC, %Comments, etc. Users can also define their own metrics using data from PyMetrics. PyMetrics optionally outputs to stdout, SQL command files and CSV files. OPTIONS
These programs follow the usual GNU command line syntax, with long options starting with two dashes (`-'). A summary of options is included below. -h, --help show this help message and exit -s SQLFILENAME, --sql=SQLFILENAME name of output SQL command file. (Default is metricData.sql) -t SQLTOKENTABLENAME, --tokentable=SQLTOKENTABLENAME name of output SQL token table. (Default is metricTokens) -m SQLMETRICSTABLENAME, --metricstable=SQLMETRICSTABLENAME name of output SQL metrics table. (Default is metricData) -c CSVFILENAME, --csv=CSVFILENAME name of output CSV data file. (Default is metricData.csv) -f INFILELIST, --files=INFILELIST File containing list of path names to modules for analysis. -i INCLUDEMETRICSSTR, --include=INCLUDEMETRICSSTR list of metrics to include in run. This is a comma separated list of metric module names with no whitespace. Optionally, you can specify the class name of the metric by following the module name with a colon (:) and the metric class name. (Default metrics are 'simple:SimpleMetric,mccabe:McCabeMetric,sloc:SLOC Metric'. Default metric class name for metric module 'wxYz' is 'WxYzMetric' when only module name given -- note capitalized metric class name.) -l LIBNAME, --library=LIBNAME user-defined name applied to collection of modules (Default is '') -e, --exists assume SQL tables exist and does not generate creation code. Using this option sets option -N. (Default is False) -N, --noold create new command output files and tables after deleting old results, if any. Ignored if -e is set. (Default is False) -B, --nobasic suppress production of Basic metrics (Default is False) -S, --nosql suppress production of output SQL command text file. (Default is False) -C, --nocsv suppress production of CSV output text file. (Default is False) -H, --noheadings suppress heading line in csv file. (Default is False) -k, --kwcnt generate keyword counts. (Default is False) -K, --nokwcnt suppress keyword counts. (Default is True) -q, --quiet suppress normal summary output to stdout. (Default is False) -z, --zero display zero or empty values in output to stdout. (Default is to suppress zero/empty output) -v, --verbose Produce verbose output - more -v's produce more output. (Default is no verbose output to stdout) -d, --debug Provide debug output, not usually generated - internal use only AUTHOR
pymetrics was written by Reg. Charney. This manual page was written by Andrew Pollock <apollock@debian.org>, for the Debian project (but may be used by others). pymetrics 0.8.1 September 2009 PYMETRICS(1)