Venn Data Maker Post: 302979752

Sponsored Content

Homework and Emergencies Emergency UNIX and Linux Support Venn Data Maker Post 302979752 by Yoda on Thursday 18th of August 2016 01:15:55 PM

08-18-2016

Moderator

An approach using gawk:-

Code:

gawk -F, '
        NR == 1  {
                print "Name," $0
        }
        NR > 1 {
                for ( i = 1; i <= NF; i++ )
                {
                        if ( $i )
                                T[$i]
                        R[$i FS i]
                }
        }
        END {
                n = asorti(T)
                for ( i = 1; i <= n; i++ )
                {
                        for ( j = 1; j <= NF; j++ )
                        {
                                if ( ( T[i] FS j ) in R )
                                        S = S ? S FS 1 : T[i] FS 1
                                else
                                        S = S ? S FS 0 : T[i] FS 0
                        }
                        print S
                        S = ""
                }
        }
' file

This User Gave Thanks to Yoda For This Post:

Yoda

View Public Profile for Yoda

Visit Yoda's homepage!

Find all posts by Yoda

2 More Discussions You Might Find Interesting

1. Programming

maker

how can i remake a program to crash a harddrive using unix:rolleyes:

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

LEARN ABOUT DEBIAN

shtool-path

SHTOOL-PATH.TMP(1)					      GNU Portable Shell Tool						SHTOOL-PATH.TMP(1)

NAME

       shtool-path - GNU shtool command dealing with shell path variables

SYNOPSIS

       shtool path [-s|--suppress] [-r|--reverse] [-d|--dirname] [-b|--basename] [-m|--magic] [-p|--path path] str [str ...]

DESCRIPTION

       This command deals with shell $PATH variables. It can find a program through one or more filenames given by one or more str arguments.  It
       prints the absolute filesystem path to the program displayed on "stdout" plus an exit code of 0 if it was really found.

OPTIONS

       The following command line options are available.

       -s, --suppress
	   Supress output. Useful to only test whether a program exists with the help of the return code.

       -r, --reverse
	   Transform a forward path to a subdirectory into a reverse path.

       -d, --dirname
	   Output the directory name of str.

       -b, --basename
	   Output the base name of str.

       -m, --magic
	   Enable advanced magic search for ""perl"" and ""cpp"".

       -p, --path path
	   Search in path. Default is to search in $PATH.

EXAMPLE

	#   shell script
	awk=`shtool path -p "${PATH}:." gawk nawk awk`
	perl=`shtool path -m perl`
	cpp=`shtool path -m cpp`
	revpath=`shtool path -r path/to/subdir`

HISTORY

       The GNU shtool path command was originally written by Ralf S.  Engelschall <rse@engelschall.com> in 1998 for Apache. It was later taken
       over into GNU shtool.

SEE ALSO

       shtool(1), which(1).

18-Jul-2008							   shtool 2.0.8 						SHTOOL-PATH.TMP(1)