Data Science, Machine Learning and more..

I came across an exciting question at Hacker Rank it was about pivoting a table in SQL. I here chose MySQL. The table had two columns of name and occupation. Problem: https://www.hackerrank.com/challenges/occupations/problem Solution: It would have been better to use Outer join. But since Outer join is not available with MySQL, i chose left join. Column with maximum values was chosen.I left joined the second maximum column to the first. Then left joined third max with them and so on. But while on final selection the columns were selected in the order as asked in the question from the joined table.

Hi everyone,    I have planned to begin '366 days of Data Science challenge' on October 10, 2019. Data Science is a hot trending word today, with applications extending to every field. Data science is all about exploring the insights of data. One can analyze a dataset and figure out hidden information, forecast an unseen feature and do much more with a given a data.    Data science is not something new , as any other field of science it has the origin at the point when early human began to think.  The development in algorithmic thinking, processor speed, memory storage and a good communication has let to the trend today. The 366 days would not be enough to peek into the core of the Data Science, but it would be sufficient to actually scratch the surface of the giant planet to become a Data scientist.    I have planned to share my knowledge in the form of articles on concepts, algorithms, tools, comparisons, recent trends in the field and more. Also i have planned to s