It's UWAweek 25 (mid-year break)

helpOSTS

This forum is provided to promote discussion amongst students enrolled in Open Source Tools and Scripting.

Please consider offering answers and suggestions to help other students! And if you fix a problem by following a suggestion here, it would be great if other interested students could see a short "Great, fixed it!"  followup message.

How do I ask a good question?
Displaying the 5 articles in this topic
Showing 5 of 439 articles.
Currently 12 other people reading this forum.


 UWA week 19 (1st semester, week 10) ↓
SVG not supported

Login to reply

👍?
helpful
9:29pm Sun 12th May, Zhenlong M.

Dear Professor,

The overall program should, for a given datafile: Based on the header (i.e. top) line, make sure that the file is a tab-separated format file Also based on the header line, report any lines that do not have the same number of cells. (Cells are allowed be empty.) Remove the column with header Continent, which is sparsely populated and is not present in one of the files. Ignore the rows that do not represent countries (the country code field is empty) Ignore the rows for years outside those for which we have at least some Cantril data. (Cantril data may be absent in certain years within the range of those for which there otherwise is data; those cells should be retained.)

I have a question : What shold I do if a country is in gdp-vs-happiness.tsv, but not in homicide-rate-unodc.tsv, should I just ignore them or i need to send to stdout? The above requirements do not mention this.

Abkhazia	OWID_ABK	2015

Thanks!


 UWA week 20 (1st semester, week 11) ↓
SVG not supported

Login to reply

👍?
helpful
10:31am Mon 13th May, Zhenlong M.

what I mean is below: $$outputfile = gdp-vs-happiness.tsv \cap homicide-rate-unodc.tsv \cap life-satisfaction-vs-life-expectancy.tsv $$ or $$outputfile = gdp-vs-happiness.tsv \sqcup homicide-rate-unodc.tsv \sqcup life-satisfaction-vs-life-expectancy.tsv $$ ?


SVG not supported

Login to reply

👍?
helpful
11:49am Mon 13th May, Zhenlong M.

left join ? right join? inner join? full join?


SVG not supported

Login to reply

👍?
helpful
2:57pm Mon 13th May, Michael W.

"Zhenlong Ma" [email protected] wrote:

left join ? right join? inner join? full join?

Hi Zhenlong, I hope that my recent email to the class makes that a bit clearer. Please get back to me if that is not the case.

Cheers MichaelW 👨‍🎨


SVG not supported

Login to reply

👍?
helpful
7:24pm Sun 19th May, ANONYMOUS

I'm still unclear about on to retain only rows which have country code And year same in all three tsv files ? Or to combine every row from three files

The University of Western Australia

Computer Science and Software Engineering

CRICOS Code: 00126G
Written by [email protected]
Powered by history
Feedback always welcome - it makes our software better!
Last modified  5:07AM Sep 06 2023
Privacy policy