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

Showing 3 of 445 articles.
Currently 15 other people reading this forum.

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

Assignment 2: Data Cleaning Ouput Consultation (all 3)

9:38am Fri 17th May, Kaichao Z.

Hi Prof. Wise, I found that sample2.tsv do not have any empty cells except <Cantril Ladder score>. But this feature is not mentioned in assignment description (or I should apologize for my neglect). I wonder if empty cells permissible in other columns like <GDP per capita>, <Population>, <Homicide Rate> and <Life Expectancy>? Your prompt attention to my petition will be highly appreciated. Best regards, Kai Zheng

Assignment 2: Data Cleaning Ouput Consultation (all 3)

12:54pm Fri 17th May, Kaichao Z.

And should I remove double quotes in raw headers as sample2.tsv did.

Assignment 2: Data Cleaning Ouput Consultation (all 3)

3:37pm Sun 19th May, Michael W.

"Kaichao Zheng" <24*4*2*7@s*u*e*t*u*a*e*u*a*> wrote:

> Hi Prof. Wise, > > I found that sample2.tsv do not have any empty cells except <Cantril Ladder score>. But this feature is not mentioned in assignment description (or I should apologize for my neglect). I wonder if empty cells permissible in other columns like <GDP per capita>, <Population>, <Homicide Rate> and <Life Expectancy>? > > Your prompt attention to my petition will be highly appreciated. > > Best regards, > Kai Zheng

Hi Kai, Empty cells are fine anywhere for the data cleaning program, so long as the rows are within the range of years of interest. Re: double quotes, you only need these in CSV format, because comma can occur naturally within a string, so the whole string is quoted. However, with TSV format, double quotes are not significant for demarcating string boundaries. 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