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

LeetCode – 175. Combine Two Tables

Problem Statement Table: Person +-------------+---------+ | Column Name | Type | +-------------+---------+ | PersonId | int | | FirstName | varchar | | LastName | varchar | +-------------+---------+ PersonId is the primary key column for this…

https://thecodingbot.com/leetcode-175-combine-two-tables/

The blog and this channel has not been active for some time now. I have been going through some rough patches in my personal life and not really sure when will I be able to continue posting. All the members are welcome to stay as I am not going to delete the channel or blog but can't assure you when will I be able to make a comeback. You guys were amazing audience.

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