[Solved] Sorting a column based on another column Post: 302744471

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

sorting csv file based on column selected

Hi all, in my csv file it'll look like this, and of course it may have more columns US to UK;abc-hq-jcl;multimedia UK to CN;def-ny-jkl;standard DE to DM;abc-ab-klm;critical FD to YM;la-yr-tym;standard HY to MC;la-yr-ytm;multimedia GT to KJ;def-ny-jrt;critical I would like to group...

2. Shell Programming and Scripting

sorting based on a specified column in a text file

I have a tab delimited file with 5 columns 79 A B 20.2340 6.1488 8.5086 1.3838 87 A B 0.1310 0.0382 0.0054 0.1413 88 A B 46.1651 99.0000 21.8107 0.2203 89 A B 0.1400 0.1132 0.0151 0.1334 114 A B 0.1088 0.0522 0.0057 0.1083 115 A B...

3. Emergency UNIX and Linux Support

[Solved] Extract records based on a repeated column value

Hi guys, I need help in making a command to find some data. I have multiple files in which multiple records are present.. Each record is separated with a carriage return and in each record there are multiple fields with each field separated by "|" what i want is that I want to extract...

4. Shell Programming and Scripting

[SOLVED] Sorting into new files based on column

Hi, I have the following file, I need to sort it based on a column and write to different output files based on this column request_guid iso_country_cd address_data response_time 32895901-d17f-414c-ac93-3e7e0f5ec240 AND BaseName:CATALUNYA; HouseNumber:1; ISOCountryCode:AND;...

5. UNIX for Dummies Questions & Answers

Sorting a file based on the absolute value of a column

I would like to sort a tab delimited text file based on the absolute value of its second column. How do I go about doing that? Thanks! Example input: A -12 B 0 C -6 D 7 Output: A -12 D 7 C -6 B 0

6. Shell Programming and Scripting

Sorting file based on a numeric column

Hi, I use UBUNTU 12.04. I have a file with this structure: Name 2 1245787 A G 12 14 12 14 .... Name 1 1245789 C T 13 12 12 12..... I would like to sort my file based on the second column so to have this output for example: Name 1 1245789 C T 13 12 12 12..... Name 2 1245787 A G 12 14...

7. UNIX for Dummies Questions & Answers

[Solved] Deleting all rows where the first column equals the second column

Hi, I have a tab delimited text file where the first two columns equal numbers. I want to delete all rows where the value in the first column equals the second column. How do I go about doing that? Thanks! Input: 1 1 ABC DEF 2 2 IJK LMN 1 2 ZYX OPW Output: 1 2 ZYX OPW

8. Shell Programming and Scripting

[Solved] Sorting a column in a file based on a column in a second file

Hello, I have two files as the following: File1: F0100020 A G F0100030 A T F0100040 A G File2: F0100040 A G BTA-28763-no-rs 77.2692 F0100030 A T BTA-29334-no-rs 11.4989 F0100020 A G BTA-29515-no-rs 127.006 I want to sort the second file based on the...

9. 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...

10. Shell Programming and Scripting

Sum column values based in common identifier in 1st column.

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...

LEARN ABOUT DEBIAN

plotit

plotit(1)						      General Commands Manual							 plotit(1)

NAME

       plotit - experiment data visualization

SYNOPSIS

       plotit -w FILE
       plotit [-lp] -q FILE [FILE]...
       plotit [-lp] Y FILE [FILE...]
       plotit [-lp] X Y FILE [FILE...]

DESCRIPTION

       The  plotit program is a simple plotting program which can draw line plots and stripcharts using a command language similar to that of gnu-
       plot.  It can also make quick plots of multiple data files from the command-line.  Wildcards may be used in the file names.

       The program takes optional expressions which can be used to manipulate data columns before plotting.  Expressions may be as simple  as  the
       designation  of	a  column  to  be  plotted or may contain arithmetic expressions and functions.  In the latter case the espression must be
       enclosed in 'single' or "double" quotation marks. Column numbers are designated by the at-sign character (@).  A single expression is  used
       for the Y axis of the plot.

OPTIONS

       -h, --help
	      Print the usage and exit.

       --version
	      Print the version number and exit.

       -w     Watch  the input file for commands to stripchart, or wait to read all of stdin before plotting.  Only one file or - for stdin may be
	      specified with this option.  No other options may be used in conjuction with this option.

       -q     Plot the first and second columns of each file.

       -l     Plot with lines.

       -p     Plot with points.

EXAMPLES

       Plot the second column versus the first of all three files with lines only.

	      plotit -lq file1.dat file2.dat file3.dat

       Plot the quotient of the third column and the second column versus the first column of all files matching the pattern using points only.

	      plotit -p '@3/@2' file??.dat

       Plot the natural log of the second column divided by the third column versus the fourth column.	By default these  data	are  plotted  with
       both lines and points.

	      plotit @4 'log(@2/@3)' file.dat

AUTHOR

       This manual page was written by Carlo Segre <segre@iit.edu>.

								 February 21, 2009							 plotit(1)