---
title: "Roshan Jha (@jha01roshan) | Hashnode"
description: "AI, ML Advocate | Data Engineering for Living. Read the latest articles by Roshan Jha on Hashnode."
url: "https://hashnode.com/@jha01roshan"
---

@jha01roshan

# Roshan Jha

@jha01roshan · Noida, India · Joined February 2021

AI, ML Advocate | Data Engineering for Living

[Website](https://learning.10xai.co/)

### [Learning SQL Window Functions - The Right Way](https://roshan-jha.hashnode.dev/learning-sql-window-functions-the-right-way?utm_source=hashnode&utm_medium=feed)

Why Window Functions? There is no simple way in SQL to calculate running aggregate on data e.g. for a monthly sales data, we may need to calculate the cumulative sales. Let's take a simple table of sales data. How will I get - Example#1 - Monthly c...

8 min read · [roshan-jha.hashnode.dev](https://roshan-jha.hashnode.dev/learning-sql-window-functions-the-right-way?utm_source=hashnode&utm_medium=feed)

[Nov 6, 2023](https://hashnode.com/posts/learning-sql-window-functions-the-right-way/65490c76732aeb1a504d688e)

### [Build with ChatGPT - Q&A Bot and Video Summarization - II](https://roshan-jha.hashnode.dev/build-with-chatgpt-qa-bot-and-video-summarization-ii?utm_source=hashnode&utm_medium=feed)

Introduction This article serves as a follow-up to our previous post on the topic \[ Link \]. In the earlier article, we delved into the essential terminologies associated with OpenAI, such as Tokens and Prompts. Additionally, we learned the fundamenta...

7 min read · [roshan-jha.hashnode.dev](https://roshan-jha.hashnode.dev/build-with-chatgpt-qa-bot-and-video-summarization-ii?utm_source=hashnode&utm_medium=feed)

[Apr 8, 2023](https://hashnode.com/posts/build-with-chatgpt-qa-bot-and-video-summarization-ii/6431a721d89f75ecc4e3243c)

### [Build with ChatGPT - Q&A Bot and Video Summarization](https://roshan-jha.hashnode.dev/build-with-chatgpt-qa-bot-and-video-summarization?utm_source=hashnode&utm_medium=feed)

Introduction ChatGPT is a product that truly requires no introduction. Since its launch, its impact has been nothing short of remarkable \[see image below \]. As someone who closely follows the AI research industry, I never imagined a scenario where a ...

6 min read · [roshan-jha.hashnode.dev](https://roshan-jha.hashnode.dev/build-with-chatgpt-qa-bot-and-video-summarization?utm_source=hashnode&utm_medium=feed)

[Apr 4, 2023](https://hashnode.com/posts/build-with-chatgpt-qa-bot-and-video-summarization/642c537ff0a926f6d13fa2b1)

### [Features correlation of every type - Explanation, and Code](https://roshan-jha.hashnode.dev/features-correlation-of-every-type-explanation-and-code?utm_source=hashnode&utm_medium=feed)

Introduction Correlation among features is one of the most discussed topics in the Machine learning space. While it is very common to find a blog explaining the correlation among Numerical features, it's quite a bit rare to have blogs explaining Corr...

9 min read · [roshan-jha.hashnode.dev](https://roshan-jha.hashnode.dev/features-correlation-of-every-type-explanation-and-code?utm_source=hashnode&utm_medium=feed)

[Aug 1, 2021](https://hashnode.com/posts/features-correlation-of-every-type-explanation-and-code/610679fc3b9b85399dcf45c8)

### [Simplifying Date and Time with Python](https://roshan-jha.hashnode.dev/simplifying-date-and-time-with-python?utm_source=hashnode&utm_medium=feed)

Introduction In this post, we will dive into the DateTime related module of Python and Pandas. Handling DateTime is always a boring part of any programming language. Many times we can achieve most of our requirements without delving much into this mo...

6 min read · [roshan-jha.hashnode.dev](https://roshan-jha.hashnode.dev/simplifying-date-and-time-with-python?utm_source=hashnode&utm_medium=feed)

[Jul 17, 2021](https://hashnode.com/posts/simplifying-date-and-time-with-python/60f2ccde66fcdb0a02741b19)
