Structured Query Language (SQL) is de facto language for storing and retrieving structured data from a table. In this post, we will create a database organization and inside this database we create the following table. Below SQL code creates a table and inserts 5 records into Employee table. CREATE DATABASE if not exists organization; USE […]
Create a Table in SQL and Select Data from Table Read More »
Python is an object-oriented language and a class can have properties and methods. In this post, I will create a simple class having a constructor __init__() and four methods namely mysum(), mymul(), mydiv() and mysub(). Moreover, they compute addition of two numbers, multiplication of two numbers, division of a number by another and subtraction of
Mathematical Operations in Python using Object-Oriented Programming in Python Read More »
R programming language is very popular for data science, machine learning and statistical computing. Furthermore, the syntax of R is very simple and easy to learn. In this pots, I am going to make a simple program in R which will add two numbers. a<-12 b<-13 c<-a+b print(c) In the above program, two numeric vectors
Addition in R programming language Read More »
Sometimes you may need to update table in SQL which you have created. For this you need to use UPDATE command with SET option. In this post, you will know that how you can update a record of SQL database. You can see in the below program that a database school is created and inside
Update Command in Structured Query Language (SQL) Read More »
An array in Java is a collection of values having contiguous memory locations and share a common name. Suppose you want to create an array of five numbers having data type integer and array name in num. So, first you need to declare as int num[]; Second, you need to allocate memory using new operator
Generators in Python are like ordinary function the difference that it contains yield statement instead of return. Furthermore, when a function encounters an yield statement it pauses execution of function and saves the state of the function. And when function is called again it starts from the next statement where it was paused. See the
Generators in Python Read More »
Suppose that in Python you want to expand an expression (x+y)2 to x2 + y2 + 2 xy, this can be done using sympy library in Python, first of all see a simple program. from sympy import * x = Symbol(‘x’) y = Symbol(‘y’) z=(x + y)**2 print(expand(z)) Output:- x**2 + 2*x*y + y**2 How
sympy Library in Python Read More »
COUNTIF() and SUMIF are very important functions in excel which are used to automate manual tasks. Furthermore, these functions are frequently used in finance and accounting. In this post, I am going to explain working of these two functions. COUNTIF() function- This function counts the values of a column when a condition if fulfilled
COUNTIF and SUMIF Functions in MS Excel Read More »
K-nearest neighbors algorithm is a machine learning algorithm which is used for classification and regression, and it can be applied where other machine learning algorithms are applied. See the typical problem setting , Suppose (x1, y1), (x2, y2), (x3, y3), ……………….(xn, yn) pairs in which x’s are attributes and y’s are labels, suppose another instance
K-Nearest Neighbors Algorithm in Python Read More »
1-import csv 2-fcsv=open(‘mycsv.csv’, ‘r’) 3-table=csv.reader(fcsv) 4-for row in table: 5- print(row) Program Description In the above program a library csv is imported in the first file which is used to manipulate csv files. Moreover, a file object fcsv is created using open function, thereafter file object is passed into reader function
Write a program which opens a CSV file in Python and Reads Data from it Read More »