Remove duplicates in a dataframe (table) keeping all the different cells of just one of the columns Post: 303032096

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Deleting table cells in a script

I'd like to use sed or awk to do this but I'm weak on both along with RE. Looking for a way with sed or awk to count for the 7th table data within a table row and if the condition is met to delete "<td>and everything in between </td>". Since the table header start on a specific line each time, that...

2. Shell Programming and Scripting

Remove duplicates based on the two key columns

Hi All, I needs to fetch unique records based on a keycolumn(ie., first column1) and also I needs to get the records which are having max value on column2 in sorted manner... and duplicates have to store in another output file. Input : Input.txt 1234,0,x 1234,1,y 5678,10,z 9999,10,k...

3. Shell Programming and Scripting

Search based on 1,2,4,5 columns and remove duplicates in the same file.

Hi, I am unable to search the duplicates in a file based on the 1st,2nd,4th,5th columns in a file and also remove the duplicates in the same file. Source filename: Filename.csv "1","ccc","information","5000","temp","concept","new" "1","ddd","information","6000","temp","concept","new"...

4. UNIX for Dummies Questions & Answers

Two files; if cells match then copy over other columns

My current issue is dealing with two space delimited files. The first file has column 1 as the sample ID's, then columns 2 - n as the observations. The second file has column 1 as the sample ID's, column 2 as the mother ID's, column 3 as the father ID's, column 4 as the gender, and column 5...

5. UNIX Desktop Questions & Answers

Using grep to remove cells instead of lines

I would like to use grep to remove certain strings from a text file but I can't use the grep -v option because it removes the whole line that includes the string whereas I just want to remove the string. How do I go about doing that? My input file: Magmas CEU rs12542019 CPNE1 RBM12 CEU...

6. Shell Programming and Scripting

CSV with commas in field values, remove duplicates, cut columns

Hi Description of input file I have: ------------------------- 1) CSV with double quotes for string fields. 2) Some string fields have Comma as part of field value. 3) Have Duplicate lines 4) Have 200 columns/fields 5) File size is more than 10GB Description of output file I need:...

7. Shell Programming and Scripting

Remove Duplicates on multiple Key Columns and get the Latest Record from Date/Time Column

Hi Experts , we have a CDC file where we need to get the latest record of the Key columns Key Columns will be CDC_FLAG and SRC_PMTN_I and fetch the latest record from the CDC_PRCS_TS Can we do it with a single awk command. Please help....

8. Shell Programming and Scripting

Remove duplicates by keeping the order intact

Hello friends, I have a file with duplicate lines. I could eliminate duplicate lines by running sort <file> |uniq >uniq_file and it works fine BUT it changes the order of the entries as it we did "sort". I need to remove duplicates and also need to keep the order/sequence of entries. I...

9. UNIX for Beginners Questions & Answers

Merge cells in all rows of a HTML table dynamically.

Hello All, I have visited many pages in Unix.com and could find out one solution for merging the HTML cells in the 1st row. (Unable to post the complete URL as I should not as per website rules). But, however I try, I couldn't achieve this merging to happen for all other rows of HTML...

10. UNIX for Beginners Questions & Answers

Sort and remove duplicates in directory based on first 5 columns:

I have /tmp dir with filename as: 010020001_S-FOR-Sort-SYEXC_20160229_2212101.marker 010020001_S-FOR-Sort-SYEXC_20160229_2212102.marker 010020001-S-XOR-Sort-SYEXC_20160229_2212104.marker 010020001-S-XOR-Sort-SYEXC_20160229_2212105.marker 010020001_S-ZOR-Sort-SYEXC_20160229_2212106.marker...

LEARN ABOUT SUSE

gtk2::table

Gtk2::Table(3)						User Contributed Perl Documentation					    Gtk2::Table(3)

NAME

       Gtk2::Table

HIERARCHY

	 Glib::Object
	 +----Glib::InitiallyUnowned
	      +----Gtk2::Object
		   +----Gtk2::Widget
			+----Gtk2::Container
			     +----Gtk2::Table

INTERFACES

	 Glib::Object::_Unregistered::AtkImplementorIface
	 Gtk2::Buildable

METHODS

   widget = Gtk2::Table->new ($rows, $columns, $homogeneous=FALSE)
       o   $rows (integer)

       o   $columns (integer)

       o   $homogeneous (boolean)

   $table->attach ($child, $left_attach, $right_attach, $top_attach, $bottom_attach, $xoptions, $yoptions, $xpadding, $ypadding)
       o   $child (Gtk2::Widget)

       o   $left_attach (integer)

       o   $right_attach (integer)

       o   $top_attach (integer)

       o   $bottom_attach (integer)

       o   $xoptions (Gtk2::AttachOptions)

       o   $yoptions (Gtk2::AttachOptions)

       o   $xpadding (integer)

       o   $ypadding (integer)

   $table->attach_defaults ($widget, $left_attach, $right_attach, $top_attach, $bottom_attach)
       o   $widget (Gtk2::Widget)

       o   $left_attach (integer)

       o   $right_attach (integer)

       o   $top_attach (integer)

       o   $bottom_attach (integer)

   integer = $table->get_col_spacing ($column)
       o   $column (integer)

   $table->set_col_spacing ($column, $spacing)
       o   $column (integer)

       o   $spacing (integer)

   $table->set_col_spacings ($spacing)
       o   $spacing (integer)

   integer = $table->get_default_col_spacing
   integer = $table->get_default_row_spacing
   boolean = $table->get_homogeneous
   $table->set_homogeneous ($homogeneous)
       o   $homogeneous (boolean)

   $table->resize ($rows, $columns)
       o   $rows (integer)

       o   $columns (integer)

   integer = $table->get_row_spacing ($row)
       o   $row (integer)

   $table->set_row_spacing ($row, $spacing)
       o   $row (integer)

       o   $spacing (integer)

   $table->set_row_spacings ($spacing)
       o   $spacing (integer)

PROPERTIES

       'column-spacing' (Glib::UInt : readable / writable / private)
	   The amount of space between two consecutive columns

       'homogeneous' (boolean : readable / writable / private)
	   If TRUE, the table cells are all the same width/height

       'n-columns' (Glib::UInt : readable / writable / private)
	   The number of columns in the table

       'n-rows' (Glib::UInt : readable / writable / private)
	   The number of rows in the table

       'row-spacing' (Glib::UInt : readable / writable / private)
	   The amount of space between two consecutive rows

ENUMS AND FLAGS

   flags Gtk2::AttachOptions
       o   'expand' / 'GTK_EXPAND'

       o   'shrink' / 'GTK_SHRINK'

       o   'fill' / 'GTK_FILL'

SEE ALSO

       Gtk2, Glib::Object, Glib::InitiallyUnowned, Gtk2::Object, Gtk2::Widget, Gtk2::Container

COPYRIGHT

       Copyright (C) 2003-2008 by the gtk2-perl team.

       This software is licensed under the LGPL.  See Gtk2 for a full notice.

perl v5.12.1							    2010-07-05							    Gtk2::Table(3)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Deleting table cells in a script

Discussion started by: phpfreak

2. Shell Programming and Scripting

Remove duplicates based on the two key columns

Discussion started by: kmsekhar

3. Shell Programming and Scripting

Search based on 1,2,4,5 columns and remove duplicates in the same file.

Discussion started by: onesuri

4. UNIX for Dummies Questions & Answers

Two files; if cells match then copy over other columns

Discussion started by: Renyulb28