It's UWAweek 24 (1st semester, 2nd exam week)


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 selected article
Showing 1 of 439 articles.
Currently 1 other person reading this forum.

 UWA week 21 (1st semester, week 12) ↓
SVG not supported

Login to reply


> ANONYMOUS wrote: > > > Hi professor, > > > > I see there is a country which is not present in one of the file(year is different) and should we suppose to retain that row as well or only take the rows which are in common(same country and year) in 3 files? For data cleaning process > > > Also > - is the provided output in LMS is what we need to get ? Or it's just a sample output ? > > And > Also, if there are rows with cells not matched with header column count, do we need to just report it or supposed to exit the program ?
Hi, Having removed the rows for entities which do not have a country code, the combination of <country code>-<year> will be unique. You need to do a join across that shared combined code, and taken in all the data (including empty cells). Is that what you mean, please? Cheers MichaelW

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