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

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 2 other people reading this forum.


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

Login to reply

👍?
helpful

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


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

Login to reply

👍?
helpful

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 ?


SVG not supported

Login to reply

👍?
helpful

ANONYMOUS wrote:
> 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


SVG not supported

Login to reply

👍?
helpful

No, let's say we have a country code JPN which is having rows of year 2011 and 2012 in one file, and in another file it doesn't have rows of 2011 and 2012 instead the file contains rows of year 2014 and 2014. Should we retain all that rows with year 2011, 2012, 2013, 2014 ? Or just exclude as the year doesn't common in both files?


SVG not supported

Login to reply

👍?
helpful

Hi, Yes. retain all rows within the range of years of interest. 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