Duplicate and change a column

Top Forums UNIX for Beginners Questions & Answers Duplicate and change a column

Prev Next

06-10-2017

Registered User

5, 2

Join Date: Jun 2017

Last Activity: 23 August 2017, 4:24 AM EDT

Posts: 5

Thanks Given: 4

Thanked 2 Times in 1 Post

Thanks to all the helpers.
Don - you are correct - I should have stated my problem better, didn't mean no offence by the partial comment.

This is my first post - I will check my input file and details better for the next ones.

These 2 Users Gave Thanks to yan1 For This Post:

yan1

View Public Profile for yan1

Find all posts by yan1

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Find duplicate values in specific column and delete all the duplicate values

Dear folks I have a map file of around 54K lines and some of the values in the second column have the same value and I want to find them and delete all of the same values. I looked over duplicate commands but my case is not to keep one of the duplicate values. I want to remove all of the same...

2. Shell Programming and Scripting

awk to sum a column based on duplicate strings in another column and show split totals

Hi, I have a similar input format- A_1 2 B_0 4 A_1 1 B_2 5 A_4 1 and looking to print in this output format with headers. can you suggest in awk?awk because i am doing some pattern matching from parent file to print column 1 of my input using awk already.Thanks! letter number_of_letters...

3. Shell Programming and Scripting

Duplicate third column to every line

Dear All, I have file input like this: INP901 5173 4114 INP902 5227 INP903 5284 INP904 5346 INP905 5400 INP906 5456 INP907 5511 INP908 5572 INP909 5622 INP910 5678 INP911 5739 INP912 5796 INP913 5845 INP914 5910 INP915 5965

4. Shell Programming and Scripting

Change column to row base on column 2

Hi Guys, Input.txt L194 A -118.2 L194 B -115.1 L194 C -118.7 L196 A 0 L196 C 0 L197 A -111.2 L197 B -118.9 L197 C -119.9 L199 A -120.4 L199 B -119.9 ...

5. Shell Programming and Scripting

Help with duplicate column 1 data

Input file Q6GZV8 AY548484>AAT09676.1>YP_031595.1>2947737>CLSP2512393 P0C9E9 AY261366 P0C9K3 AY261361>IPR004848>PF01639 P0C9I4 AY261363>IPR004848 Desired output file Q6GZV8 AY548484 Q6GZV8 AAT09676.1 Q6GZV8 YP_031595.1 Q6GZV8 2947737 Q6GZV8 CLSP2512393 P0C9E9 AY261366...

6. Shell Programming and Scripting

awk or sed: change the color of a column w/o screwing up column spacing

Hey folks. I wrote a little awk script that summarizes /proc/net/dev info and then pipes it to the nix column command to set up column spacing appropriately. Here's some example output: Iface RxMBytes RxPackets RxErrs RxDrop TxMBytes TxPackets TxErrs TxDrop bond0 9 83830...

7. UNIX for Dummies Questions & Answers

awk: duplicate a column into a new one

Hi ! I have a "|" delimited file: field 1|field2|field3|field4 AAA|BBB|CCC|DDD EEE|FFF|GGG|HHH Using awk, I need to duplicate the 2nd column and print it into a 5th new column, like that: output: field 1|field2|field3|field4|field 2 AAA|BBB|CCC|DDD|BBB EEE|FFF|GGG|HHH|FFF Thanks...

8. Shell Programming and Scripting

Change file content 4 column to one Column using script

Hi Gurus, I have file content sample: ,5113955056,,TAgent-Suspend ,5119418233,,TAgent-Suspend ,5102119078,,TAgent-Suspend filenames 120229H5_suspend, 120229H6_unsuspend I receive those files one of directory /home/temp/ I need following: 1. Backup first /home/temp/ file to...

9. Shell Programming and Scripting

duplicate a column with awk

I have some tab delimited data and I need to duplicate the second column. It seems like I should just be able to do something simple in awk like, awk '{ print $1, $2, $2, $3 }' (the second field is the one that needs to be duplicated) but I'm not sure how to print from $3 to the end of the...

10. Shell Programming and Scripting

Change names in a column based on the symbols in another column

If the 4th column has - sign then the names in 3rd column has to change to some user defined names (as shown in output). Thanx input1 1 a aaaaa + 2 b bbbbb + 3 c ccccc + 4 d ddddd + 5 e eeeee + 6 f xxxxx + 8 h hhhhh +...

LEARN ABOUT DEBIAN

svg::graph

Graph(3pm)						User Contributed Perl Documentation						Graph(3pm)

NAME

       SVG::Graph - Visualize your data in Scalable Vector Graphics (SVG) format.

SYNOPSIS

	 use SVG::Graph;
	 use SVG::Graph::Data;
	 use SVG::Graph::Data::Datum;

	 #create a new SVG document to plot in...
	 my $graph = SVG::Graph->new(width=>600,height=>600,margin=>30);

	 #and create a frame to hold the data/glyphs
	 my $frame = $graph->add_frame;

	 #let's plot y = x^2
	 my @data = map {SVG::Graph::Data::Datum->new(x=>$_,y=>$_^2)}
			(1,2,3,4,5);
	 my $data = SVG::Graph::Data->new(data => @data);

	 #put the xy data into the frame
	 $frame->add_data($data);

	 #add some glyphs to apply to the data in the frame
	 $frame->add_glyph('axis',	  #add an axis glyph
	   'x_absolute_ticks' => 1,	  #with ticks every one
					  #unit on the x axis
	   'y_absolute_ticks' => 1,	  #and ticks every one
					  #unit on the y axis

	   'stroke'	      => 'black', #draw the axis black
	   'stroke-width'     => 2,	  #and 2px thick
	 );

	 $frame->add_glyph('scatter',	  #add a scatterplot glyph
	   'stroke' => 'red',		  #the dots will be outlined
					  #in red,
	   'fill'   => 'red',		  #filled red,
	   'fill-opacity' => 0.5,	  #and 50% opaque
	 );

	 #print the graphic
	 print $graph->draw;

