05-03-2010
Help with subset and if-then statements
Hello everyone. I'm new to the boards, I hope I can get and possibly give some help through these forums.
I need some help.
I have two CSV files, let's call them File A and File B.
This is the structure for File A:
ID, VAR1, VAR2, VAR3 - VAR50 (where the VAR 1-VAR50 are either 0 or 1)
This is the structure for File B:
ID, GENDER (where GENDER is either 0 or 1)
I want to do is create 2 additonal files, File C and File D. The file needs to be the same structure and have the same number of records as File A (ID, VAR1-VAR50). But for File C, I want VAR1-VAR50 to be set to missing (in this case a space) for all men. And for File D I want VAR1-VAR50 to be set to missing for all women.
Can anybody help me with this? Does my question make sense?
Thanks in advance for any help.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi, All
I have a huge file which has 450G. Its tab-delimited format is as below
x1 A 50020 1
x1 B 50021 8
x1 C 50022 9
x1 A 50023 10
x2 D 50024 5
x2 C 50025 7
x2 F 50026 8
x2 N 50027 1
:
:
Now, I want to extract a subset from this file. In this subset, column 1 is x10, column 2 is... (3 Replies)
Discussion started by: cliffyiu
3 Replies
2. UNIX for Dummies Questions & Answers
Dear all,
I have a file lik below: n of row=420, n of letters in each row=100000 like below: there is no space between the letters.
what I want is: the 75000th letter to the 85000th letter in each row.
how to do that? thanks a lot!
... (2 Replies)
Discussion started by: forevertl
2 Replies
3. Shell Programming and Scripting
I am compiling a fortran program using gfortran and the result looks as below
I want to write a bash or awk script that will scan the information and output
only problems within a range of line numbers
Example: If I specify the file createmodl.f08, start line 1000 and end line 1100, I will... (8 Replies)
Discussion started by: kristinu
8 Replies
4. Shell Programming and Scripting
hi I am trying to write a script to count the number of files, with slightly different subset name, in a directory
for example, in directory /data, there are a subset of files that are name as follow
/data/data_1_(1to however many).txt
/data/data_2_(1 to however many).txt... (12 Replies)
Discussion started by: piynik
12 Replies
5. Shell Programming and Scripting
Each line of the file has some words exactly same letters as of the first one. But has zero or more "_+" inserted. I am interested in those words and remove the other cases.
Example:
abcde abcd_+e abcd_+de
fghig fghigi fghi_+g
klmn klmn
I want to get this:
abcde abcd_+e
fghig fghi_+g ... (7 Replies)
Discussion started by: Viernes
7 Replies
6. UNIX for Dummies Questions & Answers
Hi. I have a large data file. the first column has unique identifiers. I have approximately 5 of these files and they have varying number of columns in their rows. I need to extract ~300 of the rows in to a separate file. I'm not looking for something that would do all 5 files at once, but... (7 Replies)
Discussion started by: kadm
7 Replies
7. UNIX for Advanced & Expert Users
Hello
I have a data set which looks like this :
progeny sire dam gender
12 1 3 M
13 2 4 F
14 2 5 F
15 6 5 ... (13 Replies)
Discussion started by: sajmar
13 Replies
8. Shell Programming and Scripting
I need to know if file1 is a subset of file2 i.e all the contents of file1 are present in file2 or not.
Here is how i would do it.
Read line by line file1 and grep every line in file2 in a for loop. any failing grep would means that it is not a subset.
Is there a quicker or easier way... (3 Replies)
Discussion started by: mohtashims
3 Replies
9. Shell Programming and Scripting
In-order to check and print if file2 is a subset of file one i do the below.
var1=$(cat //tmp/file1 | sort -u | wc)
var2=$(cat /tmp/file2 /tmp/file1 | sort -u | wc)
if ; then
echo "file2 is a subset of file1 becoz var1 and var2 have the same values."
fi
However, i get the following error ... (1 Reply)
Discussion started by: mohtashims
1 Replies
10. UNIX for Beginners Questions & Answers
Ca21chr2_C_albicans_SC5314 2159343 2228327 Ca21chr2_C_albicans_SC5314 636587 638608
Ca21chr2_C_albicans_SC5314 5286 50509 Ca21chr2_C_albicans_SC5314 634021 636276
Ca21chr2_C_albicans_SC5314 1886545 1900975 Ca21chr2_C_albicans_SC5314 610758 613544... (9 Replies)
Discussion started by: cryptodice
9 Replies
LEARN ABOUT MOJAVE
file::spec::functions
File::Spec::Functions(3pm) Perl Programmers Reference Guide File::Spec::Functions(3pm)
NAME
File::Spec::Functions - portably perform operations on file names
SYNOPSIS
use File::Spec::Functions;
$x = catfile('a','b');
DESCRIPTION
This module exports convenience functions for all of the class methods provided by File::Spec.
For a reference of available functions, please consult File::Spec::Unix, which contains the entire set, and which is inherited by the
modules for other platforms. For further information, please see File::Spec::Mac, File::Spec::OS2, File::Spec::Win32, or File::Spec::VMS.
Exports
The following functions are exported by default.
canonpath
catdir
catfile
curdir
rootdir
updir
no_upwards
file_name_is_absolute
path
The following functions are exported only by request.
devnull
tmpdir
splitpath
splitdir
catpath
abs2rel
rel2abs
case_tolerant
All the functions may be imported using the ":ALL" tag.
COPYRIGHT
Copyright (c) 2004 by the Perl 5 Porters. All rights reserved.
This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
SEE ALSO
File::Spec, File::Spec::Unix, File::Spec::Mac, File::Spec::OS2, File::Spec::Win32, File::Spec::VMS, ExtUtils::MakeMaker
perl v5.18.2 2014-01-06 File::Spec::Functions(3pm)