stratascratch | google | deloitte interview questions and answers |Election Results | pyspark

preview_player
Показать описание
stratascratch | google | deloitte interview questions and answers |Election Results | pyspark

In this video we will be solving GOOGLE , DELOITTE coding question using PYSPARK

SQL Version of this problem :
===========================

PANDAS Version of this problem :
============================

#datascience #data #database #dataanalytics #dataengineers #datascientist #interview #interviewquetions #interviewquestionsforfreshers #SQLInterview #CodingInterview
#DataEngineeringInterview
#SQLProblems
#TechInterview
#SQLCoding
#SQLQuery
#DatabaseInterview
#DataScienceInterview
#SQLSkills
#CodeChallenge
#SQLPractice
#InterviewPrep
#TechRecruitment
#pyspark
#spark
#bigdata
#pandas
#python
  1. DEwithDhairy
Рекомендации по теме
StrataScratch | GOOGLE 0:16:27

StrataScratch | GOOGLE | DELOITTE | Interview Coding Question |Election Results | SQL | #DE| #DATA

Election Results - 0:02:29

Election Results - Deloitte Google - SQL StrataScratch

StrataScratch | GOOGLE 0:12:47

StrataScratch | GOOGLE | DELOITTE |Interview Coding Question |Election Results | PANDAS |#DE| #DATA

stratascratch | google 0:15:14

stratascratch | google | deloitte interview questions and answers |Election Results | pyspark

Election Results - 0:03:11

Election Results - Deloitte Google - Python StrataScratch

Decoding GOOGLE & 0:18:37

Decoding GOOGLE & DELOITTE Interview - Everyday Data Science

Spotify Days At 0:00:52

Spotify Days At Number One SQL Question

Top 5 States 0:09:07

Top 5 States with 5 Star Business | Hard | StrataScratch | SQL | Solution | Interview Problem | Yelp

Best Website to 0:21:45

Best Website to Practice Technical Interview Questions

SQL Query Interview 0:17:48

SQL Query Interview Questions And Answers From Real Companies | Prepare For Your SQL Interview

SQL Interviews Be 0:07:44

SQL Interviews Be Like

Google SQL Interview 0:18:35

Google SQL Interview Question - Calculate Correlation Coefficient

An Analysis of 0:12:15

An Analysis of 900 Data Science Interview Questions | Data Science Interview Guide

NVIDIA SQL Interview 0:08:17

NVIDIA SQL Interview Question for Data Scientists and Data Analysts (StrataScratch 10163)

Google SQL Interview 0:05:50

Google SQL Interview Question for Data Analyst Position

Solving Amazon Interview 0:09:48

Solving Amazon Interview Questions with Lambda Filter Function in Python

SQL to Count 0:04:03

SQL to Count Occurrence of a Character/Word in a String

Practice SQL Interview 0:14:47

Practice SQL Interview Query | Big 4 Interview Question

Data Analyst Roadmap 0:12:14

Data Analyst Roadmap with Free Resources !!

Deloitte Data Analyst 0:13:13

Deloitte Data Analyst Interview Question | SQL interview Problem | Using Multiple CTEs | RANK in SQL

Advanced SQL Interview 0:04:01

Advanced SQL Interview Questions for Data Analyst (Part 1)

Solving a Real 0:05:23

Solving a Real Uber SQL Data Analyst Interview Question

Access Premium Leetcode 0:07:04

Access Premium Leetcode Questions Free

SQL Interview Questions 0:10:09

SQL Interview Questions Practice

Комментарии
Автор

Solution works for the given data set but I think is not generic enough.
1. There is a possibility of tie - we should use dense_rank function
2. In the case when we have majority of voters that didn't vote at all - NULL candidate would be declared as a winner - we should first filter out these voters.

vlastimirmasic