DESCRIPTION

       SVG::Graph is a suite of perl modules for plotting data.  SVG::Graph currently supports plots of one-, two- and three-dimensional data, as
       well as N-ary rooted trees.  Data may be represented as:

	Glyph Name     Dimensionality supported
		       1d      2d      3d      tree
	--------------------------------------------------------
	Axis			       x
	Bar Graph	       x
	Bubble Plot		       x
	Heatmap Graph		       x
	Line Graph	       x
	Pie Graph      x
	Scatter Plot	       x
	Spline Graph	       x
	Tree				       x

       SVG::Graph 0.02 is a pre-alpha release. Keep in mind that many of the glyphs are not very robust.

PLOTTING

       You need to create a SVG::Graph::Frame instance from the parent SVG::Graph instance for each set of data to be plotted.	Datasets can be
       hierarchical, and to represent this, SVG::Graph::Frame instances can themselves contain subframes.  SVG::Graph::Frame can contain:

	- multiple subframes as instances of SVG::Graph::Frame
	- a single SVG::Graph::Data instance
	- multiple SVG::Graph::Glyph instances with which to render
	  the attached SVG::Graph::Data instance, and all SVG::Graph::Data
	  instances attached to SVG::Graph::Frame subinstances

       See SVG::Graph::Frame and SVG::Graph::Glyph for details.

   ONE DATA SET
	1. create an SVG::Graph instance
	2. create an SVG::Graph::Frame instance by calling
	   SVG::Graph::add_frame();
	3. create an SVG::Graph::Data instance, containing
	   an SVG::Graph::Data::Datum instance for each data point.
	4. Attach the SVG::Graph::Data instance to your SVG::Graph::Frame
	   using SVG::Graph::Frame::add_data();
	5. Attach glyphs to the SVG::Graph::Frame instance using
	   SVG::Graph::Frame::add_glyph();
	6. Call SVG::Graph::draw();

   MULTIPLE DATA SETS
	1. create an SVG::Graph instance
	2. create an SVG::Graph::Frame instance by calling
	   SVG::Graph::add_frame();
	3. create an SVG::Graph::Data instance, containing
	   an SVG::Graph::Data::Datum instance for each data point.
	4. Attach the SVG::Graph::Data instance to your SVG::Graph::Frame
	   using SVG::Graph::Frame::add_data();
	5. Attach glyphs to the SVG::Graph::Frame instance using
	   SVG::Graph::Frame::add_glyph();
	6. repeat [2-5] for each additional data set to be added.
	   add_frame() can be called on SVG::Graph to add top-level data
	   sets, or SVG::Graph::Frame to add hierarchical data sets.
	7. Call SVG::Graph::draw();

FEEDBACK

       Send an email to the svg-graph-developers list.	For more info, visit the project page at http://www.sf.net/projects/svg-graph

AUTHORS

	Allen Day,	<allenday@ucla.edu>
	Chris To,	<crsto@ucla.edu>

CONTRIBUTORS

	James Chen,	<chenj@seas.ucla.edu>
	Brian O'Connor, <boconnor@ucla.edu>

SEE ALSO

       SVG

METHODS

   new
	Title	: new
	Usage	: my $graph = SVG::Graph->new(width=>600,
					      height=>600,
					      margin=>20);
	Function: creates a new SVG::Graph object
	Returns : a SVG::Graph object
	Args	: width => the width of the SVG
		  height => the height of the SVG
		  margin => margin for the root frame

   init
	Title	: init
	Usage	:
	Function:
	Example :
	Returns :
	Args	:

   width
	Title	: width
	Usage	: $obj->width($newval)
	Function:
	Example :
	Returns : value of width (a scalar)
	Args	: on set, new value (a scalar or undef, optional)

   height
	Title	: height
	Usage	: $obj->height($newval)
	Function:
	Example :
	Returns : value of height (a scalar)
	Args	: on set, new value (a scalar or undef, optional)

   margin
	Title	: margin
	Usage	: $obj->margin($newval)
	Function:
	Example :
	Returns : value of margin (a scalar)
	Args	: on set, new value (a scalar or undef, optional)

   svg
	Title	: svg
	Usage	: $obj->svg($newval)
	Function:
	Example :
	Returns : value of svg (a scalar)
	Args	: on set, new value (a scalar or undef, optional)

   add_frame
	Title	: add_frame
	Usage	: my $frame = $graph->add_frame
	Function: adds a Frame to the current Graph
	Returns : a SVG::Graph::Frame object
	Args	: a hash.  usable keys:
		    frame_transform (optional)
		      'top' default orientation
		      'bottom' rotates graph 180 deg (about the center)
		      'right' points top position towards right
		      'left' points top position towards left

   frames
	Title	: frames
	Usage	: get/set
	Function:
	Example :
	Returns :
	Args	:

   xoffset
	Title	: xoffset
	Usage	: $obj->xoffset($newval)
	Function:
	Example :
	Returns : value of xoffset (a scalar)
	Args	: on set, new value (a scalar or undef, optional)

   yoffset
	Title	: yoffset
	Usage	: $obj->yoffset($newval)
	Function:
	Example :
	Returns : value of yoffset (a scalar)
	Args	: on set, new value (a scalar or undef, optional)

   draw
	Title	: draw
	Usage	: $graph=>draw
	Function: depends on child glyph implementations
	Returns : xmlifyied SVG object
	Args	: none

perl v5.10.0							    2009-01-07								Graph(3pm)

UNIX for Beginners Questions & Answers