helpOSTS

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 5 articles in this topic

Showing 5 of 445 articles.
Currently 43 other people reading this forum.

UWA week 20 (1st semester, week 11) ↓

Are we supposed to combine the rows which have same country code and year in each of 3 files (all 5)

8:15pm Sun 19th May, ANONYMOUS

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) ↓

Are we supposed to combine the rows which have same country code and year in each of 3 files (all 5)

9:56am Mon 20th May, ANONYMOUS

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 ?

Are we supposed to combine the rows which have same country code and year in each of 3 files (all 5)

11:32am Mon 20th May, Michael W.

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

Are we supposed to combine the rows which have same country code and year in each of 3 files (all 5)

12:05pm Mon 20th May, ANONYMOUS

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?

Are we supposed to combine the rows which have same country code and year in each of 3 files (all 5)

9:49am Tue 21st May, Michael W.

Hi, Yes. retain all rows within the range of years of interest. Cheers MichaelW

helpOSTS articles all ANNOUNCEMENTS recent articles login to post a new article helpOSTS topics from today and yesterday from the past week from the past two weeks ALL topics, most recent first	login chapter0 unitinfo research projects csforum csse-feedback csbreakdown cssubmit csmarks 2nd semester help fora Algebra Advanced Algorithms Cloud Computing High Performance Computing Intelligent Agents Professional Computing Relational Database Management Systems Systems Programming