Python Average: A Step-by-Step Guide
There are two ways to find the average of a list of numbers in Python. You can divide the sum() by the len() of a list of numbers to find the average. Or, you can find the average of a…
Python Pass: A How to Guide
The Python pass statement is a placeholder keyword. It is used in empty code blocks such as a for or if statement to prevent against a syntax error. Python recognizes the section of code in which a pass statement is…
Python List Comprehension: A How-To Guide
A Python list comprehension is a way of creating a list based on an existing list. List comprehensions are commonly used to filter items out of a list or to change the values in an existing list. List comprehensions are…
JavaScript JSON: A Guide
JSON, short for JavaScript Object Notation, is a way of storing data. In JSON objects, values are mapped to labels called keys. JSON objects can store any data type, including strings, integers, and other JSON values. JSON is a standard…
Python Remove Key from a Dictionary: A Complete Guide
The Python pop() method and del keyword remove keys from a dictionary. pop() accepts the name of the key you want to remove from the dictionary as an argument. The del keyword stands on its own and refers to a…
Python insert(): A Complete Guide
The Python insert() method adds an item to a list. This method accepts two arguments: the position at which you want to add the item, and the item you want to add. Suppose you have a list of student names,…
Python Dictionary Keys: A Complete Guide
The Python dictionary keys() method returns an object which contains the keys in a dictionary. You can use the list() method to convert the object into a list. The syntax for the keys() method is: dictionary.keys(). You may want to…
JavaScript Ternary Operators: A Step-By-Step Guide
The JavaScript ternary operator evaluates a statement and returns one of two values. A ternary operator can be instructed to return a value if the statement evaluates to either true or false. The syntax for the ternary operator is: statement…
Launch Your Tech Career with a Pathrise Fellowship
Landing your dream tech job is becoming increasingly difficult as competition heats up. In order to bridge this gap, Pathrise is looking to support people looking for a tech job through their Pathrise fellowship. Pathrise, which launched in early 2018, has adopted…
JavaScript Modulo: A How-To Guide
The JavaScript modulo operator returns the remainder of a division sum. To calculate the remainder of a division sum, use the percentage sign (%). The syntax for the modulo operator is: (number_one % number_two). How to Use the JavaScript Modulo…
Python Convert List to Dictionary: A Complete Guide
You can convert a Python list to a dictionary using a dictionary comprehension, dict.fromkeys(), or the zip() method. All three methods create a new dictionary. They do not modify the existing list. Python lists and dictionaries are two structures used…
Replace Item in List in Python: A Complete Guide
There are three ways to replace an item in a Python list. You can use list indexing or a for loop to replace an item. If you want to create a new list based on an existing list and make…
Python Dictionary Values: A Guide
The Python dictionary values() method returns an object containing the values in a dictionary. This method is useful if you want to iterate over only the values in the dictionary. If you change a dictionary later, the data stored in…
SQL Subquery: A Complete Guide
An SQL subquery is a query inside another query. It is used in the WHERE or HAVING clause of an SQL statement. Subqueries let you specify the results of one query as an argument in another query. When you’re writing…
SQL Aliases: A Complete Guide
An SQL alias is a reference name for a table or a column. They are used to shorten your queries if you have long table names. Both table and column aliases are defined using the AS keyword. An alias lasts…
SQL Left Join: A Complete Guide
An SQL LEFT JOIN is a type of SQL join. This join returns all the tables from a specified "left" column and the corresponding rows that match a particular condition in the "right" column. In many cases, when you’re writing…
SQL ORDER BY: A Complete Guide
The SQL ORDER BY statement determines the order in which records are returned by a query. You can return records in ascending or descending order by the value of any column in the table. Ordering query results makes it easier…
SQL INNER JOIN: A Complete Guide
The SQL INNER JOIN statement returns rows with exact values in two columns across two tables. You can join a table across one or multiple columns. JOIN statements connect two database tables and compare their contents. There may be times…
SQL Aggregate Functions: A Complete Guide
SQL aggregate functions retrieve information about the data in a database. You can use COUNT to find out how many records are in a database, for instance. Accepted aggregate functions are: COUNT, MIN, MAX, AVG, and SUM. There are occasions…
SQL Group By: A Complete Guide
The SQL GROUP BY statement appears in aggregate functions. It is used to collate the data you select from a query by a particular column. You can specify multiple columns which will be grouped using the GROUP BY statement. When…
SQL Like: A How-To Guide
The SQL LIKE operator uses wildcards to find data similar to a particular pattern. You can use an underscore to substitute for a single character or a percentage sign to substitute zero, one, or multiple characters. Have you ever wanted…
SQL Between: A Complete Guide
The SQL BETWEEN keyword retrieves values that fall within a particular set of values. It is often used to retrieve values between two dates or numbers. This keyword is used in WHERE clauses. The syntax for this keyword is: "BETWEEN…
SQL IN: A Beginner’s Guide
The SQL IN keyword lets you select values that appear in a range of values. You can specify a query inside an IN statement to search for records whose column has a value in the result of a query. The…
SQL ALTER TABLE: A Guide
The SQL ALTER TABLE statement adds, changes, or removes a column in a table. This statement lets you modify a table after it has been created, even if the table stores records. You may decide that you need to make…
SQL WHERE Statement: A How-To Guide
The SQL WHERE clause limits how many records are returned or affected by a command. It is used with the SELECT, UPDATE, and DELETE clauses. You can use the AND keyword to specify multiple conditions which you want records affected…
What is JavaScript Used For?
JavaScript is used to develop interactive web applications. JavaScript can power featured like interactive images, carousels, and forms. The language can be used with back-end frameworks like Node.js to power the mechanics behind a web page, such as form processing…
CSS Box Model: A How-To Guide
The browser uses the CSS box model to determine how an element should appear on a web page. The box model represents the size of an element and its border, padding, and margins. You can style each of these elements…
Java indexOf(): A How-To Guide
The Java indexOf() method finds the index position at which a specified string begins. This method lets you find a string within another string. If the value you specify is not present in the string through which you are searching,…
JavaScript String Contains: Step-By-Step Guide
You can check if a JavaScript string contains a character or phrase using the includes() method, indexOf(), or a regular expression. includes() is the most common method for checking if a string contains a letter or series of letters, and…
Python Move File: A Complete Guide
The Python shutil.move() method moves a file to another location on your computer. This method is part of the shutil model, which you must import before using this method. Moving files is a common operation in Python programs. For instance,…
