helpOSTS

It's UWAweek 30 (2nd semester, week 1)

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 selected article

Showing 1 of 445 articles.
Currently 16 other people reading this forum.

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)

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

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 1st semester help fora Computer Networks Data Structures and Algorithms Graphics and Animation Mobile and Wireless Computing Object Oriented Programming Open Source Tools and Scripting Software Requirements and Design Software Testing and Quality Assurance