December, 2024 - Code with Akshat

Create Your Personalized AI Assistant

AI Assistant, Artificial Intelligence / December 21, 2024

In this blog post, we’ll walk you through creating a personalized AI agent using OpenAI’s GPT model and the powerful Langchain library. With a GUI interface powered by Tkinter, we’ll build a system where you can load documents, search through them, and get responses from a chatbot-like agent tailored to your data. This tutorial will guide you through setting up the environment, the code, and explain how everything works to create your own custom search agent!

Create Your Personalized AI Assistant Read More »

How to Create a New Python Project in VS Code

Technical / December 20, 2024

Setting up a new Python project, versioning it with Git, and hosting it on GitHub is a standard workflow for any developer. In this guide, we’ll walk through the process of creating a new Python project in Visual Studio Code (VS Code), pushing it to a new GitHub repository, and handling common SSH authentication errors you may encounter.

How to Create a New Python Project in VS Code Read More »

SQL Challenge Problem #1 – Finding Duplicate Records

SQL, SQL Challenge / December 16, 2024

Welcome back to the SQL challenge series! In this post, we’re tackling a slightly more interesting problem: “Finding Duplicate Records.” This problem is a great way to explore how SQL handles data aggregation and filtering, and we’ll see how Presto SQL and MySQL can solve it differently.

SQL Challenge Problem #1 – Finding Duplicate Records Read More »

Embarking on Machine Learning Journey

Learning Together ML, Machine Learning / December 16, 2024

I’m thrilled to announce the start of a brand-new blog series where I’ll be diving into Machine Learning (ML) concepts. Unlike my Python and SQL series that focus on hands-on problem-solving, this series is dedicated to theoretical learning as I explore the fascinating world of Machine Learning and share what I discover along the way.

Embarking on Machine Learning Journey Read More »

LeetCode Python Problem #1 – Solving “Two Sum”

LeetCode Python Challenge, Python / December 16, 2024

Welcome back to the blog! In this post, I’m kicking off my Python coding challenge series by solving an easy yet essential problem from LeetCode: “Two Sum”. Whether you’re a beginner learning Python or someone preparing for coding interviews, this problem is a perfect place to start.

LeetCode Python Problem #1 – Solving “Two Sum” Read More »

Mastering SQL: Solving 1 Query a Day

SQL, SQL Challenge / December 15, 2024

Welcome to another exciting series of my blog! I’m, a data enthusiast passionate about working with SQL to extract meaningful insights and solve real-world problems. Today, I’m kicking off a brand-new series: solving 1 SQL question every day. This challenge isn’t just about consistency—it’s about sharpening my SQL skills, exploring various sources, and growing as a data professional. And I’d love for you to join me on this journey!

Mastering SQL: Solving 1 Query a Day Read More »

Leveling Up with LeetCode Python

LeetCode Python Challenge, Python / December 15, 2024

Welcome to my very first blog post—an exciting start to what I hope will become a journey filled with code, learning, and growth. I’m, a tech enthusiast passionate about data, programming, and solving problems one line of code at a time. Today, I’m introducing a brand-new blog series: solving 1 Python coding question from LeetCode every day! Why? Because consistent progress leads to big results—and I want to take you along for the ride.

Leveling Up with LeetCode Python Read More »

December 2024