- 143
- 79 141
Algometica
เข้าร่วมเมื่อ 1 ส.ค. 2016
Making Data Engineering great again.
Proportion Of Total Spend By Customer - Amazon, Etsy Interview Question - Pandas | GROUPBY & JOIN
If you like this video, please support me in making more of these:
www.paypal.com/ncp/payment/QYQCW68XCX85G
----------------------------------------------
----------------------------------------------
Calculate the ratio of the total spend a customer spent on each order. Output the customer’s first name, order details, and ratio of the order cost to their total spend across all orders.
Assume each customer has a unique first name (i.e., there is only 1 customer named Karen in the dataset) and that customers place at most only 1 order a day.
Percentages should be represented as decimals
--------
Companies appeared in: Amazon, Etsy
Difficulty: Medium
Ideas: Groupby and Join in Pandas
Problem: t.ly/3jeNP
----------------------------------------------
----------------------------------------------
www.paypal.com/ncp/payment/QYQCW68XCX85G
----------------------------------------------
----------------------------------------------
Calculate the ratio of the total spend a customer spent on each order. Output the customer’s first name, order details, and ratio of the order cost to their total spend across all orders.
Assume each customer has a unique first name (i.e., there is only 1 customer named Karen in the dataset) and that customers place at most only 1 order a day.
Percentages should be represented as decimals
--------
Companies appeared in: Amazon, Etsy
Difficulty: Medium
Ideas: Groupby and Join in Pandas
Problem: t.ly/3jeNP
----------------------------------------------
----------------------------------------------
มุมมอง: 26
วีดีโอ
Proportion Of Total Spend By Customer - Amazon, Etsy Interview Question - SQL | SUM Window Function
มุมมอง 5714 วันที่ผ่านมา
If you like this video, please support me in making more of these: www.paypal.com/ncp/payment/QYQCW68XCX85G Calculate the ratio of the total spend a customer spent on each order. Output the customer’s first name, order details, and ratio of the order cost to their total spend across all orders. Assume each customer has a unique first name (i.e., there is only 1 customer named Karen in the datas...
Customers who have never made an order - Amazon Interview Question - Python Pandas | Pandas MERGE
มุมมอง 50หลายเดือนก่อน
If you like this video, please support me in making more of these: buymeacoffee.com/algometica Find customers who have never made an order. Output the first name of the customer. Companies appeared in: Amazon, Apple Difficulty: Medium Ideas: Pandas MERGE Problem: t.ly/L-QTP
What's going on with the job market & Linkedin | Algometica Radio #1
มุมมอง 113หลายเดือนก่อน
In this first podcast, we talk about the state of the job market, Linkedin influencers, PerplexityAI CEO's Green card issues, and much more! If you like this video, please support me in making more of these: buymeacoffee.com/algometica Support the show by Subscribing to Algometica's TH-cam channel @algometica8564 00:00 - Current tech job market and what you can do? 11:30 - Garbage Data Science ...
Customers who have never made an order - Amazon Interview Question - pySpark JOIN and FILTER
มุมมอง 74หลายเดือนก่อน
If you like this video, please support me in making more of these: buymeacoffee.com/algometica Find customers who have never made an order. Output the first name of the customer. Companies appeared in: Amazon, Apple Difficulty: Medium Ideas: pySpark JOIN and FILTER Problem: t.ly/L-QTP
Find most frequent customers - Amazon Interview Question - PySpark | PySpark GROUPBY and FILTER
มุมมอง 44หลายเดือนก่อน
If you like this video, please support me in making more of these: buymeacoffee.com/algometica Find customers who appear in the orders table more than three times. Companies appeared in: Amazon, Apple Difficulty: Medium Ideas: PySpark GROUPBY and FILTER Problem: t.ly/qBZWJ
Find most frequent customers - Amazon Interview Question - SQL | SQL GROUP BY and HAVING
มุมมอง 59หลายเดือนก่อน
If you like this video, please support me in making more of these: buymeacoffee.com/algometica Find customers who appear in the orders table more than three times. Companies appeared in: Amazon, Apple Difficulty: Medium Ideas: GROUP BY & HAVING clause in SQL Problem: t.ly/qBZWJ
Customers who have never made an order - Amazon Interview Question - SQL | SQL JOIN
มุมมอง 22หลายเดือนก่อน
If you like this video, please support me in making more of these: buymeacoffee.com/algometica Find customers who have never made an order. Output the first name of the customer. Companies appeared in: Amazon, Apple Difficulty: Medium Ideas: SQL JOIN Problem: t.ly/L-QTP
Find most frequent customers - Amazon Interview Question - Python Pandas | Pandas GROUPBY
มุมมอง 64หลายเดือนก่อน
If you like this video, please support me in making more of these: buymeacoffee.com/algometica Find customers who appear in the orders table more than three times. Companies appeared in: Amazon, Apple Difficulty: Medium Ideas: GROUP BY & HAVING in Python Pandas Problem: t.ly/qBZWJ
How to become a Data Engineer - Early 2025 | Data Engineering is here to stay!
มุมมอง 258หลายเดือนก่อน
If you like this video, please support me in making more of these: buymeacoffee.com/algometica How to become a Data Engineer - Early 2025 | Data Engineering is here to stay! In this video we will be looking at what I think is a perfect and the most simplest path to become a Data Engineer in 2025. Some of the resources mentioned in the video in the order they appeared in the video. Datacamp - ww...
PySpark Full Course using Azure Databricks | Spark SQL and DataFrames
มุมมอง 3492 หลายเดือนก่อน
In this 1 hour PySpark course, we'll learn everything there is to know about PySpark Spark SQL and DataFrames. We will start with PySpark's introduction and architecture. We will also briefly look at what the Azure Databricks platform is - which is what we will be using in this course. We will learn different data manipulation techniques - creating new columns, renaming existing columns, filter...
Second Highest Salary - Amazon Interview Question - Python Pandas
มุมมอง 722 หลายเดือนก่อน
If you like this video, please support me in making more of these: buymeacoffee.com/algometica Second Highest Salary Companies appeared in: Amazon Difficulty: Medium Ideas: WINDOW FUNCTION - rank method Problem: t.ly/EUjoF
Second Highest Salary - Amazon Interview Question - PySpark
มุมมอง 1042 หลายเดือนก่อน
If you like this video, please support me in making more of these: buymeacoffee.com/algometica Second Highest Salary Companies appeared in: Amazon Difficulty: Medium Ideas: WINDOW FUNCTION - dense_rank() Problem: t.ly/EUjoF
Second Highest Salary - Amazon Interview Question - SQL
มุมมอง 842 หลายเดือนก่อน
If you like this video, please support me in making more of these: buymeacoffee.com/algometica Second Highest Salary Companies appeared in: Amazon Difficulty: Medium Ideas: WINDOW FUNCTION - DENSE_RANK() Problem: t.ly/EUjoF
Highest Salary - Amazon Interview Question - PySpark
มุมมอง 1203 หลายเดือนก่อน
If you like this video, please support me in making more of these: buymeacoffee.com/algometica Highest Salary Companies appeared in: Amazon, Siemens Difficulty: Medium Ideas: df.agg({'salary': 'max'}).collect()[0][0], .filter() Problem: t.ly/U1-s1
Highest Salary - Amazon Interview Question - Python Pandas
มุมมอง 1203 หลายเดือนก่อน
Highest Salary - Amazon Interview Question - Python Pandas
Highest Salary - Amazon Interview Question - SQL
มุมมอง 1513 หลายเดือนก่อน
Highest Salary - Amazon Interview Question - SQL
Highest Salaried Employees By Department - Amazon Interview Question - PySpark
มุมมอง 1083 หลายเดือนก่อน
Highest Salaried Employees By Department - Amazon Interview Question - PySpark
Highest Salaried Employees By Department - Amazon Interview Question - Python Pandas
มุมมอง 1113 หลายเดือนก่อน
Highest Salaried Employees By Department - Amazon Interview Question - Python Pandas
Highest Salaried Employees By Department - Amazon Interview Question - SQL
มุมมอง 1663 หลายเดือนก่อน
Highest Salaried Employees By Department - Amazon Interview Question - SQL
Departments With Less Than 4 Employees - Amazon Interview Question - SQL
มุมมอง 1443 หลายเดือนก่อน
Departments With Less Than 4 Employees - Amazon Interview Question - SQL
Departments With Less Than 4 Employees - Amazon Interview Question - Python Pandas
มุมมอง 1253 หลายเดือนก่อน
Departments With Less Than 4 Employees - Amazon Interview Question - Python Pandas
Departments With Less Than 4 Employees - Amazon Interview Question - PySpark
มุมมอง 1193 หลายเดือนก่อน
Departments With Less Than 4 Employees - Amazon Interview Question - PySpark
First 50% of Records From Dataset - Amazon Interview Question - PySpark
มุมมอง 1323 หลายเดือนก่อน
First 50% of Records From Dataset - Amazon Interview Question - PySpark
First 50% of Records From Dataset - Amazon Interview Question - Python Pandas
มุมมอง 1283 หลายเดือนก่อน
First 50% of Records From Dataset - Amazon Interview Question - Python Pandas
First 50% of Records From Dataset - Amazon Interview Question - SQL
มุมมอง 1604 หลายเดือนก่อน
First 50% of Records From Dataset - Amazon Interview Question - SQL
Duplicate HR Department Employees - Amazon Interview Question - PySpark
มุมมอง 1054 หลายเดือนก่อน
Duplicate HR Department Employees - Amazon Interview Question - PySpark
Duplicate HR Department Employees - Amazon Interview Question - Python Pandas
มุมมอง 1274 หลายเดือนก่อน
Duplicate HR Department Employees - Amazon Interview Question - Python Pandas
Duplicate HR Department Employees - Amazon Interview Question - SQL
มุมมอง 1524 หลายเดือนก่อน
Duplicate HR Department Employees - Amazon Interview Question - SQL
Second Highest Salary - Amazon Interview Question - PySpark
มุมมอง 1434 หลายเดือนก่อน
Second Highest Salary - Amazon Interview Question - PySpark
All the facts elaborated in very easier way 🙂
All the facts elaborated in very easier way 🙂
All the facts elaborated in very easier way 🙂
All the facts elaborated in very easier way 🙂
Nicely explained 👌👍
Nicely explained 👌👍
Nicely explained 👌👍
Informative podcast 👌👍
Nicely explained 👌👍
Nicely explained 👌👍
Nicely explained 👌👍
Thanks for the info ❤
Thanks for the info ❤
Thanks for the info ❤
Enjoyable podcast ❤
All the facts elaborated in very easier way 🙂
All the facts elaborated in very easier way 🙂
All the facts elaborated in very easier way 🙂
All the facts elaborated in very easier way 🙂
Nicely explained 👌👍
Nicely explained 👌👍
Nicely explained 👌👍
Nicely explained 👌👍
Thanks for the info ❤
Thanks for the info ❤
Thanks for the info ❤
Thanks for the info ❤
Nice video giving information about different courses to become data engineer. Great work done by you 👍
I think you need to find the original price based on the date of invoice. Here is my suggested solution: WITH valid_sales AS ( SELECT productcode, unitprice FROM online_retails WHERE quantity > 0 -- Exclude returns), original_prices AS ( SELECT productcode, MIN(unitprice) AS original_price -- Original price as the first price recorded FROM valid_sales GROUP BY productcode), average_price AS ( SELECT AVG(original_price) AS avg_price FROM original_prices) SELECT productcode, original_price AS unitprice FROM original_prices WHERE original_price > (SELECT avg_price FROM average_price);
Good job , great help to the job seekers 👍
Thanks for the helpful information 🙏
All the facts elaborated in very easier way 🙂
Nicely explained 👌👍
Glad you liked it
Thanks for the info ❤
didn't you just over complicate the stuff? there's an easier method to do it right?
There are multiple ways of doing it. What do you think is over complicated here?
Thanks for the info ❤
All the facts elaborated in very easier way 🙂
All the facts elaborated in very easier way 🙂
Nicely explained 👌👍
Nicely explained 👌👍
Thanks for the info ❤
Thankyou for the knowledge you are providing through your videos. It's great 👍
Very informative video for job aspirants 🙏
Nicely explained 👌👍
All the facts elaborated in very easier way 🙂
Thanks for the info ❤
Great explanation and simple 👍
Nicely explained 👌👍
All the facts elaborated in very easier way 🙂
Thanks for the info ❤