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/

It's sunday and we talk about miscellaneous stuff today.
Today's topic is C++ best practices.

Here are the top resources for your learning:

Books:

1. Cpp best practices(https://lefticus.gitbooks.io/cpp-best-practices/)[Intermediate-Advanced],
2. C++ notes for professional, 600+ pages of tricks and tips for developer(https://books.goalkicker.com/CPlusPlusBook/)

Youtube:

1.Jason Turner (https://www.youtube.com/user/lefticus1)
2.CppCon (https://www.youtube.com/user/CppCon)

If you don't know c++ and want to start fresh:

1.C++ 10 hours course!!!: https://www.youtube.com/watch?v=_bYFu9mBnr4&list=PL_c9BZzLwBRJVJsIfe97ey45V4LP_HXiG (Tip: To find the contents, scroll down to comment section)

2.Freecodecamp 4 hour beginner tutorial: https://www.youtube.com/watch?v=vLnPwxZdW4Y

3.The newboston c++ playlist: https://www.youtube.com/watch?v=tvC1WCdV1XU&list=PLAE85DE8440AA6B83

4.The cherno's youtube playlist : https://www.youtube.com/watch?v=18c3MTX0PK0&list=PLlrATfBNZ98dudnM48yfGUldqGD0S4FFb

Open source github projects:

1.VLC, built completely on c++ : https://github.com/videolan/vlc
2.Tenserflow, built using c++ : https://github.com/tensorflow/tensorflow
3.Electron framework for cross platform desktop application is built on the top of c++: https://github.com/electron/electron

Note: The open source projects are really advanced and it is not expected that an indivdual can implement one like them easily. Please just refer them for best coding practices and other learnings.

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

LeetCode – 387. First Unique Character in a String

Problem Statement: Given a string, find the first non-repeating character in it and return its index. If it doesn’t exist, return -1. Examples: s = "leetcode" return 0. s = "loveleetcode", return 2. Note: You may assume the string contains only lowercase letters. Solution Probably the best approach to solve this problem is by traversing the string and using a…

https://thecodingbot.com/leetcode-387-first-unique-character-in-a-string/

How to run scripts from the python shell?

Running python script from the command line or terminal is pretty easy, you just have to type run python script_name.py and it is done. Take a look at the example below to see how it…

https://thecodingbot.com/how-to-run-scripts-from-the-python-shell/

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/

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?

Figure Road-House driveway Although the question is pretty clear, it is still necessary to clarify a few things. The road actual costs nothing to build. All the costs that we are considering in the question…

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/

Print the elements of a singly linked list in reverse order

Problem Statement Given a singly linked list, print its elements in reverse order. For example: Input : 1->2->3->4->NULL Output: Printing the linked list in reverse order: 4 3 2 1 Solution First of all, readers should be clear that this problem is not the same as reversing the linked list. In this problem, we just need to…

https://thecodingbot.com/print-the-elements-of-a-singly-linked-list-in-reverse-order/

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)

Count the number of nodes in a circular linked list

Problem Statement Given a circular linked list, you have to count the number of nodes in it. For example: A Circular linked list with a total of 6 nodes. Solution Well, there is only one…

https://thecodingbot.com/count-the-number-of-nodes-in-a-circular-linked-list/

I apologize for not being active for couple of days. Will be posting regularly from 3rd. Any ideas feedback write to: thecodingbot@gmail.com