Dear Professor Can a string column contain numbers? Thanks for for your clarification

Hi Professor, From your previous reply, you mentioned, "the sample2.txt also serves to show what the output from the cleaning stage looks like." Let's take Afghanistan as an example. In the sample2.tsv file, there are 9 records, ignoring 2013 and 2014...

Hi, professor I have a question about the standard of combination. You mention that "HINT for each of the 3 input files, create a temporary version with an extra column that combines country code and year. You can then use join to join two of the 3 ...

Hi Professor, Can we assume that there will be no carriage return character at the end (or) it might present for the input files? Thanks.

Hi Professor, If i come across any inconsistent rows more than the header i should be redirect them to stderr.I was trying the same ,still its print me the msg on the screen(redirected to dev stderr).so i tried with simple echo statement in terminal ...

I would like to check what I understand from the guideline is correct. I made a sample data sheet to explain. This sheet is not in real and is finished by my cantril data cleaning. sample data sheet Country Code Year GDP Population Homicid...

Hello Prof, When I calculate the Person correlation, there are data as follows tsv Burundi BDI 2014 831.29486 10494920 5.3740325 59.9 2.905 Burundi BDI 2015 781.5793 10727153 4.2975073 60.2 2.905 Burundi BDI 2016 764.3366 10903329 5.82391 60.8 2.905 ...

Hi Professor Michael, I'm a little confused about the the description of first part, data cleaning in assignment 2. It said "The output is expected to be a tab-separated data directed, as before, to standard output", and it also said, " The output f...

Hi Professor Michael, I'm a little confused about the the description of first part, data cleaning in assignment 2. It said "The output is expected to be a tab-separated data directed, as before, to standard output", and it also said, " The output f...

Hi, I'm not that fussed about how many decimal places. Three seems reasonable. As always, please use commonsense. Cheers MichaelW

Hi, I'm not sure I understand the question. The output file is to be send to standard output, where, if stdout is not redirected into a file, it will appear on the screen. Is that what you mean? Cheers MichaelW

ANONYMOUS wrote Hi, it mostly is, but in a few cases no; the difference is really whether a code is present at all in the code cell, or absent. Cheers MichaelW

Hi Runzhi, Yes, you can use a number of scripts to get the job done, including more than one awk script, if you wish. You then put all the scripts for the two programs, plus the .git repo for the assignment, in the single zip'd tar'd directory. Re inf...

Hi Boya, Good questions. I'll reply to each below it. The trick with all of these is to place yourself in the role of a user of the system. What will they expect? What information will be useful? As far as I can see, the country data (ie data that has a...

Hi Eusha Try again now. Cheers MichaelW

Hello Mr.Wise, my grades in csmarks are showing not available.

Hi professor, and the numerical values in the output should be round to 3 decimal places?

Hi Professor, My code creates a cleaned and sorted and joined file, the output file should be displayed on the screen using cat and then deleted. or is it ok if it is not removed.

Hello sir, in the assignment 2, does the country code have to be a 3 letter word? Thanks

Hi Professor, Since I'm using a lot of lines of awk in the script, can awk commands be written as awk scripts (i.e., .awk) and then called in a shell script? If so, can they be packaged together during submission? Additionally, should awk files inclu...