How to increment/decrement a variable in bash(shell scripting)?

Overview In this tutorial, we will see how we can increment/decrement a variable value in bash(shell scripting). There are a couple of ways to modify a variable value, we will try to cover them all…

https://thecodingbot.com/how-to-increment-decrement-a-variable-in-bashshell-scripting/

What is -eq in a bash(shell script)?

Overview -eq in bash(shell scripting) is a binary comparison operator which is used for arithmetic value comparison(i.e comparison of two integers). The general syntax is: INTEGER_1 -eq INTEGER_2 # INTEGER_1 is equal to INTEGER_2 Here,…

https://thecodingbot.com/what-is-eq-in-a-bashshell-script/

Different type of looping in Python

Overview In programming, a loop is a sequence of instructions that are continuously repeated until certain condition(s) is(are) met. The condition is often known as the terminating condition. In python, the Loops are broadly classified…

https://thecodingbot.com/different-type-of-looping-in-python/

Loops in Bash(Shell scripting)

Introduction In programming, a loop is a sequence of instructions that are continuously repeated till the certain condition(s) is(are) met. The condition is often known as the terminating condition. In bash scripting, we have different loop formats which…

https://thecodingbot.com/loops-in-bashshell-scripting/

Excellent resource to learn about telecom, LTE, 3G, 2G etc sharetechnotes.com

How to Implement 2048 game with bash https://github.com/mydzor/bash2048

***Detect face using Machine Learning and Deep Learning in Python*** https://machinelearningmastery.com/how-to-perform-face-detection-with-classical-and-deep-learning-methods-in-python-with-keras/

Conditional formatting and styling in a Pandas Dataframe

Overview Since 0.17, Pandas provide support for the styling of the Dataframe. We can now style the Dataframe based on the conditions on the data. Thanks to Pandas. In this article, we will focus on…

https://thecodingbot.com/conditional-formatting-and-styling-in-a-pandas-dataframe/

One of the member requested tutorials on combinatorics. Here's list of resources on the same:

Basics of combinatorics:

1. https://www.topcoder.com/community/competitive-programming/tutorials/basics-of-combinatorics/

2.Maths for competitive programming:

https://www.topcoder.com/community/competitive-programming/tutorials/mathematics-for-topcoders/

3. Advanced tutorial(dp+combinatorics) :
https://codeforces.com/blog/entry/54154

Where to find problems on combinatorics?

1. https://a2oj.com/category?ID=90
2. https://codeforces.com/problemset?tags=combinatorics
3. https://www.codechef.com/tags/problems/combinatorics

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

How to colour a specific cell in pandas dataframe based on its position?

Overview For this particular problem, we are going to use a feature of pandas known as conditional formatting. I have written a pretty detailed tutorial on conditional formatting in pandas in great detail which you…

https://thecodingbot.com/how-to-colour-a-specific-cell-in-pandas-dataframe-based-on-its-position/

LeetCode – 177. Nth Highest Salary

Problem Statement Write a SQL query to get the nth highest salary from the Employee table. +----+--------+ | Id | Salary | +----+--------+ | 1 | 100 | | 2 | 200 | | 3 | 300 | +----+--------+…

https://thecodingbot.com/leetcode-177-nth-highest-salary/

A very detailed tutorial on autocompletion with Django and jQuery

Introduction Have you ever wondered how you type something in the search bar and suddenly you start getting suggestions? This feature has always been in my todo list and I finally implemented it a few days back in my own website.…

https://thecodingbot.com/a-very-detailed-tutorial-on-autocompletion-with-django-and-jquery/

Common Machine Learning Algorithms explanation along with codes in Python as well as R https://www.analyticsvidhya.com/blog/2017/09/common-machine-learning-algorithms/

LeetCode – 176. Second Highest Salary

Problem Statement Write a SQL query to get the second highest salary from the Employee table. +----+--------+ | Id | Salary | +----+--------+ | 1 | 100 | | 2 | 200 | | 3 | 300…

https://thecodingbot.com/leetcode-176-second-highest-salary/

***Competitive Programming***

Almost 1000 problems for newcomers to be good upto Div2-D in Codeforces by Dr Mostafa Saad Ibrahim https://goo.gl/unDETI

How to prepare for ACM-ICPC? Detailed blogpost here https://www.geeksforgeeks.org/how-to-prepare-for-acm-icpc/

145 algorithms list along with C++ code snippet http://e-maxx.ru/algo/
**Note**
The site is in russian and you will need to translate it using the google translate.

How to add comments within SQL statements?

Overview Comments are the text notes that are written by the developer to add explanatory information about the source code. The purpose of adding comments to the source code is to make it easier to…

https://thecodingbot.com/how-to-add-comments-within-sql-statements/

Mean of range in an array

Problem Statement Given an array of N integers. You are given q queries. Write a program to print floor value of mean in range l to r for each query in a new line. Examples…

https://thecodingbot.com/mean-of-range-in-an-array/