PERL Ð HASHES 10th February 2011 1) Use the data below to create a file example1.csv, Assimilate the data into a hash to answer the questions below: antonia,Perl.XML,PHP,Tcl/Tk,MySQL barbara,Tcl/Tk,ASP,Ruby,Java cherry,Perl,Java,Ruby,MySQL delia,XML,PHP,Java,ASP ethel,MySQL,Perl,Tcl/Tk,ASP florence,Ruby,PHP,Java,ASP gloria,XML,Perl,Tcl/Tk,MySQL hazel,PHP,Python,Perl,Ruby,ASP iris,Perl,MySQL,Java,Tcl/Tk jenny,XML,Perl,Ruby,ASP kerry,Perl,Tcl/Tk,Ruby,MySQL leane,PHP,Python,ASP,Perl,Java margaret,XML,Perl,Ruby,MySQL,Tcl/Tk nina,Tcl/Tk,Perl,ASP,Ruby olivia,MySQL,Python,ASP,PHP petra,XML,Tcl/Tk,ASP,Perl,Ruby queenie,Ruby,Perl,ASP,MySQL rita,PHP,ASP,Ruby,Perl sally,Tcl/Tk,Perl,XML,MySQL tina,Tcl/Tk,Ruby,Java uva,MySQL,Perl,Java,PHP venus,Java,Perl,Ruby,ASP wendy,Perl,Tcl/Tk,ASP,MySQL xena,Java,Perl,PHP,ASP,XML yollanda,Ruby,MySQL,Tcl/Tk zoe,Ruby,ASP,Perl,PHP adam,Tcl/Tk,Perl,Python,MySQL barry,Python,XML,Java,Perl,PHP charles,Perl,Ruby,MySQL,Tcl/Tk david,Perl,Tcl/Tk,Java ed,Ruby,Perl,Java,PHP fred,MySQL,Perl,Java,XML Using the hash created above answer the following: a) Print out all the names of programmers in alphabetical order b) How many programming languages are known within the group. c) Enumerate the number of programmers who can program each of the programming languages mentioned. d) Create a team of programmers who can code in Java, MySQL, PHP and XML. e) Obtain statistics about the usage of programming languages within this group e.g. java is used by 70% of programmers in this group, PHP by 20% and so on. 2) Write a program to print out the a,t,c and g percentage within each of the 20th to 40th sequences in the file /home/afedorov/EID/Human37/hs37.intEID in intron. 3) Write a program that searches for a user entered gene name through the command line. Get the genes from the file in question 2. Make a hash of all the genes (key=name, value=gene ID or sequence). 4) Write a program that will ask the user for a given name and report the corresponding family name. Use the names of people you know, or (if you spend so much time on the computer that you don't know any actual people) use the following table: Input Output fred flintstone barney rubble wilma flintstone 5) Write a script that reads a FASTA file (as an example you may use file in question 2) and stores the first 20 characters of the sequences in a hash. The gene name and intron number should be the keys and the 20 characters of the sequence should be the value. Now ask the user for a gene name and intron number and extract the sequence from the hash. If such an intron or gene name does'nt exist then print an error message.