Boyzone87

Today we'll cover a tricky data science interview question asked by Facebook. It's not so much a tricky problem as it is a problem with a non-obvious solution. But these types of questions are asked all the time on interviews because they're scenarios that you'd have to handle everyday as a data scientist. Let's cover what this question's all about. Follow along with me by going to the question below.

Link to question: https://bit.ly/3oGDZpM

______________________________________________________________________

This series is for both beginner and intermediate data scientists and ana

Let's cover 4 SQL window function interview questions asked on Airbnb, Netflix, Twitter, and Uber data science interviews. I cover the questions and how to solve them, and exactly what the functions are doing to the data.

Link to questions:
Aggregate Functions -- Uber: https://bit.ly/37zCMcS
Ranking -- Twitter: https://bit.ly/3lOFArH
NTILE() -- Netflix: https://bit.ly/3lN0qI7
LEAD/LAG -- Airbnb: https://bit.ly/37tx6kE

We're going to apply software engineering fundamentals for this common data science tasks where we are going to finish automating file imports to a database. In this last installment of this video series, I'll show you how to transform all the code into functions and separate them out from your main python file. This basically creates your own custom library of functions you can use for any future project.

I recorded 2 other parts of this series where I show you how to create the functionality and automate the python script.

- Part 1: Functionality (https://youtu.be/wqBFgaMgFQA)
- Par

This is part 2 on automating the import of CSV files to a database - a common data science task . In this video, we'll take our python script from part 1, which manually imports a CSV/Excel file to a postgres database, and completely automate the script so that it can import multiple files without the need to edit the code. You'd essentially be saving hours of work.

Importing CSV files to a database is a common task needed for data science and analytics and it can be done completely with python using pandas dataframes, numpy, os library, and the posgres database wrapper psycopg2.

This

In this video, I'll walk you through a common SQL coding interview question that is asked in many data science interviews. This SQL question tests your knowledge of SQL window functions, specifically using a PARTITION BY. I'd consider this a simple SQL window function so let's test your knowledge on this question before diving into more complicated problems. Follow along with me and head to the question below.

Link to question: https://bit.ly/38P1Pe7

Hope your week is going well and you are all looking forward to Labor Day weekend. Here is a video with some quick tips to keep in mind during Labor Day activities. Thank you for watching and you all enjoy your holiday weekend and stay safe always. #covid19 #maskup #physicaldistancing #HandWash

Today we all are worrying about COVID-19 and we are doing our best to keep ourselves safe from this pandemic situation. In this, it is not wrong to say that we are neglecting many problems around us that are an ultimately bigger threat than COVID-19. It sounds funny but isn’t it? Loneliness is one of such things you will get to know about in this video. The worst thing about loneliness is we are not taking it seriously. Because of COVID-19 no need to say that it is the right time to talk about this. We recommend you watch the full video so you can take care of yourself and your loved ones.

We're going to cover the #1 most common mistake made on data science interviews. This mistake is made by both inexperienced and experience data science professionals; it happens both on interviews and in the work setting; and the mistake takes place when trying to solve the most common data science question. Let's cover it so that you don't make the same mistake.

Follow me interactively with the question here: http://bit.ly/3mPRRfP

Platforms I recommend to practice data science real scenarios:
- https://platform.stratascratch.com (data science questions)
- https://leetcode.com (genera

Process For Buying A House & How We Help