It's UWAweek 47

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 3 articles in this topic
Showing 3 of 445 articles.
Currently 4 other people reading this forum.


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

Login to reply

👍x1
helpful
7:20pm Thu 16th May, Lyu L.

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 files, and then the third with the new combination." I notice that there are different ways, such as inner, Left, right and outer join, which will influence the output. I have no idea which one should I choose, as the sample2.tsv just has few data. In the output file, should it include all the "code + year" from three files, even if some files don't have this match key's data? or just base on one file to match, making sure this code year has data? thank you.


SVG not supported

Login to reply

👍?
helpful
8:35pm Thu 16th May, Xiaoyu S.

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


SVG not supported

Login to reply

👍x1
helpful
1:58am Sun 19th May, Runzhi Z.

In the output file, should it include all the "code + year" from three files, even if some files don't have this match key's data?

As I understand it, yes. Because sample2 is just a sample output format, not the actual merged result of the three files, and the requirements mention that cells can be empty.

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  8:08AM Aug 25 2024
Privacy policy