Hello
I have file that consist of 2 columns of millions of entries
timestamp and throughput
I want to find the average (throughput ) for each equal timestamp before change it to proper format
e.g : i want to average 2 coloumnd fot all 1308154800 values in column 1
and then
print... (4 Replies)
Hi i have data with two columns like below.
I want to find average of column values like if the value in column 2 is between 0-250000 the average of column 1 is some xx and average of column2 is ww then if value is 250001-5000000 average of column 1 is yy and average of column 2 is zz.
And my... (5 Replies)
My scenario is that I need to pick value from third column based on fourth column value, if fourth column value is 1 then first value of third column.Third column (2|3|4|6|1) values are cancatenated.
Please someone help me to resolve this issue.
Source
column1 column2 column3 column4... (2 Replies)
Hello,
I have a data such as this:
ENSGALG00000000189 329 G A 4 2 0
ENSGALG00000000189 518 T C 5 1 0
ENSGALG00000000189 1104 G A 5 1 0
ENSGALG00000000187 3687 G T 5 1 0
ENSGALG00000000187 4533 A T 4 2 0
ENSGALG00000000233 5811 T C 4 2 0
ENSGALG00000000233 5998 C A 5 1 0
I want to... (3 Replies)
Hi,
I have a table to be imported for R as matrix or data.frame but I first need to edit it because I've got several lines with the same identifier (1st column), so I want to sum the each column (2nd -nth) of each identifier (1st column)
The input is for example, after sorted:
K00001 1 1 4 3... (8 Replies)
Dear all ...
I have a file which I want to change the structure based on the values in some columns and I would be grateful if you can help...
one of my files looks like ... they all have ten rows
1,0,0
10,0,0
2,0,0
3,0,0
4,1,1
4,1,1
4,1,1
5,0,0
6,0,0
7,0,0
8,0.5,2
9,0.33,3
9,0.33,3... (1 Reply)
Hi,
Please help to fetch the values for a key from below data format in linux.
Sample Input Data Format
11055005|PurchaseCondition|GiftQuantity|1
11055005|PurchaseCondition|MinimumPurchase|400
11055005|GiftCatalogEntryIdentifier|Id|207328014
11429510|PurchaseCondition|GiftQuantity|1... (2 Replies)
I have a file (myfile.txt) with contents like this:
1.txt apple is
3.txt apple is
5.txt apple is
2.txt apple is a
7.txt apple is a
8.txt apple is a fruit
4.txt orange not a fruit
6.txt zero isThe above file is already sorted using this command:
sort -k2 myfile.txtMy objective is to get... (3 Replies)
Hi there,
I am trying to filter a big file with several columns using values on a column with values like (AC=5;AN=10;SF=341,377,517,643,662;VRT=1). I wont to filter the data based on SF= values that are (bigger than 400)
... (25 Replies)
Discussion started by: daashti
25 Replies
LEARN ABOUT DEBIAN
dctable
DCTABLE(1) DICOM PS3 - Make tables of attribute values DCTABLE(1)NAME
dctable - ACR/NEMA DICOM PS3 ... DICOM PS3 - Make tables of attribute values
SYNOPSIS
dctable " inputfile1 [ inputfile2 ... ]" [ -ignorereaderrors ] [ -v|verbose ] [ -r|recurse ] [ -describe ] [ -nofilename ] [ -noembed-
dedquotes ] [ -key|k elementname|(0xgggg,0xeeee) ] ... [ -input-nometa ] [ -input-ts uid ] [ -input-default ] [ -input-byte-
order|-input-endian big|little ] [ -input-vr implicit|explicit ]
DESCRIPTION
dctable reads the named dicom input files and creates a tab delimited table of the values of the selected attributes, with each value
enclosed in double quotes.
Binary attributes are written in hexadecimal with a preceding "0x". Numeric string attributes are written in decimal.
The first column always contains the filenames.
A header is a added only if the -describe option is specified.
If a specified attribute is not present in a file, then it the corresponding entry in the table will be empty (i.e. two consecutive quotes"
but this is not reported as an error.
OPTIONS
The table of attribute values go to standard output, and the verbose output and errors go to standard error.
The basic input switches are described in dcintro(1). Options specific to this program are:
-describe
Add a first line of output that is a header describing the attributes in each column.
-nofilename
Do not include the filename in the table.
-noembeddedquotes
Remove embedded quotes (") from within displayed values to allow them to be parsed consistenty later; also has the side effect of
displaying numeric binary values as decimal rather than hexadecimal.
-k|key elementname|(0xgggg,0xeeee)
Add a key to the list of attributes to be extracted. The attribute may also be specified as a hexadecimal pair of the form
(0xgggg,0xeeee), which also allows private attributes to be fetched.
-r|recurse
If any attribute is not found in the top level dataset, recurse through sequence attribute items until the first instance is found.
This is a depth-first traversal, i.e., all children of the first item of a sequence are searched before the sibling items.
-ignorereaderrors
Attempt to extract key values even if errors encountered whilst parsing DICOM file.
ENVIRONMENT EXAMPLES
% dctable -k Rows -k Columns
-describe test.dc3
"Filename" "Rows" "Columns"
"test.dc3" "0x0100" "0x0100"
FILES SEE ALSO dcintro(1),dckey(1)AUTHOR
Copyright (C) 2012. David A. Clunie. All rights reserved.
BUGS
Attempts to extract sequences or OB,OW attributes may fail nastily.
The order in which the attributes are extracted and written is not the same order as they are specified on the command line, and should not
be depended on.
DICOM PS3 28 March 2012 DCTABLE(1)