The data engineer at my work recently told me about Joblib and I’m hooked! This makes the code run so much faster and there is no going back anymore. Goodbye chunky for loops and hello parallelization! This is used for parallel processing the for loop to improve run time. Lets…

Following are two tables. Use them to answer these 3 questions: Select 2nd costliest order for cust_id 1004 from customer table Select all cust_id and their costliest orders from customer table select the costliest order for all customers with their names and city SQL Code Create Tables: create table orders( id int, cust_id int, price int, created_at varchar(255) ) INSERT INTO orders (id, cust_id, price…

Creating a simple python API using Flask Input: {“operation”: “sum”, “operands”: [2,2,4]} “operation” can be average, sum , median, mode Output: {“answer”: 8} from flask import Flask, jsonify, request from statistics import mean, median, mode app = Flask(__name__) @app.route("/calculate", methods=['POST']) def calculate(): data = request.get_json() function = data['operation'].lower()…

Due to some error, the latest files were not being pulled in the git local folder. Steps that helped: git reset --hard head git clean -xffd (this detaches the head) git checkout master pull pull Thats it! The head is attached again!

Q1: Write a query to reverse a number in python n= 3648 m = 0 while n!=0: m = m*10 + n%10 print(m) n = n//10 print(n) Q2: Check if two strings are palindrome s1 = "madam" if(s1 == s1[::-1]): print ("This is a palindrome") else: print ("not palindrome") Q3…

Hi! Poor SQL knowledge is definitely a deal breaker when it comes to interview. Following are few difficult queries to practice for your interview! Q1: We have a list of cricket matches between different teams. We want to create an output where we get a summary of matches_playes, no_of_wins and…

I have joined a new organization and working on Banner Pricing. Problem Statement: It's a e-commerce website and they want to have correct pricing for selling banner. previously they had only an excel sheet where they used previous few days data to estimate banner pricing. However, client was looking for…

Working on Time Series model and noticed that due to covid impact, the trend is incorrectly going negative. Option to mitigate it: Dump 2020 data and start forecasting from 2021 data only. It can be a short term solution. Add a adjusting factor to adjust page views in 2019. Make…

Data Scientist is an amalgamation of many roles — data analyst, statisticians, little data engineering. However, the most impactful and rewarding role is that of a Storyteller. We spend most of our days cooped up with our laptops trying to tweak hyper-parameters, making grid-search, deciding the best evaluation metrics etc…