Preguntas de entrevista para data scientist compartidas por los candidatos
Hacker Rank 3: Oh surprise, more regex. (I'm just joking, I can't remember the title but let's called file processing). Given a text file containing network connections information (space separated) like this: something - - "GET something something" [another thing with spaces in the middle] 4500 where: something = first column - = second column - = third column "Get something...." = forth column and so on. The last column, 4500 represents the number of bytes transmitted. You need to filter the records where a number of bytes are bigger than 5000 and the sum of bytes of those records.
Hacker Rank 1: SQL query. Having a table with a column of amounts TV_2011 (or something like that) and amounts of TV_2012, latitude and longitude, make a sum of the 2012 amounts with some conditions: 1. Take the TV_2012 amount only if there is another TV_2011 amount similar to the one in the row being evaluated. 2. Don't take amounts TV_2012 amounts if there is a duplicated location (latitude, longitude). The sum should be rounded to 2 decimals.