Open in app

Sign in

Write

Sign in

neelam singhal
neelam singhal

Home

About

Aug 1, 2022

What I have learned in last 1 year as a Data Scientist

Things I learned: Start writing functions from the start while coding. Implement version control from beginning Create a code to do analysis that clients need so you don’t have to do it manually. As much as possible, try using code and not excel for analysis.

1 min read

1 min read


Jul 28, 2022

An introduction to Joblib

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…

1 min read

1 min read


Jul 28, 2022

SQL Interview questions

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…

1 min read

1 min read


Jul 28, 2022

Simple Python API

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()…

1 min read

Simple Python API
Simple Python API

1 min read


Jun 6, 2022

GIT — when you are not able to pull files to your local system

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!

1 min read

1 min read


Apr 22, 2022

Python Coding questions

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…

1 min read

1 min read


Apr 12, 2022

SQL Difficult Queries

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…

2 min read

SQL Difficult Queries
SQL Difficult Queries

2 min read


Apr 6, 2022

My first date with Time Series Forecasting

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…

1 min read

1 min read


Apr 6, 2022

Covid impact on eCommerce websites and how to manage it in the Time Series Forecasting model

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…

1 min read

1 min read


Mar 31, 2022

How to manage impatient Non-Technical clients as a Data Scientist

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…

Data Science

2 min read

Data Science

2 min read

neelam singhal

neelam singhal

Help

Status

About

Careers

Blog

Privacy

Terms

Text to speech

Teams