"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
👨🎨