I have just done with the phone round with the Microsoft intrerview,
the Interviewer is the mots silent one I have everseen
I tired hard to cover all the edge case but still failed
We need to read the date from one txt file, below are my sample for input , file read and out put.
Color might have duiplcate, date or number or color might be null-- bad date. empty line might exits.
color date number
green 2001/02/23 8
purple 2006/05/11 1
white 2019/02/17 200
sheet = SpreadSheet("a.txt");
sheet.filter(['color', '=', 'green'])
=>
[
['green' , 2001/02/03, 8]
]