Login or Register to Ask a Question and Join Our Community


Emergency UNIX and Linux Support

Venn Data Maker

 
Thread Tools Search this Thread
Homework and Emergencies Emergency UNIX and Linux Support Venn Data Maker
Prev   Next
# 1  
Old 08-18-2016
Venn Data Maker
Hi,

My input is like this

Code:
head input.txt
Set1,Set2,Set3
g1,g2,g3
g2,g1,g3,
g4,g5,g5
g1,g1,g1,
g2,g1,g1,
g6,g7,g8
,g7,g8
,,g8


My output file should be

Code:
Name,Set1,Set2,Set3
g1,1,1,1
g2,1,1,0
g3,0,0,1
g4,1,0,0
g5,0,1,1
g6,1,0,0
g7,0,1,0
g8,0,0,1

Logic
1. First get all unique genenames (g1,g2.....g8).
2. Then look if that particular gene is present in any of the columns in the input file.
3. If it is present, print 1. If absent, print 0.

Special Notes
1. Please note that the each of the columns (Set1,Set2,Set3) in input.txt can have missing values(last two records in input.txt).
2. The columns are not always three. My actual input file has 7. So I want the column counts to be dynamic.

Thanks
This User Gave Thanks to jacobs.smith For This Post:
RavinderSingh13
 
Login or Register to Ask a Question

Previous Thread | Next Thread

2 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Venn diagram results using awk

Hi, I have the following files 1.txt a 10 b 11 c 12 d 13 e 14 f 15 g 16 h 17 i 18 j 19 k 20 2.txt a 21 b 22 (15 Replies)
Discussion started by: jacobs.smith
15 Replies

2. Programming

maker

how can i remake a program to crash a harddrive using unix:rolleyes: (2 Replies)
Discussion started by: flomper
2 Replies
Login or Register to Ask a Question

LEARN ABOUT REDHAT

setstyle

setstyle(1x)															      setstyle(1x)

NAME

       setstyle - set style related options for Window Maker or loads a theme

SYNOPSIS

       setstyle [--no-fonts] [--no-cursors] [--help] [--version] stylefile

DESCRIPTION

       setstyle reads stylefile and writes its contents to the WindowMaker domain, efectively setting the Window Maker style. If the supplied path
       is a directory, it will be treated as a theme pack and it will be loaded appropriately. If the --no-fonts flag is specified,  font  related
       options (IconTitleFont, ClipTitleFont, DisplayFont, MenuTextFont, MenuTitleFont, WindowTitleFont) in the style file will be ignored.

       If  the	--no-cursors  flag  is	specified,  any  mouse	cursor	definitions  (NormalCursor,  ArrowCursor, MoveCursor, TopLeftResizeCursor,
       TopRightResizeCursor, BottomLeftResizeCursor, BottomRightResizeCursor, VerticalResizeCursor, HorizontalResizeCursor, WaitCursor,  Question-
       Cursor, TextCursor, SelectCursor) in the style or theme will be ignored.

OPTIONS

       --no-fonts
	      ignore font related options in style file.

       --no-cursors
	      ignore cursor definition options in style file.

       --help print a help message

       --version
	      print version number

ENVIRONMENT

       GNUSTEP_USER_ROOT
	      specifies  the initial path for the Defaults directory. "Defaults/" is appended to this variable to determine the actual location of
	      the databases. If the varialbe is not set, it defaults to "~/GNUstep"

FILES

       GNUSTEP_USER_ROOT/Defaults/WindowMaker
	      This is the actual file that's written.

SEE ALSO

       getstyle(1x), wmaker(1x)

AUTHOR

       This man page was written by Marcelo Magallon <mmagallo@debian.org>.

       Window Maker was written by Alfredo K. Kojima <kojima@windowmaker.info>.

								   January 1999 						      setstyle(1x)