Blog | Jayanth Muppaneni

Analytical (Window) Functions in SQL - Navigation Functions

Navigational functions are a category of window functions which are used to access values from rows that are different from the current...

Analytical (Window) Functions in SQL - Ranking Functions

Window functions perform aggregate and ranking functions over a particular set of rows (window) that are related to each other. However,...

Formatting python-created Spreadsheets

Excel is a powerful tool that helps organize, store and visualize information effectively. However, the monotonous nature of some excel...

SQL | Efficient use of Arrays

Let us assume we have two tables - "founders" and "students": The table "students" holds the information about students and their...

Internet Usage Statistics (India)

Over the past decade, India has seen a dramatic increase in the percentage of its population availing internet services. By 2020, India...

How to download transcripts of YouTube Videos using Python?

With over a billion learning-related videos viewed daily, YouTube can be a great place to learn about things you're passionate about....

Returning multiple values from a function in Python

Assume we have a method which takes in full name and returns first & last names seperately. def split_fullname(fullname): firstname =...

Numpy Starter Functions

Numpy arrays are closer to hardware. Thus, their execution/operation times are significantly lesser compared to the usual pythonic lists....

How to convert Python file (example.py) to an executable (example.exe) ?

Open Command Prompt and navigate to the folder where .py file is located. For those unaware on how to navigate, use 'cd path' command....

Simple Linear Regression - Predicting housing prices in Kansas City

In this problem, we split our data into test and training data sets. We feed our training data for the machine to learn, then we see how...

Analyzing Iris Flower Data Set

Iris Flower data set consists of 50 specimens from each of three species of Iris Flower(Iris setosa, Iris virginica and Iris versicolor)....