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 🙏

What is k fold cross validation in machine learning? https://machinelearningmastery.com/k-fold-cross-validation/

Find row mean/average in Pandas dataframe

Introduction In this quick tutorial, we will see how we can find the row average of all the rows in a Pandas Dataframe. Later, we will create a new column with those mean values. Solution…

https://thecodingbot.com/find-row-mean-average-in-pandas-dataframe/

In these challenging times, we find ourselves in one of the most severe economic downturns, which has had a profound impact on both students and working professionals. Internship and placement opportunities for students have become scarce, while layoffs and a dearth of new opportunities have affected the livelihoods of many professionals.

As a gesture of gratitude towards the community that has supported my personal growth, I am pleased to announce the creation of a dedicated Telegram channel. The purpose of this channel is to share valuable information regarding job and internship opportunities specifically in the field of Information Technology (IT).

To ensure maximum convenience and relevance, we have organized the postings based on a structured format:

Mondays: Data Science/Machine Learning
Tuesdays: Full Stack Development
Wednesdays: DevOps
Thursdays: Frontend Development
Fridays: Backend Development
Saturdays: Testing
Sundays: Internships

Channel Link: https://t.me/be_job_ready ( @be_job_ready )


We aim to provide daily updates on relevant opportunities according to this schedule. Together, let us navigate these challenging times and support one another by sharing valuable job prospects and internships.

Thank you for being a part of this community.

Best regards,
Admin