Amazon Interview Question

Describe different JOINs in SQL. Having a categorical variable with thousands distinct values, how would you encode it? How to find linear trends in time series. How to find the flow in a matrix showing temperature. ...

Interview Answers

Anonymous

Nov 27, 2019

I replied all the questions with confidence. The two phone interviewers were very nice and did not hesitate to explain again/more each question.

Anonymous

Feb 2, 2022

You can use mean encoding technique for encoding.

Anonymous

Dec 22, 2019

Having a categorical variable with thousands distinct values, how would you encode it ? Can you please answer this ?