A good article on how to use Unsupervised Learning (K Means) + NLP https://medium.com/@lucasdesa/text-clustering-with-k-means-a039d84a941b

**SQL**
Question—> Write a SQL query to get the nth highest salary from the Employee table.
Problem statement link —> https://leetcode.com/problems/nth-highest-salary/
Detailed solution link —> https://thecodingbot.com/leetcode-177-nth-highest-salary/

Attempt the problem by yourself first :)

Different type of machine learning explained - https://thecodingbot.com/different-type-of-machine-learning-supervised-unsupervised-and-reinforcement-learning/

How to check the version of Pandas?

Table of Contents SolutionSolution 1 – GEt version number with __version__ attributeSolution 2 – Using pip Freeze + GrepSolution 3 – With PIP SHOW Solution There are several ways you check the version of pandas you are…

https://thecodingbot.com/how-to-check-the-version-of-pandas/

Any Feedback/Suggestions ? Drop a comment on the group above

A telephonic level interview problem -

Given (x,y) coordinates of n houses, where should you build a road parallel to the x-axis to minimize the construction cost of building driveways?

https://thecodingbot.com/given-xy-coordinates-of-n-houses-where-should-you-build-a-road-parallel-to-the-x-axis-to-minimize-the-construction-cost-of-building-driveways/

Happy holi fellas!!!

Rearrange a linked list such that all even index nodes come after all odd index nodes

Table of Contents Problem StatementSolutionApproachHere are the steps in detailImplementation of the Above Approach Problem Statement Given a singly linked list, group all odd nodes together followed by all the even nodes. Please note here…

https://thecodingbot.com/rearrange-a-linked-list-such-that-all-even-index-nodes-come-after-all-odd-index-nodes/

Get unique values from a Pandas column preserving the order of appearance

Introduction There are several ways to get the unique values from a column in a Pandas DataFrame, but in this tutorial, we will focus more on how we can keep the order of appearance(without rearranging…

https://thecodingbot.com/get-unique-values-from-a-pandas-column-preserving-the-order-of-appearance/

Remove duplicates from a Pandas DataFrame with two or more column in the subset criteria

Introduction There are some functions available to remove duplicates or identify duplicated rows in the dataframe in Pandas. One such function is df.duplicated() and the other function is df.drop_duplicates(). df.duplicated() not exactly removes duplicates from the dataframe but it…

https://thecodingbot.com/remove-duplicates-from-a-pandas-dataframe-with-two-or-more-column-in-the-subset-criteria/

Finding unique values and their count from all the columns in a Pandas DataFrame

Introduction Given a Pandas DataFrame, we need to find all the unique values and their count from all(or a subset of) columns. Solution TL;DR Use df.melt().value.value_counts(), here df is the DataFrame. More elaborated version –…

https://thecodingbot.com/finding-unique-values-and-their-count-from-all-the-columns-in-a-pandas-dataframe/

Use string value as a variable name in Python

Introduction I was doing a task lately and I got a need to convert some strings to variable names. I had a list of strings that I had to convert to variable names to store…

https://thecodingbot.com/use-string-value-as-a-variable-name-in-python/

Given an array nums of integers, return how many of them contain an even number of digits

Problem Statement Given an array nums of integers, return how many of them contain an even number of digits. Example 1: Input: nums = [12,345,2,6,7896] Output: 2 Explanation: 12 contains 2 digits (even number of digits).  345 contains 3…

https://thecodingbot.com/given-an-array-nums-of-integers-return-how-many-of-them-contain-an-even-number-of-digits/

Today's topic is Automation with Python. You can do many cool stuffs like spamming your friend's inbox, wishing your friend, replying to the posts on facebook wall etc.

Here are some resources from where you can learn automation in Python.

Opensource github projects:

1. https://github.com/ShivajiReddy/WhatsApp-Using-Python (Easy)
2. https://github.com/umangahuja1/Youtube/tree/master/Whatsapp%20Automation
2. https://github.com/draguve/WhatsSpam (Easy)
3. https://github.com/shauryauppal/PyWhatsapp (Slightly advanced)

Youtube tutorial:

1. https://www.youtube.com/watch?v=5hr0IdVM7Qg
2. https://www.youtube.com/watch?v=98OewpG8-yw

Documentation of the libraries you are most likely going to use in above projects:

1. Requests: https://requests.readthedocs.io/en/master/
2. Selenium: https://selenium.dev/documentation/en/

Happy Coding (thecodingbot.com,t.me/computerprogrammingcodingbot)

How to sort lines of the file based on their length in Windows PowerShell

Introduction One of my friends was working on Windows for some side project and it was when he approached me with a question – “Do you know how to sort lines of the files based…

https://thecodingbot.com/how-to-sort-lines-of-the-file-based-on-their-length-in-windows-powershell/

Please let your friends also know about thecodingbot.com, if you like it . This will help me a lot. It takes so much effort to write and provide good content after a full-time job 🙏