Sponsored Content
Top Forums UNIX for Dummies Questions & Answers Suggestion to convert data in rows to data in columns Post 302509296 by joeyg on Wednesday 30th of March 2011 12:48:32 PM
Old 03-30-2011
Please note that I tried to reformat your data, since it looked like some formatting got lost in your posting. Please verify, as the input layout will have a big effect on solutions.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Convert two column data into 8 columns

Apologies if this has been covered - I did search but couldn't find what I was looking for. I have a simple X-Y input file. I want to convert it from two columns into 8 columns - 4 pairs of X-Y data. So my input file looks like X1 Y1 X2 Y2 X3 Y3 X4 Y4 X5 Y5 etc And I want it to look... (8 Replies)
Discussion started by: NickC
8 Replies

2. Shell Programming and Scripting

Data in Rows to Columns

Hi, I am a beginner in bash&perl. I have data in form of:- A 1 B 2 C 3 D 4 E 5 I would like your help to find a simple way to change it to :- A B C D E 1 2 3 4 5 Any help would be highly appreciated. (8 Replies)
Discussion started by: umaars
8 Replies

3. Shell Programming and Scripting

Transpose columns to Rows : Big data

Hi, I did read a few posts on the subjects, tried out a few solutions, but did not solve my problem. https://www.unix.com/302121568-post11.html https://www.unix.com/shell-programming-scripting/137953-large-file-columns-into-rows-etc-4.html Please help. Problem very similar to the second link... (15 Replies)
Discussion started by: genehunter
15 Replies

4. UNIX for Dummies Questions & Answers

Convert Rows to Columns Specific Data

I have this data M36 AREA INFORMATION MDN = 0485009346 ESN = H'15fda0b0 TYPE = HLR RESULT = NOK REASON = UNRECOGNIZED MIN COMPLETED AREA INFORMATION MDN = 0498044402 ESN = H'15fdac11 TYPE... (2 Replies)
Discussion started by: krabu
2 Replies

5. Shell Programming and Scripting

Help for a Perl newcomer! Transposing data from columns to rows

I have to create a Perl script which will transpose the data output from my experiment, from columns to rows, in order for me to analyse the data. I am a complete Perl novice so any help would be greatly appreciated. The data as it stands looks like this: Subject Condition Fp1 ... (12 Replies)
Discussion started by: Sarah_W
12 Replies

6. Shell Programming and Scripting

Transpose Data from Columns to rows

Hello. very new to shell scripting and would like to know if anyone could help me. I have data thats being pulled into a txt file and currently have to manually transpose the data which is taking a long time to do. here is what the data looks like. Server1 -- Date -- Other -- value... (7 Replies)
Discussion started by: Mikes88
7 Replies

7. UNIX for Dummies Questions & Answers

Convert nxm Matrix into columns of data

Dear Unixers, I'm having some difficulty in converting an n x m data matrix into a dataset of 3 columns and nxm rows. As an example I want to convert this dataset 2 3 4 5 2 0.0 0.0 0.1 0.1 6 -0.3 2.0 0.0 0.3 7 -0.6 -1.1 0.5 0.3 9 -0.9 -4.1 -0.7 0.5 ... (2 Replies)
Discussion started by: tintin72
2 Replies

8. Shell Programming and Scripting

Convert Column data values to rows

Hi all , I have a file with the below content Header Section employee|employee name||Job description|Job code|Unitcode|Account|geography|C1|C2|C3|C4|C5|C6|C7|C8|C9|Csource|Oct|Nov|Dec|Jan|Feb|Mar|Apr|May|Jun|Jul|Aug|Sep Data section ... (1 Reply)
Discussion started by: Hypesslearner
1 Replies

9. Shell Programming and Scripting

Transpose comma delimited data in rows to columns

Hello, I have a bilingual database with the following structure a,b,c=d,e,f The right half is in a Left to right script and the second is in a Right to left script as the examples below show What I need is to separate out the database such that the first word on the left hand matches the first... (4 Replies)
Discussion started by: gimley
4 Replies

10. Shell Programming and Scripting

Extracting data from specific rows and columns from multiple csv files

I have a series of csv files in the following format eg file1 Experiment Name,XYZ_07/28/15, Specimen Name,Specimen_001, Tube Name, Control, Record Date,7/28/2015 14:50, $OP,XYZYZ, GUID,abc, Population,#Events,%Parent All Events,10500, P1,10071,95.9 Early Apoptosis,1113,11.1 Late... (6 Replies)
Discussion started by: pawannoel
6 Replies
NERO(1) 						   Alliance - nero User's Manual						   NERO(1)

NAME
nero - Negotiating Router SYNOPSIS
nero [ -h ] [ -v ] [ -V ] [ -c ] [ -2 ] [ -3 ] [ -4 ] [ -5 ] [ -6 ] [ -L ] [ -G ] [ --help ] [ --verbose ] [ --very-verbose ] [ --core-dump ] [ --local ] [ --global ] [ -p placement ] netlist layout DESCRIPTION
nero is a simple router suited for small academic designs. Currently it can process designs of size up to 4K gates. GLOBAL ROUTING A design is considered as big if it contains nets which half perimeter is greater than 800 lambdas. Global routing is used on big designs. In nero, "global routing" means that the longuests nets are completly routed in a first step with only routing layers numbers 3 & 4. Then the smaller nets are routed with all avalaibles layers. This implies that when global routing is used, the number of routing layers is forced to at least 4. In each step, the nets are routed from the shortest to the longuest with the same routing algorithm. INVOCATION
nero mandatory arguments : o netlist : the name of the design, whithout any extention. Please note that unless a -p placement option is given, the file holding the placement is expected to have the same name as the netlist file (short of the extention). o layout : the name of the resulting routed layout. Be careful of not giving the same name as the netlist, in this case the initial place- ment will be silently overwritten. nero optionnals arguments : o -h, --help : print help. o -v, --verbose : be verbose. o -V, --very-verbose : be unbearably verbose. o -c, --core-dump : do not prevent the generation of core dumps in case of a crash. Mostly used during the development stage. o -2, -3, -4, -5, -6 : set the numbers of layers used for routing. The default for small designs is 2 and 4 for big ones. When global rout- ing took place, the router will uses at least 4 routing layers. o -L, --local : turn off the global routing stage, whatever the size of the design. Be warned that this will enormously slow down the routing process. o -G, --global : turn on the global routing regardless of the size of the design. o -p placement, --place placement : specify a name for the placement file different from the netlist name. EXAMPLE
Route the netlist amd2901_core.vst, using the placement file amd2901_core_p.ap and store the result in amd2901_core_r. $ export MBK_IN_LO=vst $ export MBK_IN_PH=ap $ export MBK_OUT_PH=ap $ nero -V --place amd2901_core_p amd2901_core amd2901_core_r SEE ALSO
MBK_IN_LO(1), MBK_OUT_LO(1), MBK_IN_PH(1), MBK_OUT_PH(1), ocp(1), ocr(1), druc(1), cougar(1) ASIM
/LIP6 13 October 2002 NERO(1)
All times are GMT -4. The time now is 03:57 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy